metadata: contig_metadata: 5 rows where bioproject = "PRJNA345071" and tax

5 rows where bioproject = "PRJNA345071" and tax_phylum = "Acidobacteriota"

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
24022181	24022181	PRJNA345071_P_NODE_6079_length_273_cov_1.170000_g6039_i0	PRJNA345071	6079	273	1.17	3.1941	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	93.2	2.3e-20	NR	MEO7650235.1	2212468	g6039	i0	78.3	1.32967032967033	60	13	65.9	0	7	186	256	315	MEO7650235.1 cysteine synthase A [Bryobacteraceae bacterium]	diamond	363	93.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
26631619	26631619	PRJNA345071_P_NODE_1301_length_477_cov_5.650990_g1261_i0	PRJNA345071	1301	477	5.65099	26.9552223	Candidatus Korobacter sp.	2510641	Bacteria	Bacteria	46.2	0.023	NR	HEY3926946.1	2510641	g1261	i0	33.7	0.578616352201258	92	56	54.7	2	105	365	307	398	HEY3926946.1 SLBB domain-containing protein [Candidatus Korobacter sp.]	diamond	276	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter sp.
27502910	27502910	PRJNA345071_P_NODE_4423_length_302_cov_1.362445_g4383_i0	PRJNA345071	4423	302	1.362445	4.1145839	Bacteria	2	Bacteria	Bacteria	62.8	6.53e-9	NR	MEP7116495.1	1978231	g4383	i0	55.6	2.64238410596026	45	20	44.7	0	166	300	4	48	MEP7116495.1 pyridoxal-phosphate dependent enzyme [Acidobacteriota bacterium]	diamond	798	62.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32097859	32097859	PRJNA345071_P_NODE_9218_length_247_cov_0.896552_g9178_i0	PRJNA345071	9218	247	0.896552	2.21448344	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	56.2	6.88e-7	NR	HET6977948.1	2283092	g9178	i0	36.8	0.923076923076923	76	48	92.3	0	230	3	473	548	HET6977948.1 NACHT domain-containing protein [Pyrinomonadaceae bacterium]	diamond	228	56.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32463311	32463311	PRJNA345071_P_NODE_2739_length_356_cov_1.434629_g2699_i0	PRJNA345071	2739	356	1.434629	5.1072792400000004	Bacteria	2	Bacteria	Bacteria	65.5	1.5e-9	NR	OFW14145.1	1797190	g2699	i0	43.8	1.29775280898876	80	40	63.2	1	3	227	875	954	OFW14145.1 MAG: hypothetical protein A3F69_06655, partial [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_66_10]	diamond	462	65.9	0.993930197268589	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium RIFCSPLOWO2_12_FULL_66_10

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