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

5 rows where bioproject = "PRJNA867519", 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
17426352	17426352	PRJNA867519_P_NODE_28854_length_247_cov_0.885057_g28700_i0	PRJNA867519	28854	247	0.885057	2.18609079	[Mycoplasma] gypis	92404	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2702675406\|gb\|CP148066.1\|	92404	g28700	i0	100	0.11336032388664	28	0	11	0	139	166	194722	194695	[Mycoplasma] gypis strain B1/T1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	[Mycoplasma] gypis
27347943	27347943	PRJNA867519_P_NODE_27143_length_249_cov_0.875000_g26989_i0	PRJNA867519	27143	249	0.875	2.17875	FCB group	1783270	Bacteria	Bacteria	90.9	1.15e-19	NR	WP_262097027.1	69473	g26989	i0	53.2	4.09638554216868	79	36	94	1	238	5	33	111	WP_262097027.1 DUF1295 domain-containing protein [Paracholeplasma vituli]	diamond	1020	90.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma vituli
29549635	29549635	PRJNA867519_P_NODE_17310_length_287_cov_2.883178_g17156_i0	PRJNA867519	17310	287	2.883178	8.27472086	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	78.6	1.26e-14	NR	MCI9653063.1	2053494	g17156	i0	41.7	6.01045296167247	96	55	99.3	1	286	2	227	322	MCI9653063.1 ATP-dependent DNA helicase RecQ [Acholeplasmatales bacterium]	diamond	1725	78.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
29992007	29992007	PRJNA867519_P_NODE_18391_length_283_cov_1.133333_g18237_i0	PRJNA867519	18391	283	1.133333	3.20733239	Tenericutes bacterium HGW-Tenericutes-8	2013851	Bacteria	Bacteria	58.9	1.83e-8	NR	PKK85448.1	2013851	g18237	i0	55.8	1.48409893992933	52	18	49.8	1	282	142	67	118	PKK85448.1 MAG: hypothetical protein CVV63_05210, partial [Tenericutes bacterium HGW-Tenericutes-8]	diamond	420	58.9	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium HGW-Tenericutes-8
32236842	32236842	PRJNA867519_P_NODE_14558_length_308_cov_1.876596_g14404_i0	PRJNA867519	14558	308	1.876596	5.77991568	Spiroplasmataceae bacterium	2872178	Bacteria	Bacteria	51.2	3.25e-5	NR	MDR1670719.1	2872178	g14404	i0	39.3	0.545454545454545	56	33	53.6	1	3	167	76	131	MDR1670719.1 hypothetical protein [Spiroplasmataceae bacterium]	diamond	168	51.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae		Spiroplasmataceae 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);;