Mercurial > repos > greg > validate_affy_metadata

changeset 25:d9f3bcfeecfe draft default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author greg
date Thu, 15 Aug 2019 13:15:22 -0400
parents 8a826d1afe69
children
files .shed.yml test-data/affy_metadata.tabular validate_affy_metadata.py validate_affy_metadata.xml
diffstat 4 files changed, 157 insertions(+), 147 deletions(-) [+]
line wrap: on
line diff
--- a/.shed.yml	Tue Apr 23 08:57:13 2019 -0400
+++ b/.shed.yml	Thu Aug 15 13:15:22 2019 -0400
@@ -2,7 +2,7 @@
 owner: greg
 description: |
   Contains a tool that validates an Affymetrix metadata file for 96 well plate data.
-homepage_url: https://github.com/gregvonkuster/galaxy_tools/tree/master/tools/corals/validate_affy_metadata
+homepage_url: http://baumslab.org
 long_description: |
   Contains a tool that validates an Affymetrix metadata file for 96 well plate data.
 remote_repository_url: https://github.com/gregvonkuster/galaxy_tools/tree/master/tools/corals/validate_affy_metadata
--- a/test-data/affy_metadata.tabular	Tue Apr 23 08:57:13 2019 -0400
+++ b/test-data/affy_metadata.tabular	Thu Aug 15 13:15:22 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	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			
+#user_specimen_id	field_call	bcoral_genet_id	bsym_genet_id	reef	region	latitude	longitude	geographic_origin	colony_location	depth	disease_resist	bleach_resist	mortality	tle	spawning	collector_last_name	collector_first_name	organization	collection_date	email	seq_facility	array_version	public	public_after_date	sperm_motility	healing_time	dna_extraction_method	dna_concentration	registry_id	result_folder_name	plate_barcode
+1090	palmata			Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-04-05	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	7.636	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1091	palmata			Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-04-05	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	24.082	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1092	palmata			Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-04-05	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	43.933	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1096	palmata			Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-07-02	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	10.16	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1099	palmata			Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State		ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	32.792	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1112	palmata	P1012		Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-04-05	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	10.827	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1113	palmata	P1013		Western Sambo	Florida	24.479867	-81.718667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-04-05	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	8.922	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1146	palmata	P1019		RockKey	Florida	24.456017	-81.859633	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-07-16	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	30.495	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1151	palmata	P1020		RockKey	Florida	24.456017	-81.859633	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2002-07-16	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	22.163	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+1446	cervicornis	C1015		CRF	Florida	25.022308	-80.402375	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2005-05-07	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	6.277	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+2869	palmata	P2582		GR1	Florida	25.091146	-80.40632	Reef	unknown	-9	-9	-9	-9	-9	No	Williams	Dana	University of Miami	2010-08-17	d.williams5@miami.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	16.959	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+2905	palmata	P2598		KL4NOAA	Florida	25.022308	-80.402375	Reef	unknown	-9	-9	-9	-9	-9	No	Williams	Dana	University of Miami	2010-08-20	d.williams5@miami.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	9.667	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15624	prolifera			Sandbores	Belize	16.7791333	-88.11755	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.473	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+3846	cervicornis	C1548		Flat Cay	USVI	18.31822	-64.99104	Reef	unknown	-9	-9	-9	-9	-9	No	TNC	TNC	The Nature Conservancy	2011-11-11	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.008	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+3847	cervicornis	C1548		Flat Cay	USVI	18.31822	-64.99104	Reef	unknown	-9	-9	-9	-9	-9	No	TNC	TNC	The Nature Conservancy	2011-11-11	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	3.641	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+4917	cervicornis	C1492		Little Conch	Florida	24.946333	-80.470166	Colony	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2011-11-22	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	5.574	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+4918	cervicornis	C1494		Plantation Key	Florida	24.9509	-80.4936166	Colony	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2011-11-22	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.433	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+5130	prolifera	P1872		San Cristobal	PuertoRico	17.56493	-67.04515	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2004-06-18	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	54.198	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+6898	palmata	P2427		Looe Key	Florida	24.54585	-81.4050667	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2009-07-14	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	20.179	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15625	prolifera			Sandbores	Belize	16.7791333	-88.11755	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	40.298	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+8952	prolifera	H59		Glovers	Belize	16.908817	-87.773467	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2012-09-13	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	33.666	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9003	prolifera	H8		JudyLang	Cuba	23.220565	-82.346683	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2005-05-19	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	6.834	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9005	prolifera	H9		JudyLang	Cuba	23.220565	-82.346683	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2005-05-19	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	1.612	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9372	prolifera	H10		Nain Cay	Bahamas	22.35199	-75.79612	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	SECORE	2008-01-16	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.015	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9395	cervicornis	C1170		LowerKeys	Florida	24.517654	-81.62134	Reef	unknown	-9	-9	-9	-9	-9	No	TNC	TNC	The Nature Conservancy	2008-02-26	unknown@unknown.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.197	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9585	cervicornis	C1213		Biscayne National Park	Florida	25.39894	-80.16032	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	ACRRE	2008-06-12	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	0.231	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9592	cervicornis	C1215		Biscayne National Park	Florida	25.37236	-80.17155	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	ACRRE	2008-06-12	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	25.613	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9609	cervicornis	C1218		Biscayne National Park	Florida	25.42616	-80.14175	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	ACRRE	2008-06-12	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	5.716	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9749	cervicornis	C1224		Margara	PuertoRico	17.949552	-66.727433	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	SECORE	2008-08-25	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	0.747	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+9759	cervicornis	C1142		Margara	PuertoRico	17.949552	-66.727433	Reef	unknown	-9	-9	-9	-9	-9	No	Miller 	Margaret	SECORE	2008-08-25	m.miller@secore.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.315	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11954	palmata	P1007		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	18.468	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11956	palmata	P1002		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	5.338	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11955	palmata	P2819		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	41.167	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11957	palmata	P2817		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	22.121	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11958	palmata	P2816		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	12.93	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11962	palmata	P2818		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	17.122	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+11963	palmata	P2815		CRF	Florida	24.710868	-80.947981	Reef	unknown	-9	-9	-9	-9	-9	No	Nedimyer	Ken	CRF	2014-04-21	info@coralrestoration.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	20.695	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13692	prolifera	H110		Botany2	USVI	18.357883	-65.032967	Colony	unknown	8	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-10-27	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	5.582	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13694	palmata	P2963		Botany2	USVI	18.357883	-65.032967	Colony	unknown	8	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-10-27	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	24.272	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13710	palmata	P2966		Botany2	USVI	18.359033	-65.032833	Colony	unknown	2	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-10-28	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	12.101	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13734	prolifera	H107		Sapphire	USVI	18.3349	-64.848	Colony	unknown	5	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-10-30	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	9.935	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13756	cervicornis	C1343		FlatKey	USVI	18.316367	-64.98855	Colony	unknown	17	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-10-31	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.504	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13786	cervicornis	C1569		SouthCarrieBowCay	Belize	16.801383	-88.082783	Colony	unknown	4	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-06	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	11.766	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13805	palmata	P2956		Sandbores2	Belize	16.772567	-88.1111	Colony	unknown	3	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-07	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	16.571	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13809	palmata	P2958		SouthCarrieBowCay	Belize	16.8013222	-88.0825	Reef	unknown	2	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-06	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	47.491	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13811	palmata	P2948		GloversAtoll	Belize	16.92005	-87.767217	Colony	unknown	1	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-08	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	18.526	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13835	palmata	P2950		GloversAtoll	Belize	16.9084	-87.767217	Colony	unknown	1	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-08	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	32.604	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13841	palmata	P2965		Sandbores2	Belize	16.763667	-88.113967	Colony	unknown	4	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2015-11-07	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	23.21	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13909	palmata	P2982		SeaAquarium2	Curacao	12.083133	-68.895567	Colony	unknown	8	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-03	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	17.442	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13921	palmata	P2973		DirectorsBay	Curacao	12.0633	-68.859033	Colony	unknown	6	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-04	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	23.66	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13923	cervicornis	C1652		East Point	Curacao	12.043117	-68.762433	Colony	unknown	18	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-05	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	3.405	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13927	palmata	P2696		EastPoint2	Curacao	12.043367	-68.762517	Colony	unknown	7	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-05	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	62.191	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13929	palmata	P2971		EastPoint2	Curacao	12.043467	-68.76315	Colony	unknown	5	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-05	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	37.543	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13931	palmata	P2980		EastPoint2	Curacao	12.043317	-68.763533	Colony	unknown	17	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-05	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	29.898	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13935	cervicornis	C1522		WaterFactory	Curacao	12.109283	-68.954933	Colony	unknown	16	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-06	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	34.711	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13937	palmata	P2975		WaterFactory2	Curacao	12.109517	-68.955367	Colony	unknown	16	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2016-02-06	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	32.487	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+13972	palmata	P2985		WaterFactory2	Curacao	12.109617	-68.954517	Colony	unknown	6	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2016-02-06	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	42.685	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15364	cervicornis	C1333		site 12	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	1.784	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15371	cervicornis	C1671		Carne Nursery	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.363	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15372	cervicornis	C1674		dory channel	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.979	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15373	cervicornis	C1675		wypt 112	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	0.687	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15375	cervicornis	C1677		False Caye	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	8.068	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15377	cervicornis	C1679		by_RHT1	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	14.315	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15378	cervicornis	C1680		BBC_patch	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	38.132	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15391	palmata	P2267		1D	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	18.102	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15395	palmata	P3053		CBC wypt 51	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	37.925	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15626	prolifera			Curlew	Belize	16.7909389	-88.0830056	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	7.46	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15397	palmata	P3055		SWCB2	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	8.958	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15398	palmata	P3056		N of bath room	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	18.42	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15400	prolifera	H124		south dory	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Carne	Lisa	Fragments of Hope	2018-04-20	info@fragmentsofhope.org	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.535	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15610	palmata			SouthCarrieBow	Belize	16.80132222	-88.0825	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	4.45	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15611	palmata			SouthCarrieBow	Belize	16.80132222	-88.0825	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	3.718	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15612	palmata			SouthCarrieBow	Belize	16.80132222	-88.0825	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	23.437	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15613	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	32.171	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15614	palmata			Sandbores	Belize	16.7791333	-88.11755	Reef	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	11.302	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15615	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	14.209	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15616	palmata			Glovers-118	Belize	16.182848	-88.65966	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	5.777	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15617	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.692	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15618	palmata			Glovers-118	Belize	16.182848	-88.65966	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	3.014	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15619	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	17.031	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15620	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	29.548	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15621	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Reef	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	28.366	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15622	palmata			SouthCarrieBowCaye	Belize	16.80145	-88.0827	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	13.49	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15623	palmata			BigAcervPatch	Belize	16.731183	-88.07823	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	2.964	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15719	palmata			Belize	Belize	16.182848	-88.65966	Reef	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2017-08-01	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	21.066	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15721	prolifera			E rocks	Antigua	17.09476	-61.43875	Reef	unknown	2	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	24.012	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15722	prolifera			E rocks	Antigua	17.09476	-61.43875	Reef	unknown	2	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	62.918	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15723	prolifera			E rocks	Antigua	17.09476	-61.43875	Reef	unknown	12	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	53.169	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15724	prolifera			E rocks	Antigua	17.09476	-61.43875	Reef	unknown	10	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	43.791	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15725	prolifera			E rocks	Antigua	17.09476	-61.43875	Reef	unknown	9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	48.219	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15726	prolifera			N rocks	Antigua	17.09476	-61.43875	Reef	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	34.925	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15727	prolifera			N rocks	Antigua	17.09476	-61.43875	Reef	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	107.991	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15728	prolifera			N rocks	Antigua	17.09476	-61.43875	Reef	unknown	2	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2018-05-31	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	31.269	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15720	cervicornis			Belize	Belize	16.182848	-88.65966	Colony	unknown	-9	-9	-9	-9	-9	No	Fogarty	Nicole	NOVA Southeastern	2017-08-01	nf121@nova.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	17.184	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+15729	prolifera			JudyLang	Cuba	23.220565	-82.346683	Reef	unknown	-9	-9	-9	-9	-9	No	Baums	Iliana	Penn State	2005-05-19	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Qiagen DNeasy	7.878	-9	PRO100175_PSU175_SAX_b02	P9SR10074
+14225	palmata	P1000	F100	Horseshoe	Florida	25.139467	-80.29435	Reef	sperm	-9	-9	-9	-9	-9	Yes	Kitchen	Sheila	Penn State	2016-08-20	ibb3@psu.edu	Affymetrix	1	Yes	No	-9	-9	Nucleon Phytopure	11.469	-9	PRO100175_PSU175_SAX_b02	P9SR10074
--- a/validate_affy_metadata.py	Tue Apr 23 08:57:13 2019 -0400
+++ b/validate_affy_metadata.py	Thu Aug 15 13:15:22 2019 -0400
@@ -37,22 +37,22 @@
         return 'False'
 
 
