metadata: contig_metadata: 16 rows where bioproject = "PRJNA814235", tax_phylum = "Mycoplasmatota" and tax

16 rows where bioproject = "PRJNA814235", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

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
3369638	3369638	PRJNA814235_P_NODE_89123_length_203_cov_3.644578_g87728_i0	PRJNA814235	89123	203	3.644578	7.39849334	Metamycoplasma faucium	56142	Bacteria	Bacteria	130	7.94e-26	NTclustered	gi\|2921905358\|gb\|CP182786.1\|	56142	g87728	i0	97.368	1.49753694581281	76	2	75	0	1	76	515367	515442	Metamycoplasma faucium strain DC-333 chromosome, complete genome	blastn	304	130	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
7195351	7195351	PRJNA814235_P_NODE_198186_length_150_cov_3.575221_g196791_i0	PRJNA814235	198186	150	3.575221	5.3628315	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	87.9	3.35e-13	NTclustered	gi\|2621705280\|emb\|OY763415.1\|	1898209	g196791	i0	87.013	0.513333333333333	77	10	51	0	74	150	1692304	1692228	MAG: Acholeplasmataceae bacterium isolate 742012ca-395f-4069-aabb-f3199e209540 genome assembly, chromosome: 1	blastn	77	87.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
13981559	13981559	PRJNA814235_P_NODE_89631_length_203_cov_3.500000_g88236_i0	PRJNA814235	89631	203	3.5	7.105	Candidatus Izemoplasma	2975549	Bacteria	Bacteria	80.5	8.12e-11	NTclustered	gi\|685629397\|gb\|CP009415.1\|	1541959	g88236	i0	88.06	7.24137931034483	67	8	33	0	131	197	920299	920233	Candidatus Izimaplasma bacterium HR1 chromosome, complete genome	blastn	1470	80.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izimoplasma sp. HR1
14845136	14845136	PRJNA814235_P_NODE_194572_length_151_cov_2.438596_g193177_i0	PRJNA814235	194572	151	2.438596	3.68227996	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	99	1.56e-16	NTclustered	gi\|2621784632\|emb\|OY781090.1\|	1898209	g193177	i0	95.161	0.410596026490066	62	3	41	0	76	137	369191	369130	MAG: Acholeplasmataceae bacterium isolate ac846720-52a4-4ed8-8e7a-77cd78ec885f genome assembly, chromosome: 1	blastn	62	99	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
14846041	14846041	PRJNA814235_P_NODE_53752_length_260_cov_1.600897_g52358_i0	PRJNA814235	53752	260	1.600897	4.1623322	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1060099568\|gb\|KX687008.1\|	28903	g52358	i0	79.762	0.323076923076923	84	9	31	5	68	147	5077	4998	Mycoplasmopsis bovis strain 422 HAD-superfamily hydrolase gene, partial cds; histidine acid phosphatase family protein gene, complete cds; insertion sequence ISMbov1, 16S ribosomal RNA (rrs1), 23S ribosomal RNA (rrl1), 16S ribosomal RNA (rrs2), and 23S ribosomal RNA (rrl2) genes, complete sequence; and preprotein translocase subunit SecY (secY) gene, partial cds	blastn	84	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
21627528	21627528	PRJNA814235_P_NODE_111137_length_203_cov_2.042169_g109742_i0	PRJNA814235	111137	203	2.042169	4.14560307	Mycoplasmopsis	2767358	Bacteria	Bacteria	141	3.67e-29	NTclustered	gi\|2111402438\|gb\|CP068733.1\|	28903	g109742	i0	100	74.5024630541872	76	0	75	0	1	76	482283	482208	Mycoplasmopsis bovis strain J81 chromosome, complete genome	blastn	15124	141	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
22495720	22495720	PRJNA814235_P_NODE_98638_length_203_cov_2.518072_g97243_i0	PRJNA814235	98638	203	2.518072	5.11168616	Mycoplasmatota bacterium WC30	3075149	Bacteria	Bacteria	84.2	6.27e-12	NTclustered	gi\|2877983046\|gb\|CP134495.1\|	3075149	g97243	i0	87.5	0.733990147783251	72	9	35	0	1	72	505643	505714	Mycoplasmatota bacterium WC30 chromosome, complete genome	blastn	149	84.2	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium WC30
23771228	23771228	PRJNA814235_P_NODE_90959_length_203_cov_3.228916_g89564_i0	PRJNA814235	90959	203	3.228916	6.55469948	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	89.8	1.35e-13	NTclustered	gi\|2621786365\|emb\|OY782823.1\|	1898209	g89564	i0	88.889	1.05418719211823	72	8	35	0	132	203	1073166	1073237	MAG: Acholeplasmataceae bacterium isolate 45ae5b24-82d0-47e0-b430-a4ed073fe207 genome assembly, chromosome: 1	blastn	214	89.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
27433898	27433898	PRJNA814235_P_NODE_53443_length_260_cov_6.560538_g52049_i0	PRJNA814235	53443	260	6.560538	17.0573988	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	47.4	5.5e-4	NR	MDI3352151.1	2094	g52049	i0	95	0.230769230769231	20	1	23.1	0	18	77	8	27	MDI3352151.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	60	47.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
27623293	27623293	PRJNA814235_P_NODE_197924_length_150_cov_3.690265_g196529_i0	PRJNA814235	197924	150	3.690265	5.5353975	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	55.1	4.53e-7	NR	MCF7930077.1	1898209	g196529	i0	56.3	1.92	48	15	96	1	149	6	799	840	MCF7930077.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	288	55.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
30465473	30465473	PRJNA814235_P_NODE_199573_length_150_cov_3.106195_g198178_i0	PRJNA814235	199573	150	3.106195	4.6592925	Acholeplasma sp.	33015	Bacteria	Bacteria	50.8	1.17e-5	NR	MFA7417534.1	33015	g198178	i0	71.4	1.38	42	1	62	1	4	96	87	128	MFA7417534.1 F0F1 ATP synthase subunit A [Acholeplasma sp.]	diamond	207	50.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma sp.
31413190	31413190	PRJNA814235_P_NODE_105916_length_203_cov_2.192771_g104521_i0	PRJNA814235	105916	203	2.192771	4.45132513	Tenericutes bacterium HGW-Tenericutes-6	2013849	Bacteria	Bacteria	72.4	4.94e-13	NR	PKK93942.1	2013849	g104521	i0	56.6	1.12315270935961	76	22	96.1	1	8	202	109	184	PKK93942.1 MAG: hypothetical protein CVV61_01990 [Tenericutes bacterium HGW-Tenericutes-6]	diamond	228	72.4	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium HGW-Tenericutes-6
31453713	31453713	PRJNA814235_P_NODE_88056_length_203_cov_4.156627_g86661_i0	PRJNA814235	88056	203	4.156627	8.43795281	Acholeplasma	2147	Bacteria	Bacteria	54.3	1.49e-6	NR	WIF88958.1	2148	g86661	i0	100	1.10837438423645	25	0	36.9	0	76	2	56	80	WIF88958.1 beta-ketoacyl-ACP synthase II [Acholeplasma laidlawii]	diamond	225	54.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma laidlawii
31982494	31982494	PRJNA814235_P_NODE_190798_length_151_cov_2.956140_g189403_i0	PRJNA814235	190798	151	2.95614	4.4637714	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	88.6	4.93e-19	NR	HHX75928.1	1898209	g189403	i0	88.2	1.01324503311258	51	5	99.3	1	151	2	338	388	HHX75928.1 ABC transporter ATP-binding protein [Acholeplasmataceae bacterium]	diamond	153	88.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
32835449	32835449	PRJNA814235_P_NODE_103660_length_203_cov_2.283133_g102265_i0	PRJNA814235	103660	203	2.283133	4.63475999	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	47	3.84e-4	NR	MFA5470705.1	1898209	g102265	i0	100	0.369458128078818	25	0	36.9	0	129	203	62	86	MFA5470705.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	75	47	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
32898408	32898408	PRJNA814235_P_NODE_180120_length_152_cov_4.669565_g178725_i0	PRJNA814235	180120	152	4.669565	7.0977388	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	47.4	8.36e-5	NR	WP_282459165.1	2094	g178725	i0	68	0.986842105263158	25	8	49.3	0	141	67	1	25	WP_282459165.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	150	47.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini

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