changeset 23:84478b80cc47 draft

Uploaded
author greg
date Fri, 15 Feb 2019 08:57:22 -0500
parents e5f68d7f238e
children 8a826d1afe69
files test-data/affy_metadata.tabular validate_affy_metadata.py validate_affy_metadata.xml
diffstat 3 files changed, 110 insertions(+), 100 deletions(-) [+]
line wrap: on
line diff
--- a/test-data/affy_metadata.tabular	Thu Feb 14 13:28:26 2019 -0500
+++ b/test-data/affy_metadata.tabular	Fri Feb 15 08:57:22 2019 -0500
@@ -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
-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,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		
--- a/validate_affy_metadata.py	Thu Feb 14 13:28:26 2019 -0500
+++ b/validate_affy_metadata.py	Fri Feb 15 08:57:22 2019 -0500
@@ -76,7 +76,7 @@
             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) != 30:
+        if len(items) != 32:
             accumulated_msgs = add_error_msg(accumulated_msgs, "Line %d contains %s columns, (must be 30)." % (i, len(items)))
             stop_error(accumulated_msgs)
         # Required and validated.
@@ -161,6 +161,14 @@
         # Required and validated.
         healing_time = items[29]
         accumulated_msgs = validate_decimal(i, healing_time, accumulated_msgs)
+        # Optional.
+        dna_extraction_method = items[9]
+        # Optional.
+        dna_concentration = items[31]
+        # 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)
+       
 
 if len(accumulated_msgs) > 0:
     stop_error(accumulated_msgs)
--- a/validate_affy_metadata.xml	Thu Feb 14 13:28:26 2019 -0500
+++ b/validate_affy_metadata.xml	Fri Feb 15 08:57:22 2019 -0500
@@ -6,7 +6,7 @@
 --output '$output']]></command>
     <inputs>
         <param name="input" type="data" format="tabular" label="Affymetrix 96 well plate metadata file">
-            <validator type="expression" message="96 well plate data must have 30 columns and no more than 96 lines of data"><![CDATA[value is not None and value.metadata.columns==30 and value.metadata.data_lines<=96]]></validator>
+            <validator type="expression" message="96 well plate data must have 32 columns and no more than 96 lines of data"><![CDATA[value is not None and value.metadata.columns==32 and value.metadata.data_lines<=96]]></validator>
         </param>
     </inputs>
     <outputs>
@@ -21,7 +21,7 @@
     <help>
 **What it does**
 
-Validates an Affymetrix metadata file for 96 well plate data.  These files consist of 30 columns and no more than 96 data lines.
+Validates an Affymetrix metadata file for 96 well plate data.  These files consist of 32 columns and no more than 96 data lines.
 The tool will output the input file if it is valid.
 
 -----
@@ -58,6 +58,8 @@
  * public_after_date
  * sperm_motility
  * healing_time
+ * dna_extraction_method
+ * dna_concentration
     </help>
     <citations>
     </citations>