metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1072736" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1072736" 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
186974	186974	PRJNA1072736_S_NODE_7761_length_150_cov_0.878505_g7756_i0	PRJNA1072736	7761	150	0.878505	1.3177575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	8.92e-44	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7756	i0	89.333	1	150	16	100	0	1	150	423319	423170	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1461535	1461535	PRJNA1072736_S_NODE_2202_length_235_cov_1.317708_g2197_i0	PRJNA1072736	2202	235	1.317708	3.0966138	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	1.14e-74	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2197	i0	89.655	0.987234042553191	232	21	97	3	1	229	141303	141534	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	232	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737516	2737516	PRJNA1072736_S_NODE_1443_length_270_cov_2.140969_g1438_i0	PRJNA1072736	1443	270	2.140969	5.7806163	Mycoplasma wenyonii	65123	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1438	i0	99.63	34.262962962963	270	1	100	0	1	270	605006	604737	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	9251	494	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2737519	2737519	PRJNA1072736_S_NODE_4063_length_189_cov_1.883562_g4058_i0	PRJNA1072736	4063	189	1.883562	3.55993218	Mycoplasma wenyonii	65123	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4058	i0	98.413	1	189	3	100	0	1	189	577516	577328	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	189	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013404	4013404	PRJNA1072736_S_NODE_1024_length_303_cov_2.192308_g1019_i0	PRJNA1072736	1024	303	2.192308	6.64269324	Mycoplasma wenyonii	65123	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1019	i0	98.333	2.03630363036304	300	5	99	0	4	303	549161	548862	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	617	527	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4013409	4013409	PRJNA1072736_S_NODE_964_length_309_cov_1.334586_g959_i0	PRJNA1072736	964	309	1.334586	4.12387074	Mycoplasma wenyonii	65123	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g959	i0	98.701	0.996763754045307	308	4	99	0	1	308	86481	86174	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	308	547	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289738	5289738	PRJNA1072736_S_NODE_1585_length_262_cov_2.429224_g1580_i0	PRJNA1072736	1585	262	2.429224	6.36456688	Mycoplasma wenyonii	65123	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1580	i0	96.212	1.00763358778626	264	6	100	3	1	262	441576	441315	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	264	429	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5289739	5289739	PRJNA1072736_S_NODE_2465_length_226_cov_1.284153_g2460_i0	PRJNA1072736	2465	226	1.284153	2.90218578	Mycoplasma wenyonii	65123	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2460	i0	100	2.88053097345133	226	0	100	0	1	226	381015	380790	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	651	418	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16763878	16763878	PRJNA1072736_S_NODE_3014_length_210_cov_1.970060_g3009_i0	PRJNA1072736	3014	210	1.97006	4.137126	Mycoplasma wenyonii	65123	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3009	i0	97.143	1	210	6	100	0	1	210	304110	303901	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	355	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19312639	19312639	PRJNA1072736_S_NODE_3596_length_197_cov_1.272727_g3591_i0	PRJNA1072736	3596	197	1.272727	2.50727219	Mycoplasma wenyonii	65123	Bacteria	Bacteria	320	4.24e-83	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3591	i0	95.96	1.00507614213198	198	7	100	1	1	197	144696	144499	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	198	320	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863821	21863821	PRJNA1072736_S_NODE_4378_length_184_cov_1.375887_g4373_i0	PRJNA1072736	4378	184	1.375887	2.53163208	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	3.869999999999999e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4373	i0	100	0.989130434782609	182	0	99	0	1	182	498163	498344	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	182	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21863824	21863824	PRJNA1072736_S_NODE_5058_length_175_cov_1.424242_g5053_i0	PRJNA1072736	5058	175	1.424242	2.4924235	Mycoplasma wenyonii	65123	Bacteria	Bacteria	287	3.71e-73	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5053	i0	96.552	0.994285714285714	174	4	99	2	3	175	413486	413314	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	174	287	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23139283	23139283	PRJNA1072736_S_NODE_2599_length_222_cov_1.402235_g2594_i0	PRJNA1072736	2599	222	1.402235	3.1129617	Mycoplasma ovis	171632	Bacteria	Bacteria	178	3.11e-40	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g2594	i0	81.25	1.00900900900901	224	38	100	4	1	222	436868	436647	Mycoplasma ovis str. Michigan, complete genome	blastn	224	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis

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