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

34 rows where analysis = "blastn", bioproject = "PRJNA939415" 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
916177	916177	PRJNA939415_P_NODE_81501_length_252_cov_3.508380_g81079_i0	PRJNA939415	81501	252	3.50838	8.8411176	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g81079	i0	100	0.119047619047619	30	0	12	0	216	245	2792113	2792142	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
2191683	2191683	PRJNA939415_P_NODE_85762_length_249_cov_0.875000_g85340_i0	PRJNA939415	85762	249	0.875	2.17875	Rosistilla oblonga	2527990	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|1712737282\|gb\|CP036318.1\|	2527990	g85340	i0	80.176	2.73493975903614	227	42	90	3	3	227	4028393	4028618	Rosistilla oblonga strain Mal33 chromosome	blastn	681	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla oblonga
3465598	3465598	PRJNA939415_P_NODE_105443_length_226_cov_3.490196_g105021_i0	PRJNA939415	105443	226	3.490196	7.88784296	Limnoglobus roseus	2598579	Bacteria	Bacteria	154	5.36e-33	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g105021	i0	79.812	10.3230088495575	213	41	94	2	15	226	3045915	3046126	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2333	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
3808467	3808467	PRJNA939415_P_NODE_37183_length_298_cov_3.137778_g36761_i0	PRJNA939415	37183	298	3.137778	9.35057844	Gemmata	113	Bacteria	Bacteria	167	9.48e-37	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g36761	i0	77.17	5.23825503355705	311	55	99	9	1	296	1521376	1521067	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1561	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4744732	4744732	PRJNA939415_P_NODE_91564_length_244_cov_2.368421_g91142_i0	PRJNA939415	91564	244	2.368421	5.77894724	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	185	2.0799999999999994e-42	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g91142	i0	87.5	37.8114754098361	160	20	68	0	85	244	1146759	1146918	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	9226	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6019221	6019221	PRJNA939415_P_NODE_70745_length_263_cov_2.157895_g70323_i0	PRJNA939415	70745	263	2.157895	5.67526385	Limnoglobus roseus	2598579	Bacteria	Bacteria	100	8.45e-17	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g70323	i0	91.667	22.958174904943	72	6	27	0	34	105	4228951	4228880	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	6038	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
6019235	6019235	PRJNA939415_P_NODE_71465_length_262_cov_3.116402_g71043_i0	PRJNA939415	71465	262	3.116402	8.16497324	Planctomycetota bacterium	2026780	Bacteria	Bacteria	108	5.03e-19	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g71043	i0	83.333	0.908396946564885	120	17	45	3	136	253	1891180	1891062	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	238	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
7292856	7292856	PRJNA939415_P_NODE_102886_length_230_cov_3.700637_g102464_i0	PRJNA939415	102886	230	3.700637	8.5114651	Urbifossiella limnaea	2528023	Bacteria	Bacteria	152	1.97e-32	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g102464	i0	80.569	77.0391304347826	211	29	89	10	1	205	6293155	6292951	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	17719	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
7634809	7634809	PRJNA939415_P_NODE_74106_length_260_cov_1.647059_g73684_i0	PRJNA939415	74106	260	1.647059	4.2823534	Gemmata	113	Bacteria	Bacteria	169	2.25e-37	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g73684	i0	78.788	3.04615384615385	264	46	99	10	2	260	5340574	5340832	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	792	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9842799	9842799	PRJNA939415_P_NODE_106348_length_223_cov_4.646667_g105926_i0	PRJNA939415	106348	223	4.646667	10.36206741	Saltatorellus ferox	2528018	Bacteria	Bacteria	119	1.92e-22	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g105926	i0	83.206	9.44843049327354	131	20	58	2	94	223	1178172	1178301	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	2107	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
9843458	9843458	PRJNA939415_P_NODE_40348_length_294_cov_2.941176_g39926_i0	PRJNA939415	40348	294	2.941176	8.64705744	Rohdeia mirabilis	2528008	Bacteria	Bacteria	182	3.33e-41	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g39926	i0	83.938	90.4863945578231	193	27	65	4	20	210	4762715	4762905	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	26603	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
11119682	11119682	PRJNA939415_P_NODE_68809_length_265_cov_1.781250_g68387_i0	PRJNA939415	68809	265	1.78125	4.7203125	Gemmataceae bacterium	2052164	Bacteria	Bacteria	296	1.01e-75	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g68387	i0	87.023	38.5207547169811	262	34	99	0	4	265	3759656	3759395	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	10208	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
11119780	11119780	PRJNA939415_P_NODE_74069_length_260_cov_1.647059_g73647_i0	PRJNA939415	74069	260	1.647059	4.2823534	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	224	4.739999999999999e-54	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g73647	i0	82.745	1.91153846153846	255	40	98	4	7	260	7709667	7709416	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	497	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12395152	12395152	PRJNA939415_P_NODE_67770_length_266_cov_1.917098_g67348_i0	PRJNA939415	67770	266	1.917098	5.09948068	Gemmata massiliana	1210884	Bacteria	Bacteria	176	1.38e-39	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g67348	i0	79.231	3.90977443609023	260	48	97	5	7	263	780802	781058	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	1040	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
13668772	13668772	PRJNA939415_P_NODE_25131_length_310_cov_6.459916_g24709_i0	PRJNA939415	25131	310	6.459916	20.0257396	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	178	4.58e-40	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g24709	i0	88	6.46774193548387	150	18	48	0	161	310	7698874	7699023	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	2005	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
14943082	14943082	PRJNA939415_P_NODE_24552_length_311_cov_6.747899_g24130_i0	PRJNA939415	24552	311	6.747899	20.98596589	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	126	1.69e-24	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g24130	i0	83.453	2.42122186495177	139	19	44	4	14	150	2142604	2142468	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	753	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17494568	17494568	PRJNA939415_P_NODE_84474_length_250_cov_1.305085_g84052_i0	PRJNA939415	84474	250	1.305085	3.2627125	Gemmataceae bacterium	2052164	Bacteria	Bacteria	169	2.15e-37	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g84052	i0	79.6	9.6	250	39	98	11	7	250	4654430	4654187	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	2400	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
18766915	18766915	PRJNA939415_P_NODE_25275_length_310_cov_6.054852_g24853_i0	PRJNA939415	25275	310	6.054852	18.7700412	Planctomycetota bacterium	2026780	Bacteria	Bacteria	147	1.29e-30	NTclustered	gi\|2107958177\|gb\|CP070790.1\|	2026780	g24853	i0	84.828	37.8838709677419	145	22	47	0	161	305	3898345	3898201	MAG: Planctomycetota bacterium isolate bin1449 chromosome	blastn	11744	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
18767068	18767068	PRJNA939415_P_NODE_32815_length_310_cov_2.721519_g32393_i0	PRJNA939415	32815	310	2.721519	8.4367089	Stieleria neptunia	2527979	Bacteria	Bacteria	60.2	1.73e-4	NTclustered	gi\|1712721777\|gb\|CP037423.1\|	2527979	g32393	i0	94.737	0.12258064516129	38	2	12	0	196	233	9437027	9437064	Stieleria neptunia strain Enr13 chromosome	blastn	38	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
18767301	18767301	PRJNA939415_P_NODE_44015_length_289_cov_3.694444_g43593_i0	PRJNA939415	44015	289	3.694444	10.67694316	Rhodopirellula sp. P2	2127060	Bacteria	Bacteria	62.1	4.44e-5	NTclustered	gi\|2447573959\|gb\|CP118225.1\|	2127060	g43593	i0	100	1.10034602076125	33	0	11	0	212	244	4575083	4575051	Rhodopirellula sp. P2 chromosome, complete genome	blastn	318	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. P2
19107962	19107962	PRJNA939415_P_NODE_59115_length_274_cov_4.452736_g58693_i0	PRJNA939415	59115	274	4.452736	12.20049664	Pseudomonadati	3379134	Bacteria	Bacteria	89.8	1.92e-13	NTclustered	gi\|1712737282\|gb\|CP036318.1\|	2527990	g58693	i0	84.444	0.989051094890511	90	14	33	0	2	91	3948012	3948101	Rosistilla oblonga strain Mal33 chromosome	blastn	271	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla oblonga
21317620	21317620	PRJNA939415_P_NODE_42837_length_291_cov_1.738532_g42415_i0	PRJNA939415	42837	291	1.738532	5.05912812	Gemmataceae bacterium	2052164	Bacteria	Bacteria	233	8.969999999999999e-57	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g42415	i0	87.379	0.707903780068729	206	23	70	3	4	206	6840154	6839949	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	206	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
21318069	21318069	PRJNA939415_P_NODE_68077_length_265_cov_5.395833_g67655_i0	PRJNA939415	68077	265	5.395833	14.29895745	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	115	3.05e-21	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g67655	i0	79.096	3.57735849056604	177	29	65	7	1	173	2490470	2490642	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	948	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21318100	21318100	PRJNA939415_P_NODE_69957_length_264_cov_1.445026_g69535_i0	PRJNA939415	69957	264	1.445026	3.81486864	Gemmataceae bacterium	2052164	Bacteria	Bacteria	283	7.859999999999999e-72	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g69535	i0	86.486	1.42045454545455	259	33	97	1	1	257	7041106	7041364	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	375	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
21318540	21318540	PRJNA939415_P_NODE_95757_length_241_cov_0.916667_g95335_i0	PRJNA939415	95757	241	0.916667	2.20916747	Urbifossiella limnaea	2528023	Bacteria	Bacteria	119	2.11e-22	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g95335	i0	77.273	1.12033195020747	242	29	100	12	1	241	1560556	1560772	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	270	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22592259	22592259	PRJNA939415_P_NODE_28858_length_310_cov_3.489451_g28436_i0	PRJNA939415	28858	310	3.489451	10.8172981	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	152	2.7799999999999996e-32	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g28436	i0	96.703	0.593548387096774	91	3	29	0	214	304	6104305	6104395	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	184	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
22592359	22592359	PRJNA939415_P_NODE_33578_length_310_cov_2.565401_g33156_i0	PRJNA939415	33578	310	2.565401	7.9527431	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	150	9.98e-32	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g33156	i0	85.616	19.2967741935484	146	18	46	3	162	305	9465508	9465364	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5982	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22592684	22592684	PRJNA939415_P_NODE_50918_length_283_cov_1.233333_g50496_i0	PRJNA939415	50918	283	1.233333	3.49033239	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	126	1.52e-24	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g50496	i0	86.325	1.76678445229682	117	14	41	2	5	120	2817013	2817128	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	500	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22593160	22593160	PRJNA939415_P_NODE_76858_length_257_cov_2.380435_g76436_i0	PRJNA939415	76858	257	2.380435	6.11771795	Gemmataceae bacterium	2052164	Bacteria	Bacteria	178	3.7e-40	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g76436	i0	80.603	24.9494163424125	232	43	90	2	18	248	950482	950712	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	6412	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23868533	23868533	PRJNA939415_P_NODE_74559_length_259_cov_3.360215_g74137_i0	PRJNA939415	74559	259	3.360215	8.70295685	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	165	2.9e-36	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g74137	i0	79.365	0.972972972972973	252	38	95	14	15	259	8302224	8302468	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	252	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23868658	23868658	PRJNA939415_P_NODE_81059_length_253_cov_1.561111_g80637_i0	PRJNA939415	81059	253	1.561111	3.94961083	Limnoglobus roseus	2598579	Bacteria	Bacteria	161	3.6599999999999995e-35	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g80637	i0	80.465	30.5810276679842	215	38	84	3	41	253	8097527	8097315	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	7737	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25140902	25140902	PRJNA939415_P_NODE_104580_length_227_cov_5.779221_g104158_i0	PRJNA939415	104580	227	5.779221	13.11883167	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	230	8.699999999999997e-56	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g104158	i0	85.268	10.5462555066079	224	31	98	2	6	227	8192021	8192244	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2394	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
25141343	25141343	PRJNA939415_P_NODE_26700_length_310_cov_4.367089_g26278_i0	PRJNA939415	26700	310	4.367089	13.5379759	Gemmataceae bacterium	2052164	Bacteria	Bacteria	113	1.31e-20	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g26278	i0	80.69	39.0354838709677	145	28	47	0	5	149	7143675	7143819	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	12101	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25142560	25142560	PRJNA939415_P_NODE_92460_length_243_cov_3.723529_g92038_i0	PRJNA939415	92460	243	3.723529	9.04817547	Gemmataceae bacterium	2052164	Bacteria	Bacteria	172	1.6099999999999996e-38	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g92038	i0	82.902	0.794238683127572	193	31	79	2	1	192	3692344	3692153	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	193	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;