metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
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

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