metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
1657850	1657850	PRJNA315399_P_NODE_416902_length_160_cov_1.357724_g416454_i0	PRJNA315399	416902	160	1.357724	2.1723584	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	250	4.38e-62	NTclustered	gi\|2187152066\|emb\|OV788644.1\|	658143	g416454	i0	99.275	1.04375	138	1	86	0	15	152	738822	738685	uncultured Tenericutes bacterium isolate min17_bin35 genome assembly, chromosome: 1	blastn	167	250	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
8034459	8034459	PRJNA315399_P_NODE_110187_length_197_cov_7.050000_g109739_i0	PRJNA315399	110187	197	7.05	13.8885	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2907625690\|emb\|OZ223250.1\|	1898209	g109739	i0	100	0.142131979695431	28	0	14	0	13	40	1478206	1478179	MAG: Acholeplasmataceae bacterium isolate c289da16-4743-485f-819d-17f5771af8e7 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
8037627	8037627	PRJNA315399_S_NODE_131387_length_166_cov_4.829457_g131186_i0	PRJNA315399	131387	166	4.829457	8.01689862	Metamycoplasma buccale	55602	Bacteria	Bacteria	111	2.26e-20	NTclustered	gi\|2890643647\|gb\|CP177249.1\|	55602	g131186	i0	83.065	2.62650602409639	124	20	75	1	9	132	521935	521813	Metamycoplasma buccale strain CH20247 chromosome, complete genome	blastn	436	111	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma buccale
10587306	10587306	PRJNA315399_P_NODE_477849_length_153_cov_4.275862_g477401_i0	PRJNA315399	477849	153	4.275862	6.54206886	Spiroplasma ixodetis	2141	Bacteria	Bacteria	228	1.9399999999999995e-55	NTclustered	gi\|2721114795\|dbj\|AP028955.1\|	2141	g477401	i0	97.059	440.183006535948	136	3	89	1	7	142	463237	463371	Spiroplasma ixodetis sAp269 DNA, complete genome	blastn	67348	228	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
11269408	11269408	PRJNA315399_P_NODE_465289_length_154_cov_7.487179_g464841_i0	PRJNA315399	465289	154	7.487179	11.53025566	Ureaplasma	2129	Bacteria	Bacteria	180	5.56e-41	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g464841	i0	89.032	10.9545454545455	155	3	92	1	14	154	551647	551493	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	1687	180	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
13136099	13136099	PRJNA315399_P_NODE_295371_length_179_cov_3.119718_g294923_i0	PRJNA315399	295371	179	3.119718	5.58429522	Spiroplasma endosymbiont of Andrena trimmerana	3066316	Bacteria	Bacteria	130	6.81e-26	NTclustered	gi\|2706542393\|emb\|OZ026455.1\|	3066316	g294923	i0	98.63	97.4469273743017	73	1	79	0	13	85	211686	211758	Spiroplasma endosymbiont of Andrena trimmerana isolate 54785 genome assembly, chromosome: 1	blastn	17443	130	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Andrena trimmerana
13137284	13137284	PRJNA315399_P_NODE_487631_length_152_cov_4.739130_g487183_i0	PRJNA315399	487631	152	4.73913	7.2034776	Mycoplasmopsis edwardii	53558	Bacteria	Bacteria	135	1.2e-27	NTclustered	gi\|2425261263\|gb\|CP114370.1\|	53558	g487183	i0	84.892	3.19736842105263	139	16	89	3	6	140	127024	127161	Mycoplasmopsis edwardii strain felid995 chromosome, complete genome	blastn	486	135	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis edwardii
14414113	14414113	PRJNA315399_S_NODE_35092_length_237_cov_3.265000_g34891_i0	PRJNA315399	35092	237	3.265	7.73805	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1951496305\|gb\|CP058499.1\|	28903	g34891	i0	100	0.244725738396624	29	0	24	0	2	30	208183	208211	Mycoplasmopsis bovis strain Mb174 chromosome	blastn	58	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
16958531	16958531	PRJNA315399_P_NODE_101274_length_201_cov_2.676829_g100826_i0	PRJNA315399	101274	201	2.676829	5.38042629	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g100826	i0	100	0.144278606965174	29	0	14	0	168	196	510819	510847	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
16959133	16959133	PRJNA315399_P_NODE_191294_length_185_cov_6.452703_g190846_i0	PRJNA315399	191294	185	6.452703	11.93750055	Metamycoplasma faucium	56142	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g190846	i0	100	0.313513513513514	29	0	16	0	18	46	61933	61961	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
17643163	17643163	PRJNA315399_P_NODE_150034_length_189_cov_2.690789_g149586_i0	PRJNA315399	150034	189	2.690789	5.08559121	Ureaplasma	2129	Bacteria	Bacteria	228	2.5099999999999996e-55	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g149586	i0	91.772	9.1957671957672	158	7	84	2	24	181	348593	348442	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	1738	228	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
17643169	17643169	PRJNA315399_P_NODE_151634_length_188_cov_14.940397_g151186_i0	PRJNA315399	151634	188	14.940397	28.08794636	Ureaplasma	2129	Bacteria	Bacteria	141	3.34e-29	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g151186	i0	100	10.8510638297872	76	0	80	0	98	173	99520	99445	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	2040	141	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
18917635	18917635	PRJNA315399_P_NODE_455875_length_155_cov_7.788136_g455427_i0	PRJNA315399	455875	155	7.788136	12.0716108	Bacteria	2	Bacteria	Bacteria	100	4.49e-17	NTclustered	gi\|1403529253\|emb\|LS483439.1\|	2148	g455427	i0	93.939	41.5935483870968	66	4	43	0	9	74	74235	74170	Acholeplasma laidlawii strain NCTC10116 genome assembly, chromosome: 1	blastn	6447	100	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma laidlawii
19507644	19507644	PRJNA315399_P_NODE_179356_length_186_cov_4.859060_g178908_i0	PRJNA315399	179356	186	4.85906	9.0378516	Candidatus Hepatoplasma crinochetorum	295596	Bacteria	Bacteria	215	1.92e-51	NTclustered	gi\|2416256950\|dbj\|AP027132.1\|	295596	g178908	i0	86.42	2.08064516129032	162	21	87	1	12	172	380729	380568	MAG: Candidatus Hepatoplasma crinochetorum Tokyo2021 DNA, complete genome	blastn	387	215	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma crinochetorum
19511211	19511211	PRJNA315399_S_NODE_37916_length_232_cov_2.610256_g37715_i0	PRJNA315399	37916	232	2.610256	6.05579392	Mycoplasma mycoides	2102	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2040375687\|gb\|CP065584.1\|	40477	g37715	i0	100	0.120689655172414	28	0	12	0	178	205	31319	31346	Mycoplasma mycoides subsp. capri strain 7730 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
22061434	22061434	PRJNA315399_S_NODE_24898_length_262_cov_4.444444_g24697_i0	PRJNA315399	24898	262	4.444444	11.64444328	Palm lethal yellowing phytoplasma	39646	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|213389864\|gb\|FJ416453.1\|	39646	g24697	i0	92.308	0.148854961832061	39	2	15	1	163	201	1552	1515	Palm lethal yellowing phytoplasma strain LYSS putative CTP synthase gene, partial cds; and putative membrane protein, putative DNA replication initiation protein, putative ribonuclease III, putative fatty acid/phospholipid biosynthesis enzyme, putative ATP-dependent DNA helicase, putative asparaginyl tRNA synthetase, ABC-type maltose/maltodextrin transport system, ATP-binding protein, ABC-type maltose transport system, permease component, ABC-type maltose transport system, permease protein, sugar-binding periplasmic protein, exopolyphosphatase-related protein, tRNA modification GTPase, and threonyl tRNA synthetase genes, complete cds	blastn	39	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Palm lethal yellowing phytoplasma
23334290	23334290	PRJNA315399_P_NODE_275399_length_180_cov_3.419580_g274951_i0	PRJNA315399	275399	180	3.41958	6.155244	Candidatus Hepatoplasma scabrum	3132033	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2416257524\|dbj\|AP027133.1\|	3132033	g274951	i0	100	0.155555555555556	28	0	16	0	9	36	584581	584608	MAG: Candidatus Hepatoplasma scabrum Ps-JP DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma scabrum
24608764	24608764	PRJNA315399_P_NODE_334080_length_174_cov_3.277372_g333632_i0	PRJNA315399	334080	174	3.277372	5.70262728	Mycoplasmopsis cynos	171284	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2639807123\|gb\|CP141042.1\|	171284	g333632	i0	94.444	0.586206896551724	36	2	21	0	5	40	946204	946169	Mycoplasmopsis cynos strain 80950 chromosome	blastn	102	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis cynos
24608986	24608986	PRJNA315399_P_NODE_367620_length_166_cov_2.131783_g367172_i0	PRJNA315399	367620	166	2.131783	3.53875978	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2047331642\|gb\|CP076021.1\|	2231116	g367172	i0	96.875	0.192771084337349	32	0	19	1	135	166	515618	515588	Tenericutes bacterium strain zrk7 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium

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