metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax

34 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
905581	905581	PRJNA929922_P_NODE_111521_length_250_cov_0.870056_g110981_i0	PRJNA929922	111521	250	0.870056	2.17514	Akkermansia massiliensis	2927224	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1805957841\|gb\|CP029701.1\|	2927224	g110981	i0	99.6	99.832	250	1	100	0	1	250	946433	946682	Akkermansia massiliensis strain EB-AMDK-40 chromosome, complete genome	blastn	24958	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
906717	906717	PRJNA929922_P_NODE_165321_length_238_cov_4.806061_g164781_i0	PRJNA929922	165321	238	4.806061	11.43842518	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	425	1.09e-114	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g164781	i0	99.571	134.067226890756	233	1	98	0	4	236	2341891	2341659	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	31908	425	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium CCUG 44730
906853	906853	PRJNA929922_P_NODE_31441_length_370_cov_1.555556_g30901_i0	PRJNA929922	31441	370	1.555556	5.7555572	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	599	9.999999999999997e-167	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g30901	i0	96.927	479.8	358	9	97	2	1	358	558389	558744	Gemmata sp. SH-PL17, complete genome	blastn	177526	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
2181306	2181306	PRJNA929922_P_NODE_128622_length_247_cov_0.885057_g128082_i0	PRJNA929922	128622	247	0.885057	2.18609079	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	100	7.86e-17	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g128082	i0	89.744	3.48582995951417	78	8	32	0	137	214	4468573	4468650	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	861	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2181346	2181346	PRJNA929922_P_NODE_130362_length_247_cov_0.885057_g129822_i0	PRJNA929922	130362	247	0.885057	2.18609079	Opitutus terrae	107709	Bacteria	Bacteria	207	4.4999999999999994e-49	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g129822	i0	82.553	0.951417004048583	235	41	95	0	13	247	1725396	1725162	Opitutus terrae PB90-1, complete genome	blastn	235	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
3456394	3456394	PRJNA929922_P_NODE_107723_length_251_cov_0.865169_g107183_i0	PRJNA929922	107723	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.2	1.36e-4	NTclustered	gi\|2107958177\|gb\|CP070790.1\|	2026780	g107183	i0	100	0.127490039840637	32	0	13	0	83	114	467355	467324	MAG: Planctomycetota bacterium isolate bin1449 chromosome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
3805513	3805513	PRJNA929922_P_NODE_122783_length_248_cov_0.880000_g122243_i0	PRJNA929922	122783	248	0.88	2.1824	Akkermansia	239934	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2051350654\|gb\|CP072036.1\|	2927224	g122243	i0	100	99.6532258064516	248	0	100	0	1	248	1678452	1678699	Akkermansia massiliensis strain Akk1573 chromosome, complete genome	blastn	24714	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
4734756	4734756	PRJNA929922_P_NODE_146124_length_244_cov_0.900585_g145584_i0	PRJNA929922	146124	244	0.900585	2.1974274	Limnoglobus roseus	2598579	Bacteria	Bacteria	294	3.31e-75	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g145584	i0	88.525	9.17622950819672	244	26	99	2	2	244	410627	410869	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2239	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
6009921	6009921	PRJNA929922_P_NODE_164865_length_241_cov_0.886905_g164325_i0	PRJNA929922	164865	241	0.886905	2.13744105	Singulisphaera acidiphila	466153	Bacteria	Bacteria	230	9.34e-56	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g164325	i0	85.52	2.62655601659751	221	30	91	2	22	241	3565600	3565381	Singulisphaera acidiphila DSM 18658, complete genome	blastn	633	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
7283587	7283587	PRJNA929922_P_NODE_107646_length_251_cov_0.865169_g107106_i0	PRJNA929922	107646	251	0.865169	2.17157419	Akkermansia muciniphila	239935	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g107106	i0	100	142.509960159363	251	0	100	0	1	251	1594854	1594604	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	35770	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7284150	7284150	PRJNA929922_P_NODE_135046_length_246_cov_0.890173_g134506_i0	PRJNA929922	135046	246	0.890173	2.18982558	Pirellula staleyi	125	Bacteria	Bacteria	259	1.22e-64	NTclustered	gi\|283436255\|gb\|CP001848.1\|	530564	g134506	i0	85.714	65.0528455284553	245	35	99	0	2	246	3665547	3665791	Pirellula staleyi DSM 6068 chromosome, complete genome	blastn	16003	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
7284169	7284169	PRJNA929922_P_NODE_135886_length_246_cov_0.890173_g135346_i0	PRJNA929922	135886	246	0.890173	2.18982558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	278	3.37e-70	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g135346	i0	86.992	83.5691056910569	246	32	100	0	1	246	3156856	3157101	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	20558	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
8559340	8559340	PRJNA929922_P_NODE_152487_length_243_cov_0.905882_g151947_i0	PRJNA929922	152487	243	0.905882	2.20129326	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	320	5.44e-83	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g151947	i0	90.496	42.8312757201646	242	23	99	0	1	242	2847075	2847316	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	10408	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9834470	9834470	PRJNA929922_P_NODE_155988_length_242_cov_0.911243_g155448_i0	PRJNA929922	155988	242	0.911243	2.20520806	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g155448	i0	86.631	59.5123966942149	187	24	77	1	56	242	9399982	9399797	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	14402	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
11109097	11109097	PRJNA929922_P_NODE_107549_length_251_cov_0.865169_g107009_i0	PRJNA929922	107549	251	0.865169	2.17157419	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	9.93e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g107009	i0	81.78	2.34661354581673	236	41	94	2	1	235	7889062	7889296	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	589	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11109218	11109218	PRJNA929922_P_NODE_113649_length_250_cov_0.870056_g113109_i0	PRJNA929922	113649	250	0.870056	2.17514	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g113109	i0	84.81	1.048	158	24	63	0	92	249	3088179	3088336	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	262	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11109889	11109889	PRJNA929922_P_NODE_146049_length_244_cov_0.900585_g145509_i0	PRJNA929922	146049	244	0.900585	2.1974274	Akkermansia massiliensis	2927224	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1805957841\|gb\|CP029701.1\|	2927224	g145509	i0	100	49.5819672131148	244	0	100	0	1	244	1017972	1017729	Akkermansia massiliensis strain EB-AMDK-40 chromosome, complete genome	blastn	12098	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
12384617	12384617	PRJNA929922_P_NODE_108170_length_251_cov_0.865169_g107630_i0	PRJNA929922	108170	251	0.865169	2.17157419	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	178	3.6e-40	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g107630	i0	81.905	50.9402390438247	210	38	84	0	42	251	3211703	3211494	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	12786	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
13659502	13659502	PRJNA929922_P_NODE_123791_length_248_cov_0.880000_g123251_i0	PRJNA929922	123791	248	0.88	2.1824	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	182	2.74e-41	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g123251	i0	84.916	55	179	27	72	0	16	194	6458414	6458236	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	13640	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
13660027	13660027	PRJNA929922_P_NODE_150211_length_243_cov_0.905882_g149671_i0	PRJNA929922	150211	243	0.905882	2.20129326	Urbifossiella limnaea	2528023	Bacteria	Bacteria	224	4.3899999999999996e-54	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g149671	i0	85.714	2.8641975308642	217	25	89	5	20	236	1345922	1345712	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	696	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13660240	13660240	PRJNA929922_P_NODE_159431_length_242_cov_0.869822_g158891_i0	PRJNA929922	159431	242	0.869822	2.10496924	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g158891	i0	86.192	1.88842975206612	239	33	99	0	2	240	5210596	5210358	Tautonia plasticadhaerens strain ElP chromosome	blastn	457	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
14934645	14934645	PRJNA929922_P_NODE_164912_length_241_cov_0.880952_g164372_i0	PRJNA929922	164912	241	0.880952	2.12309432	Aquisphaera giovannonii	406548	Bacteria	Bacteria	128	3.4999999999999997e-25	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g164372	i0	81.481	0.672199170124481	162	24	66	6	8	166	9041557	9041399	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	162	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
16208550	16208550	PRJNA929922_P_NODE_111973_length_250_cov_0.870056_g111433_i0	PRJNA929922	111973	250	0.870056	2.17514	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g111433	i0	83.412	1.308	211	33	84	2	34	243	8449509	8449300	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	327	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17483834	17483834	PRJNA929922_P_NODE_112194_length_250_cov_0.870056_g111654_i0	PRJNA929922	112194	250	0.870056	2.17514	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	351	1.99e-92	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g111654	i0	92	32.452	250	20	100	0	1	250	893305	893056	Lacunisphaera limnophila strain IG16b, complete genome	blastn	8113	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
17485927	17485927	PRJNA929922_P_NODE_91134_length_266_cov_1.595855_g90594_i0	PRJNA929922	91134	266	1.595855	4.2449743	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	298	2.8299999999999997e-76	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g90594	i0	86.891	1.00375939849624	267	33	100	2	1	266	3439945	3440210	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	267	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
20032801	20032801	PRJNA929922_P_NODE_139136_length_245_cov_0.895349_g138596_i0	PRJNA929922	139136	245	0.895349	2.19360505	Aeoliella mucimassa	2527972	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g138596	i0	80.976	73.2244897959184	205	35	83	3	14	216	6173091	6172889	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	17940	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
20033144	20033144	PRJNA929922_P_NODE_155336_length_242_cov_0.911243_g154796_i0	PRJNA929922	155336	242	0.911243	2.20520806	Akkermansia muciniphila	239935	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1554502134\|gb\|CP025835.1\|	239935	g154796	i0	100	99.8099173553719	242	0	100	0	1	242	2458307	2458066	Akkermansia muciniphila strain EB-AMDK-20 chromosome, complete genome	blastn	24154	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22582968	22582968	PRJNA929922_P_NODE_125498_length_248_cov_0.880000_g124958_i0	PRJNA929922	125498	248	0.88	2.1824	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	183	7.62e-42	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g124958	i0	81.333	0.907258064516129	225	42	91	0	7	231	4003631	4003407	Lacunisphaera limnophila strain IG16b, complete genome	blastn	225	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
22583579	22583579	PRJNA929922_P_NODE_156058_length_242_cov_0.911243_g155518_i0	PRJNA929922	156058	242	0.911243	2.20520806	Urbifossiella limnaea	2528023	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g155518	i0	87.619	1.49173553719008	210	26	87	0	33	242	7716437	7716646	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	361	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23858437	23858437	PRJNA929922_P_NODE_133999_length_246_cov_0.890173_g133459_i0	PRJNA929922	133999	246	0.890173	2.18982558	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	219	2.07e-52	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g133459	i0	82.857	75.4024390243902	245	40	99	2	1	244	522624	522381	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	18549	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23858586	23858586	PRJNA929922_P_NODE_141019_length_245_cov_0.895349_g140479_i0	PRJNA929922	141019	245	0.895349	2.19360505	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	207	4.46e-49	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g140479	i0	82.305	0.991836734693878	243	39	98	3	5	245	410576	410336	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	243	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
23858851	23858851	PRJNA929922_P_NODE_153899_length_243_cov_0.870588_g153359_i0	PRJNA929922	153899	243	0.870588	2.11552884	Bremerella sp. P1	3026424	Bacteria	Bacteria	128	3.54e-25	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g153359	i0	88.571	2.7283950617284	105	12	43	0	21	125	4838600	4838496	Bremerella sp. P1 chromosome, complete genome	blastn	663	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
23858948	23858948	PRJNA929922_P_NODE_158839_length_242_cov_0.911243_g158299_i0	PRJNA929922	158839	242	0.911243	2.20520806	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g158299	i0	90.947	1.00413223140496	243	20	100	2	1	242	5072559	5072800	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	243	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
25132446	25132446	PRJNA929922_P_NODE_144220_length_244_cov_0.900585_g143680_i0	PRJNA929922	144220	244	0.900585	2.1974274	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	215	2.65e-51	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g143680	i0	82.731	2.11065573770492	249	35	100	6	1	244	1508250	1508005	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	515	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482

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