metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
1269551	1269551	PRJNA980587_P_NODE_54141_length_311_cov_1.731092_g53348_i0	PRJNA980587	54141	311	1.731092	5.38369612	Mesomycoplasma	2923352	Bacteria	Bacteria	566	8.389999999999998e-157	NTclustered	gi\|1450419971\|emb\|LS991950.1\|	2100	g53348	i0	99.676	17.5337620578778	309	1	99	0	1	309	643482	643174	Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1	blastn	5453	566	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
2231636	2231636	PRJNA980587_P_NODE_88962_length_245_cov_0.889535_g88169_i0	PRJNA980587	88962	245	0.889535	2.17936075	Mycoplasma yeatsii	51365	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g88169	i0	97.531	46.4979591836735	243	4	99	2	1	242	673555	673796	Mycoplasma yeatsii GM274B	blastn	11392	414	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
3505884	3505884	PRJNA980587_P_NODE_15483_length_669_cov_1.906040_g14719_i0	PRJNA980587	15483	669	1.90604	12.7514076	Mycoplasma cottewii	51364	Bacteria	Bacteria	1090	0	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g14719	i0	96.114	2	669	25	100	1	1	669	48031	47364	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	1338	1090	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
5097853	5097853	PRJNA980587_P_NODE_48024_length_332_cov_3.482625_g47231_i0	PRJNA980587	48024	332	3.482625	11.562315	Mesomycoplasma	2923352	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g47231	i0	100	15.8704819277108	329	0	99	0	4	332	644093	643765	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	5269	608	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
12748788	12748788	PRJNA980587_P_NODE_68210_length_274_cov_0.975124_g67417_i0	PRJNA980587	68210	274	0.975124	2.67183976	Mesomycoplasma	2923352	Bacteria	Bacteria	501	2.08e-137	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g67417	i0	99.635	15	274	1	100	0	1	274	818296	818023	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4110	501	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
14023420	14023420	PRJNA980587_P_NODE_75011_length_258_cov_1.664865_g74218_i0	PRJNA980587	75011	258	1.664865	4.2953517	Mesomycoplasma	2923352	Bacteria	Bacteria	475	1.1799999999999999e-129	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g74218	i0	100	14.9418604651163	257	0	99	0	1	257	355629	355373	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3855	475	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15297406	15297406	PRJNA980587_P_NODE_34592_length_403_cov_2.430303_g33799_i0	PRJNA980587	34592	403	2.430303	9.79412109	Mollicutes	31969	Bacteria	Bacteria	739	0	NTclustered	gi\|171703046\|dbj\|AB353273.1\|	2121	g33799	i0	99.752	109.975186104218	403	1	100	0	1	403	1474	1072	Mycoplasma orale gene for 16S ribosomal RNA, partial sequence	blastn	44320	745	0.991946308724832	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma orale
15297504	15297504	PRJNA980587_P_NODE_79032_length_251_cov_0.865169_g78239_i0	PRJNA980587	79032	251	0.865169	2.17157419	Mesomycoplasma	2923352	Bacteria	Bacteria	462	8.869999999999999e-126	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g78239	i0	100	14.9402390438247	250	0	99	0	2	251	590803	590554	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3750	462	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16258619	16258619	PRJNA980587_P_NODE_49573_length_327_cov_1.196850_g48780_i0	PRJNA980587	49573	327	1.19685	3.9136995	Metamycoplasma orale	2121	Bacteria	Bacteria	599	8.759999999999997e-167	NTclustered	gi\|1563679895\|emb\|LR214940.1\|	2121	g48780	i0	99.694	151.229357798165	327	1	100	0	1	327	698384	698710	Mycoplasma orale strain NCTC10112 genome assembly, chromosome: 1	blastn	49452	599	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma orale
25182506	25182506	PRJNA980587_P_NODE_93700_length_242_cov_0.911243_g92907_i0	PRJNA980587	93700	242	0.911243	2.20520806	Mycoplasma cottewii	51364	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g92907	i0	93.802	1	242	15	100	0	1	242	869462	869703	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	242	364	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii

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