metadata: contig_metadata: 26 rows where bioproject = "PRJNA1072736" and tax

26 rows where bioproject = "PRJNA1072736" and tax_phylum = "Mycoplasmatota"

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
186974	186974	PRJNA1072736_S_NODE_7761_length_150_cov_0.878505_g7756_i0	PRJNA1072736	7761	150	0.878505	1.3177575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	8.92e-44	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7756	i0	89.333	1	150	16	100	0	1	150	423319	423170	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1461535	1461535	PRJNA1072736_S_NODE_2202_length_235_cov_1.317708_g2197_i0	PRJNA1072736	2202	235	1.317708	3.0966138	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	1.14e-74	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2197	i0	89.655	0.987234042553191	232	21	97	3	1	229	141303	141534	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	232	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737516	2737516	PRJNA1072736_S_NODE_1443_length_270_cov_2.140969_g1438_i0	PRJNA1072736	1443	270	2.140969	5.7806163	Mycoplasma wenyonii	65123	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1438	i0	99.63	34.262962962963	270	1	100	0	1	270	605006	604737	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	9251	494	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737519	2737519	PRJNA1072736_S_NODE_4063_length_189_cov_1.883562_g4058_i0	PRJNA1072736	4063	189	1.883562	3.55993218	Mycoplasma wenyonii	65123	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4058	i0	98.413	1	189	3	100	0	1	189	577516	577328	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	189	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013404	4013404	PRJNA1072736_S_NODE_1024_length_303_cov_2.192308_g1019_i0	PRJNA1072736	1024	303	2.192308	6.64269324	Mycoplasma wenyonii	65123	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1019	i0	98.333	2.03630363036304	300	5	99	0	4	303	549161	548862	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	617	527	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013409	4013409	PRJNA1072736_S_NODE_964_length_309_cov_1.334586_g959_i0	PRJNA1072736	964	309	1.334586	4.12387074	Mycoplasma wenyonii	65123	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g959	i0	98.701	0.996763754045307	308	4	99	0	1	308	86481	86174	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	308	547	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289738	5289738	PRJNA1072736_S_NODE_1585_length_262_cov_2.429224_g1580_i0	PRJNA1072736	1585	262	2.429224	6.36456688	Mycoplasma wenyonii	65123	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1580	i0	96.212	1.00763358778626	264	6	100	3	1	262	441576	441315	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	264	429	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289739	5289739	PRJNA1072736_S_NODE_2465_length_226_cov_1.284153_g2460_i0	PRJNA1072736	2465	226	1.284153	2.90218578	Mycoplasma wenyonii	65123	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2460	i0	100	2.88053097345133	226	0	100	0	1	226	381015	380790	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	651	418	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16763878	16763878	PRJNA1072736_S_NODE_3014_length_210_cov_1.970060_g3009_i0	PRJNA1072736	3014	210	1.97006	4.137126	Mycoplasma wenyonii	65123	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3009	i0	97.143	1	210	6	100	0	1	210	304110	303901	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	355	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19312639	19312639	PRJNA1072736_S_NODE_3596_length_197_cov_1.272727_g3591_i0	PRJNA1072736	3596	197	1.272727	2.50727219	Mycoplasma wenyonii	65123	Bacteria	Bacteria	320	4.24e-83	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3591	i0	95.96	1.00507614213198	198	7	100	1	1	197	144696	144499	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	198	320	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863821	21863821	PRJNA1072736_S_NODE_4378_length_184_cov_1.375887_g4373_i0	PRJNA1072736	4378	184	1.375887	2.53163208	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	3.869999999999999e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4373	i0	100	0.989130434782609	182	0	99	0	1	182	498163	498344	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	182	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863824	21863824	PRJNA1072736_S_NODE_5058_length_175_cov_1.424242_g5053_i0	PRJNA1072736	5058	175	1.424242	2.4924235	Mycoplasma wenyonii	65123	Bacteria	Bacteria	287	3.71e-73	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5053	i0	96.552	0.994285714285714	174	4	99	2	3	175	413486	413314	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	174	287	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23139283	23139283	PRJNA1072736_S_NODE_2599_length_222_cov_1.402235_g2594_i0	PRJNA1072736	2599	222	1.402235	3.1129617	Mycoplasma ovis	171632	Bacteria	Bacteria	178	3.11e-40	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g2594	i0	81.25	1.00900900900901	224	38	100	4	1	222	436868	436647	Mycoplasma ovis str. Michigan, complete genome	blastn	224	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
26940734	26940734	PRJNA1072736_S_NODE_6002_length_164_cov_2.429752_g5997_i0	PRJNA1072736	6002	164	2.429752	3.98479328	Mycoplasma wenyonii	65123	Bacteria	Bacteria	50.4	2.23e-5	NR	WP_112665659.1	65123	g5997	i0	88	0.457317073170732	25	3	45.7	0	75	1	6	30	WP_112665659.1 phosphate ABC transporter ATP-binding protein [Mycoplasma wenyonii]	diamond	75	50.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27130182	27130182	PRJNA1072736_S_NODE_5682_length_168_cov_1.048000_g5677_i0	PRJNA1072736	5682	168	1.048	1.76064	Mycoplasma wenyonii	65123	Bacteria	Bacteria	93.6	8.139999999999999e-23	NR	WP_112665651.1	65123	g5677	i0	90.6	1.89285714285714	53	5	94.6	0	168	10	78	130	WP_112665651.1 50S ribosomal protein L19 [Mycoplasma wenyonii]	diamond	318	93.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27951862	27951862	PRJNA1072736_S_NODE_2225_length_234_cov_1.230366_g2220_i0	PRJNA1072736	2225	234	1.230366	2.87905644	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	83.6	2.13e-18	NR	WP_187150565.1	432608	g2220	i0	90.7	0.551282051282051	43	4	55.1	0	130	2	76	118	WP_187150565.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	129	83.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28046473	28046473	PRJNA1072736_S_NODE_2325_length_230_cov_1.508021_g2320_i0	PRJNA1072736	2325	230	1.508021	3.4684483	Mycoplasma wenyonii	65123	Bacteria	Bacteria	78.2	1.04e-14	NR	WP_112664956.1	65123	g2320	i0	94.7	0.495652173913044	38	2	49.6	0	173	60	805	842	WP_112664956.1 DUF3713 domain-containing protein [Mycoplasma wenyonii]	diamond	114	78.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28109525	28109525	PRJNA1072736_S_NODE_3745_length_194_cov_2.172185_g3740_i0	PRJNA1072736	3745	194	2.172185	4.2140389	Mycoplasma wenyonii	65123	Bacteria	Bacteria	103	2.75e-24	NR	WP_014850035.1	65123	g3740	i0	86.9	0.943298969072165	61	8	94.3	0	194	12	316	376	WP_014850035.1 HD domain-containing protein [Mycoplasma wenyonii]	diamond	183	103	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28583456	28583456	PRJNA1072736_S_NODE_6127_length_163_cov_1.425000_g6122_i0	PRJNA1072736	6127	163	1.425	2.32275	Mycoplasma wenyonii	65123	Bacteria	Bacteria	58.2	4.62e-8	NR	WP_014850166.1	65123	g6122	i0	100	0.533742331288344	29	0	53.4	0	2	88	748	776	WP_014850166.1 ATP-dependent zinc metalloprotease FtsH [Mycoplasma wenyonii]	diamond	87	58.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28835826	28835826	PRJNA1072736_S_NODE_6788_length_157_cov_1.552632_g6783_i0	PRJNA1072736	6788	157	1.552632	2.43763224	Mycoplasma wenyonii	65123	Bacteria	Bacteria	46.2	6.93e-4	NR	WP_014849543.1	65123	g6783	i0	53.1	0.611464968152866	32	15	61.1	0	111	16	153	184	WP_014849543.1 hypothetical protein [Mycoplasma wenyonii]	diamond	96	46.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30098839	30098839	PRJNA1072736_S_NODE_3632_length_196_cov_2.921569_g3627_i0	PRJNA1072736	3632	196	2.921569	5.72627524	Mycoplasma wenyonii	65123	Bacteria	Bacteria	110	1.72e-26	NR	WP_112665726.1	65123	g3627	i0	90.3	0.948979591836735	62	6	94.9	0	196	11	37	98	WP_112665726.1 spermidine/putrescine ABC transporter substrate-binding protein, partial [Mycoplasma wenyonii]	diamond	186	110	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30257316	30257316	PRJNA1072736_S_NODE_6572_length_159_cov_1.206897_g6567_i0	PRJNA1072736	6572	159	1.206897	1.91896623	Mycoplasma wenyonii	65123	Bacteria	Bacteria	99.8	9.85e-23	NR	WP_112665098.1	65123	g6567	i0	92.3	0.981132075471698	52	4	98.1	0	3	158	670	721	WP_112665098.1 ATP-dependent helicase [Mycoplasma wenyonii]	diamond	156	99.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30667686	30667686	PRJNA1072736_S_NODE_1753_length_254_cov_1.360190_g1748_i0	PRJNA1072736	1753	254	1.36019	3.4548826	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	99.4	5.969999999999999e-23	NR	WP_187149913.1	432608	g1748	i0	97.9	0.566929133858268	48	1	56.7	0	144	1	163	210	WP_187149913.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	144	99.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
31710904	31710904	PRJNA1072736_S_NODE_2037_length_242_cov_1.653266_g2032_i0	PRJNA1072736	2037	242	1.653266	4.00090372	Mycoplasma wenyonii	65123	Bacteria	Bacteria	139	1.15e-39	NR	WP_112665708.1	65123	g2032	i0	92	0.929752066115702	75	6	93	0	242	18	91	165	WP_112665708.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii]	diamond	225	139	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32058840	32058840	PRJNA1072736_S_NODE_4518_length_182_cov_1.352518_g4513_i0	PRJNA1072736	4518	182	1.352518	2.46158276	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	93.6	7.76e-21	NR	WP_187149882.1	432608	g4513	i0	87.9	0.956043956043956	58	7	95.6	0	174	1	90	147	WP_187149882.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	174	93.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
32533703	32533703	PRJNA1072736_S_NODE_5819_length_166_cov_3.130081_g5814_i0	PRJNA1072736	5819	166	3.130081	5.19593446	Mycoplasma wenyonii	65123	Bacteria	Bacteria	44.7	0.00208	NR	WP_112665927.1	65123	g5814	i0	44.4	0.975903614457831	54	24	86.7	2	164	21	22	75	WP_112665927.1 hypothetical protein [Mycoplasma wenyonii]	diamond	162	44.7	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);;