metadata: contig_metadata: 5 rows where bioproject = "PRJNA767802", tax_phylum = "Acidobacteriota" and tax

5 rows where bioproject = "PRJNA767802", tax_phylum = "Acidobacteriota" 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
21147693	21147693	PRJNA767802_P_NODE_12197_length_200_cov_1.350993_g12124_i0	PRJNA767802	12197	200	1.350993	2.701986	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	259	9.54e-65	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g12124	i0	93.678	420.625	174	10	87	1	1	173	2286437	2286610	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	84125	259	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
27242819	27242819	PRJNA767802_P_NODE_16883_length_165_cov_0.879310_g16810_i0	PRJNA767802	16883	165	0.87931	1.4508615	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	66.2	6.44e-11	NR	HLA96136.1	2283092	g16810	i0	63.5	0.945454545454545	52	19	94.5	0	163	8	5	56	HLA96136.1 aldehyde dehydrogenase family protein [Pyrinomonadaceae bacterium]	diamond	156	66.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27464174	27464174	PRJNA767802_P_NODE_18263_length_162_cov_0.902655_g18190_i0	PRJNA767802	18263	162	0.902655	1.4623011	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	63.5	5.55e-10	NR	HKT90090.1	2771375	g18190	i0	58.3	0.888888888888889	48	20	88.9	0	6	149	692	739	HKT90090.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.]	diamond	144	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
30147760	30147760	PRJNA767802_P_NODE_9232_length_240_cov_1.314136_g9159_i0	PRJNA767802	9232	240	1.314136	3.1539264	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	65.1	4.75e-10	NR	HKT90090.1	2771375	g9159	i0	41.9	0.925	74	42	92.5	1	226	5	618	690	HKT90090.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.]	diamond	222	65.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
30843218	30843218	PRJNA767802_P_NODE_6734_length_301_cov_1.940476_g6661_i0	PRJNA767802	6734	301	1.940476	5.84083276	Blastocatellia bacterium	2052146	Bacteria	Bacteria	49.3	3.32e-4	NR	MBA2335159.1	2052146	g6661	i0	50.9	0.847176079734219	53	23	52.8	2	19	177	234	283	MBA2335159.1 fumarylacetoacetate hydrolase family protein [Blastocatellia bacterium]	diamond	255	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia 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);;