metadata: contig_metadata: 37 rows where analysis = "diamond", bioproject = "PRJNA934332" and tax

37 rows where analysis = "diamond", bioproject = "PRJNA934332" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2185967	2185967	PRJNA934332_P_NODE_5922_length_278_cov_1.575610_g5835_i0	PRJNA934332	5922	278	1.57561	4.3801958	Bacteria	2	Bacteria	Bacteria	125	4.01e-31	NR	MDA9809519.1	2021391	g5835	i0	68.5	2.97841726618705	92	29	99.3	0	276	1	442	533	MDA9809519.1 urocanate hydratase [Flavobacteriales bacterium]	diamond	828	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
3461500	3461500	PRJNA934332_P_NODE_4803_length_302_cov_1.244541_g4716_i0	PRJNA934332	4803	302	1.244541	3.75851382	Prevotella sp.	59823	Bacteria	Bacteria	209	7.069999999999999e-66	NR	MBQ1582184.1	59823	g4716	i0	94	4.96688741721854	100	6	99.3	0	301	2	15	114	MBQ1582184.1 xylose isomerase [Prevotella sp.]	diamond	1500	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
13664211	13664211	PRJNA934332_P_NODE_5251_length_290_cov_1.419355_g5164_i0	PRJNA934332	5251	290	1.419355	4.1161295	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	185	3.959999999999999e-55	NR	HPH33174.1	1869212	g5164	i0	93.8	33.7551724137931	96	6	99.3	0	290	3	218	313	HPH33174.1 replication-associated recombination protein A [Chitinophagaceae bacterium]	diamond	9789	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
17488927	17488927	PRJNA934332_P_NODE_8074_length_250_cov_0.870056_g7987_i0	PRJNA934332	8074	250	0.870056	2.17514	Panacibacter microcysteis	2793269	Bacteria	Bacteria	167	1.97e-49	NR	WP_196988743.1	2793269	g7987	i0	97.6	12.948	83	2	99.6	0	2	250	52	134	WP_196988743.1 arsenite methyltransferase [Panacibacter microcysteis]	diamond	3237	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter microcysteis
19106821	19106821	PRJNA934332_P_NODE_5495_length_286_cov_1.248826_g5408_i0	PRJNA934332	5495	286	1.248826	3.57164236	Odoribacter sp.	1965233	Bacteria	Bacteria	116	6.86e-28	NR	MCC8174127.1	1965233	g5408	i0	60	8.95804195804196	95	36	99.7	1	286	2	20	112	MCC8174127.1 aminomethyl-transferring glycine dehydrogenase [Odoribacter sp.]	diamond	2562	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter sp.
21312685	21312685	PRJNA934332_P_NODE_5497_length_286_cov_1.211268_g5410_i0	PRJNA934332	5497	286	1.211268	3.46422648	Flavobacterium	237	Bacteria	Bacteria	130	6.32e-34	NR	WP_264542173.1	237	g5410	i0	71.3	0.986013986013986	94	27	98.6	0	3	284	251	344	WP_264542173.1 MULTISPECIES: LETM1-related biofilm-associated protein [Flavobacterium]	diamond	282	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium
26644885	26644885	PRJNA934332_P_NODE_7841_length_250_cov_0.870056_g7754_i0	PRJNA934332	7841	250	0.870056	2.17514	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	95.1	1.55e-20	NR	MFN4253882.1	2202734	g7754	i0	47	0.996	83	44	99.6	0	249	1	158	240	MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	249	95.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
26708105	26708105	PRJNA934332_P_NODE_4121_length_323_cov_1.164000_g4034_i0	PRJNA934332	4121	323	1.164	3.75972	Bacteroidota bacterium	1898104	Bacteria	Bacteria	91.7	3.84e-21	NR	MFM1913008.1	1898104	g4034	i0	53.8	2.38699690402477	93	43	86.4	0	323	45	15	107	MFM1913008.1 hypothetical protein [Bacteroidota bacterium]	diamond	771	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26905511	26905511	PRJNA934332_P_NODE_6621_length_266_cov_2.704663_g6534_i0	PRJNA934332	6621	266	2.704663	7.19440358	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	2.6299999999999998e-23	NR	WP_194111141.1	649104	g6534	i0	87.9	3.29323308270677	58	7	65.4	0	175	2	4	61	WP_194111141.1 SDR family NAD(P)-dependent oxidoreductase [Mucilaginibacter myungsuensis]	diamond	876	100	0.994	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter myungsuensis
26930078	26930078	PRJNA934332_P_NODE_9682_length_245_cov_0.895349_g9595_i0	PRJNA934332	9682	245	0.895349	2.19360505	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	72.8	9.31e-13	NR	MBU3658668.1	2021391	g9595	i0	92.3	1.43265306122449	39	3	47.8	0	244	128	399	437	MBU3658668.1 TolC family protein [Flavobacteriales bacterium]	diamond	351	72.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27182805	27182805	PRJNA934332_P_NODE_842_length_652_cov_3.412781_g761_i0	PRJNA934332	842	652	3.412781	22.25133212	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	54.3	3.31e-5	NR	MDC3318872.1	1871037	g761	i0	27.4	1.42638036809816	164	108	71.8	5	610	143	3	163	MDC3318872.1 ester cyclase [Flavobacteriaceae bacterium]	diamond	930	54.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
27253165	27253165	PRJNA934332_P_NODE_9103_length_247_cov_0.885057_g9016_i0	PRJNA934332	9103	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	84.7	6.42e-17	NR	MEM1327996.1	1898104	g9016	i0	56.3	3.82591093117409	80	34	97.2	1	240	1	211	289	MEM1327996.1 GMC family oxidoreductase N-terminal domain-containing protein [Bacteroidota bacterium]	diamond	945	84.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27348270	27348270	PRJNA934332_P_NODE_6263_length_273_cov_0.990000_g6176_i0	PRJNA934332	6263	273	0.99	2.7027	Bacteroidota	976	Bacteria	Bacteria	52.8	1.56e-5	NR	WP_396178804.1	239	g6176	i0	36.5	2.93406593406593	85	51	90.1	2	23	268	43	127	WP_396178804.1 trypsin-like peptidase domain-containing protein, partial [Flavobacterium sp.]	diamond	801	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
27348272	27348272	PRJNA934332_P_NODE_8863_length_248_cov_0.880000_g8776_i0	PRJNA934332	8863	248	0.88	2.1824	FCB group	1783270	Bacteria	Bacteria	46.6	0.00149	NR	HLB00673.1	1898104	g8776	i0	62.9	2.23790322580645	35	13	42.3	0	143	247	5	39	HLB00673.1 NAD-dependent deacylase [Bacteroidota bacterium]	diamond	555	47	0.991489361702128	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27846152	27846152	PRJNA934332_P_NODE_1924_length_440_cov_1.468665_g1837_i0	PRJNA934332	1924	440	1.468665	6.462126	Hymenobacter aquaticus	1867101	Bacteria	Bacteria	47.8	0.00369	NR	WP_135464422.1	1867101	g1837	i0	29.8	1.25454545454545	114	73	73.6	3	435	112	129	241	WP_135464422.1 DUF4397 domain-containing protein [Hymenobacter aquaticus]	diamond	552	47.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter aquaticus
27884841	27884841	PRJNA934332_P_NODE_3065_length_363_cov_0.813793_g2978_i0	PRJNA934332	3065	363	0.813793	2.95406859	Flavobacteriaceae	49546	Bacteria	Bacteria	152	1.59e-41	NR	WP_155034545.1	270914	g2978	i0	59.5	9.87603305785124	121	48	100	1	1	363	3	122	WP_155034545.1 acetyl-CoA hydrolase/transferase family protein [Myroides pelagicus]	diamond	3585	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides pelagicus
27979611	27979611	PRJNA934332_P_NODE_6805_length_263_cov_1.578947_g6718_i0	PRJNA934332	6805	263	1.578947	4.15263061	Bacteria	2	Bacteria	Bacteria	154	2.21e-41	NR	MBK9451934.1	1898104	g6718	i0	92	2.86311787072243	87	7	99.2	0	3	263	2107	2193	MBK9451934.1 HYR domain-containing protein [Bacteroidota bacterium]	diamond	753	155	0.993548387096774	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28098779	28098779	PRJNA934332_P_NODE_10765_length_242_cov_0.911243_g10678_i0	PRJNA934332	10765	242	0.911243	2.20520806	Cnuella takakiae	1302690	Bacteria	Bacteria	67.8	1.01e-12	NR	WP_143157264.1	1302690	g10678	i0	75.5	0.607438016528926	49	12	60.7	0	164	18	1	49	WP_143157264.1 hypothetical protein [Cnuella takakiae]	diamond	147	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Cnuella	Cnuella takakiae
28130576	28130576	PRJNA934332_P_NODE_11385_length_241_cov_0.916667_g11298_i0	PRJNA934332	11385	241	0.916667	2.20916747	Mucilaginibacter conchicola	2303333	Bacteria	Bacteria	131	2.02e-33	NR	WP_117392583.1	2303333	g11298	i0	82.3	0.983402489626556	79	14	98.3	0	1	237	494	572	WP_117392583.1 SusC/RagA family TonB-linked outer membrane protein [Mucilaginibacter conchicola]	diamond	237	131	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter conchicola
28162164	28162164	PRJNA934332_P_NODE_8325_length_249_cov_0.875000_g8238_i0	PRJNA934332	8325	249	0.875	2.17875	Sphingobacteriales bacterium JAD_PAG5	2044944	Bacteria	Bacteria	168	1.71e-51	NR	UPT67084.1	2982687	g8238	i0	89.2	1	83	9	100	0	249	1	10	92	UPT67084.1 MAG: SRPBCC domain-containing protein [Sphingobacteriales bacterium JAD_PAG50586_3]	diamond	249	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium JAD_PAG50586_3
28256574	28256574	PRJNA934332_P_NODE_7546_length_251_cov_0.865169_g7459_i0	PRJNA934332	7546	251	0.865169	2.17157419	Bacteroides sp.	29523	Bacteria	Bacteria	58.2	1.44e-7	NR	MBD5355844.1	29523	g7459	i0	46	0.752988047808765	63	34	75.3	0	13	201	53	115	MBD5355844.1 hypothetical protein [Bacteroides sp.]	diamond	189	58.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29582510	29582510	PRJNA934332_P_NODE_10730_length_242_cov_0.911243_g10643_i0	PRJNA934332	10730	242	0.911243	2.20520806	Ferruginibacter sp.	1940288	Bacteria	Bacteria	45.1	0.00543	NR	HQY19146.1	1940288	g10643	i0	38.3	1.48760330578512	60	34	70.7	1	60	230	220	279	HQY19146.1 hypothetical protein [Ferruginibacter sp.]	diamond	360	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
29589532	29589532	PRJNA934332_P_NODE_7070_length_258_cov_1.664865_g6983_i0	PRJNA934332	7070	258	1.664865	4.2953517	Bacteroidota	976	Bacteria	Bacteria	53.9	4.98e-6	NR	MDP4820824.1	2202734	g6983	i0	34.4	4.24418604651163	90	51	95.3	3	247	2	311	400	MDP4820824.1 hypothetical protein [Saprospiraceae bacterium]	diamond	1095	53.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29645568	29645568	PRJNA934332_P_NODE_5830_length_280_cov_1.285024_g5743_i0	PRJNA934332	5830	280	1.285024	3.5980672	Bacteroidia bacterium	2044936	Bacteria	Bacteria	72.4	1.96e-12	NR	MFN5319151.1	2044936	g5743	i0	100	0.792857142857143	37	0	39.6	0	168	278	1	37	MFN5319151.1 signal recognition particle protein [Bacteroidia bacterium]	diamond	222	72.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
29898720	29898720	PRJNA934332_P_NODE_7831_length_250_cov_1.305085_g7744_i0	PRJNA934332	7831	250	1.305085	3.2627125	Bacteroidota bacterium	1898104	Bacteria	Bacteria	109	3.78e-29	NR	MBL0342958.1	1898104	g7744	i0	80.3	1.668	71	12	85.2	1	37	249	1	69	MBL0342958.1 hypothetical protein [Bacteroidota bacterium]	diamond	417	109	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30088083	30088083	PRJNA934332_P_NODE_8932_length_247_cov_0.885057_g8845_i0	PRJNA934332	8932	247	0.885057	2.18609079	Haliscomenobacter hydrossis	2350	Bacteria	Bacteria	149	1.96e-41	NR	WP_013763792.1	2350	g8845	i0	93.3	1.82186234817814	75	5	91.1	0	2	226	334	408	WP_013763792.1 IscS subfamily cysteine desulfurase [Haliscomenobacter hydrossis]	diamond	450	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
30151105	30151105	PRJNA934332_P_NODE_8452_length_249_cov_0.875000_g8365_i0	PRJNA934332	8452	249	0.875	2.17875	Bacteroidota bacterium	1898104	Bacteria	Bacteria	80.1	2.75e-15	NR	MFM1913009.1	1898104	g8365	i0	45	0.963855421686747	80	44	96.4	0	247	8	275	354	MFM1913009.1 hypothetical protein [Bacteroidota bacterium]	diamond	240	80.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30158154	30158154	PRJNA934332_P_NODE_4972_length_297_cov_1.611607_g4885_i0	PRJNA934332	4972	297	1.611607	4.78647279	Pseudomonadati	3379134	Bacteria	Bacteria	84.7	1.29e-16	NR	HAC15454.1	1898104	g4885	i0	47.5	4.80808080808081	99	48	98	2	4	294	134	230	HAC15454.1 hypothetical protein [Bacteroidota bacterium]	diamond	1428	85.1	0.995299647473561	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30214397	30214397	PRJNA934332_P_NODE_9452_length_246_cov_0.890173_g9365_i0	PRJNA934332	9452	246	0.890173	2.18982558	Leyella stercorea	363265	Bacteria	Bacteria	162	1.1999999999999998e-44	NR	WP_007896870.1	363265	g9365	i0	100	1	82	0	100	0	246	1	194	275	WP_007896870.1 M13 family metallopeptidase [Leyella stercorea]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Leyella	Leyella stercorea
30783266	30783266	PRJNA934332_P_NODE_8734_length_248_cov_0.880000_g8647_i0	PRJNA934332	8734	248	0.88	2.1824	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	43.1	0.027	NR	MCB9201736.1	2021391	g8647	i0	61.5	0.314516129032258	26	10	31.5	0	4	81	193	218	MCB9201736.1 hypothetical protein [Flavobacteriales bacterium]	diamond	78	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30909783	30909783	PRJNA934332_P_NODE_6634_length_266_cov_1.595855_g6547_i0	PRJNA934332	6634	266	1.595855	4.2449743	Haliscomenobacter sp.	2717303	Bacteria	Bacteria	171	2.4e-51	NR	HPH21170.1	2717303	g6547	i0	88.6	1.98496240601504	88	10	99.2	0	2	265	15	102	HPH21170.1 peptidase M28 family protein [Haliscomenobacter sp.]	diamond	528	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter sp.
31162121	31162121	PRJNA934332_P_NODE_10815_length_242_cov_0.911243_g10728_i0	PRJNA934332	10815	242	0.911243	2.20520806	Bacteroidia bacterium	2044936	Bacteria	Bacteria	157	8.459999999999999e-43	NR	MCF8254012.1	2044936	g10728	i0	90	0.991735537190083	80	8	99.2	0	240	1	176	255	MCF8254012.1 AIPR family protein [Bacteroidia bacterium]	diamond	240	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
31225490	31225490	PRJNA934332_P_NODE_9535_length_246_cov_0.890173_g9448_i0	PRJNA934332	9535	246	0.890173	2.18982558	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	76.3	3.25e-16	NR	RYE01136.1	2044944	g9448	i0	57.4	0.829268292682927	68	29	82.9	0	25	228	1	68	RYE01136.1 MAG: AlpA family phage regulatory protein [Sphingobacteriales bacterium]	diamond	204	76.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
31707093	31707093	PRJNA934332_P_NODE_10657_length_243_cov_0.905882_g10570_i0	PRJNA934332	10657	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	44.7	0.00588	NR	MDI1323536.1	1872435	g10570	i0	37.5	10.5432098765432	64	35	74.1	2	241	62	8	70	MDI1323536.1 peroxiredoxin [Algoriphagus sp.]	diamond	2562	45.1	0.991130820399113	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp.
32016379	32016379	PRJNA934332_P_NODE_3618_length_340_cov_2.093633_g3531_i0	PRJNA934332	3618	340	2.093633	7.1183522	Bacteroidota bacterium	1898104	Bacteria	Bacteria	62.8	4.22e-9	NR	MEY4919463.1	1898104	g3531	i0	42.9	0.494117647058824	56	32	49.4	0	170	3	1	56	MEY4919463.1 hypothetical protein [Bacteroidota bacterium]	diamond	168	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32023520	32023520	PRJNA934332_P_NODE_2798_length_377_cov_1.506579_g2711_i0	PRJNA934332	2798	377	1.506579	5.67980283	Pseudomonadati	3379134	Bacteria	Bacteria	67	5.35e-10	NR	HZH74317.1	1954475	g2711	i0	38.9	4.3289124668435	72	44	57.3	0	299	84	36	107	HZH74317.1 glutamine synthetase III [Mariniphaga sp.]	diamond	1632	67.4	0.99406528189911	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Mariniphaga	Mariniphaga sp.
32333206	32333206	PRJNA934332_P_NODE_9059_length_247_cov_0.885057_g8972_i0	PRJNA934332	9059	247	0.885057	2.18609079	Sphingobacteriales bacterium JAD_PAG5	2044944	Bacteria	Bacteria	99	6.879999999999999e-23	NR	UPT66023.1	2982687	g8972	i0	67.4	1.04453441295547	86	20	99.6	3	247	2	187	268	UPT66023.1 MAG: ParB/RepB/Spo0J family partition protein [Sphingobacteriales bacterium JAD_PAG50586_3]	diamond	258	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium JAD_PAG50586_3

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