metadata: contig_metadata: 7 rows where bioproject = "PRJNA964500" and tax

7 rows where bioproject = "PRJNA964500" 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
14019239	14019239	PRJNA964500_S_NODE_11671_length_176_cov_2.204082_g11579_i0	PRJNA964500	11671	176	2.204082	3.87918432	Mycoplasma	2093	Bacteria	Bacteria	135	1.43e-27	NTclustered	gi\|334192594\|gb\|CP002808.1\|	859194	g11579	i0	81.006	3.60795454545455	179	26	100	6	1	176	210060	210233	Mycoplasma haemofelis Ohio2, complete genome	blastn	635	135	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
31353091	31353091	PRJNA964500_S_NODE_6796_length_219_cov_1.868421_g6704_i0	PRJNA964500	6796	219	1.868421	4.09184199	Mycoplasma wenyonii	65123	Bacteria	Bacteria	139	2.5e-41	NR	WP_110555200.1	65123	g6704	i0	100	0.917808219178082	67	0	91.8	0	218	18	10	76	WP_110555200.1 50S ribosomal protein L31 [Mycoplasma wenyonii]	diamond	201	139	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31574602	31574602	PRJNA964500_S_NODE_6556_length_222_cov_2.839378_g6464_i0	PRJNA964500	6556	222	2.839378	6.30341916	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	90.5	4.51e-19	NR	WP_187150740.1	432608	g6464	i0	72.7	1.48648648648649	55	15	74.3	0	222	58	87	141	WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	330	90.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
31732463	31732463	PRJNA964500_S_NODE_13617_length_166_cov_1.576642_g13525_i0	PRJNA964500	13617	166	1.576642	2.61722572	Mycoplasma wenyonii	65123	Bacteria	Bacteria	105	1.89e-25	NR	WP_112665901.1	65123	g13525	i0	100	0.993975903614458	55	0	99.4	0	166	2	42	96	WP_112665901.1 hypothetical protein [Mycoplasma wenyonii]	diamond	165	105	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31764198	31764198	PRJNA964500_S_NODE_14097_length_164_cov_1.651852_g14005_i0	PRJNA964500	14097	164	1.651852	2.70903728	Mycoplasma ovis	171632	Bacteria	Bacteria	101	6.3299999999999986e-24	NR	WP_024071110.1	171632	g14005	i0	83.3	0.98780487804878	54	9	98.8	0	3	164	260	313	WP_024071110.1 DnaJ domain-containing protein [Mycoplasma ovis]	diamond	162	101	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
31922361	31922361	PRJNA964500_S_NODE_17297_length_151_cov_2.434426_g17205_i0	PRJNA964500	17297	151	2.434426	3.67598326	Mycoplasma wenyonii	65123	Bacteria	Bacteria	62.4	3.49e-11	NR	WP_112665845.1	65123	g17205	i0	75.7	0.735099337748344	37	9	73.5	0	35	145	1	37	WP_112665845.1 hypothetical protein [Mycoplasma wenyonii]	diamond	111	62.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32365581	32365581	PRJNA964500_S_NODE_6639_length_221_cov_1.854167_g6547_i0	PRJNA964500	6639	221	1.854167	4.09770907	Mycoplasma wenyonii	65123	Bacteria	Bacteria	93.2	1.44e-21	NR	WP_112665629.1	65123	g6547	i0	84.3	0.692307692307692	51	8	69.2	0	177	25	91	141	WP_112665629.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii]	diamond	153	93.2	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);;