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

5 rows where bioproject = "PRJNA1092581", 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
28078183	28078183	PRJNA1092581_P_NODE_23765_length_571_cov_3.730924_g23239_i0	PRJNA1092581	23765	571	3.730924	21.30357604	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	275	5.669999999999999e-89	NR	HZR79778.1	2838779	g23239	i0	77.8	1.84938704028021	176	39	92.5	0	550	23	106	281	HZR79778.1 type 2 isopentenyl-diphosphate Delta-isomerase [Candidatus Binatia bacterium]	diamond	1056	275	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28836008	28836008	PRJNA1092581_P_NODE_78968_length_291_cov_5.041284_g78435_i0	PRJNA1092581	78968	291	5.041284	14.67013644	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	103	1.98e-24	NR	HSE90985.1	2838779	g78435	i0	91.7	0.618556701030928	60	5	61.9	0	19	198	125	184	HSE90985.1 FAD binding domain-containing protein [Candidatus Binatia bacterium]	diamond	180	103	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29909770	29909770	PRJNA1092581_P_NODE_74851_length_301_cov_2.192982_g74318_i0	PRJNA1092581	74851	301	2.192982	6.60087582	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	192	3.39e-58	NR	HEY7553280.1	2838779	g74318	i0	85	1.99335548172757	100	15	99.7	0	2	301	129	228	HEY7553280.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	600	192	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30541461	30541461	PRJNA1092581_P_NODE_108073_length_242_cov_14.124260_g107540_i0	PRJNA1092581	108073	242	14.12426	34.1807092	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	85.1	6.43e-19	NR	HZR80362.1	2838779	g107540	i0	64.6	0.805785123966942	65	23	80.6	0	36	230	41	105	HZR80362.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	195	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31110031	31110031	PRJNA1092581_P_NODE_36955_length_452_cov_2.891821_g36423_i0	PRJNA1092581	36955	452	2.891821	13.07103092	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	80.1	3.15e-14	NR	HLK10367.1	2838779	g36423	i0	38.9	0.836283185840708	126	68	83	5	64	438	321	438	HLK10367.1 pepsin-like aspartic protease [Candidatus Binatia bacterium]	diamond	378	80.1	1	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);;