metadata: contig_metadata: 10 rows where bioproject = "PRJEB83711", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJEB83711", 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
3548956	3548956	PRJEB83711_P_NODE_12363_length_509_cov_2.538991_g12099_i0	PRJEB83711	12363	509	2.538991	12.92346419	Mollicutes	31969	Bacteria	Bacteria	941	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g12099	i0	100	103.088408644401	509	0	100	0	1	509	19750	19242	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	52472	941	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13752052	13752052	PRJEB83711_P_NODE_35611_length_303_cov_1.273913_g35345_i0	PRJEB83711	35611	303	1.273913	3.85995639	Mesomycoplasma	2923352	Bacteria	Bacteria	560	3.79e-155	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g35345	i0	100	71.4257425742574	303	0	100	0	1	303	528778	528476	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	21642	560	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13752269	13752269	PRJEB83711_P_NODE_62151_length_251_cov_0.876404_g61885_i0	PRJEB83711	62151	251	0.876404	2.19977404	Mesomycoplasma	2923352	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g61885	i0	100	15	251	0	100	0	1	251	507478	507228	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	3765	464	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
14173002	14173002	PRJEB83711_P_NODE_62852_length_250_cov_1.293785_g62586_i0	PRJEB83711	62852	250	1.293785	3.2344625	Mycoplasma cottewii	51364	Bacteria	Bacteria	291	4.41e-74	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g62586	i0	87.6	1	250	31	100	0	1	250	292749	292500	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	250	291	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
15026341	15026341	PRJEB83711_P_NODE_26412_length_347_cov_1.459854_g26146_i0	PRJEB83711	26412	347	1.459854	5.06569338	Mycoplasma	2093	Bacteria	Bacteria	361	4.81e-95	NTclustered	gi\|339276163\|emb\|FR668087.1\|	866629	g26146	i0	90.775	1.99135446685879	271	24	78	1	73	343	407241	406972	Mycoplasma leachii 99/014/6 complete genome	blastn	691	361	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma leachii
22675444	22675444	PRJEB83711_P_NODE_35038_length_305_cov_1.818966_g34772_i0	PRJEB83711	35038	305	1.818966	5.5478463	Mesomycoplasma	2923352	Bacteria	Bacteria	556	4.94e-154	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g34772	i0	99.672	15	305	0	100	1	1	305	528067	528370	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4575	556	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
23951109	23951109	PRJEB83711_P_NODE_47299_length_272_cov_1.994975_g47033_i0	PRJEB83711	47299	272	1.994975	5.426332	Mesomycoplasma	2923352	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|1958638472\|gb\|MW498281.1\|	2100	g47033	i0	100	100.213235294118	272	0	100	0	1	272	2444	2173	Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence	blastn	27258	503	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
28897458	28897458	PRJEB83711_P_NODE_57248_length_253_cov_1.722222_g56982_i0	PRJEB83711	57248	253	1.722222	4.35722166	Mycoplasma sp. HU2	2108	Bacteria	Bacteria	150	4.289999999999999e-40	NR	WP_050517556.1	1664275	g56982	i0	97.6	0.99604743083004	84	2	99.6	0	253	2	615	698	WP_050517556.1 ABC transporter permease [Mycoplasma sp. HU2014]	diamond	252	150	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. HU2014
31266687	31266687	PRJEB83711_P_NODE_57915_length_253_cov_0.866667_g57649_i0	PRJEB83711	57915	253	0.866667	2.19266751	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	42.4	0.0119	NR	MDV3188738.1	2754999	g57649	i0	55.9	0.403162055335968	34	15	40.3	0	213	112	41	74	MDV3188738.1 hypothetical protein [Candidatus Phytoplasma australasiaticum]	diamond	102	42.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
32374004	32374004	PRJEB83711_P_NODE_67339_length_248_cov_0.891429_g67073_i0	PRJEB83711	67339	248	0.891429	2.21074392	Tenericutes bacterium ADurb.BinA155	1852922	Bacteria	Bacteria	110	3.35e-26	NR	OPZ37301.1	1852922	g67073	i0	63.4	0.991935483870968	82	30	99.2	0	1	246	206	287	OPZ37301.1 MAG: Iron hydrogenase 1 [Tenericutes bacterium ADurb.BinA155]	diamond	246	110	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium ADurb.BinA155

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