metadata: contig_metadata: 5 rows where bioproject = "PRJNA685060" and tax

5 rows where bioproject = "PRJNA685060" 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
10104676	10104676	PRJNA685060_P_NODE_14008_length_250_cov_0.870056_g13918_i0	PRJNA685060	14008	250	0.870056	2.17514	Mycoplasma	2093	Bacteria	Bacteria	84.2	8.03e-12	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g13918	i0	80.909	7.644	110	17	43	4	87	193	1703941	1703833	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	1911	84.2	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
13420096	13420096	PRJNA685060_P_NODE_14811_length_248_cov_0.880000_g14721_i0	PRJNA685060	14811	248	0.88	2.1824	Mesoplasma coleopterae	324078	Bacteria	Bacteria	97.1	1.02e-15	NTclustered	gi\|1359435478\|gb\|CP022510.1\|	324078	g14721	i0	76.166	2.53629032258065	193	40	77	6	1	190	296301	296112	Mesoplasma coleopterae strain BARC 786 chromosome	blastn	629	97.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma coleopterae
22343424	22343424	PRJNA685060_P_NODE_15158_length_247_cov_0.885057_g15068_i0	PRJNA685060	15158	247	0.885057	2.18609079	Malacoplasma penetrans	28227	Bacteria	Bacteria	302	2.01e-77	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g15068	i0	89.496	72.0080971659919	238	25	96	0	9	246	94843	95080	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	17786	302	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
27461572	27461572	PRJNA685060_P_NODE_17223_length_242_cov_0.911243_g17133_i0	PRJNA685060	17223	242	0.911243	2.20520806	Malacoplasma sp.	2791014	Bacteria	Bacteria	72	2.55e-13	NR	MDE5553374.1	2791014	g17133	i0	48.7	0.966942148760331	78	39	96.7	1	240	7	84	160	MDE5553374.1 DJ-1/PfpI family protein [Malacoplasma sp.]	diamond	234	72	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
30398662	30398662	PRJNA685060_P_NODE_5993_length_392_cov_1.407524_g5903_i0	PRJNA685060	5993	392	1.407524	5.51749408	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	46.6	0.00781	NR	MDK2819939.1	2685873	g5903	i0	35.5	0.581632653061224	76	45	58.2	2	276	49	351	422	MDK2819939.1 DUF262 domain-containing protein [Mycoplasmataceae bacterium]	diamond	228	46.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae 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);;