-def validate_date_string(line_no, date_string, accumulated_msgs):
+def validate_date_string(line_no, date_string, column, accumulated_msgs):
     if len(date_string) == 0:
         return accumulated_msgs
     try:
         datetime.datetime.strptime(date_string, '%Y-%m-%d')
         return accumulated_msgs
     except ValueError:
-        return add_error_msg(accumulated_msgs, "Line %d contains an incorrect date format (%s must be YYYY-MM-DD)." % (line_no, date_string))
+        return add_error_msg(accumulated_msgs, "Line %d contains an incorrect date format (%s must be YYYY-MM-DD) for column %s." % (line_no, date_string, column))
 
 
-def validate_decimal(line_no, decimal_string, accumulated_msgs):
+def validate_decimal(line_no, decimal_string, column, accumulated_msgs):
     try:
         decimal.Decimal(decimal_string)
         return accumulated_msgs
     except Exception:
-        return add_error_msg(accumulated_msgs, "Line %d contains an incorrect decimal value (%s)." % (line_no, decimal_string))
+        return add_error_msg(accumulated_msgs, "Line %d contains an incorrect decimal value (%s) for column %s." % (line_no, decimal_string, column))
 
 
 def validate_email(line_no, email, accumulated_msgs):
@@ -71,19 +71,21 @@
         if i == 0:
             # Skip the header.
             continue
