metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA853194" 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
27276375	27276375	PRJNA853194_S_NODE_54683_length_295_cov_1.364865_g53592_i0	PRJNA853194	54683	295	1.364865	4.02635175	Mycoplasma wenyonii	65123	Bacteria	Bacteria	113	3.4600000000000003e-29	NR	WP_112665591.1	65123	g53592	i0	68.3	0.833898305084746	82	25	82.4	1	265	23	61	142	WP_112665591.1 hypothetical protein [Mycoplasma wenyonii]	diamond	246	113	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27339631	27339631	PRJNA853194_S_NODE_48043_length_313_cov_1.283333_g46952_i0	PRJNA853194	48043	313	1.283333	4.01683229	Mycoplasma wenyonii	65123	Bacteria	Bacteria	204	1.28e-63	NR	WP_112665762.1	65123	g46952	i0	98.1	0.996805111821086	104	2	99.7	0	313	2	113	216	WP_112665762.1 class II fructose-1,6-bisphosphate aldolase [Mycoplasma wenyonii]	diamond	312	204	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27687214	27687214	PRJNA853194_S_NODE_56344_length_291_cov_1.385321_g55253_i0	PRJNA853194	56344	291	1.385321	4.03128411	Mycoplasma wenyonii	65123	Bacteria	Bacteria	65.5	1.35e-10	NR	WP_112664965.1	65123	g55253	i0	88.6	0.360824742268041	35	4	36.1	0	72	176	1	35	WP_112664965.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii]	diamond	105	65.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27750218	27750218	PRJNA853194_S_NODE_47364_length_315_cov_1.549587_g46273_i0	PRJNA853194	47364	315	1.549587	4.88119905	Mycoplasma wenyonii	65123	Bacteria	Bacteria	188	4.55e-58	NR	WP_112665247.1	65123	g46273	i0	97.1	0.990476190476191	104	3	99	0	313	2	32	135	WP_112665247.1 RluA family pseudouridine synthase [Mycoplasma wenyonii]	diamond	312	188	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
28255050	28255050	PRJNA853194_S_NODE_53506_length_298_cov_1.315556_g52415_i0	PRJNA853194	53506	298	1.315556	3.92035688	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	142	4.78e-38	NR	WP_187150753.1	432608	g52415	i0	72.5	1.83221476510067	91	25	91.6	0	3	275	25	115	WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	546	142	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28981571	28981571	PRJNA853194_S_NODE_67268_length_268_cov_1.051282_g66177_i0	PRJNA853194	67268	268	1.051282	2.81743576	Mycoplasma ovis	171632	Bacteria	Bacteria	129	2.26e-32	NR	WP_024071642.1	171632	g66177	i0	76.2	0.940298507462687	84	20	94	0	254	3	54	137	WP_024071642.1 type I DNA topoisomerase [Mycoplasma ovis]	diamond	252	129	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
29265344	29265344	PRJNA853194_S_NODE_59789_length_283_cov_1.804762_g58698_i0	PRJNA853194	59789	283	1.804762	5.10747646	Mycoplasma wenyonii	65123	Bacteria	Bacteria	166	5.61e-48	NR	WP_112665229.1	65123	g58698	i0	88.3	0.996466431095406	94	11	99.6	0	1	282	113	206	WP_112665229.1 methionine adenosyltransferase domain-containing protein [Mycoplasma wenyonii]	diamond	282	166	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
29707141	29707141	PRJNA853194_S_NODE_69030_length_264_cov_2.015707_g67939_i0	PRJNA853194	69030	264	2.015707	5.32146648	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	131	1.02e-36	NR	WP_187150369.1	432608	g67939	i0	86.4	0.920454545454545	81	11	92	0	245	3	1	81	WP_187150369.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	243	131	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
30781670	30781670	PRJNA853194_S_NODE_51814_length_302_cov_2.353712_g50723_i0	PRJNA853194	51814	302	2.353712	7.10821024	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	184	1.09e-51	NR	WP_245633501.1	432608	g50723	i0	100	0.993377483443709	100	0	99.3	0	300	1	352	451	WP_245633501.1 DNA gyrase/topoisomerase IV subunit A [Candidatus Mycoplasma haematobovis]	diamond	300	184	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
31318887	31318887	PRJNA853194_S_NODE_48975_length_310_cov_1.974684_g47884_i0	PRJNA853194	48975	310	1.974684	6.1215204	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	61.2	2.75e-8	NR	WP_187150740.1	432608	g47884	i0	59.6	0.503225806451613	52	21	50.3	0	160	5	1073	1124	WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	156	61.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis

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