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

37 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_clade = "PVC group"

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
26986236	26986236	PRJNA642647_P_NODE_4962_length_166_cov_2.961240_g4912_i0	PRJNA642647	4962	166	2.96124	4.9156584	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	53.5	1.83e-6	NR	HQX49920.1	2026779	g4912	i0	65.8	0.686746987951807	38	10	63.3	1	162	58	46	83	HQX49920.1 carbon-nitrogen hydrolase family protein [Planctomycetaceae bacterium]	diamond	114	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27713476	27713476	PRJNA642647_P_NODE_5644_length_160_cov_1.886179_g5594_i0	PRJNA642647	5644	160	1.886179	3.0178864	Opitutaceae bacterium	2006848	Bacteria	Bacteria	89.4	2.33e-20	NR	MBW7896562.1	2006848	g5594	i0	78.8	0.975	52	11	97.5	0	3	158	81	132	MBW7896562.1 hypothetical protein [Opitutaceae bacterium]	diamond	156	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28028934	28028934	PRJNA642647_P_NODE_6265_length_153_cov_0.905172_g6215_i0	PRJNA642647	6265	153	0.905172	1.38491316	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	74.3	7.15e-14	NR	HOX60287.1	2026799	g6215	i0	71.4	0.96078431372549	49	14	96.1	0	151	5	200	248	HOX60287.1 helicase-related protein [Verrucomicrobiota bacterium]	diamond	147	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28483183	28483183	PRJNA642647_P_NODE_3426_length_191_cov_2.246753_g3376_i0	PRJNA642647	3426	191	2.246753	4.29129823	PVC group	1783257	Bacteria	Bacteria	60.1	2.18e-9	NR	WP_088258631.1	1908690	g3376	i0	71.9	1.00523560209424	32	9	50.3	0	4	99	103	134	WP_088258631.1 zinc-finger-containing protein [Fimbriiglobus ruber]	diamond	192	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber
28565552	28565552	PRJNA642647_P_NODE_2467_length_220_cov_1.519126_g2417_i0	PRJNA642647	2467	220	1.519126	3.3420772	Luteolibacter sp.	1962973	Bacteria	Bacteria	114	8.729999999999999e-28	NR	MFT3991681.1	1962973	g2417	i0	72.2	0.981818181818182	72	20	98.2	0	216	1	105	176	MFT3991681.1 hypothetical protein [Luteolibacter sp.]	diamond	216	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
28565554	28565554	PRJNA642647_P_NODE_6367_length_152_cov_1.000000_g6317_i0	PRJNA642647	6367	152	1	1.52	Chlamydia trachomatis	813	Bacteria	Bacteria	79	1.11e-15	NR	CPR46792.1	813	g6317	i0	95.8	0.947368421052632	48	2	94.7	0	145	2	87	134	CPR46792.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	144	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
28723490	28723490	PRJNA642647_P_NODE_6727_length_150_cov_1.318584_g6677_i0	PRJNA642647	6727	150	1.318584	1.977876	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	86.3	2.57e-18	NR	MBL9172927.1	2026801	g6677	i0	81.6	0.98	49	9	98	0	148	2	134	182	MBL9172927.1 immunoglobulin domain-containing protein [Verrucomicrobiales bacterium]	diamond	147	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28912623	28912623	PRJNA642647_P_NODE_4028_length_180_cov_0.804196_g3978_i0	PRJNA642647	4028	180	0.804196	1.4475528	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	55.1	7.03e-7	NR	MFN0130813.1	2026801	g3978	i0	44.1	0.983333333333333	59	31	98.3	1	179	3	654	710	MFN0130813.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	177	55.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28912627	28912627	PRJNA642647_P_NODE_5048_length_166_cov_2.922481_g4998_i0	PRJNA642647	5048	166	2.922481	4.85131846	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	42.7	0.0134	NR	MCF7674599.1	2562705	g4998	i0	82.6	1.24698795180723	23	4	41.6	0	165	97	88	110	MCF7674599.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	207	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29134079	29134079	PRJNA642647_P_NODE_4469_length_172_cov_0.948148_g4419_i0	PRJNA642647	4469	172	0.948148	1.63081456	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	101	1.96e-24	NR	MDQ5980720.1	2026799	g4419	i0	96.3	0.941860465116279	54	2	94.2	0	6	167	84	137	MDQ5980720.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	162	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29575707	29575707	PRJNA642647_P_NODE_3510_length_189_cov_1.822368_g3460_i0	PRJNA642647	3510	189	1.822368	3.44427552	Planctomycetales bacterium 71-1	2053591	Bacteria	Bacteria	68.9	1.01e-11	NR	OJW23182.1	1895807	g3460	i0	54.8	0.984126984126984	62	28	98.4	0	2	187	223	284	OJW23182.1 MAG: hypothetical protein BGO49_27190 [Planctomycetales bacterium 71-10]	diamond	186	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 71-10
29575709	29575709	PRJNA642647_P_NODE_4390_length_173_cov_1.448529_g4340_i0	PRJNA642647	4390	173	1.448529	2.50595517	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87.8	1.26e-19	NR	MEA3224481.1	2026780	g4340	i0	69.1	2.84393063583815	55	17	95.4	0	166	2	116	170	MEA3224481.1 hypothetical protein [Planctomycetota bacterium]	diamond	492	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29638741	29638741	PRJNA642647_P_NODE_4910_length_166_cov_3.348837_g4860_i0	PRJNA642647	4910	166	3.348837	5.55906942	Opitutus sp.	1913982	Bacteria	Bacteria	51.2	1.36e-5	NR	MSU50147.1	1913982	g4860	i0	35.3	1.8433734939759	102	18	97.6	2	4	165	588	689	MSU50147.1 hypothetical protein [Opitutus sp.]	diamond	306	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29701866	29701866	PRJNA642647_P_NODE_4710_length_168_cov_2.328244_g4660_i0	PRJNA642647	4710	168	2.328244	3.91144992	Haloferula sp.	2497595	Bacteria	Bacteria	106	4.3e-26	NR	HEY1122245.1	2497595	g4660	i0	83.3	1.92857142857143	54	9	96.4	0	164	3	119	172	HEY1122245.1 hypothetical protein [Haloferula sp.]	diamond	324	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp.
29765237	29765237	PRJNA642647_P_NODE_4751_length_168_cov_1.022901_g4701_i0	PRJNA642647	4751	168	1.022901	1.71847368	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	79.3	3.1e-17	NR	MCE5266732.1	2026779	g4701	i0	92.1	0.678571428571429	38	3	67.9	0	166	53	91	128	MCE5266732.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	114	79.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29796842	29796842	PRJNA642647_P_NODE_6491_length_151_cov_3.096491_g6441_i0	PRJNA642647	6491	151	3.096491	4.67570141	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	51.2	1.09e-5	NR	MBK7997852.1	2026799	g6441	i0	59.5	2.32450331125828	37	8	59.6	1	150	61	545	581	MBK7997852.1 transglutaminase domain-containing protein [Verrucomicrobiota bacterium]	diamond	351	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29954928	29954928	PRJNA642647_P_NODE_6631_length_150_cov_3.681416_g6581_i0	PRJNA642647	6631	150	3.681416	5.522124	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	2.96e-6	NR	MCX5690565.1	2026780	g6581	i0	42.7	1.92	96	7	96	1	148	5	88	183	MCX5690565.1 AAA family ATPase [Planctomycetota bacterium]	diamond	288	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30018217	30018217	PRJNA642647_P_NODE_3571_length_188_cov_1.384106_g3521_i0	PRJNA642647	3571	188	1.384106	2.60211928	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	1.4e-12	NR	MFA5239790.1	2026778	g3521	i0	51.6	0.98936170212766	62	30	98.9	0	3	188	23	84	MFA5239790.1 HNH endonuclease signature motif containing protein [Phycisphaerae bacterium]	diamond	186	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30175935	30175935	PRJNA642647_P_NODE_5192_length_166_cov_2.573643_g5142_i0	PRJNA642647	5192	166	2.573643	4.27224738	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	68.9	9.22e-13	NR	HXI72320.1	2499141	g5142	i0	50.8	2.15060240963855	59	23	95.8	1	4	162	93	151	HXI72320.1 pentapeptide repeat-containing protein [Verrucomicrobiia bacterium]	diamond	357	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30334442	30334442	PRJNA642647_P_NODE_1372_length_299_cov_2.374046_g1322_i0	PRJNA642647	1372	299	2.374046	7.09839754	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	48.5	6.28e-4	NR	MCC6427801.1	2052180	g1322	i0	45.2	3.93311036789298	62	29	57.2	2	35	205	128	189	MCC6427801.1 hypothetical protein [Phycisphaerales bacterium]	diamond	1176	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30409869	30409869	PRJNA642647_P_NODE_5173_length_166_cov_2.682171_g5123_i0	PRJNA642647	5173	166	2.682171	4.45240386	Planctomycetia	203683	Bacteria	Bacteria	48.1	1.64e-4	NR	MBV8231459.1	2026779	g5123	i0	95.7	2.00602409638554	23	1	41.6	0	70	2	79	101	MBV8231459.1 flagellar biosynthesis protein FlhF [Planctomycetaceae bacterium]	diamond	333	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30883386	30883386	PRJNA642647_P_NODE_6394_length_151_cov_3.921053_g6344_i0	PRJNA642647	6394	151	3.921053	5.92079003	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00163	NR	RPJ30090.1	2026800	g6344	i0	72.4	3.63576158940397	29	7	55.6	1	1	84	138	166	RPJ30090.1 MAG: AAA family ATPase [Verrucomicrobiaceae bacterium]	diamond	549	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30902803	30902803	PRJNA642647_P_NODE_5594_length_161_cov_1.217742_g5544_i0	PRJNA642647	5594	161	1.217742	1.96056462	Verrucomicrobia bacterium ADurb.Bin122	1852929	Bacteria	Bacteria	84	3.21e-17	NR	OQB94327.1	1852929	g5544	i0	77.6	0.91304347826087	49	11	91.3	0	158	12	167	215	OQB94327.1 MAG: Replicative DNA helicase [Verrucomicrobia bacterium ADurb.Bin122]	diamond	147	84	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium ADurb.Bin122
30966115	30966115	PRJNA642647_P_NODE_2774_length_209_cov_0.877907_g2724_i0	PRJNA642647	2774	209	0.877907	1.83482563	Candidatus Synoicihabitans sp.	3069606	Bacteria	Bacteria	45.8	0.0019	NR	HEX2101322.1	3069606	g2724	i0	44.1	0.84688995215311	59	33	84.7	0	198	22	171	229	HEX2101322.1 hypothetical protein [Candidatus Synoicihabitans sp.]	diamond	177	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Candidatus Synoicihabitans sp.
31060982	31060982	PRJNA642647_P_NODE_2815_length_207_cov_2.441176_g2765_i0	PRJNA642647	2815	207	2.441176	5.05323432	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	115	2.55e-28	NR	WP_200274118.1	454153	g2765	i0	74.2	0.956521739130435	66	17	95.7	0	203	6	409	474	WP_200274118.1 ParB N-terminal domain-containing protein [Luteolibacter pohnpeiensis]	diamond	198	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
31123554	31123554	PRJNA642647_P_NODE_3815_length_183_cov_2.458904_g3765_i0	PRJNA642647	3815	183	2.458904	4.49979432	Parachlamydia sp.	2052048	Bacteria	Bacteria	47.4	3.83e-4	NR	MCE2983404.1	2052048	g3765	i0	63.6	0.540983606557377	33	12	54.1	0	181	83	165	197	MCE2983404.1 hypothetical protein [Parachlamydia sp.]	diamond	99	47.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
31345305	31345305	PRJNA642647_P_NODE_1816_length_258_cov_0.995475_g1766_i0	PRJNA642647	1816	258	0.995475	2.5683255	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	48.1	5.57e-4	NR	HRT29952.1	2212473	g1766	i0	37.1	0.813953488372093	70	39	81.4	1	214	5	137	201	HRT29952.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	210	48.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31408569	31408569	PRJNA642647_P_NODE_4016_length_180_cov_1.349650_g3966_i0	PRJNA642647	4016	180	1.34965	2.42937	Opitutaceae bacterium	2006848	Bacteria	Bacteria	92.8	5.78e-22	NR	MBC7365236.1	2006848	g3966	i0	76.3	0.983333333333333	59	14	98.3	0	2	178	101	159	MBC7365236.1 hypothetical protein [Opitutaceae bacterium]	diamond	177	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31420764	31420764	PRJNA642647_P_NODE_4876_length_166_cov_3.813953_g4826_i0	PRJNA642647	4876	166	3.813953	6.33116198	Bacteria	2	Bacteria	Bacteria	55.8	2.84e-7	NR	MBS0657466.1	2026799	g4826	i0	58.1	5.78313253012048	43	18	77.7	0	129	1	140	182	MBS0657466.1 sterol desaturase family protein [Verrucomicrobiota bacterium]	diamond	960	56.2	0.99288256227758	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31819573	31819573	PRJNA642647_P_NODE_2997_length_202_cov_2.321212_g2947_i0	PRJNA642647	2997	202	2.321212	4.6888482399999996	Gemmataceae bacterium	2052164	Bacteria	Bacteria	53.9	2.46e-6	NR	MCX7664400.1	2052164	g2947	i0	42.1	0.846534653465347	57	33	84.7	0	31	201	28	84	MCX7664400.1 hypothetical protein [Gemmataceae bacterium]	diamond	171	53.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31819575	31819575	PRJNA642647_P_NODE_5337_length_165_cov_0.890625_g5287_i0	PRJNA642647	5337	165	0.890625	1.46953125	Haloferula sp.	2497595	Bacteria	Bacteria	49.7	1.24e-5	NR	HEY1121745.1	2497595	g5287	i0	76.7	0.545454545454545	30	7	54.5	0	74	163	1	30	HEY1121745.1 hypothetical protein [Haloferula sp.]	diamond	90	49.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp.
32009544	32009544	PRJNA642647_P_NODE_658_length_441_cov_3.455446_g609_i0	PRJNA642647	658	441	3.455446	15.23851686	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	73.2	7.17e-12	NR	HYG84585.1	2499141	g609	i0	39.7	0.789115646258503	116	67	78.2	2	437	93	295	408	HYG84585.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	348	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32104392	32104392	PRJNA642647_P_NODE_2238_length_229_cov_6.359375_g2188_i0	PRJNA642647	2238	229	6.359375	14.56296875	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.3	0.00862	NR	HYG84585.1	2499141	g2188	i0	31.7	1.83406113537118	82	41	89.1	2	206	3	199	279	HYG84585.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	420	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32136165	32136165	PRJNA642647_P_NODE_4898_length_166_cov_3.457364_g4848_i0	PRJNA642647	4898	166	3.457364	5.73922424	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	54.7	7.97e-7	NR	MEY3895831.1	2026799	g4848	i0	33.7	1.71686746987952	95	19	92.2	1	156	4	88	182	MEY3895831.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	285	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32231213	32231213	PRJNA642647_P_NODE_2938_length_204_cov_2.449102_g2888_i0	PRJNA642647	2938	204	2.449102	4.99616808	Opitutia bacterium	2026771	Bacteria	Bacteria	51.2	2.31e-5	NR	MEL0098007.1	2026771	g2888	i0	57.9	0.558823529411765	38	10	55.9	1	91	204	191	222	MEL0098007.1 hypothetical protein [Opitutia bacterium]	diamond	114	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
32641673	32641673	PRJNA642647_P_NODE_3740_length_185_cov_0.932432_g3690_i0	PRJNA642647	3740	185	0.932432	1.7249992	Planctomycetota bacterium	2026780	Bacteria	Bacteria	51.6	6.39e-6	NR	MDP6940246.1	2026780	g3690	i0	59.5	1.75135135135135	37	15	60	0	163	53	116	152	MDP6940246.1 HK97 family phage prohead protease [Planctomycetota bacterium]	diamond	324	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32893699	32893699	PRJNA642647_P_NODE_5580_length_161_cov_1.580645_g5530_i0	PRJNA642647	5580	161	1.580645	2.54483845	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	1.59e-27	NR	MEY3894838.1	2026799	g5530	i0	96	0.93167701863354	50	2	93.2	0	157	8	183	232	MEY3894838.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium

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