metadata: contig_metadata: 12 rows where bioproject = "PRJNA939415", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA939415", 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
6360759	6360759	PRJNA939415_P_NODE_81025_length_253_cov_1.666667_g80603_i0	PRJNA939415	81025	253	1.666667	4.21666751	Mesomycoplasma	2923352	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g80603	i0	100	15.8695652173913	253	0	100	0	1	253	639775	640027	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4015	468	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6360799	6360799	PRJNA939415_P_NODE_86265_length_248_cov_3.537143_g85843_i0	PRJNA939415	86265	248	3.537143	8.77211464	Mesomycoplasma	2923352	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g85843	i0	100	16.0282258064516	248	0	100	0	1	248	643973	643726	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3975	459	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10185190	10185190	PRJNA939415_P_NODE_41128_length_293_cov_1.950000_g40706_i0	PRJNA939415	41128	293	1.95	5.7135	Mesomycoplasma	2923352	Bacteria	Bacteria	540	4.76e-149	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g40706	i0	100	28.6587030716724	292	0	99	0	2	293	645162	644871	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	8397	540	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10185492	10185492	PRJNA939415_P_NODE_9228_length_523_cov_9.848889_g8811_i0	PRJNA939415	9228	523	9.848889	51.50968947	Bacteria	2	Bacteria	Bacteria	955	0	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g8811	i0	99.618	176.988527724665	523	2	100	0	1	523	939	1461	Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	92565	955	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
11119686	11119686	PRJNA939415_P_NODE_68929_length_265_cov_1.489583_g68507_i0	PRJNA939415	68929	265	1.489583	3.94739495	Mycoplasma cottewii	51364	Bacteria	Bacteria	396	9.71e-106	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g68507	i0	93.585	2.10566037735849	265	17	100	0	1	265	662788	663052	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	558	396	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
12735647	12735647	PRJNA939415_P_NODE_110890_length_202_cov_7.697674_g110468_i0	PRJNA939415	110890	202	7.697674	15.54930148	Mesomycoplasma	2923352	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g110468	i0	100	15	202	0	100	0	1	202	672204	672003	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	3030	374	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16218612	16218612	PRJNA939415_P_NODE_48453_length_285_cov_2.386792_g48031_i0	PRJNA939415	48453	285	2.386792	6.8023572	Mycoplasma yeatsii	51365	Bacteria	Bacteria	497	2.81e-136	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g48031	i0	98.239	98.0140350877193	284	5	99	0	1	284	118025	118308	Mycoplasma yeatsii GM274B	blastn	27934	497	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
17833907	17833907	PRJNA939415_P_NODE_31814_length_310_cov_2.873418_g31392_i0	PRJNA939415	31814	310	2.873418	8.9075958	Mycoplasma	2093	Bacteria	Bacteria	243	1.6000000000000004e-59	NTclustered	gi\|731474337\|gb\|CP010267.1\|	2103	g31392	i0	95.455	17.141935483871	154	3	97	1	1	150	159262	159415	Mycoplasma mycoides subsp. mycoides strain izsam_mm5713, complete genome	blastn	5314	243	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
20041568	20041568	PRJNA939415_P_NODE_13536_length_421_cov_1.931034_g13117_i0	PRJNA939415	13536	421	1.931034	8.12965314	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	761	0	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g13117	i0	99.287	160.923990498812	421	3	100	0	1	421	371699	371279	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	67749	761	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
20382521	20382521	PRJNA939415_P_NODE_104456_length_228_cov_2.477419_g104034_i0	PRJNA939415	104456	228	2.477419	5.64851532	Mesomycoplasma	2923352	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g104034	i0	100	34.7105263157895	228	0	100	0	1	228	672170	672397	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	7914	422	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24208203	24208203	PRJNA939415_P_NODE_64659_length_269_cov_2.229592_g64237_i0	PRJNA939415	64659	269	2.229592	5.99760248	Mesomycoplasma	2923352	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g64237	i0	100	68.449814126394	269	0	100	0	1	269	64926	65194	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	18413	497	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
28983242	28983242	PRJNA939415_P_NODE_107468_length_218_cov_4.413793_g107046_i0	PRJNA939415	107468	218	4.413793	9.62206874	Candidatus Izimaplasma bacterium HR2	1541960	Bacteria	Bacteria	85.5	1.87e-17	NR	KFZ26362.1	1541960	g107046	i0	54.9	0.977064220183486	71	32	97.7	0	3	215	323	393	KFZ26362.1 MAG: Adenylosuccinate lyase [Candidatus Izimaplasma bacterium HR2]	diamond	213	85.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izimoplasma sp. HR2

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