metadata: contig_metadata: 35 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax

35 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Campylobacterota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
215905	215905	PRJNA1111146_P_NODE_216001_length_203_cov_1.493333_g214863_i0	PRJNA1111146	216001	203	1.493333	3.03146599	Campylobacter showae	204	Bacteria	Bacteria	298	2.06e-76	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g214863	i0	93.103	1.99507389162562	203	14	100	0	1	203	21802	22004	Campylobacter showae genome assembly, plasmid: V	blastn	405	298	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
1021750	1021750	PRJNA1111146_P_NODE_303721_length_186_cov_1.691729_g302583_i0	PRJNA1111146	303721	186	1.691729	3.1466159399999998	root	1	Root_unresolved	Root_unresolved	344	2.34e-90	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g302583	i0	100	113.639784946237	186	0	100	0	1	186	315320	315505	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	21137	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
1491605	1491605	PRJNA1111146_P_NODE_437962_length_177_cov_0.903226_g436824_i0	PRJNA1111146	437962	177	0.903226	1.59871002	Helicobacter mastomyrinus	287948	Bacteria	Bacteria	316	4.799999999999999e-82	NTclustered	gi\|2727596528\|gb\|CP145316.1\|	287948	g436824	i0	98.87	1.34463276836158	177	2	100	0	1	177	652952	653128	Helicobacter mastomyrinus strain Hm-17 chromosome, complete genome	blastn	238	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter mastomyrinus
2297582	2297582	PRJNA1111146_P_NODE_449282_length_167_cov_2.798246_g448144_i0	PRJNA1111146	449282	167	2.798246	4.67307082	Bacteria	2	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g448144	i0	98.795	19.8802395209581	166	2	99	0	1	166	4937	5102	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	3320	296	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
2767587	2767587	PRJNA1111146_P_NODE_437183_length_177_cov_0.911290_g436045_i0	PRJNA1111146	437183	177	0.91129	1.6129833	Campylobacter concisus	199	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g436045	i0	97.74	17.9774011299435	177	4	100	0	1	177	290687	290511	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	3182	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
4043086	4043086	PRJNA1111146_P_NODE_296484_length_187_cov_2.350746_g295346_i0	PRJNA1111146	296484	187	2.350746	4.39589502	Campylobacter concisus	199	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1938719709\|gb\|CP049264.1\|	199	g295346	i0	100	234.743315508021	187	0	100	0	1	187	656967	656781	Campylobacter concisus strain P11CDO-S1 chromosome, complete genome	blastn	43897	346	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6124481	6124481	PRJNA1111146_P_NODE_156245_length_218_cov_2.066667_g155107_i0	PRJNA1111146	156245	218	2.066667	4.50533406	Bacteria	2	Bacteria	Bacteria	372	1.3e-98	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g155107	i0	100	19.3623853211009	201	0	92	0	3	203	5259	5459	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	4221	372	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
6594321	6594321	PRJNA1111146_P_NODE_271186_length_192_cov_1.625899_g270048_i0	PRJNA1111146	271186	192	1.625899	3.12172608	Campylobacter showae	204	Bacteria	Bacteria	322	1.14e-83	NTclustered	gi\|1483583525\|emb\|LT631449.1\|	204	g270048	i0	96.875	4	192	6	100	0	1	192	669527	669336	Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I	blastn	768	322	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6594611	6594611	PRJNA1111146_P_NODE_336166_length_183_cov_0.876923_g335028_i0	PRJNA1111146	336166	183	0.876923	1.60476909	Campylobacter concisus	199	Bacteria	Bacteria	311	2.33e-80	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g335028	i0	97.268	16.879781420765	183	5	100	0	1	183	1094744	1094562	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	3089	311	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6594849	6594849	PRJNA1111146_P_NODE_390346_length_180_cov_0.881890_g389208_i0	PRJNA1111146	390346	180	0.88189	1.587402	Campylobacter rectus	203	Bacteria	Bacteria	274	2.99e-69	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g389208	i0	94.413	1.98888888888889	179	9	99	1	1	178	2520508	2520330	Campylobacter rectus strain ATCC 33238, complete genome	blastn	358	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
8675146	8675146	PRJNA1111146_P_NODE_332427_length_183_cov_1.684615_g331289_i0	PRJNA1111146	332427	183	1.684615	3.08284545	Bacteria	2	Bacteria	Bacteria	147	6.949999999999999e-31	NTclustered	gi\|2021360614\|gb\|MW854379.1\|	352960	g331289	i0	93	112.661202185792	100	7	55	0	39	138	91	190	Uncultured Campylobacterales bacterium clone DN1988 23S ribosomal RNA gene, partial sequence	blastn	20617	147	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			uncultured Campylobacterales bacterium
9144034	9144034	PRJNA1111146_P_NODE_322408_length_184_cov_1.122137_g321270_i0	PRJNA1111146	322408	184	1.122137	2.06473208	Campylobacter concisus	199	Bacteria	Bacteria	285	1.42e-72	NTclustered	gi\|1938719709\|gb\|CP049264.1\|	199	g321270	i0	94.565	12.7010869565217	184	10	100	0	1	184	1722809	1722626	Campylobacter concisus strain P11CDO-S1 chromosome, complete genome	blastn	2337	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10419885	10419885	PRJNA1111146_P_NODE_328889_length_184_cov_0.862595_g327751_i0	PRJNA1111146	328889	184	0.862595	1.5871748	Campylobacter ureolyticus	827	Bacteria	Bacteria	316	5.04e-82	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g327751	i0	97.814	3.9945652173913	183	4	99	0	1	183	1108703	1108885	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	735	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
12500838	12500838	PRJNA1111146_P_NODE_363090_length_181_cov_1.507812_g361952_i0	PRJNA1111146	363090	181	1.507812	2.72913972	Campylobacter	194	Bacteria	Bacteria	294	2.31e-75	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g361952	i0	96.133	3.94475138121547	181	5	100	2	1	181	1214854	1214676	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	714	294	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
13774888	13774888	PRJNA1111146_P_NODE_203171_length_206_cov_1.071895_g202033_i0	PRJNA1111146	203171	206	1.071895	2.2081037	Campylobacter	194	Bacteria	Bacteria	370	4.38e-98	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g202033	i0	99.029	150.684466019417	206	2	100	0	1	206	31194	30989	Campylobacter showae genome assembly, plasmid: V	blastn	31041	370	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
14244470	14244470	PRJNA1111146_P_NODE_126052_length_231_cov_0.943820_g124914_i0	PRJNA1111146	126052	231	0.94382	2.1802242	Campylobacter concisus	199	Bacteria	Bacteria	372	1.39e-98	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g124914	i0	95.671	12.8095238095238	231	10	100	0	1	231	1205081	1204851	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	2959	372	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15518452	15518452	PRJNA1111146_P_NODE_189273_length_208_cov_1.974194_g188135_i0	PRJNA1111146	189273	208	1.974194	4.10632352	Campylobacter ureolyticus	827	Bacteria	Bacteria	187	4.79e-43	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g188135	i0	99.038	3.06730769230769	104	1	98	0	1	104	431560	431457	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	638	187	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
15519178	15519178	PRJNA1111146_P_NODE_354193_length_182_cov_0.883721_g353055_i0	PRJNA1111146	354193	182	0.883721	1.60837222	Campylobacter concisus	199	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1935893765\|gb\|CP049234.1\|	199	g353055	i0	100	21.6373626373626	182	0	100	0	1	182	1810262	1810081	Campylobacter concisus strain P15UCO-S2 chromosome, complete genome	blastn	3938	337	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16793393	16793393	PRJNA1111146_P_NODE_287894_length_189_cov_1.566176_g286756_i0	PRJNA1111146	287894	189	1.566176	2.96007264	Campylobacter ureolyticus	827	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g286756	i0	94.18	2	189	11	100	0	1	189	921992	921804	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	378	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
16794100	16794100	PRJNA1111146_P_NODE_448034_length_169_cov_2.077586_g446896_i0	PRJNA1111146	448034	169	2.077586	3.51112034	Campylobacter ureolyticus	827	Bacteria	Bacteria	268	1.29e-67	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g446896	i0	95.266	3	169	8	100	0	1	169	665893	666061	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	507	268	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
17599635	17599635	PRJNA1111146_P_NODE_349394_length_182_cov_1.310078_g348256_i0	PRJNA1111146	349394	182	1.310078	2.38434196	FCB group	1783270	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g348256	i0	100	23.532967032967	182	0	100	0	1	182	4324	4143	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	4283	337	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
18067533	18067533	PRJNA1111146_P_NODE_201475_length_206_cov_1.411765_g200337_i0	PRJNA1111146	201475	206	1.411765	2.9082359	Campylobacter concisus	199	Bacteria	Bacteria	353	4.41e-93	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g200337	i0	97.573	17.9417475728155	206	5	100	0	1	206	1931755	1931960	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	3696	353	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
18068365	18068365	PRJNA1111146_P_NODE_394195_length_179_cov_1.777778_g393057_i0	PRJNA1111146	394195	179	1.777778	3.18222262	Campylobacter showae	204	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|1483583525\|emb\|LT631449.1\|	204	g393057	i0	98.883	11	179	2	100	0	1	179	16041	16219	Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I	blastn	1969	320	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
18873434	18873434	PRJNA1111146_P_NODE_30255_length_328_cov_2.476364_g29118_i0	PRJNA1111146	30255	328	2.476364	8.12247392	Campylobacter	194	Bacteria	Bacteria	584	2.459999999999999e-162	NTclustered	gi\|1938726479\|gb\|CP049270.1\|	199	g29118	i0	98.78	229.780487804878	328	4	100	0	1	328	1054521	1054194	Campylobacter concisus strain P26UCO-S2 chromosome, complete genome	blastn	75368	584	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19342412	19342412	PRJNA1111146_P_NODE_354476_length_182_cov_0.875969_g353338_i0	PRJNA1111146	354476	182	0.875969	1.59426358	Campylobacter fetus	196	Bacteria	Bacteria	331	1.7800000000000002e-86	NTclustered	gi\|1043914323\|gb\|CP014570.1\|	32020	g353338	i0	99.451	1	182	1	100	0	1	182	20478	20659	Campylobacter fetus subsp. venerealis strain 01/165 plasmid mp2, complete sequence	blastn	182	331	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
19342806	19342806	PRJNA1111146_P_NODE_434396_length_177_cov_0.919355_g433258_i0	PRJNA1111146	434396	177	0.919355	1.62725835	Campylobacter showae	204	Bacteria	Bacteria	300	4.84e-77	NTclustered	gi\|1483583493\|emb\|LT631417.1\|	204	g433258	i0	97.175	12	177	5	100	0	1	177	258561	258385	Campylobacter showae genome assembly, chromosome: I	blastn	2124	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
21424334	21424334	PRJNA1111146_P_NODE_77817_length_258_cov_1.541463_g76679_i0	PRJNA1111146	77817	258	1.541463	3.97697454	FCB group	1783270	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g76679	i0	100	86.6976744186046	258	0	100	0	1	258	6096	6353	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	22368	477	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
21893331	21893331	PRJNA1111146_P_NODE_358498_length_182_cov_0.868217_g357360_i0	PRJNA1111146	358498	182	0.868217	1.58015494	Campylobacter concisus	199	Bacteria	Bacteria	315	1.79e-81	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g357360	i0	97.814	18.1098901098901	183	3	100	1	1	182	992696	992514	Campylobacter concisus strain RMIT-O23 chromosome	blastn	3296	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21893372	21893372	PRJNA1111146_P_NODE_367098_length_181_cov_0.890625_g365960_i0	PRJNA1111146	367098	181	0.890625	1.61203125	Poseidonibacter lekithochrous	1904463	Bacteria	Bacteria	183	5.229999999999998e-42	NTclustered	gi\|1850313845\|gb\|CP054052.1\|	1904463	g365960	i0	85.714	4.94475138121547	175	23	96	2	2	175	436876	436703	Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome	blastn	895	183	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter lekithochrous
21893409	21893409	PRJNA1111146_P_NODE_371938_length_181_cov_0.882812_g370800_i0	PRJNA1111146	371938	181	0.882812	1.59788972	Campylobacter gracilis	824	Bacteria	Bacteria	252	1.41e-62	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g370800	i0	94.012	1.84530386740331	167	9	92	1	1	167	680945	681110	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	334	252	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
22698739	22698739	PRJNA1111146_P_NODE_285518_length_189_cov_2.272059_g284380_i0	PRJNA1111146	285518	189	2.272059	4.29419151	Campylobacter	194	Bacteria	Bacteria	60.2	9.69e-5	NTclustered	gi\|1919195970\|gb\|CP063088.1\|	201	g284380	i0	97.143	1.77777777777778	35	1	19	0	155	189	1268988	1268954	Campylobacter lari strain 2014D-0218 chromosome, complete genome	blastn	336	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
23168796	23168796	PRJNA1111146_P_NODE_340999_length_183_cov_0.869231_g339861_i0	PRJNA1111146	340999	183	0.869231	1.59069273	Campylobacter ureolyticus	827	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g339861	i0	100	6.10382513661202	183	0	100	0	1	183	1214608	1214426	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	1117	339	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
23169154	23169154	PRJNA1111146_P_NODE_410439_length_178_cov_1.776000_g409301_i0	PRJNA1111146	410439	178	1.776	3.16128	Campylobacter concisus	199	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|1935893765\|gb\|CP049234.1\|	199	g409301	i0	98.315	11.9606741573034	178	3	100	0	1	178	1023249	1023426	Campylobacter concisus strain P15UCO-S2 chromosome, complete genome	blastn	2129	313	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24442689	24442689	PRJNA1111146_P_NODE_389060_length_180_cov_0.889764_g387922_i0	PRJNA1111146	389060	180	0.889764	1.6015752	Campylobacter rectus	203	Bacteria	Bacteria	300	4.94e-77	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g387922	i0	96.667	2	180	6	100	0	1	180	2297467	2297646	Campylobacter rectus strain ATCC 33238, complete genome	blastn	360	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
24443167	24443167	PRJNA1111146_P_NODE_85040_length_253_cov_0.910000_g83902_i0	PRJNA1111146	85040	253	0.91	2.3023	Campylobacter concisus	199	Bacteria	Bacteria	396	9.209999999999997e-106	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g83902	i0	94.862	22.1936758893281	253	13	100	0	1	253	184871	185123	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	5615	396	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;