metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Bdellovibrionota"

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
1070139	1070139	PRJNA340009_P_NODE_63261_length_166_cov_14.965812_g62954_i0	PRJNA340009	63261	166	14.965812	24.84324792	Pseudomonadati	3379134	Bacteria	Bacteria	119	1.35e-22	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g62954	i0	81.169	221.042168674699	154	23	92	5	15	166	2950391	2950242	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	36693	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
1070192	1070192	PRJNA340009_P_NODE_76541_length_161_cov_0.910714_g76234_i0	PRJNA340009	76541	161	0.910714	1.46624954	Bdellovibrio	958	Bacteria	Bacteria	167	4.5799999999999995e-37	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g76234	i0	89.394	22.3726708074534	132	14	82	0	28	159	2146345	2146214	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	3602	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
1667112	1667112	PRJNA340009_P_NODE_69822_length_164_cov_0.886957_g69515_i0	PRJNA340009	69822	164	0.886957	1.45460948	Bacteriovorax stolpii	960	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g69515	i0	100	2	164	0	100	0	1	164	1613127	1613290	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	328	303	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1667176	1667176	PRJNA340009_P_NODE_75722_length_161_cov_1.607143_g75415_i0	PRJNA340009	75722	161	1.607143	2.58750023	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	93.5	7.88e-15	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g75415	i0	82.407	0.670807453416149	108	18	66	1	6	112	2183265	2183372	Bdellovibrio exovorus JSS, complete genome	blastn	108	93.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4219673	4219673	PRJNA340009_P_NODE_61944_length_167_cov_0.864407_g61637_i0	PRJNA340009	61944	167	0.864407	1.44355969	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	130	6.29e-26	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g61637	i0	80.952	1.0059880239521	168	28	99	3	2	167	40657	40492	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	168	130	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
4219847	4219847	PRJNA340009_P_NODE_76824_length_161_cov_0.910714_g76517_i0	PRJNA340009	76824	161	0.910714	1.46624954	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	233	4.45e-57	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g76517	i0	93.082	2.52173913043478	159	11	99	0	1	159	864250	864092	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	406	233	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
5495565	5495565	PRJNA340009_P_NODE_18445_length_279_cov_8.391304_g18138_i0	PRJNA340009	18445	279	8.391304	23.41173816	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	156	1.9e-33	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g18138	i0	84.967	4.83512544802867	153	23	55	0	127	279	2124652	2124500	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	1349	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
6172807	6172807	PRJNA340009_P_NODE_15465_length_301_cov_14.781746_g15158_i0	PRJNA340009	15465	301	14.781746	44.49305546	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	1.67e-4	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g15158	i0	100	3.67774086378738	32	0	11	0	109	140	887880	887849	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	1107	60.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6173008	6173008	PRJNA340009_P_NODE_59645_length_169_cov_20.366667_g59338_i0	PRJNA340009	59645	169	20.366667	34.41966723	Bdellovibrio	958	Bacteria	Bacteria	126	8.2e-25	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g59338	i0	92.308	16.2011834319527	91	3	53	4	46	135	1815518	1815431	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	2738	126	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
6769594	6769594	PRJNA340009_P_NODE_23386_length_252_cov_3.280788_g23079_i0	PRJNA340009	23386	252	3.280788	8.26758576	Peredibacter starrii	28202	Bacteria	Bacteria	204	5.96e-48	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g23079	i0	81.6	1.56349206349206	250	42	98	3	1	248	1197645	1197892	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	394	204	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8045555	8045555	PRJNA340009_P_NODE_51307_length_181_cov_3.621212_g51000_i0	PRJNA340009	51307	181	3.621212	6.55439372	uncultured Bacteriovoracaceae bacterium	625924	Bacteria	Bacteria	97.1	7e-16	NTclustered	gi\|2874253651\|emb\|OY968777.1\|	625924	g51000	i0	95.082	1.49171270718232	61	3	34	0	121	181	332045	332105	MAG: uncultured Bacteriovoracaceae bacterium isolate MFD03250.bin.c.5 genome assembly, chromosome: 1	blastn	270	97.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		uncultured Bacteriovoracaceae bacterium
8045574	8045574	PRJNA340009_P_NODE_52967_length_179_cov_1.476923_g52660_i0	PRJNA340009	52967	179	1.476923	2.64369217	Peredibacter starrii	28202	Bacteria	Bacteria	191	3.08e-44	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g52660	i0	87.429	3.46927374301676	175	11	97	6	7	179	4018190	4018025	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	621	191	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8045867	8045867	PRJNA340009_P_NODE_77087_length_161_cov_0.910714_g76780_i0	PRJNA340009	77087	161	0.910714	1.46624954	Bdellovibrio sp. HCB-110	3391182	Bacteria	Bacteria	132	1.6700000000000002e-26	NTclustered	gi\|2896851713\|gb\|CP178750.1\|	3391182	g76780	i0	93.258	1.04968944099379	89	6	55	0	1	89	1945029	1945117	Bdellovibrio sp. HCB-110 chromosome, complete genome	blastn	169	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-110
9320322	9320322	PRJNA340009_P_NODE_50608_length_182_cov_4.203008_g50301_i0	PRJNA340009	50608	182	4.203008	7.64947456	Bacteriovorax stolpii	960	Bacteria	Bacteria	331	1.7800000000000002e-86	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g50301	i0	99.451	3	182	1	100	0	1	182	578791	578972	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	546	331	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
10595751	10595751	PRJNA340009_P_NODE_26089_length_241_cov_2.656250_g25782_i0	PRJNA340009	26089	241	2.65625	6.4015625	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	180	9.539999999999999e-41	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g25782	i0	80.165	1.00414937759336	242	46	100	2	1	241	2129619	2129859	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	242	180	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
10596346	10596346	PRJNA340009_P_NODE_9849_length_364_cov_5.768254_g9542_i0	PRJNA340009	9849	364	5.768254	20.99644456	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	287	8.7e-73	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g9542	i0	81.285	0.983516483516483	358	64	98	3	5	360	2065660	2066016	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	358	287	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
11871225	11871225	PRJNA340009_P_NODE_76370_length_161_cov_0.910714_g76063_i0	PRJNA340009	76370	161	0.910714	1.46624954	Peredibacter starrii	28202	Bacteria	Bacteria	152	1.28e-32	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g76063	i0	87.692	1.62732919254658	130	16	81	0	32	161	2201822	2201951	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	262	152	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14420956	14420956	PRJNA340009_P_NODE_39732_length_202_cov_1.261438_g39425_i0	PRJNA340009	39732	202	1.261438	2.54810476	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	143	1.01e-29	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g39425	i0	81.868	1.8019801980198	182	21	89	7	23	202	3401502	3401331	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	364	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
14421156	14421156	PRJNA340009_P_NODE_60252_length_169_cov_1.408333_g59945_i0	PRJNA340009	60252	169	1.408333	2.38008277	Bacteriovorax stolpii	960	Bacteria	Bacteria	178	2.23e-40	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g59945	i0	93.333	3.21301775147929	120	8	99	0	49	168	3363684	3363565	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	543	178	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
14421257	14421257	PRJNA340009_P_NODE_69592_length_164_cov_0.886957_g69285_i0	PRJNA340009	69592	164	0.886957	1.45460948	Bacteriovorax stolpii	960	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g69285	i0	98.78	1.98780487804878	164	2	100	0	1	164	3143752	3143915	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	326	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15695106	15695106	PRJNA340009_P_NODE_66633_length_165_cov_0.879310_g66326_i0	PRJNA340009	66633	165	0.87931	1.4508615	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	158	2.84e-34	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g66326	i0	85.811	127.09696969697	148	21	90	0	1	148	1292800	1292653	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	20971	158	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
16969685	16969685	PRJNA340009_P_NODE_50034_length_183_cov_3.022388_g49727_i0	PRJNA340009	50034	183	3.022388	5.53097004	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	187	4.0899999999999985e-43	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g49727	i0	86.127	1.13661202185792	173	24	95	0	1	173	1773929	1774101	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	208	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
18243685	18243685	PRJNA340009_P_NODE_32455_length_220_cov_1.192982_g32148_i0	PRJNA340009	32455	220	1.192982	2.6245604	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	143	1.12e-29	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g32148	i0	85.926	19.8	135	17	61	2	86	219	2954637	2954504	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	4356	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18244122	18244122	PRJNA340009_P_NODE_73835_length_162_cov_0.902655_g73528_i0	PRJNA340009	73835	162	0.902655	1.4623011	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	137	3.6199999999999997e-28	NTclustered	gi\|2663436463\|dbj\|AP029181.1\|	3113895	g73528	i0	83.66	1.90740740740741	153	18	92	5	14	162	10758	10609	Bdellovibrio sp. HAGR004 plasmid pBdHAGR5 DNA, complete sequence	blastn	309	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
18244169	18244169	PRJNA340009_P_NODE_78355_length_158_cov_6.403670_g78048_i0	PRJNA340009	78355	158	6.40367	10.1177986	Bacteriovorax stolpii	960	Bacteria	Bacteria	291	2.54e-74	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g78048	i0	100	2.95569620253165	157	0	99	0	2	158	3757085	3757241	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	467	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18921625	18921625	PRJNA340009_P_NODE_76075_length_161_cov_0.910714_g75768_i0	PRJNA340009	76075	161	0.910714	1.46624954	Peredibacter	263370	Bacteria	Bacteria	171	3.54e-38	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g75768	i0	86.164	1.97515527950311	159	20	99	2	2	160	2771910	2772066	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	318	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19517893	19517893	PRJNA340009_P_NODE_30196_length_226_cov_4.180791_g29889_i0	PRJNA340009	30196	226	4.180791	9.44858766	Bacteriovorax stolpii	960	Bacteria	Bacteria	407	3.73e-109	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g29889	i0	99.115	3	226	2	100	0	1	226	2695893	2696118	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	678	407	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19517908	19517908	PRJNA340009_P_NODE_31516_length_222_cov_4.150289_g31209_i0	PRJNA340009	31516	222	4.150289	9.2136415800000009	Bacteriovorax stolpii	960	Bacteria	Bacteria	327	2.92e-85	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g31209	i0	97.884	2.54954954954955	189	4	85	0	34	222	255095	254907	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	566	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19518417	19518417	PRJNA340009_P_NODE_77476_length_161_cov_0.910714_g77169_i0	PRJNA340009	77476	161	0.910714	1.46624954	Bdellovibrio sp. HCB274	3394361	Bacteria	Bacteria	154	3.5600000000000004e-33	NTclustered	gi\|2895984058\|gb\|CP178623.1\|	3394361	g77169	i0	84.615	4.09316770186335	156	23	97	1	1	156	2756026	2755872	Bdellovibrio sp. HCB274 chromosome, complete genome	blastn	659	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB274
22068945	22068945	PRJNA340009_P_NODE_65598_length_165_cov_6.155172_g65291_i0	PRJNA340009	65598	165	6.155172	10.1560338	Bdellovibrio sp. HCB274	3394361	Bacteria	Bacteria	99	1.75e-16	NTclustered	gi\|2895984058\|gb\|CP178623.1\|	3394361	g65291	i0	85.87	0.557575757575758	92	13	56	0	3	94	3672893	3672802	Bdellovibrio sp. HCB274 chromosome, complete genome	blastn	92	99	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB274
22069087	22069087	PRJNA340009_P_NODE_79198_length_156_cov_3.803738_g78891_i0	PRJNA340009	79198	156	3.803738	5.93383128	Bacteriovorax stolpii	960	Bacteria	Bacteria	283	4.1899999999999994e-72	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g78891	i0	99.359	2.96153846153846	156	1	100	0	1	156	2454442	2454287	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	462	283	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
23344309	23344309	PRJNA340009_P_NODE_57839_length_172_cov_1.658537_g57532_i0	PRJNA340009	57839	172	1.658537	2.85268364	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g57532	i0	100	4	172	0	100	0	1	172	106865	107036	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	688	318	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
24618394	24618394	PRJNA340009_P_NODE_44260_length_193_cov_1.013889_g43953_i0	PRJNA340009	44260	193	1.013889	1.9568057700000001	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	226	9.259999999999997e-55	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g43953	i0	87.958	82.3834196891192	191	23	99	0	3	193	1135162	1134972	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	15900	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius

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