GERA Metadata 2023

	A	B	C	D	E	G	H	J	K	M	N	P	Q
1	Isolates			Water/Sewage Collection		Vector Collection		Mosquitos		Weather		Weather Condition Code	Weather Condition
2	isolateID	MUST be unique and start with a letter, eg S001		collectionID	MUST be unique and start with a letter, eg C023	collectionID	MUST be unique and start with a letter, eg C023	collectionID	vector collection ID	time	Time	1	Clear
3	collectionID	from water/sewage collection metadata		sample_type	sample type, eg. Sewage, Ocean Water	organism_target		organismID	individual mosquito ID	temp	Temperature	2	Fair
4	date_banked	YYYY-MM-DD		site_location	site location, eg Baquerizo	collection_method		genus		dwpt	Dew Point	3	Cloudy
5	date_extracted	YYYY-MM-DD		site_latitude	latitude from EXIF	number_collected	number of organisms caught	species	if applicable	rhum	Relative Humidity	4	Overcast
6	date_plated	YYYY-MM-DD		site_longitude	longitude from EXIF	trap_set_date		gender		prcp	Total Precipitation	5	Fog
7	amc30_mm	zone of inibition diameter in mm		collection_date	YYYY-MM-DD	trap_set_time		image		snow	Snow Depth	6	Freezing Fog
8	azm15_mm	zone of inibition diameter in mm		collection_time	HH:MM in 24 Hr Time	trap_collection_date		batch_bagID	grouping ID based on genus	wdir	Wind Direction	7	Light Rain
9	fox30_mm	zone of inibition diameter in mm		name_collector	Full Name	trap_collection_time				wspd	Wind Speed	8	Rain
10	cro30_mm	zone of inibition diameter in mm		bags_collected	Number of bags	site_location	site location, eg Baquerizo			wpgt	Peak Gust	9	Heavy Rain
11	c30_mm	zone of inibition diameter in mm		date_last_rainfall	YYYY-MM-DD	site_latitude_deg	latitude degrees from EXIF			pres	Air Pressure	10	Freezing Rain
12	gm10_mm	zone of inibition diameter in mm		volume_extracted_ml	Volume in ml	site_latitude_min	latitude minutes from EXIF			tsun	Sunshine Duration	11	Heavy Freezing Rain
13	am10_mm	zone of inibition diameter in mm		date_plated	YYYY-MM-DD	site_latitude_sec	latitude second from EXIF			coco	Weather Condition Code	12	Sleet
14	mem10_mm	zone of inibition diameter in mm		plated_dilution	Dilution factor, eg 10 for 1:10 dilution	latitude_cardinal	latitude cardinal direction from EXIF			https://meteostat.net/en/station/84008		13	Heavy Sleet
15	s10_mm	zone of inibition diameter in mm		number_non_ecoli_coliforms	number of light blue colonies	site_longitude_deg	longitude degree from EXIF			https://vhrz669.hrz.uni-marburg.de/darwin/data_pre.do?citid=22		14	Light Snowfall
16	te30_mm	zone of inibition diameter in mm		number_ecoli	number of dark blue colonies	site_longitude_min	longitude minutes from EXIF			https://www.darwinfoundation.org/en/datazone/climate		15	Snowfall
17	sxt30_mm	zone of inibition diameter in mm		date_extracted	YYYY-MM-DD	site_longitude_sec	longitude seconds from EXIF					16	Heavy Snowfall
18	cip5_mm	zone of inibition diameter in mm		date_qpcr	YYYY-MM-DD	longitude_cardinal	longitude cardinal direction from EXIF					17	Rain Shower
19	date_quad_pcr	YYYY-MM-DD		qpcr_run_id	From Biomeme	attractants						18	Heavy Rain Shower
20	phylo_quad_arpA	phylotype quadroplex PCR band, yes or no		qpcr_sample_id	From Biomeme							19	Sleet Shower
21	phylo_quad_chuA	phylotype quadroplex PCR band, yes or no		qpcr_control_ct	From Biomeme							20	Heavy Sleet Shower
22	phylo_quad_yjaA	phylotype quadroplex PCR band, yes or no		qpcr_human_ct	From Biomeme							21	Snow Shower
23	phylo_quad_TspE4.C2	phylotype quadroplex PCR band, yes or no		qpcr_animal_ct	From Biomeme							22	Heavy Snow Shower
24	date_groupc_pcr	YYYY-MM-DD		notes	Free Text							23	Lightning
25	phylo_groupc_trpA	phylotype group c trpA band, yes or no		Site codes:								24	Hail
26	phylo_groupc_cont	phylotype group c control band, yes or no		T	Tijeretas							25	Thunderstorm
27	date_groupc_pcr	YYYY-MM-DD		L	Lobería							26	Heavy Thunderstorm
28	phylo_groupe_arpA	phylotype group e arpA band, yes or no		MAR	Playa de los Marinos							27	Storm
29	phylo_groupe_cont	phylotype group e control band, yes or no		P	Pier
30	notes	Free Text		ORO	Playa de Oro
31				MAN	Playa Mann
32				CP	Punta Carola Pipe
33				CB	Punta Carola Beach
34				PC	Puerto Chino
35				B	Baquerizo
36				TR	Tongo Reef
37
38
39
40
41
42	#	Column	Description
43	1	date	Date
44	2	tavg	Avg. Temperature
45	3	tmin	Min. Temperature
46	4	tmax	Max. Temperature
47	5	prcp	Total Precipitation
48	6	snow	Snow Depth
49	7	wdir	Wind Direction
50	8	wspd	Wind Speed
51	9	wpgt	Peak Gust
52	10	pres	Air Pressure
53	11	tsun	Sunshine Duration
54
55	https://meteostat.net/en/station/84008?t=2023-06-01/2023-07-31
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100