metadata: contig_metadata: 73 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax

73 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
365990	365990	PRJNA195897_P_NODE_4261_length_232_cov_1.071038_g4228_i0	PRJNA195897	4261	232	1.071038	2.48480816	Rhodococcus opacus	37919	Bacteria	Bacteria	73.1	1.59e-8	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g4228	i0	97.674	2.74568965517241	43	0	18	1	180	221	33510	33468	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	637	73.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
1055334	1055334	PRJNA195897_P_NODE_7021_length_188_cov_0.769784_g6988_i0	PRJNA195897	7021	188	0.769784	1.44719392	Rothia	32207	Bacteria	Bacteria	313	6.69e-81	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g6988	i0	96.809	338.13829787234	188	5	100	1	1	188	1623465	1623279	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	63570	313	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
1640723	1640723	PRJNA195897_P_NODE_11002_length_165_cov_0.896552_g10969_i0	PRJNA195897	11002	165	0.896552	1.4793108	Rhodococcus opacus	37919	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g10969	i0	100	0.175757575757576	29	0	18	0	6	34	7692178	7692150	Rhodococcus opacus PD630, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
1640727	1640727	PRJNA195897_P_NODE_11362_length_164_cov_0.904348_g11329_i0	PRJNA195897	11362	164	0.904348	1.48313072	Rhodococcus opacus	37919	Bacteria	Bacteria	60.2	8.18e-5	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g11329	i0	100	3.16463414634146	32	0	23	0	119	150	7692145	7692176	Rhodococcus opacus PD630, complete genome	blastn	519	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
1640766	1640766	PRJNA195897_P_NODE_3802_length_247_cov_1.424242_g3769_i0	PRJNA195897	3802	247	1.424242	3.51787774	Mycolicibacterium brumae	85968	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2303604256\|gb\|CP104302.1\|	85968	g3769	i0	100	0.11336032388664	28	0	11	0	218	245	3630295	3630268	Mycolicibacterium brumae strain ATCC 51384 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium brumae
1640775	1640775	PRJNA195897_P_NODE_4642_length_223_cov_0.862069_g4609_i0	PRJNA195897	4642	223	0.862069	1.92241387	Rhodococcus opacus	37919	Bacteria	Bacteria	76.8	1.17e-9	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g4609	i0	97.727	2.78923766816144	44	1	21	0	6	49	33506	33463	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	622	76.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
1640786	1640786	PRJNA195897_P_NODE_62_length_1668_cov_2.978999_g56_i0	PRJNA195897	62	1668	2.978999	49.68970332	Corynebacterium gottingense	2041036	Bacteria	Bacteria	2717	0	NTclustered	gi\|2869851930\|gb\|CP175790.1\|	2041036	g56	i0	96.115	380.51139088729	1673	52	100	10	1	1668	608937	607273	Corynebacterium gottingense strain YSMAA1_1_F6 chromosome, complete genome	blastn	634693	2717	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
2330582	2330582	PRJNA195897_P_NODE_2462_length_321_cov_1.147059_g2429_i0	PRJNA195897	2462	321	1.147059	3.68205939	Micrococcaceae	1268	Bacteria	Bacteria	555	1.8799999999999998e-153	NTclustered	gi\|2666964057\|dbj\|AP029193.1\|	1671	g2429	i0	97.819	461.367601246106	321	7	100	0	1	321	809704	810024	Pseudarthrobacter oxydans JCM 2521 DNA, complete genome	blastn	148099	560	0.991071428571429	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
2330586	2330586	PRJNA195897_P_NODE_3782_length_248_cov_0.934673_g3749_i0	PRJNA195897	3782	248	0.934673	2.31798904	Microbacterium	33882	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|1085647670\|emb\|LT629692.1\|	370764	g3749	i0	98.387	176.927419354839	248	4	100	0	1	248	2943186	2942939	Microbacterium pygmaeum strain DSM 23142 genome assembly, chromosome: I	blastn	43878	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium pygmaeum
2330599	2330599	PRJNA195897_P_NODE_9462_length_168_cov_0.873950_g9429_i0	PRJNA195897	9462	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9429	i0	100	54.8571428571429	168	0	100	0	1	168	2073739	2073906	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9216	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2916648	2916648	PRJNA195897_P_NODE_2963_length_286_cov_1.097046_g2930_i0	PRJNA195897	2963	286	1.097046	3.13755156	Rhodococcus opacus	37919	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g2930	i0	100	0.300699300699301	29	0	10	0	252	280	2864921	2864893	Rhodococcus opacus PD630, complete genome	blastn	86	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
4883283	4883283	PRJNA195897_P_NODE_8104_length_176_cov_1.637795_g8071_i0	PRJNA195897	8104	176	1.637795	2.8825192	Bacteria	2	Bacteria	Bacteria	71.3	4.1e-8	NTclustered	gi\|2874253893\|emb\|OY970068.1\|	152507	g8071	i0	88.136	12.8465909090909	59	7	34	0	1	59	3594188	3594246	MAG: uncultured Actinomycetes bacterium isolate MFD04212.bin.1.59 genome assembly, chromosome: 1	blastn	2261	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
5469271	5469271	PRJNA195897_P_NODE_10025_length_167_cov_0.881356_g9992_i0	PRJNA195897	10025	167	0.881356	1.47186452	Rhodococcus opacus	37919	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|589070382\|gb\|CP003950.1\|	543736	g9992	i0	100	0.167664670658683	28	0	17	0	140	167	155274	155247	Rhodococcus opacus PD630 plasmid 1, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
5469276	5469276	PRJNA195897_P_NODE_11385_length_164_cov_0.904348_g11352_i0	PRJNA195897	11385	164	0.904348	1.48313072	Rhodococcus opacus	37919	Bacteria	Bacteria	65.8	1.76e-6	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g11352	i0	100	2.6280487804878	35	0	21	0	130	164	6864626	6864660	Rhodococcus opacus PD630, complete genome	blastn	431	65.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
5469354	5469354	PRJNA195897_P_NODE_6325_length_196_cov_0.877551_g6292_i0	PRJNA195897	6325	196	0.877551	1.71999996	Streptomyces noursei	1971	Bacteria	Bacteria	58.4	3.64e-4	NTclustered	gi\|785755366\|gb\|CP006871.1\|	1434306	g6292	i0	100	0.887755102040816	31	0	16	0	69	99	2068735	2068705	Streptomyces albulus ZPM, complete genome	blastn	174	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
6158019	6158019	PRJNA195897_P_NODE_10145_length_167_cov_0.881356_g10112_i0	PRJNA195897	10145	167	0.881356	1.47186452	Cutibacterium	1912216	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10112	i0	100	62.1616766467066	167	0	100	0	1	167	223864	223698	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10381	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6158033	6158033	PRJNA195897_P_NODE_9545_length_168_cov_0.873950_g9512_i0	PRJNA195897	9545	168	0.87395	1.468236	root	1	Root_unresolved	Root_unresolved	311	2.11e-80	NTclustered	gi\|2095693438\|gb\|OK148636.1\|	1679	g9512	i0	100	127.005952380952	168	0	100	0	1	168	418	585	Bifidobacterium longum subsp. longum strain K8 16S ribosomal RNA gene, partial sequence	blastn	21337	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
6743640	6743640	PRJNA195897_P_NODE_2386_length_326_cov_0.938628_g2353_i0	PRJNA195897	2386	326	0.938628	3.05992728	Microbacterium testaceum	2033	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2530242188\|gb\|CP103793.1\|	2033	g2353	i0	100	0.0858895705521472	28	0	9	0	29	56	22475	22448	Microbacterium testaceum strain D12 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
6743646	6743646	PRJNA195897_P_NODE_2766_length_298_cov_1.144578_g2733_i0	PRJNA195897	2766	298	1.144578	3.41084244	Streptomyces inhibens	2293571	Bacteria	Bacteria	176	1.58e-39	NTclustered	gi\|2193894640\|gb\|CP084681.1\|	2293571	g2733	i0	84.659	32.0939597315436	176	27	59	0	109	284	6381472	6381647	Streptomyces inhibens strain NRRL30439 chromosome, complete genome	blastn	9564	176	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces inhibens
6743650	6743650	PRJNA195897_P_NODE_2926_length_289_cov_0.883333_g2893_i0	PRJNA195897	2926	289	0.883333	2.55283237	Streptomyces phaeolivaceus	2653200	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1767655524\|gb\|CP045096.1\|	2653200	g2893	i0	94.286	0.121107266435986	35	2	12	0	4	38	6936980	6936946	Streptomyces phaeolivaceus strain GY16 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces phaeolivaceus
7433182	7433182	PRJNA195897_P_NODE_3366_length_265_cov_2.018519_g3333_i0	PRJNA195897	3366	265	2.018519	5.34907535	Micrococcus	1269	Bacteria	Bacteria	436	5.719999999999999e-118	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g3333	i0	96.255	318.592452830189	267	8	100	1	1	265	346974	346708	Micrococcus luteus strain V017 chromosome, complete genome	blastn	84427	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
7433189	7433189	PRJNA195897_P_NODE_6366_length_195_cov_1.068493_g6333_i0	PRJNA195897	6366	195	1.068493	2.08356135	root	1	Root_unresolved	Root_unresolved	71.3	4.65e-8	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g6333	i0	100	3.29230769230769	38	0	19	0	3	40	33504	33467	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	642	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
8019320	8019320	PRJNA195897_P_NODE_12127_length_163_cov_0.912281_g12094_i0	PRJNA195897	12127	163	0.912281	1.48701803	Actinomycetospora sp. NBC_00405	2975952	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2658591327\|gb\|CP107938.1\|	2975952	g12094	i0	96.875	2.68711656441718	160	5	98	0	4	163	2485772	2485613	Actinomycetospora sp. NBC_00405 chromosome, complete genome	blastn	438	268	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinomycetospora	Actinomycetospora sp. NBC_00405
9294028	9294028	PRJNA195897_P_NODE_12108_length_163_cov_0.912281_g12075_i0	PRJNA195897	12108	163	0.912281	1.48701803	Rhodococcus opacus	37919	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g12075	i0	100	0.171779141104294	28	0	17	0	130	157	7207982	7208009	Rhodococcus opacus PD630, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
9294030	9294030	PRJNA195897_P_NODE_12348_length_162_cov_0.920354_g12315_i0	PRJNA195897	12348	162	0.920354	1.49097348	Micromonospora terminaliae	1914461	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1776911862\|gb\|CP045309.1\|	1914461	g12315	i0	100	0.172839506172839	28	0	17	0	14	41	6229224	6229251	Micromonospora terminaliae strain DSM 101760 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora terminaliae
9294067	9294067	PRJNA195897_P_NODE_4088_length_237_cov_0.765957_g4055_i0	PRJNA195897	4088	237	0.765957	1.81531809	Nocardioides okcheonensis	2894081	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2156608594\|gb\|CP087710.1\|	2894081	g4055	i0	100	0.118143459915612	28	0	12	0	61	88	1489846	1489819	Nocardioides okcheonensis strain MMS20-HV4-12 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides okcheonensis
9294094	9294094	PRJNA195897_P_NODE_7308_length_185_cov_0.801471_g7275_i0	PRJNA195897	7308	185	0.801471	1.48272135	Rothia amarae	169480	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g7275	i0	100	357.313513513513	185	0	100	0	1	185	1623839	1624023	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	66103	342	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
9294111	9294111	PRJNA195897_P_NODE_9888_length_167_cov_0.881356_g9855_i0	PRJNA195897	9888	167	0.881356	1.47186452	Varibaculum cambriense	184870	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|2514706718\|gb\|CP126959.1\|	184870	g9855	i0	94.611	3	167	9	100	0	1	167	991625	991459	Varibaculum cambriense strain UMB0796 chromosome, complete genome	blastn	501	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Varibaculum	Varibaculum cambriense
9983341	9983341	PRJNA195897_P_NODE_11028_length_165_cov_0.896552_g10995_i0	PRJNA195897	11028	165	0.896552	1.4793108	root	1	Root_unresolved	Root_unresolved	58.4	2.97e-4	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g10995	i0	100	3.18787878787879	31	0	19	0	135	165	6864663	6864633	Rhodococcus opacus PD630, complete genome	blastn	526	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
9983342	9983342	PRJNA195897_P_NODE_1108_length_504_cov_3.470330_g1077_i0	PRJNA195897	1108	504	3.47033	17.4904632	Corynebacterium	1716	Bacteria	Bacteria	865	0	NTclustered	gi\|2869842788\|gb\|CP175780.1\|	38304	g1077	i0	97.624	368.394841269841	505	11	100	1	1	504	1230879	1230375	Corynebacterium tuberculostearicum strain YSMAA1_2_H3 chromosome, complete genome	blastn	185671	865	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
10570021	10570021	PRJNA195897_P_NODE_11589_length_164_cov_0.904348_g11556_i0	PRJNA195897	11589	164	0.904348	1.48313072	Streptomyces noursei	1971	Bacteria	Bacteria	67.6	4.89e-7	NTclustered	gi\|785755366\|gb\|CP006871.1\|	1434306	g11556	i0	97.436	3.70731707317073	39	1	24	0	1	39	3926543	3926505	Streptomyces albulus ZPM, complete genome	blastn	608	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
10570109	10570109	PRJNA195897_P_NODE_8809_length_170_cov_1.256198_g8776_i0	PRJNA195897	8809	170	1.256198	2.1355366	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	113	6.430000000000001e-21	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g8776	i0	82.443	13.4470588235294	131	21	76	2	41	170	4989143	4989272	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	2286	113	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
11258504	11258504	PRJNA195897_P_NODE_1569_length_418_cov_1.181572_g1536_i0	PRJNA195897	1569	418	1.181572	4.93897096	root	1	Root_unresolved	Root_unresolved	69.4	3.99e-7	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g1536	i0	100	1.50478468899522	37	0	9	0	374	410	33468	33504	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	629	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
11258511	11258511	PRJNA195897_P_NODE_3929_length_243_cov_1.108247_g3896_i0	PRJNA195897	3929	243	1.108247	2.69304021	root	1	Root_unresolved	Root_unresolved	63.9	1.01e-5	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g3896	i0	100	1.64197530864198	34	0	14	0	1	34	33501	33468	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	399	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
11844511	11844511	PRJNA195897_P_NODE_12110_length_163_cov_0.912281_g12077_i0	PRJNA195897	12110	163	0.912281	1.48701803	Brachybacterium sp. Z12	2759167	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1898542978\|gb\|CP060496.1\|	2759167	g12077	i0	100	0.171779141104294	28	0	17	0	26	53	3077076	3077049	Brachybacterium sp. Z12 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. Z12
11844518	11844518	PRJNA195897_P_NODE_12650_length_162_cov_0.920354_g12617_i0	PRJNA195897	12650	162	0.920354	1.49097348	Rhodococcus opacus	37919	Bacteria	Bacteria	73.1	1.03e-8	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g12617	i0	100	3.7962962962963	39	0	24	0	2	40	33505	33467	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	615	73.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
11844538	11844538	PRJNA195897_P_NODE_3570_length_256_cov_1.256039_g3537_i0	PRJNA195897	3570	256	1.256039	3.21545984	Streptomyces sp. Je 1-369	2966192	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2410828879\|gb\|CP101750.1\|	2966192	g3537	i0	100	0.109375	28	0	11	0	15	42	2438515	2438542	Streptomyces sp. Je 1-369 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Je 1-369
11844546	11844546	PRJNA195897_P_NODE_4810_length_219_cov_1.005882_g4777_i0	PRJNA195897	4810	219	1.005882	2.20288158	Streptomyces noursei	1971	Bacteria	Bacteria	76.8	1.15e-9	NTclustered	gi\|785755366\|gb\|CP006871.1\|	1434306	g4777	i0	100	2.8675799086758	41	0	19	0	178	218	9406756	9406796	Streptomyces albulus ZPM, complete genome	blastn	628	76.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
11844581	11844581	PRJNA195897_P_NODE_9970_length_167_cov_0.881356_g9937_i0	PRJNA195897	9970	167	0.881356	1.47186452	Rhodococcus opacus	37919	Bacteria	Bacteria	75	2.99e-9	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g9937	i0	97.727	3.75449101796407	44	0	27	1	122	165	33463	33505	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	627	75	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
12533928	12533928	PRJNA195897_P_NODE_10990_length_165_cov_0.896552_g10957_i0	PRJNA195897	10990	165	0.896552	1.4793108	Cutibacterium	1912216	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g10957	i0	100	52.169696969697	165	0	100	0	1	165	2248383	2248219	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	8608	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12533932	12533932	PRJNA195897_P_NODE_12350_length_162_cov_0.920354_g12317_i0	PRJNA195897	12350	162	0.920354	1.49097348	Microbacterium	33882	Bacteria	Bacteria	219	1.26e-52	NTclustered	gi\|1919991748\|gb\|CP060402.1\|	2763257	g12317	i0	91.304	35.3765432098765	161	12	99	2	1	160	1952738	1952897	Microbacterium sp. YJN-G chromosome, complete genome	blastn	5731	220	0.995454545454545	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. YJN-G
12533938	12533938	PRJNA195897_P_NODE_270_length_987_cov_2.812367_g250_i0	PRJNA195897	270	987	2.812367	27.75806229	Cutibacterium	1912216	Bacteria	Bacteria	1796	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g250	i0	99.493	278.835866261398	987	5	100	0	1	987	608005	608991	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	275211	1796	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13119736	13119736	PRJNA195897_P_NODE_12131_length_163_cov_0.912281_g12098_i0	PRJNA195897	12131	163	0.912281	1.48701803	Nocardioides sp. HDW12B	2714939	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g12098	i0	82.911	0.969325153374233	158	27	97	0	6	163	174217	174060	Nocardioides sp. HDW12B chromosome, complete genome	blastn	158	143	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
13119741	13119741	PRJNA195897_P_NODE_12711_length_162_cov_0.858407_g12678_i0	PRJNA195897	12711	162	0.858407	1.39061934	Corynebacterium matruchotii	43768	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g12678	i0	94.444	0.481481481481481	36	2	22	0	73	108	1963253	1963288	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	78	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
13119802	13119802	PRJNA195897_P_NODE_7711_length_180_cov_1.190840_g7678_i0	PRJNA195897	7711	180	1.19084	2.143512	Cutibacterium granulosum	33011	Bacteria	Bacteria	322	1.05e-83	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g7678	i0	98.889	290.394444444444	180	2	100	0	1	180	486364	486185	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	52271	322	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
13119803	13119803	PRJNA195897_P_NODE_7771_length_179_cov_1.684615_g7738_i0	PRJNA195897	7771	179	1.684615	3.01546085	Cutibacterium modestum	2559073	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|1061027374\|gb\|CP017040.1\|	2559073	g7738	i0	97.765	266.039106145251	179	4	100	0	1	179	774934	775112	Cutibacterium modestum strain F0672, complete sequence	blastn	47621	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium modestum
13808713	13808713	PRJNA195897_P_NODE_3491_length_259_cov_1.628571_g3458_i0	PRJNA195897	3491	259	1.628571	4.21799889	root	1	Root_unresolved	Root_unresolved	69.4	2.34e-7	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g3458	i0	100	2.42471042471042	37	0	14	0	11	47	6864664	6864628	Rhodococcus opacus PD630, complete genome	blastn	628	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
13808715	13808715	PRJNA195897_P_NODE_3871_length_245_cov_0.989796_g3838_i0	PRJNA195897	3871	245	0.989796	2.4250002	root	1	Root_unresolved	Root_unresolved	73.1	1.7e-8	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g3838	i0	100	2.61632653061224	39	0	18	0	32	70	33506	33468	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	641	73.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
13808722	13808722	PRJNA195897_P_NODE_8891_length_169_cov_1.416667_g8858_i0	PRJNA195897	8891	169	1.416667	2.39416723	Cutibacterium	1912216	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g8858	i0	98.817	51	169	2	100	0	1	169	1807692	1807524	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	8619	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14395084	14395084	PRJNA195897_P_NODE_6332_length_195_cov_2.164384_g6299_i0	PRJNA195897	6332	195	2.164384	4.2205488	Kocuria rosea	1275	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|1678593041\|gb\|CP035103.1\|	1275	g6299	i0	100	302.610256410256	195	0	100	0	1	195	2501411	2501605	Kocuria rosea strain ATCC 186 chromosome, complete genome	blastn	59009	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
15082822	15082822	PRJNA195897_P_NODE_10692_length_166_cov_0.888889_g10659_i0	PRJNA195897	10692	166	0.888889	1.47555574	Cutibacterium	1912216	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10659	i0	99.398	47	166	1	100	0	1	166	1331396	1331231	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	7802	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15082850	15082850	PRJNA195897_P_NODE_9572_length_168_cov_0.873950_g9539_i0	PRJNA195897	9572	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9539	i0	100	46	168	0	100	0	1	168	1069694	1069527	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	7728	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15668792	15668792	PRJNA195897_P_NODE_4433_length_227_cov_1.449438_g4400_i0	PRJNA195897	4433	227	1.449438	3.29022426	Rothia mucilaginosa	43675	Bacteria	Bacteria	368	1.77e-97	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g4400	i0	96.053	308.022026431718	228	5	99	2	3	227	653813	654039	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	69921	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
15668828	15668828	PRJNA195897_P_NODE_8613_length_171_cov_2.426230_g8580_i0	PRJNA195897	8613	171	2.42623	4.1488533	Cutibacterium granulosum	33011	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g8580	i0	99.415	253.134502923977	171	1	100	0	1	171	485637	485807	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	43286	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
15668835	15668835	PRJNA195897_P_NODE_9213_length_169_cov_0.866667_g9180_i0	PRJNA195897	9213	169	0.866667	1.46466723	Rhodococcus opacus	37919	Bacteria	Bacteria	58.4	3.03e-4	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g9180	i0	100	3.07692307692308	31	0	19	0	2	32	7692145	7692175	Rhodococcus opacus PD630, complete genome	blastn	520	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
16357711	16357711	PRJNA195897_P_NODE_2893_length_290_cov_1.721992_g2860_i0	PRJNA195897	2893	290	1.721992	4.9937768	Streptomyces	1883	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2657409952\|gb\|CP108258.1\|	2975633	g2860	i0	100	0.386206896551724	28	0	10	0	40	67	7812435	7812408	Streptomyces sp. NBC_00056 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00056
16357731	16357731	PRJNA195897_P_NODE_9993_length_167_cov_0.881356_g9960_i0	PRJNA195897	9993	167	0.881356	1.47186452	Schaalia	2529408	Bacteria	Bacteria	237	3.599999999999999e-58	NTclustered	gi\|913013404\|gb\|CP012072.1\|	52773	g9960	i0	92.353	16.1317365269461	170	7	100	5	1	167	403314	403480	Actinomyces meyeri strain W712, complete genome	blastn	2694	237	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia meyeri
16943314	16943314	PRJNA195897_P_NODE_9254_length_169_cov_0.866667_g9221_i0	PRJNA195897	9254	169	0.866667	1.46466723	Streptomyces sp. NBC_00400	2975737	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2658640823\|gb\|CP107940.1\|	2975737	g9221	i0	96.875	0.189349112426035	32	1	19	0	124	155	7680187	7680156	Streptomyces sp. NBC_00400 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00400
18217649	18217649	PRJNA195897_P_NODE_1535_length_424_cov_1.496000_g1502_i0	PRJNA195897	1535	424	1.496	6.34304	Streptomyces virginiae	1961	Bacteria	Bacteria	246	1.75e-60	NTclustered	gi\|2687121656\|gb\|CP145515.1\|	1961	g1502	i0	77.861	96.5283018867924	402	85	94	3	5	404	3199751	3200150	Streptomyces virginiae strain THA-960 chromosome, complete genome	blastn	40928	246	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
18217650	18217650	PRJNA195897_P_NODE_1555_length_420_cov_15.811321_g1522_i0	PRJNA195897	1555	420	15.811321	66.4075482	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2697500286\|gb\|CP146988.1\|	68042	g1522	i0	100	0.135714285714286	29	0	7	0	53	81	9087051	9087023	Streptomyces hygroscopicus subsp. hygroscopicus strain DSM 41954 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
18906752	18906752	PRJNA195897_P_NODE_9335_length_168_cov_1.663866_g9302_i0	PRJNA195897	9335	168	1.663866	2.79529488	Corynebacterium	1716	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g9302	i0	100	380.875	168	0	100	0	1	168	736797	736630	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	63987	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
19491936	19491936	PRJNA195897_P_NODE_10976_length_165_cov_0.896552_g10943_i0	PRJNA195897	10976	165	0.896552	1.4793108	Streptomyces noursei	1971	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|785755366\|gb\|CP006871.1\|	1434306	g10943	i0	92.308	1.10909090909091	39	1	24	1	5	43	9406748	9406784	Streptomyces albulus ZPM, complete genome	blastn	183	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
19492000	19492000	PRJNA195897_P_NODE_5436_length_208_cov_0.981132_g5403_i0	PRJNA195897	5436	208	0.981132	2.04075456	Rhodococcus opacus	37919	Bacteria	Bacteria	75	3.89e-9	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g5403	i0	97.727	2.97596153846154	44	0	21	1	31	73	6864666	6864623	Rhodococcus opacus PD630, complete genome	blastn	619	75	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
19492021	19492021	PRJNA195897_P_NODE_8836_length_170_cov_0.859504_g8803_i0	PRJNA195897	8836	170	0.859504	1.4611568	Rhodococcus opacus	37919	Bacteria	Bacteria	62.1	2.36e-5	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g8803	i0	100	3.05294117647059	33	0	21	0	2	34	7692145	7692177	Rhodococcus opacus PD630, complete genome	blastn	519	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
20181345	20181345	PRJNA195897_P_NODE_12036_length_163_cov_0.912281_g12003_i0	PRJNA195897	12036	163	0.912281	1.48701803	Bifidobacterium	1678	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1434693461\|gb\|CP031133.1\|	1679	g12003	i0	99.387	354.061349693252	163	1	100	0	1	163	1457465	1457627	Bifidobacterium longum subsp. longum strain BORI chromosome, complete genome	blastn	57712	296	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
20181359	20181359	PRJNA195897_P_NODE_5636_length_205_cov_0.820513_g5603_i0	PRJNA195897	5636	205	0.820513	1.68205165	root	1	Root_unresolved	Root_unresolved	71.3	4.94e-8	NTclustered	gi\|589062392\|gb\|CP003949.1\|	543736	g5603	i0	100	3.20487804878049	38	0	20	0	5	42	6864626	6864663	Rhodococcus opacus PD630, complete genome	blastn	657	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
20767484	20767484	PRJNA195897_P_NODE_12617_length_162_cov_0.920354_g12584_i0	PRJNA195897	12617	162	0.920354	1.49097348	Cutibacterium acnes	1747	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2493043383\|gb\|CP114012.1\|	1747	g12584	i0	100	51	162	0	100	0	1	162	567616	567455	Cutibacterium acnes strain CBS-BPNBT19269 chromosome, complete genome	blastn	8262	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21457076	21457076	PRJNA195897_P_NODE_8837_length_170_cov_0.859504_g8804_i0	PRJNA195897	8837	170	0.859504	1.4611568	root	1	Root_unresolved	Root_unresolved	71.3	3.92e-8	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g8804	i0	100	3.8	38	0	25	0	3	40	33467	33504	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	646	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
22042635	22042635	PRJNA195897_P_NODE_6318_length_196_cov_1.034014_g6285_i0	PRJNA195897	6318	196	1.034014	2.02666744	Rhodococcus opacus	37919	Bacteria	Bacteria	60.2	1.01e-4	NTclustered	gi\|589070593\|gb\|CP003951.1\|	543736	g6285	i0	92.857	2.66836734693878	42	1	21	1	45	86	40731	40692	Rhodococcus opacus PD630 plasmid 2, complete sequence	blastn	523	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
23318127	23318127	PRJNA195897_P_NODE_8399_length_174_cov_0.928000_g8366_i0	PRJNA195897	8399	174	0.928	1.61472	Streptomyces noursei	1971	Bacteria	Bacteria	73.1	1.12e-8	NTclustered	gi\|785755366\|gb\|CP006871.1\|	1434306	g8366	i0	100	7.2816091954023	39	0	44	0	28	66	9406756	9406794	Streptomyces albulus ZPM, complete genome	blastn	1267	73.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
24007270	24007270	PRJNA195897_P_NODE_12679_length_162_cov_0.911504_g12646_i0	PRJNA195897	12679	162	0.911504	1.47663648	Cutibacterium	1912216	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g12646	i0	99.383	53	162	1	100	0	1	162	1297648	1297809	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8586	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24007277	24007277	PRJNA195897_P_NODE_439_length_804_cov_4.474172_g412_i0	PRJNA195897	439	804	4.474172	35.97234288	Cutibacterium	1912216	Bacteria	Bacteria	1452	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g412	i0	99.254	286.13184079602	804	6	100	0	1	804	55366	56169	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	230050	1452	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24007292	24007292	PRJNA195897_P_NODE_9659_length_168_cov_0.873950_g9626_i0	PRJNA195897	9659	168	0.87395	1.468236	Cutibacterium	1912216	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g9626	i0	100	73.5892857142857	168	0	100	0	1	168	2031191	2031024	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12363	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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