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

32 rows where bioproject = "PRJNA312107" 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
1063635	1063635	PRJNA312107_P_NODE_10161_length_226_cov_3.175141_g9995_i0	PRJNA312107	10161	226	3.175141	7.17581866	Microcystis	1125	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|119352232\|gb\|EF121241.1\|	1126	g9995	i0	100	101	226	0	100	0	1	226	549	774	Microcystis aeruginosa strain SPC 777 16S ribosomal RNA gene, partial sequence	blastn	22826	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
1652344	1652344	PRJNA312107_P_NODE_15422_length_186_cov_1.518248_g15256_i0	PRJNA312107	15422	186	1.518248	2.82394128	Edaphophycus epilithus	2989703	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|2075814060\|gb\|MZ700338.1\|	2866019	g15256	i0	100	126.10752688172	186	0	100	0	1	186	2020	2205	Cyanobacteria bacterium FBCC-A205 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23456	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Edaphophycus	Edaphophycus epilithus
2928253	2928253	PRJNA312107_P_NODE_23803_length_164_cov_0.904348_g23637_i0	PRJNA312107	23803	164	0.904348	1.48313072	uncultured Nostoc sp.	340711	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|1766756934\|gb\|MK685841.1\|	340711	g23637	i0	93.293	172.073170731707	164	11	100	0	1	164	287	124	Uncultured Nostoc sp. clone pJSJ2-3 PsbA (psbA) gene, partial cds	blastn	28220	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.
6755332	6755332	PRJNA312107_P_NODE_8606_length_244_cov_1.569231_g8440_i0	PRJNA312107	8606	244	1.569231	3.82892364	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	370	5.35e-98	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g8440	i0	94.561	103.430327868852	239	13	98	0	1	239	1244100	1243862	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	25237	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
8030776	8030776	PRJNA312107_P_NODE_12547_length_206_cov_0.828025_g12381_i0	PRJNA312107	12547	206	0.828025	1.7057315	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	309	9.68e-80	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g12381	i0	93.689	214.699029126214	206	13	100	0	1	206	273	478	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	44228	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
8716223	8716223	PRJNA312107_P_NODE_11407_length_215_cov_0.927711_g11241_i0	PRJNA312107	11407	215	0.927711	1.99457865	Cyanophyceae	3028117	Bacteria	Bacteria	283	6.17e-72	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g11241	i0	90.654	128.827906976744	214	19	99	1	1	213	2726	2939	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27698	285	0.992982456140351	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8716227	8716227	PRJNA312107_P_NODE_14267_length_193_cov_1.590278_g14101_i0	PRJNA312107	14267	193	1.590278	3.06923654	Cyanophyceae	3028117	Bacteria	Bacteria	259	9.13e-65	NTclustered	gi\|2117893480\|dbj\|AP024987.1\|	1285375	g14101	i0	100	157.181347150259	140	0	76	0	54	193	362787	362648	Cyanobacterium endosymbiont of Braarudosphaera bigelowii CPSB-1 DNA, complete genome	blastn	30336	261	0.992337164750958	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
8716233	8716233	PRJNA312107_P_NODE_15827_length_184_cov_1.111111_g15661_i0	PRJNA312107	15827	184	1.111111	2.04444424	Acaryochloris	155977	Bacteria	Bacteria	193	8.86e-45	NTclustered	gi\|470482548\|ref\|NR_076538.1\|	155978	g15661	i0	95.798	104.29347826087	119	5	65	0	1	119	1301	1419	Acaryochloris marina strain MBIC11017 23S ribosomal RNA gene, complete sequence	blastn	19190	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
9991782	9991782	PRJNA312107_P_NODE_16388_length_181_cov_1.060606_g16222_i0	PRJNA312107	16388	181	1.060606	1.91969686	Cyanophyceae	3028117	Bacteria	Bacteria	255	1.09e-63	NTclustered	gi\|940620467\|gb\|KR676347.1\|	945751	g16222	i0	92.265	235.972375690608	181	13	100	1	1	181	2591	2770	Calenema singularis LEGE 06188 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42711	257	0.992217898832685	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Calenema	Calenema singularis
11856301	11856301	PRJNA312107_P_NODE_5410_length_304_cov_2.831373_g5244_i0	PRJNA312107	5410	304	2.831373	8.60737392	Spirirestis rafaelensis	293980	Bacteria	Bacteria	492	1.41e-134	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g5244	i0	95.765	254.529605263158	307	10	100	2	1	304	329	23	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	77377	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
13131344	13131344	PRJNA312107_P_NODE_20231_length_168_cov_0.873950_g20065_i0	PRJNA312107	20231	168	0.87395	1.468236	Plectolyngbya salina	3016459	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2106138548\|gb\|OK382088.1\|	2880696	g20065	i0	97.024	170.02380952381	168	5	100	0	1	168	2147	1980	Plectolyngbya salina FBCC-A1477 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28564	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya salina
15091341	15091341	PRJNA312107_P_NODE_15932_length_183_cov_1.552239_g15766_i0	PRJNA312107	15932	183	1.552239	2.84059737	Hassallia	482629	Bacteria	Bacteria	300	5.040000000000001e-77	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g15766	i0	96.175	250.677595628415	183	7	100	0	1	183	2200	2382	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	45874	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
17641263	17641263	PRJNA312107_P_NODE_1154_length_651_cov_3.081395_g1005_i0	PRJNA312107	1154	651	3.081395	20.05988145	Nostoc	1177	Bacteria	Bacteria	929	0	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g1005	i0	94.253	315.519201228879	609	33	99	2	40	648	2143434	2144040	Nostoc piscinale CENA21 chromosome	blastn	205403	933	0.995712754555198	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
20189696	20189696	PRJNA312107_P_NODE_14416_length_192_cov_1.454545_g14250_i0	PRJNA312107	14416	192	1.454545	2.7927264	root	1	Root_unresolved	Root_unresolved	355	1.13e-93	NTclustered	gi\|1667280853\|gb\|MK968507.1\|	1211	g14250	i0	100	117.838541666667	192	0	100	0	1	192	377	186	Uncultured cyanobacterium clone illumina55 16S ribosomal RNA gene, partial sequence	blastn	22625	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21465361	21465361	PRJNA312107_P_NODE_4557_length_330_cov_1.590747_g4391_i0	PRJNA312107	4557	330	1.590747	5.2494651	Microcystis	1125	Bacteria	Bacteria	603	6.839999999999998e-168	NTclustered	gi\|1566846205\|dbj\|LC455583.1\|	1126	g4391	i0	99.696	141.672727272727	329	1	99	0	2	330	344	16	Microcystis aeruginosa NIES-3804 gene for 23S ribosomal RNA, partial sequence	blastn	46752	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
22740416	22740416	PRJNA312107_P_NODE_25378_length_162_cov_1.380531_g25212_i0	PRJNA312107	25378	162	1.380531	2.23646022	Cyanophyceae	3028117	Bacteria	Bacteria	200	4.549999999999998e-47	NTclustered	gi\|46409892\|gb\|AY584517.1\|	251221	g25212	i0	88.957	179.283950617284	163	17	100	1	1	162	1369	1207	Gloeobacter violaceus PCC 7421 23S ribosomal RNA gene, partial sequence	blastn	29044	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
23329721	23329721	PRJNA312107_P_NODE_6119_length_287_cov_1.680672_g5953_i0	PRJNA312107	6119	287	1.680672	4.82352864	Spirirestis rafaelensis	293980	Bacteria	Bacteria	436	6.2699999999999985e-118	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g5953	i0	94.097	180.428571428571	288	16	100	1	1	287	326	613	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	51783	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
26916054	26916054	PRJNA312107_P_NODE_22702_length_165_cov_0.896552_g22536_i0	PRJNA312107	22702	165	0.896552	1.4793108	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	48.9	1.69e-5	NR	MBS1956149.1	2807733	g22536	i0	75	0.509090909090909	28	7	50.9	0	86	3	26	53	MBS1956149.1 hypothetical protein [Cyanobacteria bacterium SZAS-4]	diamond	84	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
27137026	27137026	PRJNA312107_P_NODE_26302_length_162_cov_0.911504_g26136_i0	PRJNA312107	26302	162	0.911504	1.47663648	Chamaesiphon sp. OTE_75_metabat_556	2964692	Bacteria	Bacteria	68.2	2.94e-12	NR	WP_309732336.1	2964692	g26136	i0	94.3	0.648148148148148	35	2	64.8	0	105	1	1	35	WP_309732336.1 hypothetical protein [Chamaesiphon sp. OTE_75_metabat_556]	diamond	105	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon sp. OTE_75_metabat_556
27674709	27674709	PRJNA312107_P_NODE_25164_length_163_cov_0.912281_g24998_i0	PRJNA312107	25164	163	0.912281	1.48701803	Planktothrix sp.	3088171	Bacteria	Bacteria	52	5.16e-6	NR	WP_408974114.1	3088171	g24998	i0	65.7	1.91411042944785	35	12	64.4	0	107	3	5	39	WP_408974114.1 NAD-dependent epimerase/dehydratase family protein, partial [Planktothrix sp.]	diamond	312	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
28337579	28337579	PRJNA312107_P_NODE_23526_length_164_cov_0.904348_g23360_i0	PRJNA312107	23526	164	0.904348	1.48313072	Cyanobacteria bacterium SBC	2821503	Bacteria	Bacteria	45.1	0.00196	NR	MBP0006229.1	2821503	g23360	i0	61.8	0.621951219512195	34	13	62.2	0	163	62	98	131	MBP0006229.1 hypothetical protein [Cyanobacteria bacterium SBC]	diamond	102	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SBC
28481433	28481433	PRJNA312107_P_NODE_23906_length_164_cov_0.904348_g23740_i0	PRJNA312107	23906	164	0.904348	1.48313072	Nostoc	1177	Bacteria	Bacteria	61.2	3.06e-9	NR	WP_334709631.1	1180	g23740	i0	66.7	3.05487804878049	42	14	76.8	0	20	145	205	246	WP_334709631.1 XDD3 family exosortase-dependent surface protein [Nostoc sp.]	diamond	501	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29410958	29410958	PRJNA312107_P_NODE_18389_length_170_cov_0.950413_g18223_i0	PRJNA312107	18389	170	0.950413	1.6157021	Synechococcus sp. SB0668_bin_15	2604860	Bacteria	Bacteria	41.6	0.0357	NR	MXW39839.1	2604860	g18223	i0	41.5	0.935294117647059	53	25	82.9	1	15	155	294	346	MXW39839.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Synechococcus sp. SB0668_bin_15]	diamond	159	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SB0668_bin_15
29821269	29821269	PRJNA312107_P_NODE_17911_length_172_cov_1.495935_g17745_i0	PRJNA312107	17911	172	1.495935	2.5730082	Trichocoleus	450526	Bacteria	Bacteria	72.4	4.63e-14	NR	WP_190443484.1	450526	g17745	i0	53.6	1.95348837209302	56	26	97.7	0	4	171	54	109	WP_190443484.1 MULTISPECIES: DUF2199 domain-containing protein [Trichocoleus]	diamond	336	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus
30295844	30295844	PRJNA312107_P_NODE_21312_length_166_cov_1.726496_g21146_i0	PRJNA312107	21312	166	1.726496	2.86598336	Brunnivagina elsteri	1247191	Bacteria	Bacteria	44.7	0.00269	NR	WP_095720514.1	1247191	g21146	i0	55	1.51807228915663	40	18	72.3	0	27	146	263	302	WP_095720514.1 LamG domain-containing protein [Brunnivagina elsteri]	diamond	252	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Brunnivagina	Brunnivagina elsteri
30548146	30548146	PRJNA312107_P_NODE_19273_length_169_cov_0.866667_g19107_i0	PRJNA312107	19273	169	0.866667	1.46466723	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	108	6.19e-26	NR	HCF29829.1	2055787	g19107	i0	94.5	1.95266272189349	55	3	97.6	0	3	167	403	457	HCF29829.1 amidase [Cyanobacteria bacterium UBA11049]	diamond	330	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
30692058	30692058	PRJNA312107_P_NODE_18813_length_169_cov_0.866667_g18647_i0	PRJNA312107	18813	169	0.866667	1.46466723	Chroococcales	1118	Bacteria	Bacteria	107	5.22e-26	NR	WP_002736029.1	1125	g18647	i0	85.7	7.95266272189349	56	8	99.4	0	168	1	346	401	WP_002736029.1 MULTISPECIES: DHH family phosphoesterase [Microcystis]	diamond	1344	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
30769431	30769431	PRJNA312107_P_NODE_19214_length_169_cov_0.866667_g19048_i0	PRJNA312107	19214	169	0.866667	1.46466723	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	53.9	1.2e-6	NR	MEY2857904.1	2847862	g19048	i0	50.9	1.88165680473373	53	26	94.1	0	167	9	101	153	MEY2857904.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	318	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31370090	31370090	PRJNA312107_P_NODE_22776_length_165_cov_0.896552_g22610_i0	PRJNA312107	22776	165	0.896552	1.4793108	Altericista sp. CCNU	3082949	Bacteria	Bacteria	95.5	7.37e-22	NR	WP_404787685.1	3082949	g22610	i0	81.5	0.981818181818182	54	10	98.2	0	3	164	53	106	WP_404787685.1 carbohydrate kinase family protein [Altericista sp. CCNU0014]	diamond	162	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
31939075	31939075	PRJNA312107_P_NODE_18517_length_169_cov_1.408333_g18351_i0	PRJNA312107	18517	169	1.408333	2.38008277	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	62	2.08e-9	NR	MFA6213499.1	2364082	g18351	i0	54.5	0.976331360946746	55	25	97.6	0	5	169	135	189	MFA6213499.1 DUF5309 family protein [Candidatus Obscuribacterales bacterium]	diamond	165	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32146664	32146664	PRJNA312107_P_NODE_20598_length_167_cov_0.881356_g20432_i0	PRJNA312107	20598	167	0.881356	1.47186452	Bacteria	2	Bacteria	Bacteria	40.8	0.0499	NR	MCA9818457.1	2775581	g20432	i0	51.3	1.59880239520958	39	18	70.1	1	152	36	50	87	MCA9818457.1 hypothetical protein [Cyanobacteria bacterium HKST-UBA01]	diamond	267	41.2	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium HKST-UBA01
32287585	32287585	PRJNA312107_P_NODE_25419_length_162_cov_1.247788_g25253_i0	PRJNA312107	25419	162	1.247788	2.02141656	Rivularia sp. IAM M-261	448371	Bacteria	Bacteria	43.5	0.00107	NR	GJD20192.1	448371	g25253	i0	53.7	1.51851851851852	41	19	75.9	0	123	1	5	45	GJD20192.1 hypothetical protein RIVM261_051480 [Rivularia sp. IAM M-261]	diamond	246	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. IAM M-261

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