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

35 rows where analysis = "blastn", bioproject = "PRJNA594101" and tax_phylum = "Actinomycetota"

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
567176	567176	PRJNA594101_S_NODE_47021_length_255_cov_1.329670_g46719_i0	PRJNA594101	47021	255	1.32967	3.3906585	Mycolicibacterium mengxianglii	2736649	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1946838276\|gb\|CP065373.2\|	2736649	g46719	i0	100	0.109803921568627	28	0	11	0	18	45	5034074	5034047	Mycolicibacterium mengxianglii strain Z-34 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mengxianglii
1139440	1139440	PRJNA594101_S_NODE_50621_length_249_cov_0.875000_g50319_i0	PRJNA594101	50621	249	0.875	2.17875	Streptomyces	1883	Bacteria	Bacteria	71.3	6.22e-8	NTclustered	gi\|2657594964\|gb\|CP108309.1\|	2975621	g50319	i0	92	15.2208835341365	50	4	20	0	187	236	6332705	6332656	Streptomyces sp. NBC_00012 chromosome, complete genome	blastn	3790	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00012
1842484	1842484	PRJNA594101_S_NODE_18162_length_391_cov_1.188679_g17860_i0	PRJNA594101	18162	391	1.188679	4.64773489	Arsenicicoccus dermatophilus	1076331	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2865374122\|gb\|CP124757.1\|	1076331	g17860	i0	100	0.143222506393862	28	0	7	0	326	353	1465518	1465545	Arsenicicoccus dermatophilus strain KM 894/11 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Arsenicicoccus	Arsenicicoccus dermatophilus
2414821	2414821	PRJNA594101_S_NODE_42102_length_268_cov_4.097436_g41800_i0	PRJNA594101	42102	268	4.097436	10.98112848	Mycobacterium	1763	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2573969471\|gb\|CP133601.1\|	1765	g41800	i0	100	10.4477611940299	28	0	10	0	12	39	3696365	3696392	Mutant Mycobacterium tuberculosis variant bovis isolate PHOPR KO3, partial genome	blastn	2800	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
2414828	2414828	PRJNA594101_S_NODE_52422_length_247_cov_0.885057_g52120_i0	PRJNA594101	52422	247	0.885057	2.18609079	Cutibacterium	1912216	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g52120	i0	99.595	51.0404858299595	247	1	100	0	1	247	392847	392601	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12607	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3117911	3117911	PRJNA594101_S_NODE_17643_length_396_cov_1.798762_g17341_i0	PRJNA594101	17643	396	1.798762	7.12309752	Glutamicibacter mishrai	1775880	Bacteria	Bacteria	58.4	8.15e-4	NTclustered	gi\|2274419970\|gb\|CP101461.1\|	1775880	g17341	i0	97.059	0.156565656565657	34	1	9	0	164	197	1710703	1710670	Glutamicibacter mishrai strain CX1 chromosome, complete genome	blastn	62	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter mishrai
7517303	7517303	PRJNA594101_S_NODE_50086_length_249_cov_2.386364_g49784_i0	PRJNA594101	50086	249	2.386364	5.94204636	Streptosporangium	2000	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2651931882\|gb\|CP109068.1\|	106412	g49784	i0	100	1.81927710843373	29	0	12	0	27	55	8175820	8175848	Streptosporangium subroseum strain NBC 01811 chromosome, complete genome	blastn	453	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium	Streptosporangium subroseum
8792242	8792242	PRJNA594101_S_NODE_13687_length_447_cov_1.548128_g13385_i0	PRJNA594101	13687	447	1.548128	6.92013216	Streptomyces	1883	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1841659211\|gb\|CP049838.1\|	249586	g13385	i0	90.698	0.48993288590604	43	2	9	2	105	145	7343127	7343085	Streptomyces asoensis strain H2S5 chromosome, complete genome	blastn	219	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces asoensis
8792255	8792255	PRJNA594101_S_NODE_35127_length_292_cov_1.223744_g34825_i0	PRJNA594101	35127	292	1.223744	3.57333248	Corynebacterium	1716	Bacteria	Bacteria	58.4	5.82e-4	NTclustered	gi\|2869836054\|gb\|CP175786.1\|	43765	g34825	i0	86.792	0.907534246575342	53	6	18	1	108	160	2140570	2140621	Corynebacterium amycolatum strain YSMAA1_2_B5 chromosome, complete genome	blastn	265	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium amycolatum
9495412	9495412	PRJNA594101_S_NODE_25028_length_338_cov_1.694340_g24726_i0	PRJNA594101	25028	338	1.69434	5.7268692	Dactylosporangium aurantiacum	35754	Bacteria	Bacteria	115	4.01e-21	NTclustered	gi\|2304868179\|gb\|CP073767.1\|	35754	g24726	i0	80.233	0.887573964497041	172	18	49	9	27	193	8940155	8940315	Dactylosporangium aurantiacum strain NRRL B-8018 chromosome, complete genome	blastn	300	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium aurantiacum
9495481	9495481	PRJNA594101_S_NODE_34528_length_294_cov_1.235294_g34226_i0	PRJNA594101	34528	294	1.235294	3.63176436	Microbacterium resistens	156977	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2164491193\|gb\|CP082781.1\|	156977	g34226	i0	100	0.0952380952380952	28	0	10	0	84	111	3978833	3978806	Microbacterium resistens strain MZT7 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium resistens
9495576	9495576	PRJNA594101_S_NODE_47328_length_254_cov_1.690608_g47026_i0	PRJNA594101	47328	254	1.6906080000000001	4.29414432	Kitasatospora purpeofusca	67352	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2813952684\|gb\|CP170483.1\|	67352	g47026	i0	94.444	0.141732283464567	36	1	14	1	169	204	5481184	5481218	Kitasatospora purpeofusca strain ZZ-48 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora purpeofusca
9495628	9495628	PRJNA594101_S_NODE_53548_length_245_cov_1.779070_g53246_i0	PRJNA594101	53548	245	1.77907	4.3587215	Phytohabitans flavus	1076124	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1823819873\|dbj\|AP022870.1\|	1076124	g53246	i0	96.875	0.130612244897959	32	0	13	1	148	178	8918118	8918149	Phytohabitans flavus NBRC 107702 DNA, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Phytohabitans	Phytohabitans flavus
10068019	10068019	PRJNA594101_S_NODE_21068_length_366_cov_1.177474_g20766_i0	PRJNA594101	21068	366	1.177474	4.30955484	Corynebacterium	1716	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1948708487\|gb\|CP066067.1\|	36808	g20766	i0	100	0.387978142076503	29	0	8	0	308	336	1281004	1281032	Corynebacterium bovis strain FDAARGOS_1052 chromosome, complete genome	blastn	142	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium bovis
12046265	12046265	PRJNA594101_S_NODE_43030_length_266_cov_1.196891_g42728_i0	PRJNA594101	43030	266	1.196891	3.18373006	Yimella sp. cx-51	2770551	Bacteria	Bacteria	122	1.8299999999999994e-23	NTclustered	gi\|2019559805\|gb\|CP072113.1\|	2770551	g42728	i0	91.111	33.6766917293233	90	8	34	0	150	239	2085599	2085510	Yimella sp. cx-51 chromosome, complete genome	blastn	8958	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Yimella	Yimella sp. cx-51
12046416	12046416	PRJNA594101_S_NODE_8410_length_564_cov_1.594705_g8110_i0	PRJNA594101	8410	564	1.594705	8.9941362	Streptomyces fradiae	1906	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|2786436842\|gb\|CP065958.1\|	1906	g8110	i0	94.444	0.0638297872340425	36	0	6	2	337	370	7493133	7493098	Streptomyces fradiae strain T2-24 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces fradiae
13321082	13321082	PRJNA594101_S_NODE_37991_length_282_cov_0.923445_g37689_i0	PRJNA594101	37991	282	0.923445	2.6041149	Friedmanniella luteola	546871	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1085823321\|emb\|LT629749.1\|	546871	g37689	i0	100	0.099290780141844	28	0	10	0	113	140	45146	45173	Friedmanniella luteola strain DSM 21741 genome assembly, chromosome: I	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	Friedmanniella luteola
13893444	13893444	PRJNA594101_S_NODE_10491_length_506_cov_12.448037_g10190_i0	PRJNA594101	10491	506	12.448037	62.98706722	root	1	Root_unresolved	Root_unresolved	52.8	0.049	NTclustered	gi\|1052266331\|emb\|LT607411.1\|	1881	g10190	i0	100	0.16600790513834	28	0	6	0	258	285	7048882	7048909	Micromonospora viridifaciens strain DSM 43909 genome assembly, chromosome: I	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora viridifaciens
13893452	13893452	PRJNA594101_S_NODE_22471_length_355_cov_1.854610_g22169_i0	PRJNA594101	22471	355	1.85461	6.5838655	Actinomycetes	1760	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2654984670\|gb\|CP108653.1\|	53448	g22169	i0	100	0.425352112676056	29	0	8	0	313	341	5229641	5229613	Streptomyces gougerotii strain NBC_01103 chromosome, complete genome	blastn	151	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces gougerotii
14595781	14595781	PRJNA594101_S_NODE_11432_length_487_cov_1.036232_g11131_i0	PRJNA594101	11432	487	1.036232	5.04644984	Actinoplanes digitatis	1868	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2666988659\|dbj\|AP029199.1\|	1868	g11131	i0	100	0.0574948665297741	28	0	6	0	357	384	4144692	4144665	Actinoplanes digitatis JCM 3060 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinoplanes	Actinoplanes digitatis
15167525	15167525	PRJNA594101_S_NODE_30872_length_309_cov_0.902542_g30570_i0	PRJNA594101	30872	309	0.902542	2.78885478	Actinomycetes	1760	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1540223313\|emb\|LR134501.1\|	2014	g30570	i0	100	0.543689320388349	28	0	9	0	250	277	4841209	4841182	Nocardiopsis dassonvillei strain NCTC10488 genome assembly, chromosome: 1	blastn	168	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis dassonvillei
15167545	15167545	PRJNA594101_S_NODE_8572_length_559_cov_1.600823_g8272_i0	PRJNA594101	8572	559	1.600823	8.94860057	Actinomycetes	1760	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|256355458\|gb\|CP001700.1\|	479433	g8272	i0	94.444	0.121645796064401	36	0	6	1	334	369	2855421	2855388	Catenulispora acidiphila DSM 44928 chromosome, complete genome	blastn	68	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Catenulisporales	Catenulisporaceae	Catenulispora	Catenulispora acidiphila
17144842	17144842	PRJNA594101_S_NODE_45794_length_258_cov_2.032432_g45492_i0	PRJNA594101	45794	258	2.032432	5.24367456	Saccharothrix espanaensis	103731	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|407879691\|emb\|HE804045.1\|	1179773	g45492	i0	100	0.108527131782946	28	0	11	0	213	240	7567674	7567701	Saccharothrix espanaensis DSM 44229 complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharothrix	Saccharothrix espanaensis
17144888	17144888	PRJNA594101_S_NODE_51634_length_248_cov_0.880000_g51332_i0	PRJNA594101	51634	248	0.88	2.1824	Streptomyces sp. NBC_00886	2975858	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2655393229\|gb\|CP108792.1\|	2975858	g51332	i0	92.5	1.58870967741935	40	2	16	1	200	239	1214440	1214478	Streptomyces sp. NBC_00886 chromosome, complete genome	blastn	394	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00886
17717270	17717270	PRJNA594101_S_NODE_36194_length_288_cov_1.255814_g35892_i0	PRJNA594101	36194	288	1.255814	3.61674432	Micrococcales	85006	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|983654113\|gb\|KT441095.1\|	1270	g35892	i0	100	100	288	0	100	0	1	288	332	45	Micrococcus luteus strain IARI-SWK 9 16S ribosomal RNA gene, partial sequence	blastn	28800	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
18418766	18418766	PRJNA594101_S_NODE_12095_length_474_cov_1.975062_g11793_i0	PRJNA594101	12095	474	1.975062	9.36179388	Terrabacter sp. C0L_2	3108389	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2668325565\|gb\|CP143557.1\|	3108389	g11793	i0	94.286	0.0738396624472574	35	1	7	1	286	319	3777219	3777253	Terrabacter sp. C0L_2 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Terrabacter	Terrabacter sp. C0L_2
19693645	19693645	PRJNA594101_S_NODE_54856_length_244_cov_0.900585_g54554_i0	PRJNA594101	54856	244	0.900585	2.1974274	Neomicrococcus aestuarii	556325	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1109133054\|gb\|CP018135.1\|	556325	g54554	i0	99.59	1	244	1	100	0	1	244	82577	82334	Neomicrococcus aestuarii strain B18 chromosome, complete genome	blastn	244	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Neomicrococcus	Neomicrococcus aestuarii
20265894	20265894	PRJNA594101_S_NODE_26176_length_331_cov_3.178295_g25874_i0	PRJNA594101	26176	331	3.178295	10.52015645	Streptomyces	1883	Bacteria	Bacteria	143	1.8e-29	NTclustered	gi\|2424005877\|gb\|CP114203.1\|	1920	g25874	i0	81.111	42.3655589123867	180	32	54	2	143	321	9245532	9245710	Streptomyces nigrescens strain DSM 40276 chromosome, complete genome	blastn	14023	143	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces nigrescens
20969177	20969177	PRJNA594101_S_NODE_19197_length_381_cov_3.061688_g18895_i0	PRJNA594101	19197	381	3.061688	11.66503128	Microbacterium oxydans	82380	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2370304889\|gb\|CP092891.1\|	82380	g18895	i0	100	0.073490813648294	28	0	7	0	216	243	774888	774861	Microbacterium oxydans strain ML-6 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
20969458	20969458	PRJNA594101_S_NODE_55577_length_243_cov_0.905882_g55275_i0	PRJNA594101	55577	243	0.905882	2.20129326	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g55275	i0	99.177	352.37037037037	243	2	100	0	1	243	293092	293334	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	85626	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
22244460	22244460	PRJNA594101_S_NODE_8658_length_556_cov_3.273292_g8358_i0	PRJNA594101	8658	556	3.273292	18.19950352	Streptomyces sp. TN58	234612	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1130049210\|gb\|CP018870.1\|	234612	g8358	i0	87.037	0.0971223021582734	54	2	9	5	86	137	3237889	3237839	Streptomyces sp. TN58, complete genome	blastn	54	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. TN58
22244463	22244463	PRJNA594101_S_NODE_878_length_1466_cov_2.429289_g769_i0	PRJNA594101	878	1466	2.429289	35.61337674	Streptomyces parvus	66428	Bacteria	Bacteria	54.7	0.042	NTclustered	gi\|2754649811\|gb\|CP159802.1\|	66428	g769	i0	100	0.0197817189631651	29	0	2	0	563	591	446129	446101	Streptomyces parvus strain A612 chromosome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces parvus
22816618	22816618	PRJNA594101_S_NODE_16198_length_413_cov_1.755882_g15896_i0	PRJNA594101	16198	413	1.755882	7.25179266	Micrococcus	1269	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2851356301\|gb\|CP085253.1\|	86171	g15896	i0	94.444	0.174334140435835	36	0	8	2	267	301	212885	212919	Micrococcus antarcticus strain ABH-515 chromosome, complete genome	blastn	72	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus antarcticus
23519495	23519495	PRJNA594101_S_NODE_38639_length_279_cov_2.383495_g38337_i0	PRJNA594101	38639	279	2.383495	6.64995105	Amycolatopsis nalaikhensis	715472	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2518115977\|gb\|CP127173.1\|	715472	g38337	i0	100	0.100358422939068	28	0	10	0	142	169	3599899	3599926	Amycolatopsis nalaikhensis strain 2-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis nalaikhensis
25365736	25365736	PRJNA594101_S_NODE_55960_length_243_cov_0.900000_g55658_i0	PRJNA594101	55960	243	0.9	2.187	Streptomyces	1883	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2667573168\|gb\|CP107811.1\|	2975770	g55658	i0	100	0.345679012345679	28	0	12	0	21	48	4707089	4707062	Streptomyces sp. NBC_00539 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00539

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