# HG changeset patch # User greg # Date 1556024233 14400 # Node ID 8a826d1afe69c69ff266c77050aa4f7cf1e56b47 # Parent 84478b80cc479d15e3b0828acec063be8a01780b Uploaded diff -r 84478b80cc47 -r 8a826d1afe69 test-data/affy_metadata.tabular --- a/test-data/affy_metadata.tabular Fri Feb 15 08:57:22 2019 -0500 +++ b/test-data/affy_metadata.tabular Tue Apr 23 08:57:13 2019 -0400 @@ -1,97 +1,97 @@ -#user_specimen_id,field_call,bcoral_genet_id,bsym_genet_id,reef,region,latitude,longitude,geographic_origin,sample_location,latitude_outplant,longitude_outplant,depth,dist_shore,disease_resist,bleach_resist,mortality,tle,spawning,collector_last_name,collector_first_name,org,collection_date,contact_email,seq_facility,array_version,public,public_after_date,sperm_motility,healing_time,dna_extraction_method,dna_concentration -test_002 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_003 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_005 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_006 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_007 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_008 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_010 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_011 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 12 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_012 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 24 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_013 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_014 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 15 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_015 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_016 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_017 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_018 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_019 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 15 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_020 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_021 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_022 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_023 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_024 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_025 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_026 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_027 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_028 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_029 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_030 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_031 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_032 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_033 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_034 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_035 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_036 palmata Curlew Belize 16.7909389 -88.0830056 Reef 23 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_037 palmata Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_038 palmata Curlew Belize 16.7909389 -88.0830056 Reef 9 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_039 palmata Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_040 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_041 palmata Curlew Belize 16.7909389 -88.0830056 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_042 palmata Curlew Belize 16.7909389 -88.0830056 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_043 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_044 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_045 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_046 palmata Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_047 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_048 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_049 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_050 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_051 palmata Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_052 palmata Curlew Belize 16.7909389 -88.0830056 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_053 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_054 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_055 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_056 palmata Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_057 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_058 palmata Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_059 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_060 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_061 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_062 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_063 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_064 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_065 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 27 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_066 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 25 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_067 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_068 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_069 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 9 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_070 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_072 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 16 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_073 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_074 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_075 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_076 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_077 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_078 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 16 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_079 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_080 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_081 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_083 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_084 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_085 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_086 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_087 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_088 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_089 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_090 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_091 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_092 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_093 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_094 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_095 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_096 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 8 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_001 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_004 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_009 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_071 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 -test_082 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +#user_specimen_id field_call bcoral_genet_id bsym_genet_id reef region latitude longitude geographic_origin sample_location latitude_outplant longitude_outplant depth disease_resist bleach_resist mortality tle spawning collector_last_name collector_first_name org collection_date email seq_facility array_version public public_after_date sperm_motility healing_time dna_extraction_method dna_concentration registry_id +test_002 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_003 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_005 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_006 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_007 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_008 prolifera JohnsonsReef Bahamas 18.361733 -64.7743 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_010 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_011 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 12 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_012 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 24 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_013 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_014 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 15 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_015 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_016 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_017 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_018 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_019 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 15 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_020 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_021 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_022 cervicornis LittleGrecian Florida 25.11844009 -80.3171895 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_023 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_024 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_025 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_026 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_027 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_028 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_029 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_030 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_031 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_032 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_033 prolifera Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_034 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_035 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_036 palmata Curlew Belize 16.7909389 -88.0830056 Reef 23 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_037 palmata Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_038 palmata Curlew Belize 16.7909389 -88.0830056 Reef 9 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_039 palmata Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_040 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_041 palmata Curlew Belize 16.7909389 -88.0830056 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_042 palmata Curlew Belize 16.7909389 -88.0830056 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_043 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_044 palmata Curlew Belize 16.7909389 -88.0830056 Reef 17 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_045 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_046 palmata Curlew Belize 16.7909389 -88.0830056 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_047 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_048 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_049 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_050 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_051 palmata Curlew Belize 16.7909389 -88.0830056 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_052 palmata Curlew Belize 16.7909389 -88.0830056 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_053 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_054 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_055 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_056 palmata Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_057 palmata Curlew Belize 16.7909389 -88.0830056 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_058 palmata Curlew Belize 16.7909389 -88.0830056 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_059 palmata Curlew Belize 16.7909389 -88.0830056 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_060 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_061 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_062 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_063 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_064 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_065 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 27 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_066 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 25 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_067 cervicornis SeaAquarium2 Curacao 12.0842 -68.8966 Reef 13 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_068 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_069 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 9 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_070 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_072 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 16 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_073 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_074 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_075 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_076 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_077 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_078 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 16 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_079 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_080 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 11 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_081 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_083 palmata SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_084 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_085 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_086 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_087 prolifera SeaAquarium2 Curacao 12.0842 -68.8966 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_088 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_089 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_090 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_091 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 4 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_092 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_093 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 1 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_094 palmata Margara Puerto Rico 17.949552 -66.727433 Reef 2 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_095 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_096 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 8 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_001 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 7 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_004 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 6 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_009 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 10 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_071 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 3 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 +test_082 cervicornis Margara Puerto Rico 17.949552 -66.727433 Reef 5 False Kitchen Sheila Penn State 2018-11-08 sak89@psu.edu Affymetrix 1 True -9.0 -9.0 diff -r 84478b80cc47 -r 8a826d1afe69 validate_affy_metadata.py --- a/validate_affy_metadata.py Fri Feb 15 08:57:22 2019 -0500 +++ b/validate_affy_metadata.py Tue Apr 23 08:57:13 2019 -0400 @@ -77,7 +77,7 @@ stop_error(accumulated_msgs) items = line.split("\t") if len(items) != 32: - accumulated_msgs = add_error_msg(accumulated_msgs, "Line %d contains %s columns, (must be 30)." % (i, len(items))) + accumulated_msgs = add_error_msg(accumulated_msgs, "Line %d contains %s columns, (must be 32)." % (i, len(items))) stop_error(accumulated_msgs) # Required and validated. # Required. @@ -115,59 +115,59 @@ # Optional. depth = items[12] # Optional. - dist_shore = items[13] + disease_resist = items[13] # Optional. - disease_resist = items[14] + bleach_resist = items[14] # Optional. - bleach_resist = items[15] + mortality = items[15] # Optional. - mortality = items[16] - # Optional. - tle = items[17] + tle = items[16] # Optional. - spawning = string_as_boolean_string(items[18]) + spawning = string_as_boolean_string(items[17]) # Required. - collector_last_name = items[19] + collector_last_name = items[18] if len(collector_last_name) == 0: accumulated_msgs = empty_value(i, "collector_last_name", accumulated_msgs) # Required. - collector_first_name = items[20] + collector_first_name = items[19] if len(collector_first_name) == 0: accumulated_msgs = empty_value(i, "collector_first_name", accumulated_msgs) # Required. - org = items[21] + org = items[20] if len(org) == 0: accumulated_msgs = empty_value(i, "org", accumulated_msgs) # Required and validated. - collection_date = items[22] + collection_date = items[21] accumulated_msgs = validate_date_string(i, collection_date, accumulated_msgs) # Required and validated. - contact_email = items[23] + contact_email = items[22] accumulated_msgs = validate_email(i, contact_email, accumulated_msgs) # Required. - seq_facility = items[24] + seq_facility = items[23] if len(seq_facility) == 0: accumulated_msgs = empty_value(i, "seq_facility", accumulated_msgs) # Optional. - array_version = items[25] + array_version = items[24] # Optional. - public = string_as_boolean_string(items[26]) + public = string_as_boolean_string(items[25]) # Optional. - public_after_date = items[27] + public_after_date = items[26] accumulated_msga = validate_date_string(i, public_after_date, accumulated_msgs) # Required and validated. - sperm_motility = items[28] + sperm_motility = items[27] accumulated_msgs = validate_decimal(i, sperm_motility, accumulated_msgs) # Required and validated. - healing_time = items[29] + healing_time = items[28] accumulated_msgs = validate_decimal(i, healing_time, accumulated_msgs) # Optional. - dna_extraction_method = items[9] + dna_extraction_method = items[29] # Optional. - dna_concentration = items[31] + dna_concentration = items[30] # If dna_concentration has a value, then it must be decimal. if len(dna_concentration) > 0: accumulated_msgs = validate_decimal(i, dna_concentration, accumulated_msgs) + # Optional. + registry_id = items[31] if len(accumulated_msgs) > 0: diff -r 84478b80cc47 -r 8a826d1afe69 validate_affy_metadata.xml --- a/validate_affy_metadata.xml Fri Feb 15 08:57:22 2019 -0500 +++ b/validate_affy_metadata.xml Tue Apr 23 08:57:13 2019 -0400 @@ -41,7 +41,6 @@ * latitude_outplant * longitude_outplant * depth - * dist_shore * disease_resist * bleach_resist * mortality @@ -60,6 +59,7 @@ * healing_time * dna_extraction_method * dna_concentration + * registry_id