metadata: contig_metadata: 5 rows where bioproject = "PRJNA724011", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA724011", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"

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_clade	tax_phylum	tax_class	tax_species
28694585	28694585	PRJNA724011_P_NODE_52587_length_355_cov_3.436170_g51564_i0	PRJNA724011	52587	355	3.43617	12.1984035	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	133	1.09e-33	NR	HEX9879458.1	2838779	g51564	i0	54.5	2.7887323943662	110	50	93	0	19	348	405	514	HEX9879458.1 glycoside hydrolase family 15 protein [Candidatus Binatia bacterium]	diamond	990	133	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30589233	30589233	PRJNA724011_P_NODE_9753_length_1010_cov_3.613661_g8964_i0	PRJNA724011	9753	1010	3.613661	36.4979761	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	115	2.08e-24	NR	HLK10367.1	2838779	g8964	i0	32.4	0.825742574257426	278	158	80.2	11	942	133	321	576	HLK10367.1 pepsin-like aspartic protease [Candidatus Binatia bacterium]	diamond	834	115	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31506117	31506117	PRJNA724011_P_NODE_95916_length_250_cov_0.870056_g94893_i0	PRJNA724011	95916	250	0.870056	2.17514	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	46.2	9.23e-4	NR	HJY81241.1	2838779	g94893	i0	47.3	1.92	55	28	66	1	229	65	88	141	HJY81241.1 DUF1772 domain-containing protein [Candidatus Binatia bacterium]	diamond	480	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31758868	31758868	PRJNA724011_P_NODE_4397_length_1482_cov_2.232079_g3914_i0	PRJNA724011	4397	1482	2.232079	33.07941078	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	128	1.32e-27	NR	HLK10367.1	2838779	g3914	i0	33.7	1.33603238866397	329	192	64	12	1482	535	254	569	HLK10367.1 pepsin-like aspartic protease [Candidatus Binatia bacterium]	diamond	1980	128	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32497159	32497159	PRJNA724011_P_NODE_13119_length_851_cov_4.519280_g12210_i0	PRJNA724011	13119	851	4.51928	38.4590728	Bacteria candidate phyla	1783234	Bacteria	Bacteria	158	4.34e-41	NR	HEU4341818.1	2838779	g12210	i0	42.5	4.93537015276146	233	127	82.1	4	851	153	229	454	HEU4341818.1 MmgE/PrpD family protein [Candidatus Binatia bacterium]	diamond	4200	159	0.993710691823899	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia 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);;