+        # Keep 1-based line value for error messages.
+        line_no = i + 1
         line = line.rstrip("\r\n")
         if i > 97:
             accumulated_msgs = add_error_msg(accumulated_msgs, "The input file contains more than 97 lines (must be 1 header line and no more than 96 data lines).")
             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 32)." % (i, len(items)))
+            accumulated_msgs = add_error_msg(accumulated_msgs, "Line %d contains %s columns, (must be 32)." % (line_no, len(items)))
             stop_error(accumulated_msgs)
         # Required and validated.
         # Required.
         user_specimen_id = items[0]
         if len(user_specimen_id) == 0:
-            accumulated_msgs = empty_value(i, "user_specimen_id", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "user_specimen_id", accumulated_msgs)
         # Optional.
         field_call = items[1]
         # Optional.
@@ -93,82 +95,82 @@
         # Required.
         reef = items[4]
         if len(reef) == 0:
-            accumulated_msgs = empty_value(i, "reef", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "reef", accumulated_msgs)
         # Required.
         region = items[5]
         if len(region) == 0:
-            accumulated_msgs = empty_value(i, "region", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "region", accumulated_msgs)
         # Required and validated.
         latitude = items[6]
-        accumulated_msgs = validate_decimal(i, latitude, accumulated_msgs)
+        accumulated_msgs = validate_decimal(line_no, latitude, "latitude", accumulated_msgs)
         # Required and validated.
         longitude = items[7]
