metadata: contig_metadata: 5 rows where bioproject = "PRJNA1159911", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA1159911", tax_kingdom = "Bacillati" 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_order	tax_family	tax_genus	tax_species
4866022	4866022	PRJNA1159911_P_NODE_73224_length_276_cov_1.975369_g72682_i0	PRJNA1159911	73224	276	1.975369	5.45201844	Metamycoplasmataceae	2895623	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1563788636\|emb\|LR214955.1\|	2115	g72682	i0	100	5	276	0	100	0	1	276	360485	360210	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1	blastn	1380	510	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
15611089	15611089	PRJNA1159911_P_NODE_68393_length_287_cov_2.462617_g67851_i0	PRJNA1159911	68393	287	2.462617	7.06771079	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	503	6.1e-138	NTclustered	gi\|2620084710\|gb\|CP138194.1\|	2231116	g67851	i0	98.258	101.094076655052	287	5	100	0	1	287	162838	162552	MAG: Mycoplasmatota bacterium isolate Ac_bin3.5 chromosome, complete genome	blastn	29014	503	1	Bacteria	Bacillati	Mycoplasmatota				Mycoplasmatota bacterium
18889514	18889514	PRJNA1159911_P_NODE_64275_length_298_cov_1.200000_g63733_i0	PRJNA1159911	64275	298	1.2	3.576	Mesomycoplasma	2923352	Bacteria	Bacteria	544	3.7499999999999997e-150	NTclustered	gi\|557878761\|gb\|CP006849.1\|	634997	g63733	i0	99.664	15	298	0	100	1	1	298	784951	784655	Mycoplasma hyorhinis DBS 1050, complete genome	blastn	4470	544	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
27672412	27672412	PRJNA1159911_P_NODE_99444_length_242_cov_0.911243_g98902_i0	PRJNA1159911	99444	242	0.911243	2.20520806	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	157	4.1399999999999994e-48	NR	WP_367896666.1	2109	g98902	i0	100	0.991735537190083	80	0	99.2	0	242	3	11	90	WP_367896666.1 aldehyde dehydrogenase family protein, partial [Mycoplasmopsis synoviae]	diamond	240	157	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
31841825	31841825	PRJNA1159911_P_NODE_44557_length_373_cov_9.783333_g44015_i0	PRJNA1159911	44557	373	9.783333	36.49183209	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	134	2.57e-34	NR	WP_206602618.1	2094	g44015	i0	94.4	3.48257372654155	72	4	57.9	0	351	136	289	360	WP_206602618.1 NADH-quinone oxidoreductase subunit A [Mycoplasmopsis arginini]	diamond	1299	135	0.992592592592593	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini

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