metadata: contig_metadata: 5 rows where bioproject = "PRJNA950981", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA950981", tax_kingdom = "Bacillati" 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
7640446	7640446	PRJNA950981_P_NODE_12286_length_293_cov_1.418182_g12110_i0	PRJNA950981	12286	293	1.418182	4.15527326	Mesomycoplasma	2923352	Bacteria	Bacteria	529	1.0299999999999996e-145	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g12110	i0	99.315	14.962457337884	292	2	99	0	1	292	643502	643793	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4384	529	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10191238	10191238	PRJNA950981_P_NODE_18588_length_249_cov_0.880682_g18412_i0	PRJNA950981	18588	249	0.880682	2.19289818	Mesomycoplasma	2923352	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g18412	i0	100	25.0883534136546	249	0	100	0	1	249	310722	310970	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	6247	460	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
20388782	20388782	PRJNA950981_P_NODE_17596_length_251_cov_0.876404_g17420_i0	PRJNA950981	17596	251	0.876404	2.19977404	Mesomycoplasma	2923352	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g17420	i0	100	15	251	0	100	0	1	251	412322	412072	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	3765	464	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
21664786	21664786	PRJNA950981_P_NODE_3237_length_533_cov_2.673913_g3063_i0	PRJNA950981	3237	533	2.673913	14.25195629	Mycoplasma	2093	Bacteria	Bacteria	946	0	NTclustered	gi\|1450425804\|emb\|LS991954.1\|	2123	g3063	i0	98.687	177.013133208255	533	7	100	0	1	533	305581	305049	Mycoplasma putrefaciens strain NCTC10155 genome assembly, chromosome: 1	blastn	94348	952	0.993697478991597	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma putrefaciens
22940258	22940258	PRJNA950981_P_NODE_518_length_1221_cov_3.711672_g436_i0	PRJNA950981	518	1221	3.711672	45.31951512	Mycoplasma	2093	Bacteria	Bacteria	2047	0	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g436	i0	96.967	193.686322686323	1220	36	99	1	1	1219	269101	270320	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	236491	2047	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);;