metadata: contig_metadata: 35 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax

35 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_phylum = "Bacillota"

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
221894	221894	PRJNA1113956_P_NODE_19821_length_251_cov_0.865169_g19481_i0	PRJNA1113956	19821	251	0.865169	2.17157419	Solobacterium moorei	102148	Bacteria	Bacteria	327	3.37e-85	NTclustered	gi\|2589153872\|dbj\|AP028934.1\|	102148	g19481	i0	90.438	2.00398406374502	251	20	100	4	1	251	240680	240434	Solobacterium moorei JCM 10645 DNA, complete genome	blastn	503	327	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium moorei
1023919	1023919	PRJNA1113956_P_NODE_6561_length_628_cov_2.111712_g6237_i0	PRJNA1113956	6561	628	2.111712	13.26155136	Bacillus	1386	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2049478593\|gb\|CP036023.1\|	1405	g6237	i0	100	3.19904458598726	31	0	5	0	122	152	3877451	3877421	Bacillus mycoides strain BPN52/2 chromosome, complete genome	blastn	2009	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
1023968	1023968	PRJNA1113956_P_NODE_9061_length_479_cov_1.827586_g8722_i0	PRJNA1113956	9061	479	1.827586	8.75413694	Bacillales	1385	Bacteria	Bacteria	885	0	NTclustered	gi\|1950109764\|gb\|CP066376.1\|	1282	g8722	i0	100	537.102296450939	479	0	100	0	1	479	2298172	2298650	Staphylococcus epidermidis strain PH1-28 chromosome, complete sequence	blastn	257272	885	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1496592	1496592	PRJNA1113956_P_NODE_11322_length_398_cov_1.760000_g10982_i0	PRJNA1113956	11322	398	1.76	7.0048	Staphylococcus equorum	246432	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1042803749\|gb\|CP013714.1\|	246432	g10982	i0	100	0.070351758793969807	28	0	7	0	161	188	1697251	1697224	Staphylococcus equorum strain C2014 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus equorum
1496693	1496693	PRJNA1113956_P_NODE_19742_length_251_cov_0.865169_g19402_i0	PRJNA1113956	19742	251	0.865169	2.17157419	Veillonella atypica	39777	Bacteria	Bacteria	276	1.24e-69	NTclustered	gi\|2592626561\|gb\|CP103397.1\|	39777	g19402	i0	86.454	1	251	34	100	0	1	251	1300631	1300881	Veillonella atypica strain G765s_culture10 chromosome, complete genome	blastn	251	276	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
1496714	1496714	PRJNA1113956_P_NODE_21002_length_247_cov_0.885057_g20662_i0	PRJNA1113956	21002	247	0.885057	2.18609079	Veillonella atypica	39777	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|2592626561\|gb\|CP103397.1\|	39777	g20662	i0	95.547	18.4898785425101	247	11	100	0	1	247	1736111	1735865	Veillonella atypica strain G765s_culture10 chromosome, complete genome	blastn	4567	396	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
2299169	2299169	PRJNA1113956_P_NODE_13082_length_353_cov_1.096429_g12742_i0	PRJNA1113956	13082	353	1.096429	3.87039437	root	1	Root_unresolved	Root_unresolved	621	2.0299999999999997e-173	NTclustered	gi\|407866\|emb\|Z26888.1\|	29378	g12742	i0	98.31	123.696883852691	355	4	100	1	1	353	489	135	S.arlettae gene for 16S ribosomal RNA	blastn	43665	627	0.990430622009569	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
2299272	2299272	PRJNA1113956_P_NODE_21102_length_246_cov_0.890173_g20762_i0	PRJNA1113956	21102	246	0.890173	2.18982558	Anoxybacillus	150247	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g20762	i0	100	6.76829268292683	246	0	100	0	1	246	872366	872611	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	1665	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
2772489	2772489	PRJNA1113956_P_NODE_11203_length_401_cov_2.966463_g10863_i0	PRJNA1113956	11203	401	2.966463	11.89551663	Priestia filamentosa	1402861	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2216394118\|gb\|CP063142.1\|	1402861	g10863	i0	96.774	0.0773067331670823	31	1	8	0	193	223	4998453	4998483	Priestia filamentosa strain GN1 chromosome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia filamentosa
4048884	4048884	PRJNA1113956_P_NODE_19784_length_251_cov_0.865169_g19444_i0	PRJNA1113956	19784	251	0.865169	2.17157419	Desulfitobacterium metallireducens	142877	Bacteria	Bacteria	65.8	2.92e-6	NTclustered	gi\|570734635\|gb\|CP007032.1\|	871968	g19444	i0	84.615	0.258964143426295	65	10	26	0	5	69	916172	916108	Desulfitobacterium metallireducens DSM 15288, complete genome	blastn	65	65.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfitobacterium	Desulfitobacterium metallireducens
4851840	4851840	PRJNA1113956_P_NODE_20984_length_247_cov_0.885057_g20644_i0	PRJNA1113956	20984	247	0.885057	2.18609079	Streptococcus	1301	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|959991280\|gb\|CP013216.1\|	1304	g20644	i0	96.371	42.1012145748988	248	7	100	2	1	247	1512443	1512689	Streptococcus salivarius strain HSISS4 chromosome, complete genome	blastn	10399	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
4851842	4851842	PRJNA1113956_P_NODE_21084_length_246_cov_0.890173_g20744_i0	PRJNA1113956	21084	246	0.890173	2.18982558	Enterococcus	1350	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|939198273\|gb\|CP010060.1\|	44008	g20744	i0	100	555.211382113821	246	0	100	0	1	246	140325	140080	Enterococcus cecorum strain SA1 genome	blastn	136582	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
4851865	4851865	PRJNA1113956_P_NODE_22784_length_241_cov_0.916667_g22444_i0	PRJNA1113956	22784	241	0.916667	2.20916747	Streptococcus	1301	Bacteria	Bacteria	403	5.199999999999998e-108	NTclustered	gi\|1985957267\|gb\|CP069427.1\|	1303	g22444	i0	96.721	24.4813278008299	244	5	100	2	1	241	276506	276749	Streptococcus oralis strain SF100 chromosome, complete genome	blastn	5900	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
5324928	5324928	PRJNA1113956_P_NODE_22105_length_243_cov_0.905882_g21765_i0	PRJNA1113956	22105	243	0.905882	2.20129326	Bulleidia sp. 10714-15	3241172	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2793725965\|dbj\|AP036017.1\|	3241172	g21765	i0	99.588	1	243	1	100	0	1	243	79822	79580	Bulleidia sp. 10714-15 DNA, complete genome	blastn	243	444	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Bulleidia	Bulleidia sp. 10714-15
6600087	6600087	PRJNA1113956_P_NODE_20546_length_248_cov_0.880000_g20206_i0	PRJNA1113956	20546	248	0.88	2.1824	Veillonella atypica	39777	Bacteria	Bacteria	381	2.519999999999999e-101	NTclustered	gi\|2592626561\|gb\|CP103397.1\|	39777	g20206	i0	94.355	56.7862903225806	248	14	100	0	1	248	675247	675000	Veillonella atypica strain G765s_culture10 chromosome, complete genome	blastn	14083	381	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
6600123	6600123	PRJNA1113956_P_NODE_3926_length_900_cov_1.802902_g3654_i0	PRJNA1113956	3926	900	1.802902	16.226118	Enterococcus saccharolyticus	41997	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|2452059382\|gb\|CP118957.1\|	1814218	g3654	i0	100	0.0322222222222222	29	0	3	0	868	896	39021	38993	Enterococcus saccharolyticus subsp. saccharolyticus strain DSM 20726 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus saccharolyticus
9149704	9149704	PRJNA1113956_P_NODE_20968_length_247_cov_0.885057_g20628_i0	PRJNA1113956	20968	247	0.885057	2.18609079	Streptococcus oralis	1303	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g20628	i0	96.356	31.1376518218623	247	9	100	0	1	247	807690	807936	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	7691	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9952011	9952011	PRJNA1113956_P_NODE_16948_length_287_cov_1.242991_g16608_i0	PRJNA1113956	16948	287	1.242991	3.56738417	Lactobacillus	1578	Bacteria	Bacteria	520	6.049999999999999e-143	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g16608	i0	99.303	30	287	2	100	0	1	287	486522	486808	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	8610	520	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
9952073	9952073	PRJNA1113956_P_NODE_21628_length_245_cov_0.883721_g21288_i0	PRJNA1113956	21628	245	0.883721	2.16511645	Lactobacillus	1578	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|470474342\|ref\|NR_076210.1\|	33959	g21288	i0	100	518.530612244898	245	0	100	0	1	245	2649	2893	Lactobacillus johnsonii strain NCC 533 23S ribosomal RNA gene, complete sequence	blastn	127040	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus johnsonii
11700693	11700693	PRJNA1113956_P_NODE_17610_length_278_cov_1.185366_g17270_i0	PRJNA1113956	17610	278	1.185366	3.29531748	Streptococcus sp. oral taxon 431	712633	Bacteria	Bacteria	411	3.659999999999999e-110	NTclustered	gi\|987460635\|gb\|CP014264.1\|	712633	g17270	i0	93.478	422.985611510791	276	18	100	0	1	276	1086362	1086637	Streptococcus sp. oral taxon 431 strain F0610 (5-114) chromosome, complete genome	blastn	117590	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. oral taxon 431
11700704	11700704	PRJNA1113956_P_NODE_18490_length_266_cov_1.595855_g18150_i0	PRJNA1113956	18490	266	1.595855	4.2449743	Lactobacillus crispatus	47770	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g18150	i0	100	97.5864661654135	266	0	100	0	1	266	275856	276121	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	25958	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11700756	11700756	PRJNA1113956_P_NODE_22090_length_243_cov_0.905882_g21750_i0	PRJNA1113956	22090	243	0.905882	2.20129326	Streptococcus salivarius	1304	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2878060592\|gb\|CP145858.1\|	1304	g21750	i0	99.177	99.9711934156379	243	2	100	0	1	243	1000840	1001082	Streptococcus salivarius strain KSS11 chromosome, complete genome	blastn	24293	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
12502690	12502690	PRJNA1113956_P_NODE_20330_length_249_cov_0.875000_g19990_i0	PRJNA1113956	20330	249	0.875	2.17875	Veillonella	29465	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|1835309918\|emb\|LR778174.1\|	29466	g19990	i0	95.582	9.91566265060241	249	11	100	0	1	249	1955858	1956106	Veillonella parvula strain SKV38 genome assembly, chromosome: 1	blastn	2469	399	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
12975786	12975786	PRJNA1113956_P_NODE_18931_length_260_cov_1.673797_g18591_i0	PRJNA1113956	18931	260	1.673797	4.3518722	Streptococcus parasanguinis	1318	Bacteria	Bacteria	442	1.1999999999999999e-119	NTclustered	gi\|2578556603\|gb\|CP133988.1\|	1318	g18591	i0	97.308	18.9615384615385	260	7	100	0	1	260	1046861	1047120	Streptococcus parasanguinis strain B-1756 chromosome, complete genome	blastn	4930	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
13777179	13777179	PRJNA1113956_P_NODE_20551_length_248_cov_0.880000_g20211_i0	PRJNA1113956	20551	248	0.88	2.1824	Streptococcus	1301	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g20211	i0	99.597	99.9314516129032	248	1	100	0	1	248	1240601	1240848	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	24783	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
14250818	14250818	PRJNA1113956_P_NODE_10912_length_410_cov_4.985163_g10573_i0	PRJNA1113956	10912	410	4.985163	20.4391683	Brochothrix thermosphacta	2756	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|2688293211\|gb\|CP145608.1\|	1121126	g10573	i0	100	0.0682926829268293	28	0	7	0	310	337	2383062	2383089	Brochothrix thermosphacta DSM 20171 = FSL F6-1036 strain DSM 20171 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Brochothrix	Brochothrix thermosphacta
15051489	15051489	PRJNA1113956_P_NODE_18692_length_263_cov_1.621053_g18352_i0	PRJNA1113956	18692	263	1.621053	4.26336939	Ethanoligenens	253238	Bacteria	Bacteria	398	2.6799999999999995e-106	NTclustered	gi\|470487490\|ref\|NR_076821.1\|	253239	g18352	i0	93.916	359.136882129278	263	16	100	0	1	263	802	1064	Ethanoligenens harbinense strain YUAN-3 23S ribosomal RNA gene, complete sequence	blastn	94453	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ethanoligenens	Ethanoligenens harbinense
15524587	15524587	PRJNA1113956_P_NODE_21633_length_245_cov_0.866279_g21293_i0	PRJNA1113956	21633	245	0.866279	2.12238355	Streptococcus sanguinis	1305	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|1864130110\|gb\|CP040798.1\|	1305	g21293	i0	96.735	9.91428571428571	245	8	100	0	1	245	110265	110509	Streptococcus sanguinis strain CGMH058 chromosome, complete genome	blastn	2429	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
16799137	16799137	PRJNA1113956_P_NODE_22834_length_241_cov_0.916667_g22494_i0	PRJNA1113956	22834	241	0.916667	2.20916747	Intestinibaculum porci	2487118	Bacteria	Bacteria	84.2	7.69e-12	NTclustered	gi\|1514766016\|dbj\|AP019309.1\|	2487118	g22494	i0	90.625	0.738589211618257	64	5	26	1	15	77	1707514	1707451	Erysipelotrichaceae bacterium SG0102 DNA, complete genome	blastn	178	84.2	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Intestinibaculum	Intestinibaculum porci
17601570	17601570	PRJNA1113956_P_NODE_21174_length_246_cov_0.890173_g20834_i0	PRJNA1113956	21174	246	0.890173	2.18982558	Streptococcus	1301	Bacteria	Bacteria	377	3.2300000000000003e-100	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g20834	i0	95	11.1991869918699	240	12	98	0	6	245	750360	750121	Streptococcus infantis strain SO chromosome, complete genome	blastn	2755	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
18073623	18073623	PRJNA1113956_P_NODE_21535_length_245_cov_0.895349_g21195_i0	PRJNA1113956	21535	245	0.895349	2.19360505	Solobacterium moorei	102148	Bacteria	Bacteria	344	3.26e-90	NTclustered	gi\|2589153872\|dbj\|AP028934.1\|	102148	g21195	i0	92.213	2.00408163265306	244	17	99	2	1	243	548379	548621	Solobacterium moorei JCM 10645 DNA, complete genome	blastn	491	344	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium moorei
22700929	22700929	PRJNA1113956_P_NODE_8838_length_489_cov_2.884615_g8500_i0	PRJNA1113956	8838	489	2.884615	14.10576735	Bacilli	91061	Bacteria	Bacteria	52.8	0.048	NTclustered	gi\|2701690059\|gb\|MK024372.1\|	1282	g8500	i0	100	0.171779141104294	28	0	6	0	165	192	268	241	Staphylococcus epidermidis strain 9696 plasmid 9696_2, complete sequence	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24448113	24448113	PRJNA1113956_P_NODE_19820_length_251_cov_0.865169_g19480_i0	PRJNA1113956	19820	251	0.865169	2.17157419	Streptococcus sp. FSL R7-0248	2975324	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|2709568351\|gb\|CP150201.1\|	2975324	g19480	i0	97.61	99.9760956175299	251	6	100	0	1	251	550660	550410	Streptococcus sp. FSL R7-0248 chromosome, complete genome	blastn	25094	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. FSL R7-0248
24448137	24448137	PRJNA1113956_P_NODE_21460_length_245_cov_0.895349_g21120_i0	PRJNA1113956	21460	245	0.895349	2.19360505	Streptococcus sp. NPS 308	1902136	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1080114141\|dbj\|AP017652.1\|	1902136	g21120	i0	98.776	43.8571428571429	245	3	100	0	1	245	1805709	1805953	Streptococcus sp. NPS 308 DNA, complete genome	blastn	10745	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. NPS 308
24448151	24448151	PRJNA1113956_P_NODE_22780_length_241_cov_0.916667_g22440_i0	PRJNA1113956	22780	241	0.916667	2.20916747	Streptococcus sp. NPS 308	1902136	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1080114141\|dbj\|AP017652.1\|	1902136	g22440	i0	99.585	30.6763485477178	241	1	100	0	1	241	1756657	1756897	Streptococcus sp. NPS 308 DNA, complete genome	blastn	7393	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. NPS 308

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