metadata: contig_metadata: 35 rows where bioproject = "PRJNA721440" and tax

35 rows where bioproject = "PRJNA721440" 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
3261470	3261470	PRJNA721440_S_NODE_5183_length_262_cov_2.985915_g5057_i0	PRJNA721440	5183	262	2.985915	7.8230973	Aeromicrobium erythreum	2041	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|973193275\|gb\|CP011502.1\|	2041	g5057	i0	96.198	163.309160305344	263	8	100	2	1	262	958063	957802	Aeromicrobium erythreum strain AR18 chromosome, complete genome	blastn	42787	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium erythreum
3745375	3745375	PRJNA721440_S_NODE_13803_length_182_cov_1.022556_g13677_i0	PRJNA721440	13803	182	1.022556	1.86105192	Cutibacterium	1912216	Bacteria	Bacteria	329	6.39e-86	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13677	i0	99.448	271.763736263736	181	1	99	0	2	182	55703	55883	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	49461	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3745384	3745384	PRJNA721440_S_NODE_21783_length_153_cov_2.788462_g21657_i0	PRJNA721440	21783	153	2.788462	4.26634686	Kytococcus	57499	Bacteria	Bacteria	250	4.14e-62	NTclustered	gi\|1948607475\|gb\|CP066015.1\|	1276	g21657	i0	96.078	221.124183006536	153	6	100	0	1	153	312563	312715	Kytococcus sedentarius strain FDAARGOS_1061 chromosome, complete genome	blastn	33832	250	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Kytococcaceae	Kytococcus	Kytococcus sedentarius
3745388	3745388	PRJNA721440_S_NODE_5423_length_257_cov_21.908654_g5297_i0	PRJNA721440	5423	257	21.908654	56.30524078	Micrococcus	1269	Bacteria	Bacteria	259	1.28e-64	NTclustered	gi\|2274423316\|gb\|CP101465.1\|	1270	g5297	i0	99.301	150.105058365759	143	1	56	0	2	144	364317	364459	Micrococcus luteus strain DNA1 chromosome, complete genome	blastn	38577	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
5021911	5021911	PRJNA721440_S_NODE_13284_length_184_cov_3.125926_g13158_i0	PRJNA721440	13284	184	3.125926	5.75170384	Nocardiaceae	85025	Bacteria	Bacteria	335	1.3899999999999996e-87	NTclustered	gi\|1707199879\|gb\|CP041647.1\|	43767	g13158	i0	99.457	327.125	184	1	100	0	1	184	926260	926443	Prescottella equi strain WY chromosome, complete genome	blastn	60191	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Prescottella	Prescottella equi
5813719	5813719	PRJNA721440_S_NODE_2705_length_342_cov_2.843003_g2579_i0	PRJNA721440	2705	342	2.843003	9.72307026	Aeromicrobium erythreum	2041	Bacteria	Bacteria	586	7.17e-163	NTclustered	gi\|973193275\|gb\|CP011502.1\|	2041	g2579	i0	97.661	427.318713450292	342	6	99	2	2	342	959036	958696	Aeromicrobium erythreum strain AR18 chromosome, complete genome	blastn	146143	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium erythreum
8846613	8846613	PRJNA721440_S_NODE_16047_length_172_cov_1.894309_g15921_i0	PRJNA721440	16047	172	1.894309	3.25821148	Rothia	32207	Bacteria	Bacteria	311	2.16e-80	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g15921	i0	100	272.03488372093	168	0	98	0	1	168	1003110	1002943	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	46790	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
10914180	10914180	PRJNA721440_S_NODE_22049_length_152_cov_2.126214_g21923_i0	PRJNA721440	22049	152	2.126214	3.23184528	Rothia amarae	169480	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g21923	i0	100	276.065789473684	152	0	100	0	1	152	1622385	1622536	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	41962	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
13947471	13947471	PRJNA721440_S_NODE_18591_length_165_cov_1.025862_g18465_i0	PRJNA721440	18591	165	1.025862	1.6926723	Rothia	32207	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g18465	i0	100	411.806060606061	165	0	100	0	1	165	652992	653156	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	67948	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
15222181	15222181	PRJNA721440_S_NODE_1072_length_506_cov_4.426696_g948_i0	PRJNA721440	1072	506	4.426696	22.39908176	Micrococcus	1269	Bacteria	Bacteria	918	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g948	i0	99.407	367.108695652174	506	3	100	0	1	506	346118	346623	Micrococcus luteus strain V017 chromosome, complete genome	blastn	185757	918	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15222182	15222182	PRJNA721440_S_NODE_10812_length_199_cov_2.340000_g10686_i0	PRJNA721440	10812	199	2.34	4.6566	Micrococcus	1269	Bacteria	Bacteria	326	9.22e-85	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g10686	i0	100	354.281407035176	176	0	88	0	1	176	348365	348540	Micrococcus luteus strain V017 chromosome, complete genome	blastn	70502	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16012692	16012692	PRJNA721440_S_NODE_8353_length_218_cov_5.360947_g8227_i0	PRJNA721440	8353	218	5.360947	11.68686446	Alloscardovia omnicolens	419015	Bacteria	Bacteria	69.4	1.91e-7	NTclustered	gi\|2766231342\|gb\|CP159991.1\|	419015	g8227	i0	100	0.169724770642202	37	0	17	0	1	37	623064	623100	Alloscardovia omnicolens strain AN1009 chromosome	blastn	37	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Alloscardovia	Alloscardovia omnicolens
18562007	18562007	PRJNA721440_S_NODE_9035_length_212_cov_2.055215_g8909_i0	PRJNA721440	9035	212	2.055215	4.3570558	Bacillati	1783272	Bacteria	Bacteria	93.6	8.6e-21	NR	MEN9923770.1	2900548	g8909	i0	60.3	13.7405660377358	68	27	96.2	0	208	5	173	240	MEN9923770.1 hypothetical protein [Actinomycetota bacterium]	diamond	2913	93.6	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
21112758	21112758	PRJNA721440_S_NODE_2457_length_357_cov_3.568182_g2331_i0	PRJNA721440	2457	357	3.568182	12.73840974	Corynebacterium matruchotii	43768	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g2331	i0	100	0.168067226890756	30	0	8	0	74	103	2042710	2042681	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	60	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
22871152	22871152	PRJNA721440_S_NODE_5598_length_254_cov_5.107317_g5472_i0	PRJNA721440	5598	254	5.107317	12.97258518	Micrococcus	1269	Bacteria	Bacteria	451	1.95e-122	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g5472	i0	98.814	308.952755905512	253	3	99	0	2	254	345709	345457	Micrococcus luteus strain V017 chromosome, complete genome	blastn	78474	453	0.995584988962472	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
23663197	23663197	PRJNA721440_S_NODE_20279_length_160_cov_3.099099_g20153_i0	PRJNA721440	20279	160	3.099099	4.9585584	Rothia terrae	396015	Bacteria	Bacteria	279	5.59e-71	NTclustered	gi\|1907834973\|gb\|CP061539.1\|	396015	g20153	i0	98.125	225.9375	160	3	100	0	1	160	1733456	1733297	Rothia terrae strain KJZ-14 chromosome, complete genome	blastn	36150	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
24145180	24145180	PRJNA721440_S_NODE_9259_length_210_cov_3.037267_g9133_i0	PRJNA721440	9259	210	3.037267	6.3782607	Cutibacterium	1912216	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9133	i0	100	269.252380952381	210	0	100	0	1	210	58170	58379	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	56543	388	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27209905	27209905	PRJNA721440_S_NODE_8162_length_220_cov_3.245614_g8036_i0	PRJNA721440	8162	220	3.2456140000000002	7.1403508	Jatrophihabitans sp.	1932789	Bacteria	Bacteria	43.9	0.0107	NR	HEX4729337.1	1932789	g8036	i0	44.2	0.586363636363636	43	24	58.6	0	131	3	460	502	HEX4729337.1 ComEC/Rec2 family competence protein [Jatrophihabitans sp.]	diamond	129	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Jatrophihabitantales	Jatrophihabitantaceae	Jatrophihabitans	Jatrophihabitans sp.
27368474	27368474	PRJNA721440_S_NODE_10523_length_201_cov_2.052632_g10397_i0	PRJNA721440	10523	201	2.052632	4.12579032	Actinocrispum sp. NPDC	1891916	Bacteria	Bacteria	60.8	8.6e-9	NR	WP_364762316.1	3154835	g10397	i0	57.4	3.83582089552239	61	26	91	0	199	17	409	469	WP_364762316.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Actinocrispum sp. NPDC049592]	diamond	771	60.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinocrispum	Actinocrispum sp. NPDC049592
27715855	27715855	PRJNA721440_S_NODE_13504_length_183_cov_2.619403_g13378_i0	PRJNA721440	13504	183	2.619403	4.79350749	Thermoleophilia bacterium	2026888	Bacteria	Bacteria	70.1	3.84e-12	NR	MBN1630852.1	2026888	g13378	i0	50	0.950819672131147	58	29	95.1	0	1	174	460	517	MBN1630852.1 HAD-IC family P-type ATPase [Thermoleophilia bacterium]	diamond	174	70.1	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia				Thermoleophilia bacterium
28704842	28704842	PRJNA721440_S_NODE_4727_length_272_cov_2.511211_g4601_i0	PRJNA721440	4727	272	2.511211	6.83049392	Bacteria	2	Bacteria	Bacteria	91.3	4.58e-19	NR	HEY3021937.1	2586742	g4601	i0	47.6	3.68382352941176	84	44	92.6	0	21	272	575	658	HEY3021937.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	1002	91.7	0.995637949836423	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28978567	28978567	PRJNA721440_S_NODE_13948_length_181_cov_1.856061_g13822_i0	PRJNA721440	13948	181	1.856061	3.35947041	Streptomyces chilikensis	1194079	Bacteria	Bacteria	42.7	0.0166	NR	WP_166024730.1	1194079	g13822	i0	40	0.911602209944751	55	29	87.8	2	5	163	85	137	WP_166024730.1 FUSC family protein [Streptomyces chilikensis]	diamond	165	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces chilikensis
29578087	29578087	PRJNA721440_S_NODE_9830_length_206_cov_2.363057_g9704_i0	PRJNA721440	9830	206	2.363057	4.86789742	Actinomycetota bacterium	2900548	Bacteria	Bacteria	92.8	1.85e-21	NR	MEI9907527.1	2900548	g9704	i0	58.8	5.94174757281553	68	28	99	0	3	206	93	160	MEI9907527.1 NAD(P)H-dependent oxidoreductase [Actinomycetota bacterium]	diamond	1224	92.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30051911	30051911	PRJNA721440_S_NODE_6091_length_246_cov_1.152284_g5965_i0	PRJNA721440	6091	246	1.152284	2.83461864	Actinophytocola sp.	1872138	Bacteria	Bacteria	71.2	1.11e-12	NR	WP_331979228.1	1872138	g5965	i0	65.5	1.3780487804878	55	19	67.1	0	80	244	6	60	WP_331979228.1 SDR family oxidoreductase [Actinophytocola sp.]	diamond	339	71.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinophytocola	Actinophytocola sp.
30241719	30241719	PRJNA721440_S_NODE_6652_length_238_cov_1.582011_g6526_i0	PRJNA721440	6652	238	1.582011	3.76518618	Piscicoccus intestinalis	746033	Bacteria	Bacteria	45.4	0.00361	NR	WP_068430052.1	746033	g6526	i0	48.8	0.516806722689076	41	21	51.7	0	33	155	205	245	WP_068430052.1 universal stress protein [Piscicoccus intestinalis]	diamond	123	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Piscicoccus	Piscicoccus intestinalis
30368463	30368463	PRJNA721440_S_NODE_21092_length_156_cov_2.841121_g20966_i0	PRJNA721440	21092	156	2.841121	4.43214876	Nocardioides sp.	35761	Bacteria	Bacteria	72	4.77e-13	NR	WP_324499474.1	35761	g20966	i0	64.7	0.980769230769231	51	18	98.1	0	153	1	86	136	WP_324499474.1 hypothetical protein [Nocardioides sp.]	diamond	153	72	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
30441815	30441815	PRJNA721440_S_NODE_20933_length_157_cov_2.138889_g20807_i0	PRJNA721440	20933	157	2.138889	3.35805573	Bacteria	2	Bacteria	Bacteria	52.8	3.25e-6	NR	WP_380029331.1	53362	g20807	i0	52.9	5.46496815286624	51	24	97.5	0	3	155	232	282	WP_380029331.1 amino acid adenylation domain-containing protein, partial [Dactylosporangium vinaceum]	diamond	858	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium vinaceum
30463201	30463201	PRJNA721440_S_NODE_10413_length_202_cov_1.261438_g10287_i0	PRJNA721440	10413	202	1.261438	2.54810476	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	52.8	6.24e-6	NR	WP_393627803.1	3365591	g10287	i0	44.9	1.02475247524752	69	34	99.5	3	1	201	54	120	WP_393627803.1 hypothetical protein [Streptomyces sp. NPDC048751]	diamond	207	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC048751
30683846	30683846	PRJNA721440_S_NODE_10673_length_200_cov_2.066225_g10547_i0	PRJNA721440	10673	200	2.066225	4.13245	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	61.2	8.09e-10	NR	MBX9717869.1	1873462	g10547	i0	48.3	1.485	58	30	87	0	174	1	35	92	MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium]	diamond	297	61.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
31189139	31189139	PRJNA721440_S_NODE_5135_length_263_cov_2.850467_g5009_i0	PRJNA721440	5135	263	2.850467	7.49672821	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	60.5	2.38e-8	NR	HEV7885180.1	2586742	g5009	i0	38.4	0.980988593155893	86	48	98.1	1	259	2	197	277	HEV7885180.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	258	60.5	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
31821925	31821925	PRJNA721440_S_NODE_2277_length_368_cov_5.764890_g2151_i0	PRJNA721440	2277	368	5.76489	21.2147952	Cryobacterium sp. N19	2048288	Bacteria	Bacteria	44.3	0.03	NR	WP_104088036.1	2048288	g2151	i0	31.4	0.831521739130435	102	63	77.4	3	303	19	81	182	WP_104088036.1 endonuclease III domain-containing protein [Cryobacterium sp. N19]	diamond	306	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Cryobacterium	Cryobacterium sp. N19
32339031	32339031	PRJNA721440_S_NODE_7299_length_230_cov_1.453039_g7173_i0	PRJNA721440	7299	230	1.453039	3.3419897	Bacteria	2	Bacteria	Bacteria	82.8	4.52e-17	NR	MBS31570.1	2024894	g7173	i0	59.2	11.895652173913	76	24	99.1	2	229	2	62	130	MBS31570.1 hypothetical protein [Acidimicrobiaceae bacterium]	diamond	2736	83.6	0.990430622009569	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		Acidimicrobiaceae bacterium
32675642	32675642	PRJNA721440_S_NODE_16140_length_172_cov_0.926829_g16014_i0	PRJNA721440	16140	172	0.926829	1.59414588	Streptomyces sp. b94	1827634	Bacteria	Bacteria	75.1	5.65e-14	NR	WP_210962443.1	1827634	g16014	i0	62.1	4.04651162790698	58	21	99.4	1	171	1	788	845	WP_210962443.1 amino acid adenylation domain-containing protein [Streptomyces sp. b94]	diamond	696	75.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. b94
32707251	32707251	PRJNA721440_S_NODE_15860_length_173_cov_0.991935_g15734_i0	PRJNA721440	15860	173	0.991935	1.71604755	Cellulomonas endophytica	2494735	Bacteria	Bacteria	41.2	0.0255	NR	WP_129337206.1	2494735	g15734	i0	39.6	0.919075144508671	53	27	90.2	2	11	166	77	125	WP_129337206.1 hypothetical protein [Cellulomonas endophytica]	diamond	159	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas endophytica
32896099	32896099	PRJNA721440_S_NODE_6080_length_246_cov_1.847716_g5954_i0	PRJNA721440	6080	246	1.847716	4.54538136	Streptomyces sp. ACA25	3022596	Bacteria	Bacteria	63.2	2.45e-9	NR	WP_271683730.1	3022596	g5954	i0	42.1	0.926829268292683	76	42	92.7	1	19	246	210	283	WP_271683730.1 diaminopimelate decarboxylase [Streptomyces sp. ACA25]	diamond	228	63.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. ACA25

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