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

37 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_phylum = "Bacillota"

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
14906019	14906019	PRJNA900999_S_NODE_1532_length_298_cov_4.312268_g1476_i0	PRJNA900999	1532	298	4.312268	12.85055864	Peptoniphilus	162289	Bacteria	Bacteria	144	3.77e-41	NR	WP_023059544.1	162289	g1476	i0	94.6	0.74496644295302	74	4	74.5	0	61	282	1	74	WP_023059544.1 MULTISPECIES: adenylate kinase [Peptoniphilus]	diamond	222	144	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus
16180838	16180838	PRJNA900999_S_NODE_6893_length_173_cov_2.312500_g6837_i0	PRJNA900999	6893	173	2.3125	4.000625	Anaerococcus sp.	1872515	Bacteria	Bacteria	103	1.85e-24	NR	WP_316116052.1	1872515	g6837	i0	89.5	0.988439306358382	57	6	98.8	0	173	3	344	400	WP_316116052.1 histidine--tRNA ligase [Anaerococcus sp.]	diamond	171	103	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp.
18729532	18729532	PRJNA900999_S_NODE_6755_length_174_cov_3.862069_g6699_i0	PRJNA900999	6755	174	3.862069	6.72000006	Anaerococcus	165779	Bacteria	Bacteria	113	3.9999999999999994e-28	NR	WP_117521007.1	165779	g6699	i0	100	4.91379310344828	57	0	98.3	0	2	172	122	178	WP_117521007.1 MULTISPECIES: GTPase HflX [Anaerococcus]	diamond	855	113	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
21280019	21280019	PRJNA900999_S_NODE_4077_length_212_cov_4.196721_g4021_i0	PRJNA900999	4077	212	4.196721	8.89704852	Anaerococcus	165779	Bacteria	Bacteria	133	6.44e-36	NR	WP_044566810.1	938293	g4021	i0	97.1	3.91981132075472	69	2	97.6	0	212	6	264	332	WP_044566810.1 electron transfer flavoprotein subunit alpha/FixB family protein [Anaerococcus provencensis]	diamond	831	134	0.992537313432836	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus provencensis
27024146	27024146	PRJNA900999_S_NODE_8082_length_162_cov_2.526316_g8026_i0	PRJNA900999	8082	162	2.526316	4.09263192	Anaerococcus nagyae	1755241	Bacteria	Bacteria	79.7	6.63e-16	NR	WP_209813824.1	1755241	g8026	i0	84.9	0.981481481481482	53	8	98.1	0	159	1	1	53	WP_209813824.1 CAMP factor family pore-forming toxin [Anaerococcus nagyae]	diamond	159	79.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
27055928	27055928	PRJNA900999_S_NODE_8642_length_158_cov_2.325581_g8586_i0	PRJNA900999	8642	158	2.325581	3.67441798	Peptostreptococcaceae bacterium AS15	936556	Bacteria	Bacteria	95.9	2.22e-21	NR	EJP25705.1	936556	g8586	i0	96	0.949367088607595	50	2	94.9	0	158	9	502	551	EJP25705.1 copper amine oxidase N-terminal domain protein [Peptostreptococcaceae bacterium AS15]	diamond	150	95.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium AS15
27182070	27182070	PRJNA900999_S_NODE_5202_length_193_cov_2.195122_g5146_i0	PRJNA900999	5202	193	2.195122	4.23658546	Eubacteriales bacterium ADMFC1	3385205	Bacteria	Bacteria	44.3	0.00522	NR	BFT87135.1	3385205	g5146	i0	57.6	1.0259067357513	33	14	51.3	0	188	90	213	245	BFT87135.1 hypothetical protein ADMFC1_12130 [Eubacteriales bacterium ADMFC1]	diamond	198	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium ADMFC1
27213664	27213664	PRJNA900999_S_NODE_6222_length_180_cov_3.695364_g6166_i0	PRJNA900999	6222	180	3.695364	6.6516552	Clostridium rhizosphaerae	2803861	Bacteria	Bacteria	124	4.2799999999999994e-31	NR	WP_202748846.1	2803861	g6166	i0	95	1	60	3	100	0	180	1	640	699	WP_202748846.1 transglutaminase-like domain-containing protein [Clostridium rhizosphaerae]	diamond	180	124	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium rhizosphaerae
27498325	27498325	PRJNA900999_S_NODE_6003_length_183_cov_2.207792_g5947_i0	PRJNA900999	6003	183	2.207792	4.04025936	Ezakiella sp.	1935205	Bacteria	Bacteria	77	1.41e-14	NR	WP_321137531.1	1935205	g5947	i0	61.7	0.983606557377049	60	23	98.4	0	180	1	646	705	WP_321137531.1 S-layer homology domain-containing protein [Ezakiella sp.]	diamond	180	77	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella sp.
27529756	27529756	PRJNA900999_S_NODE_3383_length_227_cov_12.868687_g3327_i0	PRJNA900999	3383	227	12.868687	29.21191949	Compostibacillus humi	1245525	Bacteria	Bacteria	44.7	7.41e-4	NR	GGH72047.1	1245525	g3327	i0	48.8	0.541850220264317	41	21	54.2	0	87	209	8	48	GGH72047.1 hypothetical protein GCM10010978_08600 [Compostibacillus humi]	diamond	123	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Compostibacillus	Compostibacillus humi
27561134	27561134	PRJNA900999_S_NODE_7664_length_165_cov_6.470588_g7608_i0	PRJNA900999	7664	165	6.470588	10.6764702	Tissierellia bacterium KA	2049431	Bacteria	Bacteria	90.5	1.87e-19	NR	KXB44343.1	1588751	g7608	i0	97.9	0.854545454545454	47	1	85.5	0	143	3	14	60	KXB44343.1 hypothetical protein HMPREF3188_01238 [Tissierellia bacterium KA00581]	diamond	141	90.5	1	Bacteria	Bacillati	Bacillota	Tissierellia				Tissierellia bacterium KA00581
27908381	27908381	PRJNA900999_S_NODE_7725_length_165_cov_2.625000_g7669_i0	PRJNA900999	7725	165	2.625	4.33125	Johnsonella ignava	43995	Bacteria	Bacteria	67.4	2.03e-13	NR	WP_005541618.1	43995	g7669	i0	66.7	0.872727272727273	48	16	87.3	0	3	146	2	49	WP_005541618.1 hypothetical protein [Johnsonella ignava]	diamond	144	67.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Johnsonella	Johnsonella ignava
28255848	28255848	PRJNA900999_S_NODE_4186_length_210_cov_2.944751_g4130_i0	PRJNA900999	4186	210	2.944751	6.1839771	Clostridium subterminale	1550	Bacteria	Bacteria	97.4	4.71e-22	NR	WP_343825098.1	1550	g4130	i0	94.7	0.814285714285714	57	3	81.4	0	209	39	176	232	WP_343825098.1 NlpC/P60 family protein [Clostridium subterminale]	diamond	171	97.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium subterminale
28319081	28319081	PRJNA900999_S_NODE_6986_length_172_cov_2.300699_g6930_i0	PRJNA900999	6986	172	2.300699	3.95720228	Tissierellia bacterium KA	2049431	Bacteria	Bacteria	72.4	5e-13	NR	KXB44868.1	1588751	g6930	i0	78.6	0.976744186046512	56	12	97.7	0	172	5	652	707	KXB44868.1 signal peptide protein, YSIRK family, partial [Tissierellia bacterium KA00581]	diamond	168	72.4	1	Bacteria	Bacillati	Bacillota	Tissierellia				Tissierellia bacterium KA00581
28666543	28666543	PRJNA900999_S_NODE_6767_length_174_cov_3.413793_g6711_i0	PRJNA900999	6767	174	3.413793	5.93999982	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	115	2.85e-29	NR	RKW32263.1	1898203	g6711	i0	100	0.982758620689655	57	0	98.3	0	173	3	255	311	RKW32263.1 MAG: electron transfer flavoprotein subunit alpha/FixB family protein [Lachnospiraceae bacterium]	diamond	171	115	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28729638	28729638	PRJNA900999_S_NODE_3367_length_228_cov_2.512563_g3311_i0	PRJNA900999	3367	228	2.512563	5.72864364	Desnuesiella massiliensis	1650662	Bacteria	Bacteria	50.4	3.92e-5	NR	WP_055666505.1	1650662	g3311	i0	72.4	0.381578947368421	29	8	38.2	0	102	16	35	63	WP_055666505.1 DUF3793 family protein [Desnuesiella massiliensis]	diamond	87	50.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Desnuesiella	Desnuesiella massiliensis
28768687	28768687	PRJNA900999_S_NODE_1667_length_291_cov_3.522901_g1611_i0	PRJNA900999	1667	291	3.522901	10.25164191	Anaerococcus	165779	Bacteria	Bacteria	125	5.22e-31	NR	WP_115595882.1	54007	g1611	i0	94.4	2.19587628865979	71	4	73.2	0	290	78	3	73	WP_115595882.1 GA module-containing protein [Anaerococcus octavius]	diamond	639	125	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus octavius
28887326	28887326	PRJNA900999_S_NODE_5908_length_184_cov_2.709677_g5852_i0	PRJNA900999	5908	184	2.709677	4.98580568	Peptostreptococcus stomatis	341694	Bacteria	Bacteria	113	1.58e-29	NR	WP_314961233.1	341694	g5852	i0	100	0.994565217391304	61	0	99.5	0	184	2	78	138	WP_314961233.1 PASTA domain-containing protein [Peptostreptococcus stomatis]	diamond	183	113	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus	Peptostreptococcus stomatis
28918841	28918841	PRJNA900999_S_NODE_6148_length_181_cov_2.881579_g6092_i0	PRJNA900999	6148	181	2.881579	5.21565799	Anaerococcus nagyae	1755241	Bacteria	Bacteria	63.9	5.5e-10	NR	WP_209814756.1	1755241	g6092	i0	82.5	0.662983425414365	40	7	66.3	0	148	29	872	911	WP_209814756.1 FIVAR domain-containing protein [Anaerococcus nagyae]	diamond	120	63.9	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
29077068	29077068	PRJNA900999_S_NODE_2248_length_264_cov_3.344681_g2192_i0	PRJNA900999	2248	264	3.344681	8.82995784	Anaerococcus ihuae	2899519	Bacteria	Bacteria	109	7.59e-29	NR	WP_236786657.1	2899519	g2192	i0	98.2	0.647727272727273	57	1	64.8	0	85	255	1	57	WP_236786657.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Anaerococcus ihuae]	diamond	171	109	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus ihuae
29266150	29266150	PRJNA900999_S_NODE_1649_length_292_cov_3.604563_g1593_i0	PRJNA900999	1649	292	3.604563	10.52532396	Lachnoanaerobaculum saburreum	467210	Bacteria	Bacteria	90.9	9.04e-21	NR	WP_008755312.1	467210	g1593	i0	97.7	0.441780821917808	43	1	44.2	0	233	105	77	119	WP_008755312.1 CBO2463/CBO2479 domain-containing protein [Lachnoanaerobaculum saburreum]	diamond	129	90.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum saburreum
29266151	29266151	PRJNA900999_S_NODE_3369_length_228_cov_2.341709_g3313_i0	PRJNA900999	3369	228	2.341709	5.33909652	Anaerococcus	165779	Bacteria	Bacteria	141	3.4099999999999998e-40	NR	WP_106460808.1	165779	g3313	i0	95.7	2.76315789473684	70	3	92.1	0	226	17	150	219	WP_106460808.1 MULTISPECIES: response regulator transcription factor [Anaerococcus]	diamond	630	141	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
29361122	29361122	PRJNA900999_S_NODE_3009_length_237_cov_6.711538_g2953_i0	PRJNA900999	3009	237	6.711538	15.90634506	Eubacterium ventriosum ATCC 2756	39496	Bacteria	Bacteria	51.2	2.21e-6	NR	EDM52309.1	411463	g2953	i0	49.2	0.79746835443038	63	30	79.7	2	29	217	10	70	EDM52309.1 hypothetical protein EUBVEN_00519 [Eubacterium ventriosum ATCC 27560]	diamond	189	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ventriosum
29937149	29937149	PRJNA900999_S_NODE_3531_length_224_cov_3.671795_g3475_i0	PRJNA900999	3531	224	3.671795	8.2248208	Peptoniphilus	162289	Bacteria	Bacteria	144	5.7e-38	NR	WP_010245699.1	1175452	g3475	i0	98.6	1.95535714285714	73	1	97.8	0	3	221	38	110	WP_010245699.1 pilin N-terminal domain-containing protein [Peptoniphilus rhinitidis]	diamond	438	145	0.993103448275862	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis
30150378	30150378	PRJNA900999_S_NODE_3712_length_219_cov_455.547368_g3656_i0	PRJNA900999	3712	219	455.547368	997.64873592	uncultured Anaerococcus sp.	293428	Bacteria	Bacteria	55.8	8.87e-8	NR	WP_299035044.1	293428	g3656	i0	70.7	0.561643835616438	41	12	56.2	0	124	2	1	41	WP_299035044.1 FMN-binding protein [uncultured Anaerococcus sp.]	diamond	123	55.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	uncultured Anaerococcus sp.
30948314	30948314	PRJNA900999_S_NODE_2994_length_238_cov_1.913876_g2938_i0	PRJNA900999	2994	238	1.913876	4.55502488	Eubacteriales	186802	Bacteria	Bacteria	55.5	1.17e-6	NR	WP_014312914.1	755731	g2938	i0	40.6	6.5672268907563	64	38	80.7	0	7	198	607	670	WP_014312914.1 tail fiber domain-containing protein [Clostridium sp. BNL1100]	diamond	1563	55.8	0.99462365591397806	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. BNL1100
31200436	31200436	PRJNA900999_S_NODE_2795_length_244_cov_3.851163_g2739_i0	PRJNA900999	2795	244	3.851163	9.39683772	Anaerocolumna	1843210	Bacteria	Bacteria	114	2.24e-27	NR	WP_185255493.1	1727145	g2739	i0	87.9	4.08196721311475	66	8	81.1	0	203	6	1	66	WP_185255493.1 DUF4097 family beta strand repeat-containing protein [Anaerocolumna chitinilytica]	diamond	996	114	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna chitinilytica
31264148	31264148	PRJNA900999_S_NODE_6515_length_176_cov_572.945578_g6459_i0	PRJNA900999	6515	176	572.945578	1008.38421728	Bacillota	1239	Bacteria	Bacteria	51.2	6.98e-7	NR	WP_407820324.1	1280	g6459	i0	64.1	2.71022727272727	39	14	66.5	0	150	34	11	49	WP_407820324.1 50S ribosomal protein L21, partial [Staphylococcus aureus]	diamond	477	51.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31288030	31288030	PRJNA900999_S_NODE_7075_length_171_cov_2.640845_g7019_i0	PRJNA900999	7075	171	2.640845	4.51584495	Finegoldia magna	1260	Bacteria	Bacteria	77.4	2.13e-17	NR	WP_004167030.1	1260	g7019	i0	97	0.578947368421053	33	1	57.9	0	169	71	12	44	WP_004167030.1 lachnocin family radical SAM-modified peptide [Finegoldia magna]	diamond	99	77.4	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
31446287	31446287	PRJNA900999_S_NODE_6576_length_176_cov_3.095238_g6520_i0	PRJNA900999	6576	176	3.095238	5.44761888	[Eubacterium] yurii	39498	Bacteria	Bacteria	70.5	2.5e-12	NR	SKC54698.1	39498	g6520	i0	80	2.30113636363636	45	8	76.7	1	174	40	509	552	SKC54698.1 von Willebrand factor type A domain-containing protein [[Eubacterium] yurii]	diamond	405	70.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Peptoanaerobacter	[Eubacterium] yurii
31889021	31889021	PRJNA900999_S_NODE_7837_length_164_cov_2.607407_g7781_i0	PRJNA900999	7837	164	2.607407	4.27614748	Eubacterium plexicaudatum ASF492	1235802	Bacteria	Bacteria	71.2	1.12e-12	NR	KAI4448712.1	1235802	g7781	i0	81.1	1.31707317073171	37	7	67.7	0	111	1	1	37	KAI4448712.1 Beta-galactosidase [Eubacterium plexicaudatum ASF492]	diamond	216	71.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium plexicaudatum
32395467	32395467	PRJNA900999_S_NODE_2439_length_256_cov_10.167401_g2383_i0	PRJNA900999	2439	256	10.167401	26.02854656	Blautia obeum ATCC 29174	411459	Bacteria	Bacteria	42.4	0.0455	NR	EDM87878.1	411459	g2383	i0	64	0.29296875	25	9	29.3	0	40	114	153	177	EDM87878.1 hypothetical protein RUMOBE_01293 [Blautia obeum ATCC 29174]	diamond	75	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
32679306	32679306	PRJNA900999_S_NODE_4560_length_203_cov_2.885057_g4504_i0	PRJNA900999	4560	203	2.885057	5.85666571	Tissierellia bacterium	2049431	Bacteria	Bacteria	87.4	2.3e-18	NR	NLX62670.1	2049431	g4504	i0	76.4	0.812807881773399	55	11	78.3	1	160	2	109	163	NLX62670.1 type III-A CRISPR-associated RAMP protein Csm5 [Tissierellia bacterium]	diamond	165	87.4	1	Bacteria	Bacillati	Bacillota	Tissierellia				Tissierellia bacterium
32773941	32773941	PRJNA900999_S_NODE_4180_length_210_cov_3.762431_g4124_i0	PRJNA900999	4180	210	3.762431	7.9011051	Anaerococcus sp.	1872515	Bacteria	Bacteria	129	2.14e-36	NR	MDU4715506.1	1872515	g4124	i0	98.6	0.985714285714286	69	1	98.6	0	209	3	28	96	MDU4715506.1 YtxH domain-containing protein [Anaerococcus sp.]	diamond	207	129	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp.
32773942	32773942	PRJNA900999_S_NODE_6880_length_173_cov_2.916667_g6824_i0	PRJNA900999	6880	173	2.916667	5.04583391	Geobacillus vulcani	135517	Bacteria	Bacteria	43.1	0.0104	NR	WP_031408017.1	135517	g6824	i0	61.3	1.07514450867052	31	12	53.8	0	97	5	45	75	WP_031408017.1 DUF5309 domain-containing protein [Geobacillus vulcani]	diamond	186	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus vulcani
32805468	32805468	PRJNA900999_S_NODE_3160_length_233_cov_5.083333_g3104_i0	PRJNA900999	3160	233	5.083333	11.84416589	uncultured Anaerococcus sp.	293428	Bacteria	Bacteria	50.4	6.14e-5	NR	WP_297281514.1	293428	g3104	i0	41.9	0.952789699570815	74	42	95.3	1	223	2	170	242	WP_297281514.1 hypothetical protein [uncultured Anaerococcus sp.]	diamond	222	50.4	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	uncultured Anaerococcus sp.
32836941	32836941	PRJNA900999_S_NODE_8200_length_161_cov_2.803030_g8144_i0	PRJNA900999	8200	161	2.80303	4.5128783	Staphylococcus equorum	246432	Bacteria	Bacteria	86.7	3.74e-19	NR	MDN5602163.1	246432	g8144	i0	71.7	0.987577639751553	53	15	98.8	0	1	159	83	135	MDN5602163.1 hypothetical protein [Staphylococcus equorum]	diamond	159	86.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus equorum

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