metadata: contig_metadata: 32 rows where bioproject = "PRJEB7614" and tax

32 rows where bioproject = "PRJEB7614" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6099580	6099580	PRJEB7614_P_NODE_4805_length_193_cov_7.573171_g4738_i0	PRJEB7614	4805	193	7.573171	14.61622003	Micrococcus	1269	Bacteria	Bacteria	215	2.01e-51	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g4738	i0	99.167	109.181347150259	120	0	100	1	75	193	345537	345418	Micrococcus luteus strain V017 chromosome, complete genome	blastn	21072	215	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15024308	15024308	PRJEB7614_P_NODE_9032_length_158_cov_8.728682_g8965_i0	PRJEB7614	9032	158	8.728682	13.79131756	Nakamurella	53460	Bacteria	Bacteria	152	1.2499999999999998e-32	NTclustered	gi\|1085737951\|emb\|LT629710.1\|	1090615	g8965	i0	100	145.177215189873	82	0	52	0	77	158	2057509	2057590	Nakamurella panacisegetis strain P4-7,KCTC 19426,CECT 7604 genome assembly, chromosome: I	blastn	22938	152	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella panacisegetis
22673336	22673336	PRJEB7614_P_NODE_298_length_441_cov_7.087379_g250_i0	PRJEB7614	298	441	7.087379	31.25534139	Cutibacterium	1912216	Bacteria	Bacteria	486	9.859999999999997e-133	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g250	i0	100	214.993197278912	263	0	88	0	15	277	55865	55603	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	94812	486	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25222547	25222547	PRJEB7614_P_NODE_4740_length_194_cov_6.206061_g4673_i0	PRJEB7614	4740	194	6.206061	12.03975834	Nocardiaceae	85025	Bacteria	Bacteria	187	4.4e-43	NTclustered	gi\|1708030867\|gb\|CP041695.1\|	1823	g4673	i0	96.46	334.556701030928	113	4	100	0	1	113	2263254	2263366	Nocardia otitidiscaviarum strain NEB252 chromosome, complete genome	blastn	64904	187	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia otitidiscaviarum
25525701	25525701	PRJEB7614e_S_NODE_641_length_274_cov_906.732218_g633_i0	PRJEB7614	641	274	906.732218	2484.44627732	Corynebacterium sp. SCR2211	1720	Bacteria	Bacteria	339	1.73e-88	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g633	i0	96.569	296.076642335766	204	7	74	0	71	274	79865	79662	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	81125	339	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
25616356	25616356	PRJEB7614a_S_NODE_11897_length_445_cov_18.270732_g10791_i0	PRJEB7614	11897	445	18.270732	81.3047574	Cutibacterium	1912216	Bacteria	Bacteria	822	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10791	i0	100	245.840449438202	445	0	100	0	1	445	55344	55788	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	109399	822	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25616372	25616372	PRJEB7614a_S_NODE_91321_length_197_cov_2.086420_g90117_i0	PRJEB7614	91321	197	2.08642	4.1102474	Micrococcus	1269	Bacteria	Bacteria	305	1.19e-78	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g90117	i0	100	215.609137055838	165	0	84	0	1	165	346680	346844	Micrococcus luteus strain V017 chromosome, complete genome	blastn	42475	305	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25616374	25616374	PRJEB7614b_S_NODE_1201_length_205_cov_3.023529_g1199_i0	PRJEB7614	1201	205	3.023529	6.19823445	Cutibacterium	1912216	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1199	i0	100	276.341463414634	205	0	100	0	1	205	55490	55694	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	56650	379	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25616390	25616390	PRJEB7614e_S_NODE_6329_length_181_cov_3.664384_g6321_i0	PRJEB7614	6329	181	3.664384	6.63253504	Micrococcus	1269	Bacteria	Bacteria	311	2.3e-80	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g6321	i0	100	229.121546961326	168	0	93	0	14	181	346803	346636	Micrococcus luteus strain V017 chromosome, complete genome	blastn	41471	311	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25752623	25752623	PRJEB7614a_S_NODE_110378_length_176_cov_2.517730_g109174_i0	PRJEB7614	110378	176	2.51773	4.4312048	Cutibacterium	1912216	Bacteria	Bacteria	241	2.950000000000001e-59	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g109174	i0	100	215.147727272727	130	0	74	0	47	176	56694	56565	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	37866	241	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25752626	25752626	PRJEB7614a_S_NODE_122346_length_165_cov_1.484615_g121142_i0	PRJEB7614	122346	165	1.484615	2.44961475	Actinomycetes	1760	Bacteria	Bacteria	268	1.26e-67	NTclustered	gi\|2246833622\|gb\|CP094265.1\|	1993	g121142	i0	96.319	234.957575757576	163	6	99	0	1	163	3187	3349	Actinomadura madurae strain MRC008 chromosome, complete genome	blastn	38768	268	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura madurae
25752671	25752671	PRJEB7614e_S_NODE_1282_length_223_cov_4.313830_g1274_i0	PRJEB7614	1282	223	4.31383	9.6198409	Corynebacterium	1716	Bacteria	Bacteria	355	1.35e-93	NTclustered	gi\|662020105\|ref\|NR_121992.1\|	38305	g1274	i0	95.516	359.286995515695	223	8	99	2	1	222	1055	834	Corynebacterium vitaeruminis strain DSM 20294 23S ribosomal RNA gene, complete sequence	blastn	80121	357	0.994397759103641	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium vitaeruminis
25888369	25888369	PRJEB7614d_S_NODE_4483_length_151_cov_2.853448_g4445_i0	PRJEB7614	4483	151	2.853448	4.30870648	Cutibacterium	1912216	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4445	i0	100	281.072847682119	151	0	100	0	1	151	56707	56557	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	42442	279	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25888376	25888376	PRJEB7614e_S_NODE_1723_length_210_cov_2.302857_g1715_i0	PRJEB7614	1723	210	2.302857	4.8359997	Microbacteriaceae	85023	Bacteria	Bacteria	281	2.16e-71	NTclustered	gi\|1487528433\|gb\|CP032630.1\|	2419774	g1715	i0	94.972	153.242857142857	179	9	85	0	1	179	3066361	3066183	Protaetiibacter intestinalis strain 2DFWR-13 chromosome, complete genome	blastn	32181	281	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Protaetiibacter	Protaetiibacter intestinalis
26024651	26024651	PRJEB7614a_S_NODE_100980_length_185_cov_13.180000_g99776_i0	PRJEB7614	100980	185	13.18	24.383	Corynebacterium	1716	Bacteria	Bacteria	300	5.110000000000001e-77	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g99776	i0	98.81	332.12972972973	168	2	91	0	18	185	2489966	2490133	Corynebacterium accolens strain CA3 chromosome	blastn	61444	300	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
26024707	26024707	PRJEB7614e_S_NODE_9900_length_174_cov_3.266187_g9892_i0	PRJEB7614	9900	174	3.266187	5.68316538	Bifidobacterium	1678	Bacteria	Bacteria	185	1.38e-42	NTclustered	gi\|2669472383\|gb\|CP143938.1\|	28026	g9892	i0	90.714	256.137931034483	140	12	80	1	35	174	1690564	1690702	Bifidobacterium pseudocatenulatum strain DFI.7.61 chromosome, complete genome	blastn	44568	185	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
26069957	26069957	PRJEB7614d_S_NODE_845_length_233_cov_7.414141_g807_i0	PRJEB7614	845	233	7.414141	17.27494853	Rothia amarae	169480	Bacteria	Bacteria	387	5.03e-103	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g807	i0	99.528	315.515021459227	212	1	91	0	22	233	1624704	1624493	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	73515	387	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
26160854	26160854	PRJEB7614d_S_NODE_4221_length_153_cov_1.220339_g4183_i0	PRJEB7614	4221	153	1.220339	1.86711867	Rothia	32207	Bacteria	Bacteria	255	8.900000000000001e-64	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g4183	i0	96.732	299.483660130719	153	5	100	0	1	153	511	663	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	45821	255	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
26160855	26160855	PRJEB7614d_S_NODE_685_length_249_cov_2.364486_g647_i0	PRJEB7614	685	249	2.364486	5.88757014	Kocuria	57493	Bacteria	Bacteria	424	4.15e-114	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g647	i0	98.34	400.698795180723	241	4	97	0	7	247	220885	220645	Kocuria palustris strain MU14/1, complete genome	blastn	99774	424	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
26160862	26160862	PRJEB7614e_S_NODE_6333_length_181_cov_2.561644_g6325_i0	PRJEB7614	6333	181	2.561644	4.63657564	Micrococcales	85006	Bacteria	Bacteria	257	3.04e-64	NTclustered	gi\|2452059386\|gb\|CP118972.1\|	1670	g6325	i0	95.092	347.71270718232	163	8	90	0	10	172	238450	238288	Arthrobacter citreus strain DSM 15046 chromosome, complete genome	blastn	62936	257	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
26160865	26160865	PRJEB7614e_S_NODE_781_length_260_cov_3.537778_g773_i0	PRJEB7614	781	260	3.537778	9.1982228	Micrococcaceae	1268	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|2452059386\|gb\|CP118972.1\|	1670	g773	i0	96.234	415.992307692308	239	9	92	0	1	239	239999	239761	Arthrobacter citreus strain DSM 15046 chromosome, complete genome	blastn	108158	392	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
26160866	26160866	PRJEB7614e_S_NODE_8661_length_176_cov_4.553191_g8653_i0	PRJEB7614	8661	176	4.553191	8.01361616	Rhodoluna	529883	Bacteria	Bacteria	246	6.349999999999999e-61	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g8653	i0	94.904	140.295454545455	157	8	89	0	20	176	476756	476600	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	24692	246	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
26296617	26296617	PRJEB7614e_S_NODE_38_length_595_cov_4.367857_g33_i0	PRJEB7614	38	595	4.367857	25.98874915	Cutibacterium	1912216	Bacteria	Bacteria	992	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g33	i0	97.755	267.826890756303	579	8	99	3	17	595	55995	55422	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	159357	992	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26342067	26342067	PRJEB7614d_S_NODE_2687_length_166_cov_4.778626_g2649_i0	PRJEB7614	2687	166	4.778626	7.93251916	Micrococcus porci	2856555	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2099415156\|gb\|CP083691.1\|	2856555	g2649	i0	100	275.692771084337	166	0	100	0	1	166	1443188	1443023	Micrococcus porci strain KD337-16 chromosome, complete genome	blastn	45765	307	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus porci
26432627	26432627	PRJEB7614c_S_NODE_2375_length_182_cov_2.755102_g2374_i0	PRJEB7614	2375	182	2.755102	5.01428564	Corynebacterium	1716	Bacteria	Bacteria	276	8.440000000000001e-70	NTclustered	gi\|2547417233\|gb\|CP073096.1\|	38304	g2374	i0	98.71	312.505494505494	155	2	87	0	28	182	790377	790223	Corynebacterium tuberculostearicum strain CTNIH20 chromosome, complete genome	blastn	56876	276	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
26432636	26432636	PRJEB7614d_S_NODE_87_length_510_cov_7.520000_g50_i0	PRJEB7614	87	510	7.52	38.352	Cutibacterium	1912216	Bacteria	Bacteria	942	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g50	i0	100	247.164705882353	510	0	100	0	1	510	55845	55336	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	126054	942	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26478318	26478318	PRJEB7614d_S_NODE_736_length_243_cov_10.581731_g698_i0	PRJEB7614	736	243	10.581731	25.71360633	Corynebacterium dentalis	2014528	Bacteria	Bacteria	412	8.72e-111	NTclustered	gi\|2831254150\|gb\|CP170996.1\|	2014528	g698	i0	99.558	392.740740740741	226	1	93	0	1	226	2693	2918	Corynebacterium dentalis strain WGS1543 chromosome, complete genome	blastn	95436	412	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium dentalis
26568621	26568621	PRJEB7614a_S_NODE_89224_length_199_cov_14.304878_g88020_i0	PRJEB7614	89224	199	14.304878	28.46670722	Micrococcus	1269	Bacteria	Bacteria	315	1.99e-81	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g88020	i0	99.422	249.954773869347	173	1	87	0	1	173	345418	345590	Micrococcus luteus strain V017 chromosome, complete genome	blastn	49741	315	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
26568623	26568623	PRJEB7614a_S_NODE_93120_length_194_cov_44.207547_g91916_i0	PRJEB7614	93120	194	44.207547	85.76264118	root	1	Root_unresolved	Root_unresolved	359	8.809999999999999e-95	NTclustered	gi\|1212877687\|gb\|MF405214.1\|	1270	g91916	i0	100	100	194	0	100	0	1	194	326	133	Micrococcus luteus strain D27 16S ribosomal RNA gene, partial sequence	blastn	19400	359	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
26568625	26568625	PRJEB7614b_S_NODE_1144_length_207_cov_767.843023_g1142_i0	PRJEB7614	1144	207	767.843023	1589.43505761	Corynebacterium	1716	Bacteria	Bacteria	316	5.819999999999998e-82	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g1142	i0	100	302.115942028986	171	0	83	0	1	171	990584	990414	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	62538	316	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
33066303	33066303	PRJEB7614a_S_NODE_120381_length_167_cov_1.030303_g119177_i0	PRJEB7614	120381	167	1.030303	1.72060601	Mycolicibacterium chitae	1792	Bacteria	Bacteria	41.2	0.0161	NR	WP_179967258.1	1792	g119177	i0	41.8	3.95209580838323	55	28	91.6	2	166	14	23	77	WP_179967258.1 DUF4233 domain-containing protein [Mycolicibacterium chitae]	diamond	660	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium chitae
33179351	33179351	PRJEB7614a_S_NODE_76304_length_218_cov_5.311475_g75100_i0	PRJEB7614	76304	218	5.311475	11.5790155	Bacteria	2	Bacteria	Bacteria	40.8	0.0194	NR	MDU7610945.1	1681	g75100	i0	78.9	0.509174311926605	19	4	26.1	0	38	94	1	19	MDU7610945.1 hypothetical protein [Bifidobacterium bifidum]	diamond	111	41.2	0.990291262135922	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium bifidum

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