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

10 rows where bioproject = "PRJNA781453", 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
6316237	6316237	PRJNA781453_P_NODE_32785_length_250_cov_0.870056_g32670_i0	PRJNA781453	32785	250	0.870056	2.17514	Mycoplasma	2093	Bacteria	Bacteria	235	2.09e-57	NTclustered	gi\|339276163\|emb\|FR668087.1\|	866629	g32670	i0	92.638	2.12	163	12	65	0	88	250	406379	406541	Mycoplasma leachii 99/014/6 complete genome	blastn	530	235	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma leachii
15240639	15240639	PRJNA781453_P_NODE_24572_length_293_cov_2.822727_g24457_i0	PRJNA781453	24572	293	2.822727	8.27059011	Mycoplasma	2093	Bacteria	Bacteria	531	2.86e-146	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g24457	i0	99.317	100.839590443686	293	2	100	0	1	293	73052	73344	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	29546	536	0.990671641791045	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
16515173	16515173	PRJNA781453_P_NODE_39273_length_243_cov_0.905882_g39158_i0	PRJNA781453	39273	243	0.905882	2.20129326	Mesomycoplasma	2923352	Bacteria	Bacteria	440	4e-119	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g39158	i0	99.587	15.9218106995885	242	0	99	1	2	243	649069	648829	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	3869	440	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16515183	16515183	PRJNA781453_P_NODE_9153_length_494_cov_25.429929_g9039_i0	PRJNA781453	9153	494	25.429929	125.62384926	Bacteria	2	Bacteria	Bacteria	902	0	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g9039	i0	99.595	173.965587044534	494	2	100	0	1	494	945	1438	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	85939	902	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
17789955	17789955	PRJNA781453_P_NODE_35114_length_248_cov_0.874286_g34999_i0	PRJNA781453	35114	248	0.874286	2.16822928	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	161	3.33e-46	NR	MCI6931842.1	2231116	g34999	i0	98.8	0.991935483870968	82	1	99.2	0	1	246	179	260	MCI6931842.1 IS1634 family transposase [Mycoplasmatota bacterium]	diamond	246	161	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
18614400	18614400	PRJNA781453_P_NODE_33735_length_249_cov_0.875000_g33620_i0	PRJNA781453	33735	249	0.875	2.17875	Mycoplasma cottewii	51364	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g33620	i0	93.96	50.0522088353414	149	9	60	0	98	246	781818	781966	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	12463	226	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
19063931	19063931	PRJNA781453_P_NODE_36455_length_246_cov_0.890173_g36340_i0	PRJNA781453	36455	246	0.890173	2.18982558	Mesomycoplasma	2923352	Bacteria	Bacteria	363	9.039999999999999e-96	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g36340	i0	100	11.9512195121951	196	0	80	0	32	227	32504	32699	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2940	363	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24163895	24163895	PRJNA781453_P_NODE_20819_length_320_cov_1.603239_g20704_i0	PRJNA781453	20819	320	1.603239	5.1303648	Mesomycoplasma	2923352	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g20704	i0	100	69.2875	320	0	100	0	1	320	524862	524543	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	22172	592	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
25439024	25439024	PRJNA781453_P_NODE_17480_length_349_cov_1.876812_g17365_i0	PRJNA781453	17480	349	1.876812	6.55007388	Mycoplasmopsis	2767358	Bacteria	Bacteria	645	1.1899999999999993e-180	NTclustered	gi\|2496025365\|gb\|CP123300.1\|	28903	g17365	i0	100	191.034383954155	349	0	100	0	1	349	491571	491223	Mycoplasmopsis bovis strain 15DD0238 chromosome, complete genome	blastn	66671	645	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
30716974	30716974	PRJNA781453_P_NODE_36214_length_246_cov_0.890173_g36099_i0	PRJNA781453	36214	246	0.890173	2.18982558	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	140	6.929999999999999e-40	NR	MCI5733354.1	2231116	g36099	i0	97.5	0.98780487804878	81	2	98.8	0	2	244	20	100	MCI5733354.1 Bax inhibitor-1/YccA family protein [Mycoplasmatota bacterium]	diamond	243	140	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota 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);;