metadata: contig_metadata: 10 rows where bioproject = "PRJNA715462" and tax

10 rows where bioproject = "PRJNA715462" 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
705212	705212	PRJNA715462_P_NODE_12221_length_583_cov_1.868627_g11432_i0	PRJNA715462	12221	583	1.868627	10.89409541	Candidatus Phytoplasma cynodontis	72990	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2511947619\|gb\|CP126225.1\|	72990	g11432	i0	100	0.0514579759862779	30	0	5	0	228	257	435024	434995	MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma cynodontis
7084856	7084856	PRJNA715462_P_NODE_51726_length_251_cov_0.865169_g50930_i0	PRJNA715462	51726	251	0.865169	2.17157419	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	63.5	7.06e-11	NR	MBR2055756.1	2685873	g50930	i0	64.6	0.573705179282869	48	17	57.4	0	249	106	51	98	MBR2055756.1 hypothetical protein [Mycoplasmataceae bacterium]	diamond	144	63.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
12671811	12671811	PRJNA715462_P_NODE_15030_length_503_cov_1.123256_g14235_i0	PRJNA715462	15030	503	1.123256	5.64997768	root	1	Root_unresolved	Root_unresolved	120	1.3099999999999998e-31	NR	MDI4567532.1	2108	g14235	i0	50.4	13.2226640159046	125	61	74.6	1	439	65	18	141	MDI4567532.1 30S ribosomal protein S9 [Mycoplasma sp.]	diamond	6651	121	0.991735537190083	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
13460089	13460089	PRJNA715462_P_NODE_62391_length_245_cov_0.895349_g61595_i0	PRJNA715462	62391	245	0.895349	2.19360505	Mesomycoplasma moatsii	171287	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|2860287645\|gb\|CP174166.1\|	171287	g61595	i0	87.755	24.3020408163265	245	30	100	0	1	245	450369	450613	Mesomycoplasma moatsii strain MK 405 chromosome, complete genome	blastn	5954	287	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma moatsii
13946183	13946183	PRJNA715462_P_NODE_70191_length_231_cov_2.284810_g69395_i0	PRJNA715462	70191	231	2.28481	5.2779111	Mycoplasmopsis	2767358	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2673562796\|gb\|CP144311.1\|	2110	g69395	i0	100	1.004329004329	29	0	13	0	105	133	305318	305290	Mycoplasmopsis agalactiae strain GA572 chromosome, complete genome	blastn	232	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis agalactiae
24932198	24932198	PRJNA715462_P_NODE_26940_length_346_cov_1.164835_g26144_i0	PRJNA715462	26940	346	1.164835	4.0303291	Spiroplasma endosymbiont of Harpalus anxius	3077931	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2813305944\|emb\|OZ187007.1\|	3077931	g26144	i0	100	0.0838150289017341	29	0	8	0	72	100	1750943	1750915	Spiroplasma endosymbiont of Harpalus anxius isolate 66129c39-b7a8-4b37-864c-2d57ae6f9329 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Harpalus anxius
26734981	26734981	PRJNA715462_P_NODE_60181_length_246_cov_0.890173_g59385_i0	PRJNA715462	60181	246	0.890173	2.18982558	Malacoplasma sp.	2791014	Bacteria	Bacteria	43.9	0.0145	NR	MCF0227332.1	2791014	g59385	i0	40.7	1.31707317073171	54	29	62.2	1	2	154	318	371	MCF0227332.1 leucine-rich repeat protein [Malacoplasma sp.]	diamond	324	43.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
31125822	31125822	PRJNA715462_P_NODE_64575_length_243_cov_1.564706_g63779_i0	PRJNA715462	64575	243	1.564706	3.80223558	Paracholeplasma manati	591373	Bacteria	Bacteria	164	2.3899999999999994e-48	NR	WP_263608320.1	591373	g63779	i0	100	0.975308641975309	79	0	97.5	0	239	3	149	227	WP_263608320.1 thymidylate synthase [Paracholeplasma manati]	diamond	237	164	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma manati
31980061	31980061	PRJNA715462_P_NODE_63098_length_244_cov_0.900585_g62302_i0	PRJNA715462	63098	244	0.900585	2.1974274	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	122	1.7999999999999998e-33	NR	MBR3571256.1	2685873	g62302	i0	79.4	1.69672131147541	68	14	83.6	0	5	208	84	151	MBR3571256.1 rRNA maturation RNase YbeY [Mycoplasmataceae bacterium]	diamond	414	122	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
32296940	32296940	PRJNA715462_P_NODE_40319_length_280_cov_1.352657_g39523_i0	PRJNA715462	40319	280	1.352657	3.7874396	Mesomycoplasma moatsii	171287	Bacteria	Bacteria	141	1.19e-37	NR	WP_022935309.1	171287	g39523	i0	84.5	0.9	84	13	90	0	29	280	232	315	WP_022935309.1 FAD-dependent oxidoreductase [Mesomycoplasma moatsii]	diamond	252	141	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma moatsii

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