metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA934472" 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
14939096	14939096	PRJNA934472_P_NODE_35232_length_251_cov_0.977528_g34854_i0	PRJNA934472	35232	251	0.977528	2.45359528	Mycoplasma ovis	171632	Bacteria	Bacteria	135	1.3e-35	NR	WP_024071000.1	171632	g34854	i0	90.1	0.848605577689243	71	7	84.9	0	250	38	253	323	WP_024071000.1 glutamate--tRNA ligase [Mycoplasma ovis]	diamond	213	135	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
27404380	27404380	PRJNA934472_P_NODE_28643_length_277_cov_1.014706_g28265_i0	PRJNA934472	28643	277	1.014706	2.81073562	Mycoplasma wenyonii	65123	Bacteria	Bacteria	123	1.4499999999999998e-31	NR	WP_112665002.1	65123	g28265	i0	81.5	0.877256317689531	81	14	87.7	1	244	2	163	242	WP_112665002.1 glutamyl-tRNA amidotransferase [Mycoplasma wenyonii]	diamond	243	123	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27499070	27499070	PRJNA934472_P_NODE_39523_length_234_cov_2.341615_g39145_i0	PRJNA934472	39523	234	2.341615	5.4793791	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	53.5	5.24e-6	NR	WP_187150740.1	432608	g39145	i0	41	1.06410256410256	83	42	97.4	2	232	5	962	1044	WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	249	53.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28288139	28288139	PRJNA934472_P_NODE_30346_length_270_cov_1.050761_g29968_i0	PRJNA934472	30346	270	1.050761	2.8370547	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	61.2	1.54e-8	NR	WP_187150751.1	432608	g29968	i0	43.4	0.922222222222222	83	38	91.1	4	23	268	241	315	WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	249	61.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28446319	28446319	PRJNA934472_P_NODE_34366_length_254_cov_1.353591_g33988_i0	PRJNA934472	34366	254	1.353591	3.43812114	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	116	2.45e-28	NR	WP_187150751.1	432608	g33988	i0	65.9	0.968503937007874	82	28	96.9	0	4	249	88	169	WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	246	116	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
30814826	30814826	PRJNA934472_P_NODE_31234_length_266_cov_1.430052_g30856_i0	PRJNA934472	31234	266	1.430052	3.80393832	Mycoplasma wenyonii	65123	Bacteria	Bacteria	162	5.42e-46	NR	WP_238530690.1	65123	g30856	i0	94.3	1.98496240601504	88	5	99.2	0	265	2	21	108	WP_238530690.1 adenylosuccinate synthase [Mycoplasma wenyonii]	diamond	528	162	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31383905	31383905	PRJNA934472_P_NODE_30076_length_271_cov_1.196970_g29698_i0	PRJNA934472	30076	271	1.19697	3.2437887	Mycoplasma wenyonii	65123	Bacteria	Bacteria	167	2.5999999999999997e-47	NR	WP_112665597.1	65123	g29698	i0	94.4	0.996309963099631	90	5	99.6	0	1	270	214	303	WP_112665597.1 iron-containing alcohol dehydrogenase [Mycoplasma wenyonii]	diamond	270	167	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32333207	32333207	PRJNA934472_P_NODE_32439_length_261_cov_2.138298_g32061_i0	PRJNA934472	32439	261	2.138298	5.58095778	Mycoplasma wenyonii	65123	Bacteria	Bacteria	97.1	3.14e-21	NR	WP_112665853.1	65123	g32061	i0	65.7	2.25287356321839	67	23	77	0	47	247	17	83	WP_112665853.1 type I restriction-modification system subunit M [Mycoplasma wenyonii]	diamond	588	97.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32427831	32427831	PRJNA934472_P_NODE_29279_length_274_cov_1.298507_g28901_i0	PRJNA934472	29279	274	1.298507	3.55790918	Mycoplasma wenyonii	65123	Bacteria	Bacteria	80.9	2e-15	NR	WP_043911371.1	65123	g28901	i0	50.6	0.886861313868613	81	40	88.7	0	273	31	406	486	WP_043911371.1 N-6 DNA methylase [Mycoplasma wenyonii]	diamond	243	80.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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