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

34 rows where analysis = "blastn", bioproject = "PRJNA773247" and tax_phylum = "Planctomycetota"

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
2024820	2024820	PRJNA773247_P_NODE_2622_length_1223_cov_11.198261_g2569_i0	PRJNA773247	2622	1223	11.198261	136.95473203	Humisphaera borealis	2807512	Bacteria	Bacteria	305	8.68e-78	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2569	i0	82.72	0.573998364677024	353	51	28	8	1	348	6966765	6966418	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	702	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
2024859	2024859	PRJNA773247_P_NODE_2862_length_1161_cov_8.351103_g2804_i0	PRJNA773247	2862	1161	8.351103	96.95630583	Urbifossiella limnaea	2528023	Bacteria	Bacteria	599	3.369999999999999e-166	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g2804	i0	79.33	0.745908699397071	866	169	74	7	264	1124	2471005	2470145	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	866	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
2482398	2482398	PRJNA773247_P_NODE_1622_length_1550_cov_9.751523_g1590_i0	PRJNA773247	1622	1550	9.751523	151.1486065	Engelhardtia	139931	Bacteria	Bacteria	488	1.0199999999999998e-132	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g1590	i0	81.15	37.6541935483871	626	102	40	13	928	1545	2960780	2961397	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	58364	488	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
3300048	3300048	PRJNA773247_P_NODE_25303_length_278_cov_2.868293_g25219_i0	PRJNA773247	25303	278	2.868293	7.97385454	Limnoglobus roseus	2598579	Bacteria	Bacteria	359	1.35e-94	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g25219	i0	90.217	0.992805755395683	276	25	99	2	1	274	8129949	8129674	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	276	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
4576929	4576929	PRJNA773247_P_NODE_12244_length_436_cov_15.782369_g12161_i0	PRJNA773247	12244	436	15.782369	68.81112884	Humisphaera borealis	2807512	Bacteria	Bacteria	379	1.7e-100	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g12161	i0	82.679	25.9036697247706	433	69	99	5	7	436	4390373	4390802	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11294	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
4577129	4577129	PRJNA773247_P_NODE_26104_length_273_cov_3.045000_g26020_i0	PRJNA773247	26104	273	3.045	8.31285	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	287	6.31e-73	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g26020	i0	86.822	1.9010989010989	258	33	94	1	12	268	6276798	6276541	Lacipirellula limnantheis strain I41 chromosome	blastn	519	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
4577138	4577138	PRJNA773247_P_NODE_26464_length_271_cov_2.666667_g26380_i0	PRJNA773247	26464	271	2.666667	7.22666757	Gemmata massiliana	1210884	Bacteria	Bacteria	252	2.2799999999999998e-62	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g26380	i0	83.395	1.98154981549816	271	45	100	0	1	271	2031867	2031597	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	537	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
5852457	5852457	PRJNA773247_P_NODE_2625_length_1223_cov_2.488696_g2572_i0	PRJNA773247	2625	1223	2.488696	30.43675208	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	579	4.629999999999999e-160	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g2572	i0	82.302	0.599345870809485	695	98	56	19	526	1215	6503508	6502834	Lacipirellula limnantheis strain I41 chromosome	blastn	733	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
8401990	8401990	PRJNA773247_P_NODE_19307_length_328_cov_2.094118_g19223_i0	PRJNA773247	19307	328	2.094118	6.86870704	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	551	2.499999999999999e-152	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g19223	i0	96.951	2.08536585365854	328	10	100	0	1	328	5483907	5484234	Lacipirellula limnantheis strain I41 chromosome	blastn	684	551	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
8402115	8402115	PRJNA773247_P_NODE_27247_length_266_cov_11.492228_g27163_i0	PRJNA773247	27247	266	11.492228	30.56932648	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g27163	i0	84.348	0.432330827067669	115	18	43	0	9	123	919818	919704	Planctomyces sp. SH-PL14, complete genome	blastn	115	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
8402244	8402244	PRJNA773247_P_NODE_37327_length_201_cov_4.421875_g37243_i0	PRJNA773247	37327	201	4.421875	8.88796875	Urbifossiella limnaea	2528023	Bacteria	Bacteria	248	2.08e-61	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g37243	i0	89	0.995024875621891	200	22	99	0	2	201	277305	277504	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	200	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10952992	10952992	PRJNA773247_P_NODE_25929_length_274_cov_2.706468_g25845_i0	PRJNA773247	25929	274	2.706468	7.41572232	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	344	3.71e-90	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g25845	i0	89.888	13.7408759124088	267	27	97	0	3	269	2165388	2165122	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	3765	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12228466	12228466	PRJNA773247_P_NODE_17270_length_351_cov_2.791367_g17186_i0	PRJNA773247	17270	351	2.791367	9.79769817	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	89.8	2.53e-13	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g17186	i0	90.909	0.188034188034188	66	6	19	0	284	349	733750	733815	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	66	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
12228832	12228832	PRJNA773247_P_NODE_7310_length_614_cov_2.375231_g7227_i0	PRJNA773247	7310	614	2.375231	14.58391834	Humisphaera borealis	2807512	Bacteria	Bacteria	363	2.48e-95	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g7227	i0	78.017	4.6498371335504904	605	113	97	18	10	604	4399433	4400027	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2855	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13502429	13502429	PRJNA773247_P_NODE_14651_length_390_cov_0.971609_g14567_i0	PRJNA773247	14651	390	0.971609	3.7892751	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	460	5.23e-125	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g14567	i0	87.98	2.19230769230769	391	45	100	2	1	390	2555105	2554716	Lacipirellula limnantheis strain I41 chromosome	blastn	855	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
14777867	14777867	PRJNA773247_P_NODE_36752_length_222_cov_5.946309_g36668_i0	PRJNA773247	36752	222	5.946309	13.20080598	Stieleria bergensis	2528025	Bacteria	Bacteria	161	3.14e-35	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g36668	i0	80.093	0.972972972972973	216	43	97	0	1	216	6589806	6590021	Planctomycetes bacterium SV_7m_r chromosome	blastn	216	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
17327392	17327392	PRJNA773247_P_NODE_37454_length_197_cov_4.314516_g37370_i0	PRJNA773247	37454	197	4.314516	8.49959652	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	163	7.55e-36	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g37370	i0	82.199	0.969543147208122	191	32	96	2	8	197	5444933	5445122	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	191	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
18600477	18600477	PRJNA773247_P_NODE_14135_length_398_cov_28.089231_g14051_i0	PRJNA773247	14135	398	28.089231	111.79513938	Limnoglobus roseus	2598579	Bacteria	Bacteria	298	4.43e-76	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g14051	i0	84.59	0.846733668341708	305	41	76	5	8	309	3236161	3235860	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	337	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18600522	18600522	PRJNA773247_P_NODE_16855_length_356_cov_3.431095_g16771_i0	PRJNA773247	16855	356	3.431095	12.2146982	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	398	3.759999999999999e-106	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g16771	i0	88.288	18.0955056179775	333	37	93	2	13	344	1482459	1482790	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	6442	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
18600904	18600904	PRJNA773247_P_NODE_7015_length_631_cov_4.121864_g6933_i0	PRJNA773247	7015	631	4.121864	26.00896184	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	409	3.23e-109	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g6933	i0	78.864	8.81299524564184	634	113	99	19	9	631	4421936	4422559	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	5561	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19875461	19875461	PRJNA773247_P_NODE_15296_length_379_cov_5.571895_g15212_i0	PRJNA773247	15296	379	5.571895	21.11748205	Urbifossiella limnaea	2528023	Bacteria	Bacteria	505	2.3099999999999995e-138	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g15212	i0	91.005	1.51715039577836	378	29	99	4	1	375	4901162	4901537	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	575	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19875821	19875821	PRJNA773247_P_NODE_6056_length_700_cov_5.057416_g5975_i0	PRJNA773247	6056	700	5.057416	35.401912	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	69.4	6.94e-7	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g5975	i0	87.931	0.142857142857143	58	7	8	0	624	681	8426368	8426425	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	100	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
21151407	21151407	PRJNA773247_P_NODE_21537_length_306_cov_5.553648_g21453_i0	PRJNA773247	21537	306	5.553648	16.99416288	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	130	1.28e-25	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g21453	i0	82.877	0.477124183006536	146	24	47	1	11	155	2321275	2321130	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	146	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
22426153	22426153	PRJNA773247_P_NODE_21618_length_306_cov_1.081545_g21534_i0	PRJNA773247	21618	306	1.081545	3.3095277	Gemmataceae bacterium	2052164	Bacteria	Bacteria	279	1.2e-70	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g21534	i0	83.784	0.967320261437909	296	46	96	2	12	306	7734030	7733736	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	296	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22426236	22426236	PRJNA773247_P_NODE_28118_length_262_cov_1.349206_g28034_i0	PRJNA773247	28118	262	1.349206	3.53491972	Planctopirus limnophila	120	Bacteria	Bacteria	180	1.0499999999999999e-40	NTclustered	gi\|296012614\|gb\|CP001744.1\|	521674	g28034	i0	89.437	0.541984732824427	142	15	54	0	93	234	1403982	1403841	Planctopirus limnophila DSM 3776 chromosome, complete genome	blastn	142	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
22426265	22426265	PRJNA773247_P_NODE_30158_length_251_cov_1.713483_g30074_i0	PRJNA773247	30158	251	1.713483	4.30084233	Limnoglobus roseus	2598579	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g30074	i0	82.883	10.4900398406375	222	32	88	5	1	220	2546703	2546920	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2633	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
22426348	22426348	PRJNA773247_P_NODE_35558_length_235_cov_6.364198_g35474_i0	PRJNA773247	35558	235	6.364198	14.9558653	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g35474	i0	100	0.238297872340426	28	0	12	0	1	28	620866	620839	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
23701720	23701720	PRJNA773247_P_NODE_15659_length_374_cov_1.514950_g15575_i0	PRJNA773247	15659	374	1.51495	5.665913	Aureliella sp.	2795609	Bacteria	Bacteria	309	1.9100000000000003e-79	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g15575	i0	82.955	120.919786096257	352	51	93	7	26	371	5640320	5640668	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	45224	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
23701724	23701724	PRJNA773247_P_NODE_15899_length_370_cov_3.973064_g15815_i0	PRJNA773247	15899	370	3.973064	14.7003368	Stieleria maiorica	2795974	Bacteria	Bacteria	73.1	2.7e-8	NTclustered	gi\|1726207917\|gb\|CP036264.1\|	2795974	g15815	i0	84.81	16.2	79	5	21	4	177	253	2864526	2864599	Stieleria maiorica strain Mal15 chromosome	blastn	5994	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria maiorica
23701931	23701931	PRJNA773247_P_NODE_31579_length_248_cov_0.880000_g31495_i0	PRJNA773247	31579	248	0.88	2.1824	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g31495	i0	96.774	2.9758064516129	248	8	100	0	1	248	28550	28797	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	738	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
24158625	24158625	PRJNA773247_P_NODE_16259_length_364_cov_15.374570_g16175_i0	PRJNA773247	16259	364	15.37457	55.9634348	Gemmata	113	Bacteria	Bacteria	281	4.05e-71	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g16175	i0	81.633	3.80494505494505	343	59	94	4	21	361	7166113	7166453	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1385	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
24975421	24975421	PRJNA773247_P_NODE_16860_length_356_cov_2.968198_g16776_i0	PRJNA773247	16860	356	2.968198	10.56678488	Gemmataceae bacterium	2052164	Bacteria	Bacteria	244	5.18e-60	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g16776	i0	81.329	8.65449438202247	316	45	87	14	23	331	2501936	2502244	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	3081	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
24975561	24975561	PRJNA773247_P_NODE_25420_length_277_cov_5.416667_g25336_i0	PRJNA773247	25420	277	5.416667	15.00416759	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	193	1.44e-44	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g25336	i0	79.787	810.137184115523	282	43	98	13	1	272	7050692	7050415	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	224408	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24975693	24975693	PRJNA773247_P_NODE_3440_length_1028_cov_2.469110_g3378_i0	PRJNA773247	3440	1028	2.46911	25.3824508	Humisphaera borealis	2807512	Bacteria	Bacteria	512	3.98e-140	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g3378	i0	79.915	25.4805447470817	707	134	68	7	167	869	6465141	6464439	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	26194	512	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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