-        accumulated_msgs = validate_decimal(i, longitude, accumulated_msgs)
+        accumulated_msgs = validate_decimal(line_no, longitude, "longitude", accumulated_msgs)
         # Optional.
         geographic_origin = items[8]
         # Optional.
-        sample_location = items[9]
+        colony_location = items[9]
         # Optional.
-        latitude_outplant = items[10]
+        depth = items[10]
         # Optional.
-        longitude_outplant = items[11]
+        disease_resist = items[11]
         # Optional.
-        depth = items[12]
-        # Optional.
-        disease_resist = items[13]
+        bleach_resist = items[12]
         # Optional.
-        bleach_resist = items[14]
+        mortality = items[13]
         # Optional.
-        mortality = items[15]
+        tle = items[14]
         # Optional.
-        tle = items[16]
-        # Optional.
-        spawning = string_as_boolean_string(items[17])
+        spawning = string_as_boolean_string(items[15])
         # Required.
-        collector_last_name = items[18]
+        collector_last_name = items[16]
         if len(collector_last_name) == 0:
-            accumulated_msgs = empty_value(i, "collector_last_name", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "collector_last_name", accumulated_msgs)
         # Required.
-        collector_first_name = items[19]
+        collector_first_name = items[17]
         if len(collector_first_name) == 0:
