metadata: contig_metadata: 13 rows where bioproject = "PRJNA1092581", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJNA1092581", 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
2293443	2293443	PRJNA1092581_P_NODE_21202_length_604_cov_3.387947_g20680_i0	PRJNA1092581	21202	604	3.387947	20.46319988	Mesomycoplasma	2923352	Bacteria	Bacteria	1068	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g20680	i0	99.658	29.6804635761589	584	2	97	0	21	604	772502	771919	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	17927	1068	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
4023478	4023478	PRJNA1092581_P_NODE_39984_length_432_cov_17.493036_g39451_i0	PRJNA1092581	39984	432	17.493036	75.56991552	Spiroplasma sp. crk	1176365	Bacteria	Bacteria	641	1.9499999999999998e-179	NTclustered	gi\|385654450\|gb\|JQ768460.1\|	1176365	g39451	i0	94.891	119.775462962963	411	20	95	1	17	426	2251	1841	Spiroplasma sp. crk 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, and 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	51743	641	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma sp. crk
4846670	4846670	PRJNA1092581_P_NODE_71324_length_309_cov_8.067797_g70791_i0	PRJNA1092581	71324	309	8.067797	24.92949273	Mycoplasma	2093	Bacteria	Bacteria	484	2.3999999999999998e-132	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g70791	i0	97.203	1.85113268608414	286	8	93	0	22	307	594612	594897	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	572	484	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
9946153	9946153	PRJNA1092581_P_NODE_124948_length_207_cov_4.492537_g124415_i0	PRJNA1092581	124948	207	4.492537	9.29955159	Mesomycoplasma	2923352	Bacteria	Bacteria	370	4.4e-98	NTclustered	gi\|1563681457\|emb\|LR214948.1\|	2100	g124415	i0	99.034	17	207	0	100	2	1	207	1797	2001	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 2	blastn	3519	370	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
11222171	11222171	PRJNA1092581_P_NODE_82969_length_283_cov_2.052381_g82436_i0	PRJNA1092581	82969	283	2.052381	5.80823823	Mesomycoplasma	2923352	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g82436	i0	99.647	31.0671378091873	283	1	100	0	1	283	239485	239767	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	8792	518	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
12949546	12949546	PRJNA1092581_P_NODE_115891_length_230_cov_3.764331_g115358_i0	PRJNA1092581	115891	230	3.764331	8.6579613	Mycoplasma yeatsii	51365	Bacteria	Bacteria	291	4e-74	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g115358	i0	91.509	1.04347826086957	212	16	91	1	21	230	889313	889102	Mycoplasma yeatsii GM274B	blastn	240	291	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
15499989	15499989	PRJNA1092581_P_NODE_59013_length_345_cov_11.426471_g58480_i0	PRJNA1092581	59013	345	11.426471	39.42132495	Mycoplasma yeatsii	51365	Bacteria	Bacteria	490	5.84e-134	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g58480	i0	93.846	1.88115942028986	325	20	94	0	21	345	886343	886019	Mycoplasma yeatsii GM274B	blastn	649	490	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
15500464	15500464	PRJNA1092581_P_NODE_77093_length_295_cov_11.265766_g76560_i0	PRJNA1092581	77093	295	11.265766	33.2340097	Mycoplasma yeatsii	51365	Bacteria	Bacteria	479	1.0599999999999996e-130	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g76560	i0	98.175	79.6745762711864	274	5	93	0	1	274	524084	524357	Mycoplasma yeatsii GM274B	blastn	23504	479	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
18869931	18869931	PRJNA1092581_P_NODE_43795_length_410_cov_10.528190_g43262_i0	PRJNA1092581	43795	410	10.52819	43.165579	Mesomycoplasma	2923352	Bacteria	Bacteria	754	0	NTclustered	gi\|1932032494\|gb\|CP064323.1\|	2100	g43262	i0	100	86.5658536585366	408	0	100	0	3	410	444348	443941	Mesomycoplasma hyorhinis strain IMT49388 chromosome, complete genome	blastn	35492	754	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
20596578	20596578	PRJNA1092581_P_NODE_100237_length_252_cov_6.139665_g99704_i0	PRJNA1092581	100237	252	6.139665	15.4719558	Mycoplasma yeatsii	51365	Bacteria	Bacteria	296	9.56e-76	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g99704	i0	89.956	4.83333333333333	229	23	91	0	23	251	888495	888267	Mycoplasma yeatsii GM274B	blastn	1218	296	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
21420469	21420469	PRJNA1092581_P_NODE_57097_length_352_cov_3.724014_g56564_i0	PRJNA1092581	57097	352	3.724014	13.10852928	Mesomycoplasma	2923352	Bacteria	Bacteria	651	0	NTclustered	gi\|1563681457\|emb\|LR214948.1\|	2100	g56564	i0	100	17	352	0	100	0	1	352	1381	1732	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 2	blastn	5984	651	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
23148050	23148050	PRJNA1092581_P_NODE_115559_length_230_cov_71.050955_g115026_i0	PRJNA1092581	115559	230	71.050955	163.4171965	Mycoplasmopsis pulmonis	2107	Bacteria	Bacteria	357	3.89e-94	NTclustered	gi\|1563796921\|emb\|LR215008.1\|	2107	g115026	i0	100	24.8478260869565	193	0	84	0	24	216	797995	797803	Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1	blastn	5715	357	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis pulmonis
31711129	31711129	PRJNA1092581_P_NODE_91557_length_266_cov_22.269430_g91024_i0	PRJNA1092581	91557	266	22.26943	59.2366838	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	67.8	6.5e-11	NR	MCI5939670.1	1898209	g91024	i0	37.6	1.04887218045113	93	40	90.2	3	20	259	133	220	MCI5939670.1 peptide chain release factor 2 [Acholeplasmataceae bacterium]	diamond	279	67.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae 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);;