metadata: contig_metadata: 32 rows where bioproject = "PRJNA640143" and tax_clade = "Cyanobacteriota/Melainabacteria group"

32 rows where bioproject = "PRJNA640143" and tax_clade = "Cyanobacteriota/Melainabacteria 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
3160915	3160915	PRJNA640143_S_NODE_2583_length_486_cov_37.138085_g2402_i0	PRJNA640143	2583	486	37.138085	180.4910931	Aliterella chasmolithica	2739056	Bacteria	Bacteria	627	6.189999999999998e-175	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2402	i0	91.63	115.843621399177	454	36	93	2	34	486	1965	2417	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56300	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
3707113	3707113	PRJNA640143_S_NODE_28923_length_162_cov_1.328000_g28713_i0	PRJNA640143	28923	162	1.328	2.15136	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	237	3.47e-58	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g28713	i0	93.168	134.722222222222	161	11	99	0	1	161	5577607	5577447	Anabaena sp. YBS01 chromosome, complete genome	blastn	21825	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
5713778	5713778	PRJNA640143_S_NODE_5605_length_350_cov_3.926518_g5395_i0	PRJNA640143	5605	350	3.926518	13.742813	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	503	7.59e-138	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5395	i0	92.635	150.485714285714	353	20	99	3	1	349	2033	2383	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52670	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9538351	9538351	PRJNA640143_S_NODE_18728_length_202_cov_11.563636_g18518_i0	PRJNA640143	18728	202	11.563636	23.35854472	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	292	9.52e-75	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18518	i0	98.204	2.21287128712871	167	3	83	0	1	167	5032591	5032425	Calothrix sp. PCC 7716 DNA, complete genome	blastn	447	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
16458148	16458148	PRJNA640143_S_NODE_17973_length_206_cov_17.147929_g17763_i0	PRJNA640143	17973	206	17.147929	35.32473374	Bacteria	2	Bacteria	Bacteria	307	3.4800000000000004e-79	NTclustered	gi\|315190017\|gb\|HQ595208.1\|	1211	g17763	i0	100	117.776699029126	166	0	81	0	41	206	1	166	Uncultured cyanobacterium clone IC3040 16S ribosomal RNA gene, partial sequence	blastn	24262	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21012285	21012285	PRJNA640143_S_NODE_21337_length_190_cov_6.928105_g21127_i0	PRJNA640143	21337	190	6.928105	13.1633995	Candidatus Melainabacteria bacterium RIFCSPHIGHO2_	2052166	Bacteria	Bacteria	109	1.2e-26	NR	OGI19083.1	1801607	g21127	i0	88.5	0.963157894736842	61	7	96.3	0	184	2	21	81	OGI19083.1 MAG: hypothetical protein A3B68_07760 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	183	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
21012368	21012368	PRJNA640143_S_NODE_25397_length_175_cov_2.224638_g25187_i0	PRJNA640143	25397	175	2.224638	3.8931165	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	172	1.08e-38	NTclustered	gi\|2112847628\|emb\|OU815587.1\|	693223	g25187	i0	84.483	18.5142857142857	174	27	99	0	1	174	345	172	Gloeocapsopsis crepidinum cpcB gene for C-phycocyanin beta chain, strain CCAP 1425/1	blastn	3240	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
22832763	22832763	PRJNA640143_S_NODE_11658_length_253_cov_11.893519_g11448_i0	PRJNA640143	11658	253	11.893519	30.09060307	Drouetiella	2303513	Bacteria	Bacteria	351	2.02e-92	NTclustered	gi\|2312649307\|gb\|OP577847.1\|	2983374	g11448	i0	96.279	144.928853754941	215	6	84	2	6	218	2121	1907	Drouetiella lurida ACKU666 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36667	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella lurida
22832840	22832840	PRJNA640143_S_NODE_2198_length_519_cov_4.788382_g2042_i0	PRJNA640143	2198	519	4.788382	24.85170258	Microcystis	1125	Bacteria	Bacteria	553	1.1399999999999995e-152	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g2042	i0	86.747	148.400770712909	498	64	96	2	1	498	4186376	4186871	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	77020	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
23562787	23562787	PRJNA640143_S_NODE_4959_length_369_cov_3.701807_g4749_i0	PRJNA640143	4959	369	3.701807	13.65966783	Drouetiella epilithica	3059494	Bacteria	Bacteria	555	2.1899999999999999e-153	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g4749	i0	96.429	119.457994579946	336	12	91	0	1	336	2438	2103	Drouetiella epilithica ACKU670 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44080	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica
23562805	23562805	PRJNA640143_S_NODE_5559_length_351_cov_106.149682_g5349_i0	PRJNA640143	5559	351	106.149682	372.58538382	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	388	2.23e-103	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g5349	i0	92.91	171.680911680912	268	17	76	1	36	301	1234	1501	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	60260	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
25381760	25381760	PRJNA640143_S_NODE_19460_length_199_cov_1.444444_g19250_i0	PRJNA640143	19460	199	1.444444	2.87444356	Nostoc	1177	Bacteria	Bacteria	62.1	2.87e-5	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g19250	i0	88.679	0.683417085427136	53	3	25	2	1	50	1081594	1081646	Nostoc sp. NIES-3756 DNA, complete genome	blastn	136	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
27143807	27143807	PRJNA640143_S_NODE_19042_length_201_cov_2.018293_g18832_i0	PRJNA640143	19042	201	2.018293	4.05676893	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	49.7	7.56e-5	NR	WP_250124880.1	155894	g18832	i0	41.8	0.82089552238806	55	32	82.1	0	35	199	34	88	WP_250124880.1 restriction endonuclease subunit S [Chroococcidiopsis sp. CCMEE 29]	diamond	165	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
27302403	27302403	PRJNA640143_S_NODE_9563_length_277_cov_226.100000_g9353_i0	PRJNA640143	9563	277	226.1	626.297	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	72	5.43e-13	NR	MBI3591838.1	2052166	g9353	i0	51.7	2.10108303249097	60	29	65	0	90	269	2	61	MBI3591838.1 ComF family protein [Candidatus Melainabacteria bacterium]	diamond	582	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27933865	27933865	PRJNA640143_S_NODE_5165_length_362_cov_4.067692_g4955_i0	PRJNA640143	5165	362	4.067692	14.72504504	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	72	7.16e-13	NR	WP_009632138.1	927677	g4955	i0	94.7	0.314917127071823	38	2	31.5	0	116	3	1	38	WP_009632138.1 phycocyanin subunit beta [Synechocystis sp. PCC 7509]	diamond	114	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28312856	28312856	PRJNA640143_S_NODE_5706_length_347_cov_12.370968_g5496_i0	PRJNA640143	5706	347	12.370968	42.92725896	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	159	1.1099999999999998e-47	NR	MFN4150757.1	2762020	g5496	i0	98.8	0.708933717579251	82	1	70.9	0	92	337	1	82	MFN4150757.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	246	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28344267	28344267	PRJNA640143_S_NODE_13626_length_235_cov_9.646465_g13416_i0	PRJNA640143	13626	235	9.646465	22.66919275	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	115	3.1299999999999995e-31	NR	MFN4150651.1	2762020	g13416	i0	88.5	0.778723404255319	61	7	77.9	0	37	219	36	96	MFN4150651.1 transglycosylase SLT domain-containing protein [Candidatus Sericytochromatia bacterium]	diamond	183	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28344273	28344273	PRJNA640143_S_NODE_23246_length_183_cov_1.335616_g23036_i0	PRJNA640143	23246	183	1.335616	2.44417728	Xenococcaceae cyanobacterium MO_188.B32	3036640	Bacteria	Bacteria	43.5	0.00211	NR	MDJ0687266.1	3036640	g23036	i0	67.7	0.508196721311475	31	10	50.8	0	3	95	65	95	MDJ0687266.1 RNA-binding protein [Xenococcaceae cyanobacterium MO_188.B32]	diamond	93	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_188.B32
28407519	28407519	PRJNA640143_S_NODE_23086_length_183_cov_4.020548_g22876_i0	PRJNA640143	23086	183	4.020548	7.35760284	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	86.7	4.76e-19	NR	MFN4151522.1	2762020	g22876	i0	90	0.819672131147541	50	4	80.3	1	35	181	16	65	MFN4151522.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	150	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28786163	28786163	PRJNA640143_S_NODE_18987_length_201_cov_3.414634_g18777_i0	PRJNA640143	18987	201	3.414634	6.86341434	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	57.4	1.45e-7	NR	MBI2995626.1	2052166	g18777	i0	75	0.477611940298507	32	8	47.8	0	104	199	108	139	MBI2995626.1 VCBS repeat-containing protein [Candidatus Melainabacteria bacterium]	diamond	96	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28912353	28912353	PRJNA640143_S_NODE_11428_length_256_cov_1.849315_g11218_i0	PRJNA640143	11428	256	1.849315	4.7342464	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	75.1	1.83e-13	NR	MBI2995253.1	2052166	g11218	i0	67.8	0.69140625	59	19	69.1	0	74	250	361	419	MBI2995253.1 chromosome segregation protein SMC [Candidatus Melainabacteria bacterium]	diamond	177	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29417690	29417690	PRJNA640143_S_NODE_10809_length_262_cov_49.560000_g10599_i0	PRJNA640143	10809	262	49.56	129.8472	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	144	6.51e-41	NR	MFN4151287.1	2762020	g10599	i0	97.2	1.62595419847328	71	2	81.3	0	225	13	20	90	MFN4151287.1 uracil-DNA glycosylase family protein [Candidatus Sericytochromatia bacterium]	diamond	426	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29525115	29525115	PRJNA640143_S_NODE_26510_length_171_cov_1.671642_g26300_i0	PRJNA640143	26510	171	1.671642	2.85850782	Bacteria	2	Bacteria	Bacteria	60.1	9.78e-9	NR	OGI20562.1	1801607	g26300	i0	71.1	2.36842105263158	45	13	78.9	0	154	20	143	187	OGI20562.1 MAG: hypothetical protein A3B68_05830 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	405	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
29575475	29575475	PRJNA640143_S_NODE_18250_length_205_cov_2.321429_g18040_i0	PRJNA640143	18250	205	2.321429	4.75892945	Nostocaceae	1162	Bacteria	Bacteria	67.8	3.33e-12	NR	WP_126987027.1	1162	g18040	i0	52.3	0.951219512195122	65	30	95.1	1	203	9	70	133	WP_126987027.1 MULTISPECIES: hypothetical protein [Nostocaceae]	diamond	195	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
29967149	29967149	PRJNA640143_S_NODE_14651_length_227_cov_13.878947_g14441_i0	PRJNA640143	14651	227	13.878947	31.50520969	Bacteria	2	Bacteria	Bacteria	43.5	0.0166	NR	KPQ31753.1	1666911	g14441	i0	42	2.04845814977974	50	26	66.1	2	198	49	537	583	KPQ31753.1 MAG: protein of unknown function (DUF3883) [Phormidesmis priestleyi Ana]	diamond	465	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis priestleyi
30143839	30143839	PRJNA640143_S_NODE_22512_length_185_cov_12.033784_g22302_i0	PRJNA640143	22512	185	12.033784	22.2625004	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	75.1	3.7e-14	NR	MFN4150107.1	2762020	g22302	i0	100	0.632432432432432	39	0	63.2	0	34	150	1	39	MFN4150107.1 FAD-dependent thymidylate synthase [Candidatus Sericytochromatia bacterium]	diamond	117	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30618043	30618043	PRJNA640143_S_NODE_7113_length_315_cov_4.043165_g6903_i0	PRJNA640143	7113	315	4.043165	12.73596975	Candidatus Melainabacteria bacterium RIFCSPHIGHO2_	2052166	Bacteria	Bacteria	84.3	2.12e-17	NR	OGI18898.1	1801607	g6903	i0	55.7	0.666666666666667	70	31	66.7	0	272	63	159	228	OGI18898.1 MAG: hypothetical protein A3B68_06650 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	210	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
30681092	30681092	PRJNA640143_S_NODE_12833_length_242_cov_2.907317_g12623_i0	PRJNA640143	12833	242	2.907317	7.03570714	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	150	3.96e-43	NR	MFN4151288.1	2762020	g12623	i0	93.7	1.95867768595041	79	5	97.9	0	241	5	186	264	MFN4151288.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	474	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30681096	30681096	PRJNA640143_S_NODE_22793_length_184_cov_7.918367_g22583_i0	PRJNA640143	22793	184	7.918367	14.56979528	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	97.4	5.15e-23	NR	MFN4149905.1	2762020	g22583	i0	97.9	0.766304347826087	47	1	76.6	0	142	2	79	125	MFN4149905.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	141	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31123274	31123274	PRJNA640143_S_NODE_12275_length_247_cov_252.195238_g12065_i0	PRJNA640143	12275	247	252.195238	622.92223786	Pleurocapsa sp. CCALA 161	2107688	Bacteria	Bacteria	136	1.82e-37	NR	WP_106236211.1	2107688	g12065	i0	98.6	0.838056680161943	69	1	83.8	0	207	1	72	140	WP_106236211.1 SDR family oxidoreductase [Pleurocapsa sp. CCALA 161]	diamond	207	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. CCALA 161
32515784	32515784	PRJNA640143_S_NODE_9319_length_280_cov_6.316872_g9109_i0	PRJNA640143	9319	280	6.316872	17.6872416	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	147	1.15e-41	NR	WP_106369903.1	2107693	g9109	i0	98.6	0.792857142857143	74	1	79.3	0	34	255	46	119	WP_106369903.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	222	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32685475	32685475	PRJNA640143_S_NODE_28640_length_163_cov_1.238095_g28430_i0	PRJNA640143	28640	163	1.238095	2.01809485	Bacteria	2	Bacteria	Bacteria	45.8	1.5e-4	NR	OGI20361.1	1801607	g28430	i0	69.2	1.43558282208589	26	8	47.9	0	2	79	33	58	OGI20361.1 MAG: hypothetical protein A3B68_02420 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	234	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12

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