-            accumulated_msgs = empty_value(i, "collector_first_name", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "collector_first_name", accumulated_msgs)
         # Required.
-        org = items[20]
+        org = items[18]
         if len(org) == 0:
-            accumulated_msgs = empty_value(i, "org", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "org", accumulated_msgs)
         # Required and validated.
-        collection_date = items[21]
-        accumulated_msgs = validate_date_string(i, collection_date, accumulated_msgs)
+        collection_date = items[19]
+        accumulated_msgs = validate_date_string(line_no, collection_date, "collection_date", accumulated_msgs)
         # Required and validated.
-        contact_email = items[22]
-        accumulated_msgs = validate_email(i, contact_email, accumulated_msgs)
+        contact_email = items[20]
+        accumulated_msgs = validate_email(line_no, contact_email, accumulated_msgs)
         # Required.
-        seq_facility = items[23]
+        seq_facility = items[21]
         if len(seq_facility) == 0:
-            accumulated_msgs = empty_value(i, "seq_facility", accumulated_msgs)
+            accumulated_msgs = empty_value(line_no, "seq_facility", accumulated_msgs)
         # Optional.
-        array_version = items[24]
+        array_version = items[22]
         # Optional.
-        public = string_as_boolean_string(items[25])
+        public = string_as_boolean_string(items[23])
         # Optional.
-        public_after_date = items[26]
-        accumulated_msga = validate_date_string(i, public_after_date, accumulated_msgs)
+        public_after_date = items[24]
+        accumulated_msga = validate_date_string(line_no, public_after_date, "public_after_date", accumulated_msgs)
         # Required and validated.
-        sperm_motility = items[27]
-        accumulated_msgs = validate_decimal(i, sperm_motility, accumulated_msgs)
+        sperm_motility = items[25]
+        accumulated_msgs = validate_decimal(line_no, sperm_motility, "sperm_motility", accumulated_msgs)
         # Required and validated.
-        healing_time = items[28]
-        accumulated_msgs = validate_decimal(i, healing_time, accumulated_msgs)
+        healing_time = items[26]
+        accumulated_msgs = validate_decimal(line_no, healing_time, "healing_time", accumulated_msgs)
         # Optional.
-        dna_extraction_method = items[29]
+        dna_extraction_method = items[27]
         # Optional.
-        dna_concentration = items[30]
+        dna_concentration = items[28]
         # 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)
+            accumulated_msgs = validate_decimal(line_no, dna_concentration, "dna_concentration", accumulated_msgs)
+        # Optional.
+        registry_id = items[29]
         # Optional.
-        registry_id = items[31]
-       
+        result_folder_name = items[30]
+        # Optional.
+        plate_barcode = items[31]
+
 
 if len(accumulated_msgs) > 0:
     stop_error(accumulated_msgs)
--- a/validate_affy_metadata.xml	Tue Apr 23 08:57:13 2019 -0400
+++ b/validate_affy_metadata.xml	Thu Aug 15 13:15:22 2019 -0400
@@ -37,9 +37,7 @@
  * latitude
  * longitude
  * geographic_origin
- * sample_location
- * latitude_outplant
- * longitude_outplant
+ * colony_location
  * depth
  * disease_resist
  * bleach_resist
@@ -60,8 +58,18 @@
  * dna_extraction_method
  * dna_concentration
  * registry_id
+ * result_folder_name
+ * plate_barcode
     </help>
     <citations>
+        <citation type="bibtex">
+            @misc{None,
+            journal = {None},
+            author = {Baums I},
+            title = {Manuscript in preparation},
+            year = {None},
+            url = {http://baumslab.org}
+        </citation>
     </citations>
 </tool>