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

32 rows where bioproject = "PRJNA1168532" and tax_kingdom = "Bacillati"

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
1040232	1040232	PRJNA1168532_S_NODE_226421_length_203_cov_1.762500_g223478_i0	PRJNA1168532	226421	203	1.7625	3.577875	root	1	Root_unresolved	Root_unresolved	375	9.24e-100	NTclustered	gi\|2497259144\|gb\|OQ874907.1\|	1306	g223478	i0	100	100	203	0	100	0	1	203	498	296	Streptococcus sp. strain QT-53 16S ribosomal RNA gene, partial sequence	blastn	20300	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
1589845	1589845	PRJNA1168532_S_NODE_219762_length_207_cov_1.310976_g216819_i0	PRJNA1168532	219762	207	1.310976	2.71372032	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	355	1.23e-93	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g216819	i0	97.585	325.729468599034	207	5	100	0	1	207	552129	551923	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	67426	355	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
5418256	5418256	PRJNA1168532_S_NODE_256445_length_187_cov_1.437500_g253502_i0	PRJNA1168532	256445	187	1.4375	2.688125	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	62.1	2.66e-5	NTclustered	gi\|530190787\|emb\|HG379975.1\|	152507	g253502	i0	93.182	0.235294117647059	44	0	22	3	114	154	68	25	Uncultured actinobacterium partial 16S rRNA gene, clone ET3Rk82	blastn	44	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
5418264	5418264	PRJNA1168532_S_NODE_295985_length_170_cov_1.645669_g293042_i0	PRJNA1168532	295985	170	1.645669	2.7976373	Staphylococcus auricularis	29379	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g293042	i0	100	495.6	170	0	100	0	1	170	1486561	1486730	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	84252	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
5418288	5418288	PRJNA1168532_S_NODE_9285_length_801_cov_2.121372_g7745_i0	PRJNA1168532	9285	801	2.121372	16.99218972	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	143	2.87e-39	NR	POH17992.1	1625	g7745	i0	60.3	0.49063670411985	131	52	49.1	0	102	494	1	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	393	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
6143095	6143095	PRJNA1168532_S_NODE_221685_length_206_cov_1.159509_g218742_i0	PRJNA1168532	221685	206	1.159509	2.38858854	root	1	Root_unresolved	Root_unresolved	241	3.5800000000000007e-59	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g218742	i0	100	69.8155339805825	130	0	100	0	1	130	1185	1314	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	14382	241	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7418092	7418092	PRJNA1168532_S_NODE_242326_length_194_cov_2.337748_g239383_i0	PRJNA1168532	242326	194	2.337748	4.53523112	Streptococcus	1301	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g239383	i0	99.485	428.329896907216	194	1	100	0	1	194	424105	424298	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	83096	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
7968502	7968502	PRJNA1168532_S_NODE_318607_length_162_cov_1.579832_g315664_i0	PRJNA1168532	318607	162	1.579832	2.55932784	Mycoplasma wenyonii	65123	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g315664	i0	100	1	162	0	100	0	1	162	447386	447225	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	162	300	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
8693201	8693201	PRJNA1168532_S_NODE_288207_length_173_cov_1.446154_g285264_i0	PRJNA1168532	288207	173	1.446154	2.50184642	root	1	Root_unresolved	Root_unresolved	309	7.81e-80	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g285264	i0	98.844	97.9479768786127	173	2	100	0	1	173	259	87	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	16945	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8693203	8693203	PRJNA1168532_S_NODE_5047_length_1001_cov_3.054280_g4069_i0	PRJNA1168532	5047	1001	3.05428	30.5733428	Cutibacterium	1912216	Bacteria	Bacteria	1844	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4069	i0	99.9	254.448551448551	1001	1	100	0	1	1001	55515	56515	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	254703	1844	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9968382	9968382	PRJNA1168532_S_NODE_347308_length_153_cov_1.572727_g344365_i0	PRJNA1168532	347308	153	1.572727	2.40627231	Corynebacterium	1716	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g344365	i0	100	368	153	0	100	0	1	153	2492766	2492918	Corynebacterium accolens strain CA3 chromosome	blastn	56304	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
11243535	11243535	PRJNA1168532_S_NODE_250889_length_190_cov_1.102041_g247946_i0	PRJNA1168532	250889	190	1.102041	2.0938779	Staphylococcus	1279	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g247946	i0	100	84.2473684210526	190	0	100	0	1	190	2002019	2001830	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	16007	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
11793795	11793795	PRJNA1168532_S_NODE_288550_length_173_cov_1.261538_g285607_i0	PRJNA1168532	288550	173	1.261538	2.18246074	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g285607	i0	100	355.71676300578	173	0	100	0	1	173	1846	1674	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	61539	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
12518935	12518935	PRJNA1168532_S_NODE_206770_length_215_cov_1.308140_g203827_i0	PRJNA1168532	206770	215	1.30814	2.812501	Micrococcus	1269	Bacteria	Bacteria	350	5.999999999999999e-92	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g203827	i0	96.244	312.158139534884	213	8	99	0	1	213	347478	347266	Micrococcus luteus strain V017 chromosome, complete genome	blastn	67114	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16342763	16342763	PRJNA1168532_S_NODE_55373_length_409_cov_1.568306_g52501_i0	PRJNA1168532	55373	409	1.568306	6.41437154	Bacillati	1783272	Bacteria	Bacteria	715	0	NTclustered	gi\|9623518\|gb\|AF269622.1\|AF269622	1282	g52501	i0	98.997	505.672371638142	399	4	98	0	11	409	3766	3368	Staphylococcus epidermidis strain SR1 clone step.1014c03 genomic sequence	blastn	206820	715	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20166586	20166586	PRJNA1168532_S_NODE_110356_length_306_cov_1.844106_g107413_i0	PRJNA1168532	110356	306	1.844106	5.64296436	Corynebacterium	1716	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g107413	i0	99.346	339.052287581699	306	2	100	0	1	306	2773	3078	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	103750	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
20166591	20166591	PRJNA1168532_S_NODE_226536_length_203_cov_1.625000_g223593_i0	PRJNA1168532	226536	203	1.625	3.29875	Staphylococcus	1279	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g223593	i0	100	545.768472906404	203	0	100	0	1	203	699770	699972	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	110791	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20716532	20716532	PRJNA1168532_S_NODE_254117_length_188_cov_1.620690_g251174_i0	PRJNA1168532	254117	188	1.62069	3.0468972	Mycoplasma ovis	171632	Bacteria	Bacteria	187	4.2299999999999985e-43	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g251174	i0	84.574	1	188	29	100	0	1	188	59113	59300	Mycoplasma ovis str. Michigan, complete genome	blastn	188	187	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
22717158	22717158	PRJNA1168532_S_NODE_210058_length_213_cov_1.176471_g207115_i0	PRJNA1168532	210058	213	1.176471	2.50588323	Corynebacterium	1716	Bacteria	Bacteria	344	2.76e-90	NTclustered	gi\|2869858840\|gb\|CP175793.1\|	3383589	g207115	i0	100	319.201877934272	186	0	87	0	1	186	723712	723527	Corynebacterium sp. YSMAA1_1_D6 chromosome, complete genome	blastn	67990	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_D6
26597009	26597009	PRJNA1168532_S_NODE_264961_length_183_cov_1.307143_g262018_i0	PRJNA1168532	264961	183	1.307143	2.39207169	Mycoplasma wenyonii	65123	Bacteria	Bacteria	51.2	6.9e-6	NR	WP_112665915.1	65123	g262018	i0	47.9	0.786885245901639	48	9	78.7	1	3	146	58	89	WP_112665915.1 hypothetical protein [Mycoplasma wenyonii]	diamond	144	51.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28146170	28146170	PRJNA1168532_S_NODE_232565_length_200_cov_0.885350_g229622_i0	PRJNA1168532	232565	200	0.88535	1.7707	Staphylococcus aureus	1280	Bacteria	Bacteria	54.7	1.26e-6	NR	QHG80002.1	1280	g229622	i0	50	1.02	68	28	99	3	198	1	297	360	QHG80002.1 hypothetical protein D7B62_12520 [Staphylococcus aureus]	diamond	204	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28146171	28146171	PRJNA1168532_S_NODE_348325_length_153_cov_1.281818_g345382_i0	PRJNA1168532	348325	153	1.281818	1.96118154	Mycoplasma wenyonii	65123	Bacteria	Bacteria	63.5	5.07e-10	NR	WP_112665000.1	65123	g345382	i0	100	0.647058823529412	33	0	64.7	0	99	1	529	561	WP_112665000.1 CHC2 zinc finger domain-containing protein [Mycoplasma wenyonii]	diamond	99	63.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28682903	28682903	PRJNA1168532_S_NODE_230747_length_201_cov_0.892405_g227804_i0	PRJNA1168532	230747	201	0.892405	1.79373405	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	105	1.24e-26	NR	WP_187149852.1	432608	g227804	i0	100	0.82089552238806	55	0	82.1	0	192	28	1	55	WP_187149852.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	165	105	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
29377334	29377334	PRJNA1168532_S_NODE_275489_length_178_cov_1.740741_g272546_i0	PRJNA1168532	275489	178	1.740741	3.09851898	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	44.7	0.00316	NR	WP_187150753.1	432608	g272546	i0	58.1	0.72471910112359506	43	18	72.5	0	48	176	4	46	WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	129	44.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
30040527	30040527	PRJNA1168532_S_NODE_243411_length_194_cov_1.205298_g240468_i0	PRJNA1168532	243411	194	1.205298	2.33827812	Mycoplasma ovis	171632	Bacteria	Bacteria	88.6	1.3e-18	NR	WP_327084515.1	171632	g240468	i0	81.8	2.55154639175258	55	10	85.1	0	3	167	271	325	WP_327084515.1 methionine--tRNA ligase [Mycoplasma ovis]	diamond	495	88.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
30166730	30166730	PRJNA1168532_S_NODE_337692_length_156_cov_1.415929_g334749_i0	PRJNA1168532	337692	156	1.415929	2.20884924	Mycoplasma wenyonii	65123	Bacteria	Bacteria	92	4.49e-20	NR	WP_112665841.1	65123	g334749	i0	81.8	1.05769230769231	55	7	100	1	156	1	223	277	WP_112665841.1 MIP family Ig-specific serine endopeptidase [Mycoplasma wenyonii]	diamond	165	92	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30293670	30293670	PRJNA1168532_S_NODE_232152_length_200_cov_1.331210_g229209_i0	PRJNA1168532	232152	200	1.33121	2.66242	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	44.7	0.00434	NR	WP_187150745.1	432608	g229209	i0	71.4	0.9	28	7	40.5	1	14	94	332	359	WP_187150745.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	180	44.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
30735561	30735561	PRJNA1168532_S_NODE_174514_length_238_cov_1.266667_g171571_i0	PRJNA1168532	174514	238	1.266667	3.01466746	Mycoplasma wenyonii	65123	Bacteria	Bacteria	146	4.22e-44	NR	WP_110555200.1	65123	g171571	i0	97.3	0.920168067226891	73	2	92	0	237	19	4	76	WP_110555200.1 50S ribosomal protein L31 [Mycoplasma wenyonii]	diamond	219	146	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30735562	30735562	PRJNA1168532_S_NODE_84734_length_345_cov_2.453642_g81791_i0	PRJNA1168532	84734	345	2.453642	8.4650649	Cutibacterium acnes	1747	Bacteria	Bacteria	54.3	9.04e-6	NR	MES6376112.1	1747	g81791	i0	46.6	0.504347826086956	58	29	48.7	1	134	301	258	315	MES6376112.1 reverse transcriptase family protein [Cutibacterium acnes]	diamond	174	54.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
31494359	31494359	PRJNA1168532_S_NODE_208496_length_214_cov_1.099415_g205553_i0	PRJNA1168532	208496	214	1.099415	2.3527481	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	120	5.1e-32	NR	WP_187149669.1	432608	g205553	i0	100	0.883177570093458	63	0	88.3	0	191	3	133	195	WP_187149669.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	189	120	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
31652180	31652180	PRJNA1168532_S_NODE_311017_length_165_cov_1.155738_g308074_i0	PRJNA1168532	311017	165	1.155738	1.9069677	Mycoplasma wenyonii	65123	Bacteria	Bacteria	72.4	4.56e-13	NR	WP_014849924.1	65123	g308074	i0	80.5	0.745454545454545	41	8	74.5	0	123	1	361	401	WP_014849924.1 glutamine-hydrolyzing GMP synthase [Mycoplasma wenyonii]	diamond	123	72.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32884596	32884596	PRJNA1168532_S_NODE_360480_length_150_cov_1.317757_g357537_i0	PRJNA1168532	360480	150	1.317757	1.9766355	Mycoplasma wenyonii	65123	Bacteria	Bacteria	71.6	5.29e-13	NR	WP_112665748.1	65123	g357537	i0	75.6	0.82	41	10	82	0	3	125	1	41	WP_112665748.1 hypothetical protein [Mycoplasma wenyonii]	diamond	123	71.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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