demo_dataset_errors_Jan_2022.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Database Identifiers												Sample collection and processing																															Host Information																	Host vaccination information					Host exposure information												Host reinfection information						Sequencing												Bioinformatics and QC metrics
2	specimen collector sample ID	third party lab service provider name	third party lab sample ID	case ID	Related specimen primary ID	IRIDA sample name	umbrella bioproject accession	bioproject accession	biosample accession	SRA accession	GenBank accession	GISAID accession	sample collected by	sample collector contact email	sample collector contact address	sequence submitted by	sequence submitter contact email	sequence submitter contact address	sample collection date	sample collection date precision	sample received date	geo_loc_name (country)	geo_loc_name (state/province/territory)	geo_loc_name (city)	organism	isolate	purpose of sampling	purpose of sampling details	NML submitted specimen type	Related specimen relationship type	anatomical material	anatomical part	body product	environmental material	environmental site	collection device	collection method	collection protocol	specimen processing	lab host	passage number	passage method	biomaterial extracted	host (common name)	host (scientific name)	host health state	host health status details	host health outcome	host disease	host age	host age unit	host age bin	host gender	host residence geo_loc name (country)	host residence geo_loc name (state/province/territory)	host subject ID	symptom onset date	signs and symptoms	pre-existing conditions and risk factors	complications	host vaccination status	vaccine name	number of vaccine doses received	first dose vaccination date	last dose vaccination date	location of exposure geo_loc name (country)	destination of most recent travel (city)	destination of most recent travel (state/province/territory)	destination of most recent travel (country)	most recent travel departure date	most recent travel return date	travel history	exposure event	exposure contact level	host role	exposure setting	exposure details	prior SARS-CoV-2 infection	prior SARS-CoV-2 infection isolate	prior SARS-CoV-2 infection date	prior SARS-CoV-2 antiviral treatment	prior SARS-CoV-2 antiviral treatment agent	prior SARS-CoV-2 antiviral treatment date	purpose of sequencing	purpose of sequencing details	sequencing date	library ID	amplicon size	library preparation kit	flow cell barcode	sequencing instrument	sequencing protocol name	sequencing protocol	sequencing kit number	amplicon pcr primer scheme	raw sequence data processing method	dehosting method	consensus sequence name	consensus sequence filename	consensus sequence filepath
3	abcd1234											EPI_ISL_436489	bccdc			BCCDC Public Health Laboratory			2021-12-15	day		Canada	British Columbia		Severe acute respiratory syndrome coronavirus 2	hCov-19/CANADA/BC-abcd1234/2021	Diagnostic testing	Not Provided	Not Applicable		Not Applicable	Nasopharynx (NP)	Not Applicable	Not Applicable	Not Applicable	Collection Container	Not Applicable								Homo sapiens				COVID-19	33		30 - 39	Female																															Baseline surveillance (random sampling)	Not Provided	2022-01-02		1200				Illumina NovaSeq 6000	Viral sequencing was performed according to a tiling amplicon strategy using the Freed (2020) amplicon scheme and an Illumina NovaSeq 6000 sequencing instrument.		Freed	not done	https://github.com/phac-nml/ncov-dehoster
4	abcd1235											EPI_ISL_436491	BCCDC Public Health Laboratory			BCCDC Public Health Laboratory			Dec 17 2021	day		Canada	British Columbia		Severe acute respiratory syndrome coronavirus 2	hCov-19/CANADA/BC-abcd1235/2021	Diagnostic testing	Not Provided	Not Applicable		Not Applicable	Oropharynx (OP)	Not Applicable	Not Applicable	Not Applicable	Swab	Not Applicable								Homo sapiens				COVID-19	67		60 - 69	Male																															Testing asymptomatic patients	Not Provided	2022-01-02		1200				Illumina NextSeq 550	Viral sequencing was performed according to a tiling amplicon strategy using the Freed (2020) amplicon scheme and an Illumina NextSeq 550 sequencing instrument.		Freed	BCCDC_filter_process_method 1.5.1	https://github.com/phac-nml/ncov-dehoster
5	abcd1236											EPI_ISL_555555	BCCDC Public Health Laboratory						2021-12-15	day		Canada	British Columbia		Severe acute respiratory syndrome coronavirus 2	hCov-19/CANADA/BC-abcd1236/2021	Diagnostic testing	Not Provided	Not Applicable		Not Applicable	Nasopharynx (NP)	Not Applicable	Not Applicable	Not Applicable	Swab	Not Applicable								Homo sapiens				COVID-19	89		80 - 89	Female																															Screening for Variants of Concern (VOC)	Not Provided	2022-01-02		1200				Illumina	Viral sequencing was performed according to a tiling amplicon strategy using the Freed (2020) amplicon scheme and an Illumina sequencing instrument.		Freed	BCCDC_filter_process_method 1.5.2	https://github.com/phac-nml/ncov-dehoster
6	abcd1237											EPI_ISL_888887	BCCDC Public Health Laboratory			BCCDC Public Health Laboratory			2022-12-21	day		Canada	British Columbia		Severe acute respiratory syndrome coronavirus 2	unknown	Diagnostic testing	Not Provided	Not Applicable		Not Applicable	Nasopharynx (NP)	Not Applicable	Not Applicable	Not Applicable	Swab	Not Applicable								Homo sapiens				COVID-19	11		10 - 19	Female																															Sample has epidemiological link to Omicron Variant	Not Provided	2022-01-02		2000				Illumina MiSeq	Viral sequencing was performed according to a tiling amplicon strategy using the Resende (2020) amplicon scheme and an Illumina MiSeq sequencing instrument.		Resende	Trimmomatic 0.38	https://github.com/phac-nml/ncov-dehoster
7	abcd1238												BCCDC Public Health Laboratory			BCCDC Public Health Laboratory			2021-12	day		Canada	BC		Severe acute respiratory syndrome coronavirus 2	not provided	Diagnostic testing	Not Provided	Not Applicable		Not Applicable	Not Applicable	Not Applicable	Not Applicable	Not Applicable	Not Applicable	salt water gargle								Human				COVID-19	Not Provided	Not Provided	30 - 39	Unknown																															Surveillance of international border crossing by air travel or ground transport	Airport testing	2022-01-02		NOT PROVIDED			Oxford Nanopore		Viral sequencing was performed according to a tiling amplicon strategy using the ARTIC V4 amplicon scheme and an Oxford Nanopore sequencing instrument.		ARTIC V4	https://github.com/phac-nml/ncov2019-artic-nf	Nanostripper 1.0
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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