metadata: contig_metadata: 36 rows where bioproject = "PRJNA1175041" and tax

36 rows where bioproject = "PRJNA1175041" and tax_kingdom = "Bacillati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1041123	1041123	PRJNA1175041_P_NODE_66661_length_342_cov_1.182156_g63793_i0	PRJNA1175041	66661	342	1.182156	4.04297352	Mesomycoplasma	2923352	Bacteria	Bacteria	625	1.5199999999999998e-174	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g63793	i0	99.707	16.3099415204678	341	1	99	0	2	342	671212	670872	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	5578	625	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
1591112	1591112	PRJNA1175041_P_NODE_103802_length_243_cov_0.894118_g100934_i0	PRJNA1175041	103802	243	0.894118	2.17270674	Streptococcus pasteurianus	197614	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2605139866\|gb\|CP136943.1\|	197614	g100934	i0	100	22	243	0	100	0	1	243	831437	831195	Streptococcus pasteurianus strain WUSP082 chromosome, complete genome	blastn	5346	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pasteurianus
2316390	2316390	PRJNA1175041_P_NODE_39102_length_553_cov_1.456250_g36248_i0	PRJNA1175041	39102	553	1.45625	8.0530625	Bacillus	1386	Bacteria	Bacteria	1016	0	NTclustered	gi\|2798377728\|gb\|CP168764.1\|	1392	g36248	i0	99.819	100	553	1	100	0	1	553	3916615	3917167	Bacillus anthracis strain Z03-J001 chromosome, complete genome	blastn	55300	1016	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
4869162	4869162	PRJNA1175041_P_NODE_107384_length_239_cov_1.783133_g104516_i0	PRJNA1175041	107384	239	1.783133	4.26168787	Mesomycoplasma	2923352	Bacteria	Bacteria	431	2.3599999999999996e-116	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g104516	i0	99.167	15.0627615062761	240	1	100	1	1	239	423457	423696	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3600	431	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
5420677	5420677	PRJNA1175041_P_NODE_98305_length_248_cov_0.868571_g95437_i0	PRJNA1175041	98305	248	0.868571	2.15405608	Corynebacterium hadale	2026255	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g95437	i0	100	385.064516129032	248	0	100	0	1	248	1273267	1273514	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	95496	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
6143960	6143960	PRJNA1175041_P_NODE_27345_length_781_cov_1.593220_g24659_i0	PRJNA1175041	27345	781	1.59322	12.4430482	Bacillus	1386	Bacteria	Bacteria	1432	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g24659	i0	99.744	100.166453265045	781	2	100	0	1	781	3356875	3357655	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	78230	1432	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
8694045	8694045	PRJNA1175041_P_NODE_46807_length_467_cov_1.446701_g43941_i0	PRJNA1175041	46807	467	1.446701	6.75609367	Corynebacterium	1716	Bacteria	Bacteria	841	0	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g43941	i0	99.355	366.758029978587	465	1	99	1	1	465	293904	294366	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	171276	841	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
8694047	8694047	PRJNA1175041_P_NODE_50007_length_440_cov_1.408719_g47140_i0	PRJNA1175041	50007	440	1.408719	6.1983636	Bacillus	1386	Bacteria	Bacteria	813	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g47140	i0	100	100	440	0	100	0	1	440	3948299	3947860	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	44000	813	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9244378	9244378	PRJNA1175041_P_NODE_104108_length_242_cov_1.408284_g101240_i0	PRJNA1175041	104108	242	1.408284	3.40804728	Lachnospiraceae bacterium JLR.KK009	3114295	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2692820420\|gb\|CP143549.1\|	3114295	g101240	i0	96.281	1.61157024793388	242	9	100	0	1	242	390155	389914	Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome	blastn	390	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium JLR.KK009
9245502	9245502	PRJNA1175041_P_NODE_99028_length_247_cov_0.873563_g96160_i0	PRJNA1175041	99028	247	0.873563	2.15770061	Schaalia odontolytica	1660	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|1663040979\|gb\|CP040006.1\|	1660	g96160	i0	98.571	0.283400809716599	70	1	28	0	1	70	1127189	1127258	Schaalia odontolytica strain XH001 chromosome, complete genome	blastn	70	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
9969225	9969225	PRJNA1175041_P_NODE_54328_length_409_cov_1.523810_g51460_i0	PRJNA1175041	54328	409	1.52381	6.2323829	Mollicutes	31969	Bacteria	Bacteria	750	0	NTclustered	gi\|281186773\|gb\|GU227378.1\|	2100	g51460	i0	99.756	100.987775061125	409	1	100	0	1	409	1346	938	Mycoplasma hyorhinis strain USP36P 16S ribosomal RNA gene, partial sequence	blastn	41304	750	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
9969239	9969239	PRJNA1175041_P_NODE_70868_length_325_cov_1.448413_g68000_i0	PRJNA1175041	70868	325	1.448413	4.70734225	Bacillus	1386	Bacteria	Bacteria	590	5.2299999999999986e-164	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g68000	i0	99.385	100	325	2	100	0	1	325	3971078	3971402	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	32500	590	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9969264	9969264	PRJNA1175041_P_NODE_99408_length_247_cov_0.862069_g96540_i0	PRJNA1175041	99408	247	0.862069	2.12931043	Bifidobacterium	1678	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2450724931\|gb\|CP118598.1\|	1679	g96540	i0	99.595	8	247	1	100	0	1	247	1222869	1223115	Bifidobacterium longum subsp. longum strain F2 chromosome, complete genome	blastn	1976	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
12519810	12519810	PRJNA1175041_P_NODE_96810_length_249_cov_0.863636_g93942_i0	PRJNA1175041	96810	249	0.863636	2.15045364	root	1	Root_unresolved	Root_unresolved	399	6.989999999999999e-107	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g93942	i0	95.582	99.566265060241	249	11	100	0	1	249	2463444	2463692	Staphylococcus aureus strain WH9628 chromosome	blastn	24792	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13794446	13794446	PRJNA1175041_P_NODE_96051_length_250_cov_1.000000_g93183_i0	PRJNA1175041	96051	250	1	2.5	Geodermatophilaceae	85030	Bacteria	Bacteria	302	2.04e-77	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93183	i0	88.538	241.064	253	24	100	5	1	250	1652	1402	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	60266	303	0.996699669966997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
14346520	14346520	PRJNA1175041_P_NODE_90452_length_265_cov_0.973958_g87584_i0	PRJNA1175041	90452	265	0.973958	2.5809887	Corynebacterium gottingense	2041036	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2869851930\|gb\|CP175790.1\|	2041036	g87584	i0	99.623	362.581132075472	265	1	100	0	1	265	244019	244283	Corynebacterium gottingense strain YSMAA1_1_F6 chromosome, complete genome	blastn	96084	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
15619271	15619271	PRJNA1175041_P_NODE_106713_length_240_cov_0.910180_g103845_i0	PRJNA1175041	106713	240	0.91018	2.184432	Streptococcus mitis	28037	Bacteria	Bacteria	377	3.14e-100	NTclustered	gi\|2886508907\|emb\|OZ217344.1\|	28037	g103845	i0	95	100	240	12	100	0	1	240	785652	785891	Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1	blastn	24000	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
16343619	16343619	PRJNA1175041_P_NODE_108173_length_239_cov_0.915663_g105305_i0	PRJNA1175041	108173	239	0.915663	2.18843457	Streptococcus	1301	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|335369081\|gb\|CP002843.1\|	760570	g105305	i0	100	12.7531380753138	239	0	100	0	1	239	1698443	1698681	Streptococcus parasanguinis ATCC 15912, complete genome	blastn	3048	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
16893501	16893501	PRJNA1175041_P_NODE_101494_length_245_cov_0.883721_g98626_i0	PRJNA1175041	101494	245	0.883721	2.16511645	Angelakisella sp.	1935177	Bacteria	Bacteria	139	2.56e-36	NR	MCI9667402.1	1935177	g98626	i0	96.2	1.91020408163265	79	3	96.7	0	238	2	1	79	MCI9667402.1 hypothetical protein [Angelakisella sp.]	diamond	468	139	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Angelakisella	Angelakisella sp.
16893568	16893568	PRJNA1175041_P_NODE_105694_length_241_cov_0.904762_g102826_i0	PRJNA1175041	105694	241	0.904762	2.18047642	Streptomyces sp. 11x1	3038642	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2591930018\|gb\|CP122458.1\|	3038642	g102826	i0	96.875	0.132780082987552	32	0	13	1	91	122	5456664	5456634	Streptomyces sp. 11x1 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 11x1
17618900	17618900	PRJNA1175041_P_NODE_40814_length_531_cov_1.296943_g37952_i0	PRJNA1175041	40814	531	1.296943	6.88676733	Bacillus	1386	Bacteria	Bacteria	754	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g37952	i0	100	100.566854990584	408	0	100	0	124	531	3356178	3356585	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	53401	754	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
22718005	22718005	PRJNA1175041_P_NODE_103818_length_243_cov_0.894118_g100950_i0	PRJNA1175041	103818	243	0.894118	2.17270674	Clostridia	186801	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2777750333\|dbj\|AP031452.1\|	39491	g100950	i0	99.177	20.7325102880658	243	2	100	0	1	243	2575854	2575612	Agathobacter rectalis k41-0107-C12 DNA, complete genome	blastn	5038	438	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
22718040	22718040	PRJNA1175041_P_NODE_79638_length_295_cov_1.063063_g76770_i0	PRJNA1175041	79638	295	1.063063	3.13603585	Corynebacterium	1716	Bacteria	Bacteria	512	1.04e-140	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g76770	i0	97.966	433.840677966102	295	6	100	0	1	295	735100	735394	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	127983	512	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
22718041	22718041	PRJNA1175041_P_NODE_79918_length_294_cov_1.262443_g77050_i0	PRJNA1175041	79918	294	1.262443	3.71158242	Corynebacterium	1716	Bacteria	Bacteria	514	2.8899999999999997e-141	NTclustered	gi\|2869815348\|gb\|CP175785.1\|	1979527	g77050	i0	98.299	370.585034013605	294	3	100	2	1	294	545944	546235	Corynebacterium kefirresidentii strain YSMAA1_2_B7 chromosome, complete genome	blastn	108952	514	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
22718057	22718057	PRJNA1175041_P_NODE_99958_length_246_cov_0.878613_g97090_i0	PRJNA1175041	99958	246	0.878613	2.16138798	Corynebacterium	1716	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g97090	i0	97.154	4.00813008130081	246	7	100	0	1	246	17556	17311	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	986	416	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
26964737	26964737	PRJNA1175041_P_NODE_99382_length_247_cov_0.873563_g96514_i0	PRJNA1175041	99382	247	0.873563	2.15770061	Bacillati	1783272	Bacteria	Bacteria	105	1.13e-25	NR	WP_261197916.1	1423	g96514	i0	71.3	16.0931174089069	80	23	97.2	0	242	3	19	98	WP_261197916.1 hypothetical protein [Bacillus subtilis]	diamond	3975	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
27103675	27103675	PRJNA1175041_P_NODE_99982_length_246_cov_0.878613_g97114_i0	PRJNA1175041	99982	246	0.878613	2.16138798	uncultured Dubosiella sp.	1937011	Bacteria	Bacteria	168	1.63e-49	NR	WP_289197645.1	1937011	g97114	i0	98.8	1	82	1	100	0	246	1	120	201	WP_289197645.1 PolC-type DNA polymerase III [uncultured Dubosiella sp.]	diamond	246	168	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Dubosiella	uncultured Dubosiella sp.
27514595	27514595	PRJNA1175041_P_NODE_82003_length_288_cov_1.093023_g79135_i0	PRJNA1175041	82003	288	1.093023	3.14790624	Eubacterium sp.	142586	Bacteria	Bacteria	202	9.95e-63	NR	MCI9209700.1	142586	g79135	i0	100	1	96	0	100	0	1	288	214	309	MCI9209700.1 alpha/beta hydrolase [Eubacterium sp.]	diamond	288	202	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
27577714	27577714	PRJNA1175041_P_NODE_107804_length_239_cov_0.915663_g104936_i0	PRJNA1175041	107804	239	0.915663	2.18843457	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	157	8.44e-44	NR	MDY2789824.1	1898203	g104936	i0	94.9	6.94142259414226	79	4	99.2	0	2	238	285	363	MDY2789824.1 amidophosphoribosyltransferase [Lachnospiraceae bacterium]	diamond	1659	157	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27798906	27798906	PRJNA1175041_P_NODE_107224_length_240_cov_0.886228_g104356_i0	PRJNA1175041	107224	240	0.886228	2.1269472	Eubacterium sp.	142586	Bacteria	Bacteria	89.4	3.27e-19	NR	MCI9412796.1	142586	g104356	i0	73.1	0.65	52	14	65	0	3	158	250	301	MCI9412796.1 restriction endonuclease [Eubacterium sp.]	diamond	156	89.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
28619849	28619849	PRJNA1175041_P_NODE_102187_length_244_cov_0.888889_g99319_i0	PRJNA1175041	102187	244	0.888889	2.16888916	unclassified Turicibacter	2638206	Bacteria	Bacteria	67.8	1.6e-12	NR	WP_262953588.1	2638206	g99319	i0	67.3	0.602459016393443	49	16	60.2	0	178	32	55	103	WP_262953588.1 MULTISPECIES: helix-turn-helix domain-containing protein [unclassified Turicibacter]	diamond	147	67.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter
30420088	30420088	PRJNA1175041_P_NODE_96513_length_249_cov_0.863636_g93645_i0	PRJNA1175041	96513	249	0.863636	2.15045364	Lachnospiraceae bacterium 1	1898203	Bacteria	Bacteria	120	1.15e-31	NR	EOS78106.1	1235800	g93645	i0	77.5	0.963855421686747	80	18	96.4	0	9	248	6	85	EOS78106.1 hypothetical protein C819_00417 [Lachnospiraceae bacterium 10-1]	diamond	240	120	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium 10-1
30628254	30628254	PRJNA1175041_P_NODE_83373_length_284_cov_1.218009_g80505_i0	PRJNA1175041	83373	284	1.218009	3.45914556	Actinomycetes	1760	Bacteria	Bacteria	43.9	0.0232	NR	WP_281860861.1	120377	g80505	i0	32.2	1.26760563380282	59	40	62.3	0	7	183	370	428	WP_281860861.1 ATP-binding protein [Salana multivorans]	diamond	360	44.3	0.99097065462754	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Beutenbergiaceae	Salana	Salana multivorans
30862062	30862062	PRJNA1175041_P_NODE_96934_length_249_cov_0.863636_g94066_i0	PRJNA1175041	96934	249	0.863636	2.15045364	Acetatifactor sp.	1872090	Bacteria	Bacteria	166	1.92e-48	NR	MFG6356014.1	1872090	g94066	i0	100	0.987951807228916	82	0	98.8	0	248	3	152	233	MFG6356014.1 Rpn family recombination-promoting nuclease/putative transposase [Acetatifactor sp.]	diamond	246	166	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Acetatifactor	Acetatifactor sp.
31336035	31336035	PRJNA1175041_P_NODE_78416_length_299_cov_1.039823_g75548_i0	PRJNA1175041	78416	299	1.039823	3.10907077	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	91.3	3.82e-21	NR	POH17992.1	1625	g75548	i0	84.1	0.632107023411371	63	10	63.2	0	1	189	69	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	189	91.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
32664249	32664249	PRJNA1175041_P_NODE_106680_length_240_cov_0.910180_g103812_i0	PRJNA1175041	106680	240	0.91018	2.184432	Dorea sp.	2040332	Bacteria	Bacteria	148	4.56e-41	NR	MCI8321910.1	2040332	g103812	i0	100	1	80	0	100	0	1	240	15	94	MCI8321910.1 hypothetical protein [Dorea sp.]	diamond	240	148	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Dorea	Dorea sp.

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