metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
743633	743633	PRJNA763243_P_NODE_54601_length_248_cov_6.491429_g54255_i0	PRJNA763243	54601	248	6.491429	16.09874392	Humisphaera borealis	2807512	Bacteria	Bacteria	396	9e-106	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g54255	i0	96.266	556.407258064516	241	9	97	0	4	244	5063758	5063998	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	137989	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
743984	743984	PRJNA763243_P_NODE_69661_length_222_cov_6.832215_g69315_i0	PRJNA763243	69661	222	6.832215	15.1675173	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	387	4.749999999999998e-103	NTclustered	gi\|544315340\|gb\|KF318250.1\|	156588	g69315	i0	99.07	95.8378378378378	215	2	97	0	4	218	414	628	Uncultured Verrucomicrobia bacterium clone ATW092 16S ribosomal RNA gene, partial sequence	blastn	21276	387	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
1205262	1205262	PRJNA763243_P_NODE_71721_length_212_cov_6.877698_g71375_i0	PRJNA763243	71721	212	6.877698	14.58071976	Phycisphaerae	666505	Bacteria	Bacteria	322	1.29e-83	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g71375	i0	94.686	121.688679245283	207	11	98	0	6	212	1831831	1831625	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	25798	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
2019095	2019095	PRJNA763243_P_NODE_29582_length_310_cov_2.818565_g29236_i0	PRJNA763243	29582	310	2.818565	8.7375515	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	80.5	1.33e-10	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g29236	i0	85.714	1.80322580645161	77	9	25	2	74	150	2372655	2372729	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	559	80.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
2019113	2019113	PRJNA763243_P_NODE_30202_length_308_cov_9.234043_g29856_i0	PRJNA763243	30202	308	9.234043	28.44085244	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	1.25e-50	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g29856	i0	93.706	5.96103896103896	143	8	94	1	7	148	1316393	1316251	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	1836	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2480834	2480834	PRJNA763243_P_NODE_8562_length_505_cov_4.178241_g8220_i0	PRJNA763243	8562	505	4.178241	21.10011705	Bacteria	2	Bacteria	Bacteria	558	2.39e-154	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8220	i0	87.123	366.063366336634	497	58	98	6	11	504	2002386	2002879	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	184862	558	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3294034	3294034	PRJNA763243_P_NODE_16843_length_379_cov_6.771242_g16498_i0	PRJNA763243	16843	379	6.771242	25.66300718	Victivallaceae bacterium	2793042	Bacteria	Bacteria	300	1.17e-76	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g16498	i0	82.073	213.802110817942	357	58	94	6	4	357	1446919	1447272	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	81031	300	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
3295395	3295395	PRJNA763243_P_NODE_8383_length_509_cov_46.250000_g8042_i0	PRJNA763243	8383	509	46.25	235.4125	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	444	7.03e-120	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g8042	i0	82.772	437.7721021611	505	80	99	7	8	509	4422886	4422386	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	222826	444	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4571861	4571861	PRJNA763243_P_NODE_49524_length_255_cov_2.291209_g49178_i0	PRJNA763243	49524	255	2.291209	5.84258295	Akkermansia sp. N21116	3040764	Bacteria	Bacteria	322	1.6e-83	NTclustered	gi\|2634178342\|gb\|CP139035.1\|	3040764	g49178	i0	91.213	256.862745098039	239	17	93	3	14	250	790668	790904	Akkermansia sp. N21116 chromosome, complete genome	blastn	65500	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. N21116
5847255	5847255	PRJNA763243_P_NODE_58005_length_245_cov_6.430233_g57659_i0	PRJNA763243	58005	245	6.430233	15.75407085	Luteolibacter sp.	1962973	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g57659	i0	97.942	284.102040816327	243	3	98	1	5	245	1010010	1009768	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	69605	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
7122442	7122442	PRJNA763243_P_NODE_59906_length_244_cov_0.900585_g59560_i0	PRJNA763243	59906	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	2.5399999999999992e-81	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g59560	i0	90.204	577.020491803279	245	19	99	4	1	241	7051951	7051708	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	140793	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7583404	7583404	PRJNA763243_P_NODE_75046_length_198_cov_4.040000_g74700_i0	PRJNA763243	75046	198	4.04	7.9992	Bacteria	2	Bacteria	Bacteria	303	4.29e-78	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g74700	i0	94.444	178.641414141414	198	10	99	1	1	197	948214	948411	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	35371	303	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
8396057	8396057	PRJNA763243_P_NODE_20107_length_353_cov_0.975000_g19761_i0	PRJNA763243	20107	353	0.975	3.44175	planctomycete str. 449	79870	Bacteria	Bacteria	477	4.6499999999999996e-130	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g19761	i0	91.404	164.521246458924	349	29	99	1	1	349	597	250	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	58076	477	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
8396490	8396490	PRJNA763243_P_NODE_38147_length_281_cov_13.211538_g37801_i0	PRJNA763243	38147	281	13.211538	37.12442178	Gemmataceae bacterium	2052164	Bacteria	Bacteria	324	4.97e-84	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g37801	i0	87.9	67.5658362989324	281	27	99	5	1	277	4437996	4437719	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	18986	324	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10946989	10946989	PRJNA763243_P_NODE_23449_length_332_cov_1.057915_g23103_i0	PRJNA763243	23449	332	1.057915	3.5122778	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	488	2.01e-133	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g23103	i0	93.353	55.1355421686747	331	20	99	1	1	329	627693	627363	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	18305	488	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
10947999	10947999	PRJNA763243_P_NODE_64849_length_238_cov_9.618182_g64503_i0	PRJNA763243	64849	238	9.618182	22.89127316	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	329	8.82e-86	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g64503	i0	91.915	154.424369747899	235	19	99	0	4	238	4959610	4959844	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	36753	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
10948145	10948145	PRJNA763243_P_NODE_71569_length_213_cov_4.157143_g71223_i0	PRJNA763243	71569	213	4.157143	8.85471459	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	183	6.369999999999998e-42	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g71223	i0	82.71	10.0892018779343	214	29	99	8	1	210	16712	16503	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	2149	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12222330	12222330	PRJNA763243_P_NODE_15130_length_396_cov_3.015480_g14785_i0	PRJNA763243	15130	396	3.01548	11.9413008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	403	9.08e-108	NTclustered	gi\|2621705096\|emb\|OY763323.1\|	2026780	g14785	i0	86.047	121.444444444444	387	40	97	7	7	392	1008035	1007662	MAG: Planctomycetota bacterium isolate 3a5a21b3-ef55-46fa-90a9-c954c41cad77 genome assembly, chromosome: 1	blastn	48092	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
12223707	12223707	PRJNA763243_P_NODE_71290_length_214_cov_5.936170_g70944_i0	PRJNA763243	71290	214	5.93617	12.7034038	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	270	4.779999999999999e-68	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g70944	i0	99.329	119.504672897196	149	1	89	0	43	191	160	12	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	25574	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13497665	13497665	PRJNA763243_P_NODE_66911_length_232_cov_2.069182_g66565_i0	PRJNA763243	66911	232	2.069182	4.80050224	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	226	1.1599999999999999e-54	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g66565	i0	84.783	73.8577586206897	230	30	98	4	4	231	2502733	2502507	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	17135	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
13497713	13497713	PRJNA763243_P_NODE_68811_length_226_cov_2.679739_g68465_i0	PRJNA763243	68811	226	2.679739	6.05621014	Polystyrenella longa	2528007	Bacteria	Bacteria	233	6.689999999999999e-57	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g68465	i0	90.503	111.778761061947	179	14	78	3	2	178	1416777	1416954	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	25262	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
14772929	14772929	PRJNA763243_P_NODE_71172_length_214_cov_28.978723_g70826_i0	PRJNA763243	71172	214	28.978723	62.01446722	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	315	2.18e-81	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g70826	i0	94.175	158.406542056075	206	12	96	0	5	210	5153088	5152883	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33899	315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14772993	14772993	PRJNA763243_P_NODE_73552_length_204_cov_4.732824_g73206_i0	PRJNA763243	73552	204	4.732824	9.65496096	Alienimonas californiensis	2527989	Bacteria	Bacteria	198	2.16e-46	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g73206	i0	84.878	101.480392156863	205	22	98	7	2	201	373550	373350	Alienimonas californiensis strain CA12 chromosome	blastn	20702	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
17322180	17322180	PRJNA763243_P_NODE_65294_length_237_cov_2.664634_g64948_i0	PRJNA763243	65294	237	2.664634	6.31518258	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	231	2.55e-56	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g64948	i0	84.681	9.94514767932489	235	32	99	4	1	234	1827427	1827196	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	2357	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17322379	17322379	PRJNA763243_P_NODE_73714_length_203_cov_8.500000_g73368_i0	PRJNA763243	73714	203	8.5	17.255	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	9.58e-75	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g73368	i0	93	254.275862068966	200	14	99	0	1	200	2001869	2001670	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	51618	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18594996	18594996	PRJNA763243_P_NODE_42575_length_270_cov_13.370558_g42229_i0	PRJNA763243	42575	270	13.370558	36.1005066	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	398	2.759999999999999e-106	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g42229	i0	95.238	135.840740740741	252	10	93	2	19	268	7630497	7630246	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	36677	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18595576	18595576	PRJNA763243_P_NODE_67355_length_230_cov_8.363057_g67009_i0	PRJNA763243	67355	230	8.363057	19.2350311	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	268	1.87e-67	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g67009	i0	90.955	103.930434782609	199	18	87	0	29	227	1831263	1831065	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	23904	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19869834	19869834	PRJNA763243_P_NODE_2716_length_812_cov_6.143437_g2452_i0	PRJNA763243	2716	812	6.143437	49.88470844	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1360	0	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g2452	i0	99.598	247.512315270936	746	2	99	1	1	746	4778	4034	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	200980	1360	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19870113	19870113	PRJNA763243_P_NODE_38116_length_281_cov_57.615385_g37770_i0	PRJNA763243	38116	281	57.615385	161.89923185	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	370	6.3e-98	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g37770	i0	91.071	113.540925266904	280	16	99	7	5	281	4317334	4317607	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	31905	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21146216	21146216	PRJNA763243_P_NODE_557_length_1540_cov_14.133606_g453_i0	PRJNA763243	557	1540	14.133606	217.6575324	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	2806	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g453	i0	99.61	224.97012987013	1537	6	99	0	4	1540	279	1815	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	346454	2806	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22420316	22420316	PRJNA763243_P_NODE_29178_length_310_cov_4.139241_g28832_i0	PRJNA763243	29178	310	4.139241	12.8316471	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	263	1.23e-65	NTclustered	gi\|294828894\|gb\|GU929353.1\|	156588	g28832	i0	99.31	90.5774193548387	145	1	95	0	4	148	188	332	Uncultured Verrucomicrobia bacterium clone 45_b6 16S ribosomal RNA gene, partial sequence	blastn	28079	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23696988	23696988	PRJNA763243_P_NODE_72679_length_207_cov_32.365672_g72333_i0	PRJNA763243	72679	207	32.365672000000004	66.99694104	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	316	5.819999999999998e-82	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g72333	i0	94.608	192.386473429952	204	11	99	0	1	204	1844442	1844645	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	39824	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
25431752	25431752	PRJNA763243_P_NODE_12720_length_427_cov_2.409605_g12375_i0	PRJNA763243	12720	427	2.409605	10.28901335	Candidatus Amphibiichlamydia	1290369	Bacteria	Bacteria	104	1.12e-17	NTclustered	gi\|924421616\|gb\|KP988775.1\|	174324	g12375	i0	76.303	19.7353629976581	211	41	49	7	214	422	182	385	Uncultured Chlamydiales bacterium clone MESOT560 16S ribosomal RNA gene, partial sequence	blastn	8427	104	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;