metadata: contig_metadata: 14 rows where bioproject = "PRJNA597223", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA597223", 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
1140786	1140786	PRJNA597223_P_NODE_75201_length_163_cov_2.828125_g73355_i0	PRJNA597223	75201	163	2.828125	4.60984375	Mesomycoplasma	2923352	Bacteria	Bacteria	292	7.35e-75	NTclustered	gi\|1958638505\|gb\|MW498314.1\|	2100	g73355	i0	99.379	110.668711656442	161	1	99	0	1	161	2087	2247	Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence	blastn	18039	292	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
1844677	1844677	PRJNA597223_P_NODE_3542_length_915_cov_16.075000_g2560_i0	PRJNA597223	3542	915	16.075	147.08625	Malacoplasma muris	2119	Bacteria	Bacteria	880	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g2560	i0	86.849	127.497267759563	806	82	87	21	106	903	802	1591	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	116660	880	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
3120407	3120407	PRJNA597223_P_NODE_70263_length_170_cov_2.118519_g68417_i0	PRJNA597223	70263	170	2.118519	3.6014823	Metamycoplasma faucium	56142	Bacteria	Bacteria	135	1.37e-27	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g68417	i0	88.889	1.07058823529412	117	4	68	4	1	115	309693	309584	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	182	135	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
8222809	8222809	PRJNA597223_P_NODE_84407_length_153_cov_1.754237_g82561_i0	PRJNA597223	84407	153	1.754237	2.68398261	Metamycoplasma faucium	56142	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g82561	i0	100	2	153	0	100	0	1	153	78850	79002	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	306	283	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
11343959	11343959	PRJNA597223_P_NODE_12349_length_485_cov_2262.397778_g10611_i0	PRJNA597223	12349	485	2262.397778	10972.6292233	Mollicutes	31969	Bacteria	Bacteria	664	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g10611	i0	91.358	141.779381443299	486	40	100	2	1	485	969	485	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	68763	664	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
11344133	11344133	PRJNA597223_P_NODE_67489_length_175_cov_0.942857_g65643_i0	PRJNA597223	67489	175	0.942857	1.64999975	Mollicutes	31969	Bacteria	Bacteria	316	4.74e-82	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g65643	i0	99.425	62.7257142857143	174	1	99	0	1	174	625923	626096	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	10977	318	0.993710691823899	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
14598146	14598146	PRJNA597223_P_NODE_55612_length_189_cov_1.363636_g53766_i0	PRJNA597223	55612	189	1.363636	2.57727204	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1951495622\|gb\|CP058497.1\|	28903	g53766	i0	100	0.158730158730159	30	0	16	0	85	114	655154	655183	Mycoplasmopsis bovis strain Mb180 chromosome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
17146956	17146956	PRJNA597223_P_NODE_56074_length_188_cov_2.333333_g54228_i0	PRJNA597223	56074	188	2.333333	4.38666604	Metamycoplasma faucium	56142	Bacteria	Bacteria	324	3.09e-84	NTclustered	gi\|2921905358\|gb\|CP182786.1\|	56142	g54228	i0	98.37	9.36702127659574	184	3	98	0	5	188	270429	270246	Metamycoplasma faucium strain DC-333 chromosome, complete genome	blastn	1761	324	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
17147061	17147061	PRJNA597223_P_NODE_67754_length_174_cov_2.230216_g65908_i0	PRJNA597223	67754	174	2.230216	3.88057584	Metamycoplasma faucium	56142	Bacteria	Bacteria	193	8.269999999999999e-45	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g65908	i0	98.182	2.11494252873563	110	2	100	0	1	110	74281	74390	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	368	193	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
19695786	19695786	PRJNA597223_P_NODE_66136_length_177_cov_1.894366_g64290_i0	PRJNA597223	66136	177	1.894366	3.35302782	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g64290	i0	100	0.163841807909605	29	0	16	0	8	36	26051	26079	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
20267123	20267123	PRJNA597223_P_NODE_28776_length_283_cov_11.532258_g26930_i0	PRJNA597223	28776	283	11.532258	32.63629014	Mycoplasmoidales	2790996	Bacteria	Bacteria	409	1.3499999999999998e-109	NTclustered	gi\|1563789200\|emb\|LR214962.1\|	2115	g26930	i0	93.165	324.752650176678	278	19	98	0	1	278	355586	355863	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8	blastn	91905	409	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
20267159	20267159	PRJNA597223_P_NODE_3956_length_873_cov_11.151551_g2902_i0	PRJNA597223	3956	873	11.151551	97.35304023	Mycoplasmoidales	2790996	Bacteria	Bacteria	841	0	NTclustered	gi\|1563789200\|emb\|LR214962.1\|	2115	g2902	i0	84.589	130.955326460481	863	112	98	8	1	859	358435	357590	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8	blastn	114324	846	0.994089834515366	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
20267178	20267178	PRJNA597223_P_NODE_46236_length_206_cov_4.362573_g44390_i0	PRJNA597223	46236	206	4.362573	8.98690038	Bacteria	2	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g44390	i0	100	86.1990291262136	201	0	98	0	1	201	428875	429075	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	17757	372	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
20267308	20267308	PRJNA597223_P_NODE_80116_length_157_cov_3.524590_g78270_i0	PRJNA597223	80116	157	3.52459	5.5336063	Mollicutes	31969	Bacteria	Bacteria	281	1.52e-71	NTclustered	gi\|285179718\|gb\|GU417336.1\|	56142	g78270	i0	100	97.3503184713376	152	0	97	0	4	155	50	201	Mycoplasma faucium clone WWP_SS7_G24 16S ribosomal RNA gene, partial sequence	blastn	15284	281	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium

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