metadata: contig_metadata: 2 rows where bioproject = "PRJNA849822" and tax_phylum = "Candidatus Buchananiibacteriota"

2 rows where bioproject = "PRJNA849822" and tax_phylum = "Candidatus Buchananiibacteriota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28254988	28254988	PRJNA849822_P_NODE_31886_length_259_cov_1.258065_g31712_i0	PRJNA849822	31886	259	1.258065	3.25838835	Candidatus Buchananbacteria bacterium	2268182	Bacteria	Bacteria	72	2.21e-12		NR	NUM25579.1	2268182	g31712	i0	47.1	0.787644787644788	68	35	78.8	1	35	238	107	173	NUM25579.1 hypothetical protein [Candidatus Buchananbacteria bacterium]	diamond	204	72	1	Bacteria	Bacteria candidate phyla		Candidatus Buchananiibacteriota					Candidatus Buchananbacteria bacterium
28413066	28413066	PRJNA849822_P_NODE_7946_length_540_cov_1.331906_g7774_i0	PRJNA849822	7946	540	1.331906	7.1922924	Candidatus Buchananbacteria bacterium	2268182	Bacteria	Bacteria	52	4.16e-4		NR	MFA6410268.1	2268182	g7774	i0	29.6	0.844444444444444	152	82	77.2	6	445	29	427	566	MFA6410268.1 polymorphic toxin-type HINT domain-containing protein [Candidatus Buchananbacteria bacterium]	diamond	456	52	1	Bacteria	Bacteria candidate phyla		Candidatus Buchananiibacteriota					Candidatus Buchananbacteria 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);;