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

5 rows where bioproject = "PRJNA1195374", 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_class	tax_order	tax_family	tax_genus	tax_species
21998789	21998789	PRJNA1195374_P_NODE_64938_length_267_cov_0.860825_g64594_i0	PRJNA1195374	64938	267	0.860825	2.29840275	Mycoplasma cottewii	51364	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g64594	i0	96.97	0.123595505617978	33	0	12	1	229	261	242304	242273	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	33	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
27660229	27660229	PRJNA1195374_P_NODE_18484_length_527_cov_1.632159_g18141_i0	PRJNA1195374	18484	527	1.632159	8.60147793	Bacillati	1783272	Bacteria	Bacteria	56.6	9.22e-6	NR	MCP4336419.1	2108	g18141	i0	41.8	8.06641366223909	67	38	38.1	1	525	325	610	675	MCP4336419.1 RNA-binding transcriptional accessory protein [Mycoplasma sp.]	diamond	4251	56.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
30957287	30957287	PRJNA1195374_P_NODE_56474_length_289_cov_1.129630_g56130_i0	PRJNA1195374	56474	289	1.12963	3.2646307	Haloplasma contractile	471825	Bacteria	Bacteria	44.7	0.0114	NR	WP_008824474.1	471825	g56130	i0	33.9	0.643598615916955	62	36	64.4	1	36	221	6	62	WP_008824474.1 sporulation transcription factor Spo0A [Haloplasma contractile]	diamond	186	44.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Haloplasmatales	Haloplasmataceae	Haloplasma	Haloplasma contractile
32285715	32285715	PRJNA1195374_P_NODE_21699_length_487_cov_1.659420_g21356_i0	PRJNA1195374	21699	487	1.65942	8.0813754	Acholeplasma oculi	35623	Bacteria	Bacteria	225	6.489999999999999e-72	NR	WP_045749762.1	35623	g21356	i0	84.5	0.794661190965092	129	20	79.5	0	389	3	67	195	WP_045749762.1 uracil phosphoribosyltransferase [Acholeplasma oculi]	diamond	387	225	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma oculi
32380476	32380476	PRJNA1195374_P_NODE_79699_length_245_cov_0.895349_g79355_i0	PRJNA1195374	79699	245	0.895349	2.19360505	Candidatus Izimaplasma bacterium	N/A	Bacteria	Bacteria	43.9	0.0148	NR	MCK5762068.1	2315156	g79355	i0	45.5	0.538775510204082	44	24	53.9	0	48	179	7	50	MCK5762068.1 ferrous iron transport protein B [Candidatus Izimaplasma bacterium]	diamond	132	43.9	1	Bacteria	Bacillati	Mycoplasmatota	Candidatus Izimaplasma				Candidatus Izimaplasma bacterium

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