metadata: contig_metadata: 36 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

36 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
182829	182829	PRJNA1068830_P_NODE_43361_length_336_cov_1.186312_g42658_i0	PRJNA1068830	43361	336	1.186312	3.98600832	uncultured Helicobacter sp.	175537	Bacteria	Bacteria	181	1.51e-52	NR	WP_297814130.1	175537	g42658	i0	96.8	0.839285714285714	94	3	83.9	0	282	1	1	94	WP_297814130.1 type VI secretion system baseplate subunit TssK [uncultured Helicobacter sp.]	diamond	282	181	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	uncultured Helicobacter sp.
26782694	26782694	PRJNA1068830_P_NODE_73921_length_252_cov_0.871508_g73218_i0	PRJNA1068830	73921	252	0.871508	2.19620016	Helicobacter	209	Bacteria	Bacteria	94	4.7399999999999997e-23	NR	WP_115551819.1	209	g73218	i0	100	0.547619047619048	46	0	54.8	0	251	114	38	83	WP_115551819.1 MULTISPECIES: RNA-binding S4 domain-containing protein [Helicobacter]	diamond	138	94	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
27098913	27098913	PRJNA1068830_P_NODE_75362_length_251_cov_0.876404_g74659_i0	PRJNA1068830	75362	251	0.876404	2.19977404	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	43.5	0.00731	NR	WP_105925513.1	28198	g74659	i0	73.9	0.274900398406374	23	6	27.5	0	251	183	101	123	WP_105925513.1 hypothetical protein [Aliarcobacter cryaerophilus]	diamond	69	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
27320289	27320289	PRJNA1068830_P_NODE_55683_length_292_cov_1.068493_g54980_i0	PRJNA1068830	55683	292	1.068493	3.11999956	Helicobacter	209	Bacteria	Bacteria	189	2.5199999999999997e-56	NR	WP_300806490.1	209	g54980	i0	100	0.996575342465753	97	0	99.7	0	292	2	293	389	WP_300806490.1 MULTISPECIES: type VI secretion system domain-containing protein, partial [Helicobacter]	diamond	291	189	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
27604609	27604609	PRJNA1068830_P_NODE_76984_length_250_cov_0.881356_g76281_i0	PRJNA1068830	76984	250	0.881356	2.20339	Helicobacter ganmani	60246	Bacteria	Bacteria	42.4	0.0218	NR	WP_416829653.1	60246	g76281	i0	100	0.264	22	0	26.4	0	185	250	1	22	WP_416829653.1 nitrate- and nitrite sensing domain-containing protein, partial [Helicobacter ganmani]	diamond	66	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
27691100	27691100	PRJNA1068830_P_NODE_50764_length_307_cov_1.666667_g50061_i0	PRJNA1068830	50764	307	1.666667	5.11666769	Arcobacteraceae	2808963	Bacteria	Bacteria	110	5.77e-26	NR	WP_076082840.1	1850254	g50061	i0	59.1	6.29315960912052	93	37	89.9	1	30	305	333	425	WP_076082840.1 PhoH family protein [Poseidonibacter parvus]	diamond	1932	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter parvus
27754095	27754095	PRJNA1068830_P_NODE_88464_length_242_cov_0.923077_g87761_i0	PRJNA1068830	88464	242	0.923077	2.23384634	Nitratiruptor	269258	Bacteria	Bacteria	80.9	1.37e-15	NR	WP_370583958.1	2724897	g87761	i0	62.7	1.66115702479339	67	24	81.8	1	3	200	265	331	WP_370583958.1 NHL repeat-containing protein [Nitratiruptor sp. YY08-10]	diamond	402	80.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitratiruptor	Nitratiruptor sp. YY08-10
28069599	28069599	PRJNA1068830_P_NODE_87205_length_243_cov_0.917647_g86502_i0	PRJNA1068830	87205	243	0.917647	2.22988221	Helicobacter	209	Bacteria	Bacteria	102	3.5300000000000003e-26	NR	WP_301009253.1	209	g86502	i0	100	4.40740740740741	51	0	63	0	153	1	1	51	WP_301009253.1 MULTISPECIES: hypothetical protein [Helicobacter]	diamond	1071	102	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
28290488	28290488	PRJNA1068830_P_NODE_83946_length_245_cov_0.906977_g83243_i0	PRJNA1068830	83946	245	0.906977	2.22209365	Helicobacter	209	Bacteria	Bacteria	148	5.089999999999998e-41	NR	WP_115550714.1	60246	g83243	i0	100	2.97551020408163	81	0	99.2	0	245	3	27	107	WP_115550714.1 metallophosphoesterase [Helicobacter ganmani]	diamond	729	148	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
28393708	28393708	PRJNA1068830_P_NODE_19606_length_540_cov_2.616702_g18908_i0	PRJNA1068830	19606	540	2.616702	14.1301908	Campylobacter ureolyticus	827	Bacteria	Bacteria	46.6	0.0252	NR	WP_311337590.1	827	g18908	i0	30.6	1.23888888888889	121	66	62.2	3	461	126	197	308	WP_311337590.1 relaxase/mobilization nuclease domain-containing protein [Campylobacter ureolyticus]	diamond	669	46.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
28709681	28709681	PRJNA1068830_P_NODE_52087_length_303_cov_1.160870_g51384_i0	PRJNA1068830	52087	303	1.16087	3.5174361	Sulfurovum sp.	1969726	Bacteria	Bacteria	202	4.07e-60	NR	MDD3500783.1	1969726	g51384	i0	97	0.99009900990099	100	3	99	0	301	2	346	445	MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.]	diamond	300	202	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
28898794	28898794	PRJNA1068830_P_NODE_81088_length_247_cov_0.896552_g80385_i0	PRJNA1068830	81088	247	0.896552	2.21448344	Helicobacter	209	Bacteria	Bacteria	92.8	1.0300000000000001e-22	NR	WP_115552208.1	209	g80385	i0	95.7	0.57085020242915	47	2	57.1	0	143	3	1	47	WP_115552208.1 MULTISPECIES: FeoA family protein [Helicobacter]	diamond	141	92.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
29048549	29048549	PRJNA1068830_P_NODE_86408_length_243_cov_1.376471_g85705_i0	PRJNA1068830	86408	243	1.376471	3.34482453	Helicobacter	209	Bacteria	Bacteria	155	2.74e-45	NR	WP_301009432.1	209	g85705	i0	100	3.95061728395062	80	0	98.8	0	2	241	88	167	WP_301009432.1 MULTISPECIES: PAS domain-containing protein, partial [Helicobacter]	diamond	960	155	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
29056946	29056946	PRJNA1068830_P_NODE_74828_length_251_cov_1.747191_g74125_i0	PRJNA1068830	74828	251	1.747191	4.38544941	Campylobacter mucosalis	202	Bacteria	Bacteria	53.1	8.65e-6	NR	WP_169764606.1	202	g74125	i0	42.9	0.836653386454183	70	36	83.7	1	214	5	357	422	WP_169764606.1 AMP-binding protein [Campylobacter mucosalis]	diamond	210	53.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter mucosalis
29711091	29711091	PRJNA1068830_P_NODE_80990_length_247_cov_0.896552_g80287_i0	PRJNA1068830	80990	247	0.896552	2.21448344	Helicobacter	209	Bacteria	Bacteria	162	2.51e-47	NR	WP_290882045.1	218	g80287	i0	98.8	1.9919028340081	82	1	99.6	0	246	1	61	142	WP_290882045.1 hypothetical protein [Helicobacter sp.]	diamond	492	162	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
29932730	29932730	PRJNA1068830_P_NODE_37951_length_363_cov_1.493103_g37248_i0	PRJNA1068830	37951	363	1.493103	5.41996389	Campylobacter	194	Bacteria	Bacteria	57	7.29e-8	NR	EAJ2917428.1	195	g37248	i0	46.3	1.33884297520661	54	29	44.6	0	200	361	1	54	EAJ2917428.1 hypothetical protein [Campylobacter coli]	diamond	486	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
30288900	30288900	PRJNA1068830_P_NODE_57492_length_287_cov_1.355140_g56789_i0	PRJNA1068830	57492	287	1.35514	3.8892518	Helicobacter	209	Bacteria	Bacteria	186	1.89e-53	NR	WP_115552021.1	209	g56789	i0	98.9	0.993031358885017	95	1	99.3	0	1	285	270	364	WP_115552021.1 MULTISPECIES: asparagine synthase (glutamine-hydrolyzing) [Helicobacter]	diamond	285	186	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
30383708	30383708	PRJNA1068830_P_NODE_79433_length_248_cov_0.891429_g78730_i0	PRJNA1068830	79433	248	0.891429	2.21074392	Helicobacter ganmani	60246	Bacteria	Bacteria	163	2.43e-47	NR	WP_297600217.1	60246	g78730	i0	100	0.991935483870968	82	0	99.2	0	248	3	32	113	WP_297600217.1 glycosyltransferase family 2 protein [Helicobacter ganmani]	diamond	246	163	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
30415223	30415223	PRJNA1068830_P_NODE_25913_length_457_cov_1.015625_g25211_i0	PRJNA1068830	25913	457	1.015625	4.64140625	Helicobacter	209	Bacteria	Bacteria	129	3.76e-36	NR	WP_115551535.1	209	g25211	i0	95.3	0.420131291028446	64	3	42	0	207	16	1	64	WP_115551535.1 MULTISPECIES: hypothetical protein [Helicobacter]	diamond	192	129	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
30564122	30564122	PRJNA1068830_P_NODE_74213_length_252_cov_0.871508_g73510_i0	PRJNA1068830	74213	252	0.871508	2.19620016	Helicobacter	209	Bacteria	Bacteria	119	2.26e-33	NR	WP_300827224.1	209	g73510	i0	98.3	5.52380952380952	58	1	69	0	3	176	17	74	WP_300827224.1 MULTISPECIES: ATP-binding domain-containing protein [Helicobacter]	diamond	1392	120	0.991666666666667	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
30595856	30595856	PRJNA1068830_P_NODE_72533_length_253_cov_0.866667_g71830_i0	PRJNA1068830	72533	253	0.866667	2.19266751	Helicobacter	209	Bacteria	Bacteria	72.4	2.01e-14	NR	WP_300674629.1	209	g71830	i0	100	1.80237154150198	38	0	45.1	0	115	2	1	38	WP_300674629.1 MULTISPECIES: DUF520 family protein, partial [Helicobacter]	diamond	456	72.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
30793927	30793927	PRJNA1068830_P_NODE_44994_length_329_cov_1.218750_g44291_i0	PRJNA1068830	44994	329	1.21875	4.0096875	Helicobacter sp.	218	Bacteria	Bacteria	204	2.69e-59	NR	WP_290880637.1	218	g44291	i0	90.8	0.993920972644377	109	10	99.4	0	327	1	18	126	WP_290880637.1 hypothetical protein [Helicobacter sp.]	diamond	327	204	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
30825568	30825568	PRJNA1068830_P_NODE_30534_length_413_cov_1.147059_g29831_i0	PRJNA1068830	30534	413	1.147059	4.73735367	Helicobacter sp. UBA34	218	Bacteria	Bacteria	265	7.57e-88	NR	WP_301008717.1	1946588	g29831	i0	100	0.995157384987893	137	0	99.5	0	1	411	21	157	WP_301008717.1 TetR/AcrR family transcriptional regulator, partial [Helicobacter sp. UBA3407]	diamond	411	265	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. UBA3407
31015187	31015187	PRJNA1068830_P_NODE_71295_length_255_cov_1.241758_g70592_i0	PRJNA1068830	71295	255	1.241758	3.1664829	Helicobacter sp. MIT	218	Bacteria	Bacteria	72.4	9.56e-13	NR	WP_138121674.1	1548150	g70592	i0	85.7	0.494117647058824	42	6	49.4	0	225	100	272	313	WP_138121674.1 malate dehydrogenase [Helicobacter sp. MIT 05-5294]	diamond	126	72.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. MIT 05-5294
31047082	31047082	PRJNA1068830_P_NODE_35675_length_376_cov_1.646865_g34972_i0	PRJNA1068830	35675	376	1.646865	6.1922124	Sulfurovum sp.	1969726	Bacteria	Bacteria	160	9.3e-45	NR	MEN8718491.1	1969726	g34972	i0	80.6	1.48404255319149	93	18	74.2	0	376	98	322	414	MEN8718491.1 hypothetical protein [Sulfurovum sp.]	diamond	558	160	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
31268055	31268055	PRJNA1068830_P_NODE_74975_length_251_cov_1.353933_g74272_i0	PRJNA1068830	74975	251	1.353933	3.39837183	Aliarcobacter butzleri	28197	Bacteria	Bacteria	88.2	2.86e-20	NR	WP_260879532.1	28197	g74272	i0	60.7	0.729083665338645	61	24	72.9	0	249	67	63	123	WP_260879532.1 hypothetical protein [Aliarcobacter butzleri]	diamond	183	88.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
31299611	31299611	PRJNA1068830_P_NODE_32675_length_397_cov_0.870370_g31972_i0	PRJNA1068830	32675	397	0.87037	3.4553689	Helicobacter ganmani	60246	Bacteria	Bacteria	126	3.4399999999999996e-35	NR	WP_416860183.1	60246	g31972	i0	95.7	1.06549118387909	70	3	52.9	0	215	6	1	70	WP_416860183.1 hypothetical protein [Helicobacter ganmani]	diamond	423	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
31552958	31552958	PRJNA1068830_P_NODE_85076_length_244_cov_0.912281_g84373_i0	PRJNA1068830	85076	244	0.912281	2.22596564	Helicobacter	209	Bacteria	Bacteria	154	3.0699999999999992e-43	NR	WP_115551231.1	209	g84373	i0	100	1.9672131147541	80	0	98.4	0	5	244	1	80	WP_115551231.1 MULTISPECIES: amidohydrolase family protein [Helicobacter]	diamond	480	154	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
31639013	31639013	PRJNA1068830_P_NODE_34356_length_385_cov_1.346154_g33653_i0	PRJNA1068830	34356	385	1.346154	5.1826929	Helicobacter	209	Bacteria	Bacteria	254	2.12e-82	NR	WP_115551241.1	209	g33653	i0	100	1.97922077922078	127	0	99	0	383	3	87	213	WP_115551241.1 MULTISPECIES: endolytic transglycosylase MltG [Helicobacter]	diamond	762	254	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
31805690	31805690	PRJNA1068830_P_NODE_75397_length_251_cov_0.876404_g74694_i0	PRJNA1068830	75397	251	0.876404	2.19977404	Helicobacter	209	Bacteria	Bacteria	159	3.92e-45	NR	WP_297578836.1	209	g74694	i0	100	0.99203187250996006	83	0	99.2	0	250	2	195	277	WP_297578836.1 MULTISPECIES: aminoacetone oxidase family FAD-binding enzyme [Helicobacter]	diamond	249	159	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
31868880	31868880	PRJNA1068830_P_NODE_41617_length_344_cov_1.151292_g40914_i0	PRJNA1068830	41617	344	1.151292	3.96044448	Helicobacter	209	Bacteria	Bacteria	152	2.4799999999999993e-42	NR	WP_297599876.1	209	g40914	i0	100	0.680232558139535	78	0	68	0	2	235	299	376	WP_297599876.1 MULTISPECIES: glycosyltransferase family 4 protein [Helicobacter]	diamond	234	152	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
32249020	32249020	PRJNA1068830_P_NODE_57518_length_287_cov_1.275701_g56815_i0	PRJNA1068830	57518	287	1.275701	3.66126187	unclassified Campylobacter	2593542	Bacteria	Bacteria	95.1	9.09e-21	NR	WP_270862637.1	2593542	g56815	i0	52.6	3.97212543554007	95	45	99.3	0	285	1	244	338	WP_270862637.1 MULTISPECIES: DNA-methyltransferase [unclassified Campylobacter]	diamond	1140	95.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter
32312278	32312278	PRJNA1068830_P_NODE_66959_length_264_cov_2.026178_g66256_i0	PRJNA1068830	66959	264	2.026178	5.34910992	Helicobacter ganmani	60246	Bacteria	Bacteria	179	1.1399999999999999e-54	NR	WP_416860715.1	60246	g66256	i0	97.7	1	88	2	100	0	1	264	95	182	WP_416860715.1 AzlC family ABC transporter permease [Helicobacter ganmani]	diamond	264	179	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
32470403	32470403	PRJNA1068830_P_NODE_81979_length_246_cov_1.352601_g81276_i0	PRJNA1068830	81979	246	1.352601	3.32739846	Helicobacter sp. UBA34	218	Bacteria	Bacteria	73.2	7.14e-13	NR	WP_301008030.1	1946588	g81276	i0	97.1	0.426829268292683	35	1	42.7	0	1	105	401	435	WP_301008030.1 bifunctional UDP-N-acetylglucosamine diphosphorylase/glucosamine-1-phosphate N-acetyltransferase GlmU, partial [Helicobacter sp. UBA3407]	diamond	105	73.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. UBA3407
32596702	32596702	PRJNA1068830_P_NODE_78200_length_249_cov_0.886364_g77497_i0	PRJNA1068830	78200	249	0.886364	2.20704636	Campylobacter geochelonis	1780362	Bacteria	Bacteria	52.8	8.07e-7	NR	WP_075495202.1	1780362	g77497	i0	68.4	0.951807228915663	38	12	45.8	0	136	249	1	38	WP_075495202.1 acyl carrier protein [Campylobacter geochelonis]	diamond	237	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter geochelonis
32848432	32848432	PRJNA1068830_P_NODE_69760_length_258_cov_1.513514_g69057_i0	PRJNA1068830	69760	258	1.513514	3.90486612	Helicobacter sp. MIT 11-5569	1548151	Bacteria	Bacteria	125	2.09e-33	NR	WP_034287773.1	1548151	g69057	i0	86.8	1.58139534883721	68	9	79.1	0	3	206	190	257	WP_034287773.1 ferredoxin-type protein NapG [Helicobacter sp. MIT 11-5569]	diamond	408	125	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. MIT 11-5569

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);;