metadata: contig_metadata: 7 rows where bioproject = "PRJEB83101", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJEB83101", 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
6100898	6100898	PRJEB83101_P_NODE_35905_length_310_cov_1.316456_g35600_i0	PRJEB83101	35905	310	1.316456	4.0810136	Mesomycoplasma	2923352	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g35600	i0	100	16.258064516129	310	0	100	0	1	310	799321	799630	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	5040	573	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6100966	6100966	PRJEB83101_P_NODE_40445_length_294_cov_1.647059_g40140_i0	PRJEB83101	40445	294	1.647059	4.84235346	Mesomycoplasma	2923352	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g40140	i0	100	16	294	0	100	0	1	294	671301	671008	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	4704	544	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6520274	6520274	PRJEB83101_P_NODE_47586_length_280_cov_1.705314_g47281_i0	PRJEB83101	47586	280	1.705314	4.7748792	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g47281	i0	100	0.1	28	0	10	0	168	195	142434	142407	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
7375169	7375169	PRJEB83101_P_NODE_24606_length_370_cov_1.932660_g24301_i0	PRJEB83101	24606	370	1.93266	7.150842	Malacoplasma	2791001	Bacteria	Bacteria	403	8.43e-108	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g24301	i0	86.559	120.118918918919	372	42	99	8	1	368	437	70	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	44444	403	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
9925711	9925711	PRJEB83101_P_NODE_27608_length_349_cov_3.561594_g27303_i0	PRJEB83101	27608	349	3.561594	12.42996306	Mollicutes	31969	Bacteria	Bacteria	645	1.1899999999999993e-180	NTclustered	gi\|1958638505\|gb\|MW498314.1\|	2100	g27303	i0	100	101.446991404011	349	0	100	0	1	349	1361	1013	Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence	blastn	35405	645	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
9925883	9925883	PRJEB83101_P_NODE_41628_length_291_cov_1.903670_g41323_i0	PRJEB83101	41628	291	1.90367	5.5396797	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|1253318474\|gb\|CP023736.1\|	2151	g41323	i0	100	0.652920962199313	30	0	10	0	21	50	662218	662189	Mesoplasma florum strain PPA1 chromosome, complete genome	blastn	190	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma florum
15445800	15445800	PRJEB83101_P_NODE_88533_length_235_cov_2.407407_g88228_i0	PRJEB83101	88533	235	2.407407	5.65740645	Malacoplasma muris	2119	Bacteria	Bacteria	366	6.62e-97	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g88228	i0	94.894	146.395744680851	235	11	100	1	1	235	563	330	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	34403	366	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris

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