metadata: contig_metadata: 12 rows where bioproject = "PRJNA1123686", tax_phylum = "Mycoplasmatota" and tax

12 rows where bioproject = "PRJNA1123686", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

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
280886	280886	PRJNA1123686_S_NODE_10561_length_186_cov_6.318471_g10529_i0	PRJNA1123686	10561	186	6.318471	11.75235606	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	8.61e-75	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10529	i0	95.135	0.99462365591397806	185	9	99	0	1	185	258402	258218	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	185	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
280945	280945	PRJNA1123686_S_NODE_7041_length_209_cov_4.155556_g7009_i0	PRJNA1123686	7041	209	4.155556	8.68511204	Mycoplasma wenyonii	65123	Bacteria	Bacteria	353	4.489999999999999e-93	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7009	i0	97.129	1	209	6	100	0	1	209	323239	323031	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	209	353	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1555481	1555481	PRJNA1123686_S_NODE_15682_length_166_cov_1.635036_g15650_i0	PRJNA1123686	15682	166	1.635036	2.71415976	Mycoplasma wenyonii	65123	Bacteria	Bacteria	263	5.9e-66	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15650	i0	95.181	1	166	8	100	0	1	166	612284	612449	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	166	263	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4107941	4107941	PRJNA1123686_S_NODE_4924_length_231_cov_14.485149_g4892_i0	PRJNA1123686	4924	231	14.485149	33.46069419	Mycoplasma wenyonii	65123	Bacteria	Bacteria	368	1.7999999999999995e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4892	i0	96.018	0.978354978354978	226	9	98	0	5	230	565821	566046	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	226	368	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5384059	5384059	PRJNA1123686_S_NODE_4465_length_236_cov_2.913043_g4433_i0	PRJNA1123686	4465	236	2.913043	6.87478148	Mycoplasma wenyonii	65123	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4433	i0	100	1	236	0	100	0	1	236	528805	528570	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	236	436	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5384072	5384072	PRJNA1123686_S_NODE_9325_length_193_cov_5.835366_g9293_i0	PRJNA1123686	9325	193	5.835366	11.26225638	Mycoplasma wenyonii	65123	Bacteria	Bacteria	178	2.63e-40	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9293	i0	83.42	1.75647668393782	193	30	99	2	2	193	638832	638641	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	339	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16858109	16858109	PRJNA1123686_S_NODE_2394_length_274_cov_6.220408_g2362_i0	PRJNA1123686	2394	274	6.220408	17.04391792	Mycoplasma wenyonii	65123	Bacteria	Bacteria	466	7.58e-127	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2362	i0	97.436	0.996350364963504	273	7	99	0	2	274	96527	96799	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	273	466	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27891372	27891372	PRJNA1123686_S_NODE_6485_length_214_cov_4.491892_g6453_i0	PRJNA1123686	6485	214	4.491892	9.61264888	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	144	3.929999999999999e-40	NR	WP_187150667.1	432608	g6453	i0	97.1	0.981308411214953	70	2	98.1	0	2	211	197	266	WP_187150667.1 hypothetical protein [Candidatus Mycoplasma haematobovis]	diamond	210	144	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematobovis
28523102	28523102	PRJNA1123686_S_NODE_6007_length_219_cov_4.126316_g5975_i0	PRJNA1123686	6007	219	4.126316	9.03663204	Mycoplasma wenyonii	65123	Bacteria	Bacteria	62.4	1.38e-9	NR	WP_014850079.1	65123	g5975	i0	51.9	1.50684931506849	54	24	74	1	162	1	164	215	WP_014850079.1 hypothetical protein [Mycoplasma wenyonii]	diamond	330	62.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
29186257	29186257	PRJNA1123686_S_NODE_20169_length_154_cov_2.448000_g20137_i0	PRJNA1123686	20169	154	2.448	3.76992	Mycoplasma wenyonii	65123	Bacteria	Bacteria	74.7	5.9e-14	NR	WP_014849727.1	65123	g20137	i0	86.7	1.75324675324675	45	6	87.7	0	136	2	77	121	WP_014849727.1 hypothetical protein [Mycoplasma wenyonii]	diamond	270	74.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32599585	32599585	PRJNA1123686_S_NODE_21480_length_151_cov_2.344262_g21448_i0	PRJNA1123686	21480	151	2.344262	3.53983562	Mycoplasma wenyonii	65123	Bacteria	Bacteria	72.4	2.44e-13	NR	WP_110555174.1	65123	g21448	i0	77.1	0.95364238410596	48	11	95.4	0	1	144	274	321	WP_110555174.1 L-lactate dehydrogenase [Mycoplasma wenyonii]	diamond	144	72.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
32630771	32630771	PRJNA1123686_S_NODE_7280_length_207_cov_5.050562_g7248_i0	PRJNA1123686	7280	207	5.050562	10.45466334	Candidatus Mycoplasma haematobovis	432608	Bacteria	Bacteria	62.4	1.9e-9	NR	WP_187150208.1	432608	g7248	i0	100	0.434782608695652	30	0	43.5	0	190	101	255	284	WP_187150208.1 50S ribosomal protein L2 [Candidatus Mycoplasma haematobovis]	diamond	90	62.4	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);;