metadata: contig_metadata: 6 rows where bioproject = "PRJNA1028258", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA1028258", 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_order	tax_family	tax_species
163141	163141	PRJNA1028258_P_NODE_114381_length_249_cov_1.183333_g113818_i0	PRJNA1028258	114381	249	1.183333	2.94649917	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g113818	i0	86.008	95.4578313253012	243	32	97	2	8	249	1849042	1848801	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	23769	259	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27414625	27414625	PRJNA1028258_P_NODE_98923_length_262_cov_1.253886_g98360_i0	PRJNA1028258	98923	262	1.253886	3.28518132	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	48.5	4.22e-4	NR	HZZ07563.1	2785449	g98360	i0	35.5	2.75954198473282	76	45	82.4	1	219	4	127	202	HZZ07563.1 beta-propeller fold lactonase family protein [Candidatus Binataceae bacterium]	diamond	723	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28045719	28045719	PRJNA1028258_P_NODE_111585_length_251_cov_1.450549_g111022_i0	PRJNA1028258	111585	251	1.450549	3.64087799	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	49.7	1.16e-5	NR	HYC55217.1	2838779	g111022	i0	70	0.358565737051793	30	9	35.9	0	92	3	1	30	HYC55217.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	90	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28393124	28393124	PRJNA1028258_P_NODE_64266_length_319_cov_1.136000_g63703_i0	PRJNA1028258	64266	319	1.136	3.62384	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	58.2	3.52e-7	NR	HEV7732924.1	2838779	g63703	i0	51.5	0.620689655172414	66	24	62.1	4	295	98	413	470	HEV7732924.1 putative Ig domain-containing protein [Candidatus Binatia bacterium]	diamond	198	58.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31710223	31710223	PRJNA1028258_P_NODE_89677_length_272_cov_1.399015_g89114_i0	PRJNA1028258	89677	272	1.399015	3.8053208	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	97.4	2e-22	NR	GIW40638.1	2838779	g89114	i0	59.3	5.01838235294118	91	32	99.3	3	272	3	24	110	GIW40638.1 MAG: enoyl-CoA hydratase [Candidatus Binatia bacterium]	diamond	1365	97.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32596026	32596026	PRJNA1028258_P_NODE_18080_length_600_cov_1.868173_g17527_i0	PRJNA1028258	18080	600	1.868173	11.209038	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	45.4	0.048	NR	HZR84528.1	2838779	g17527	i0	49	0.255	51	26	25.5	0	151	303	79	129	HZR84528.1 RdgB/HAM1 family non-canonical purine NTP pyrophosphatase [Candidatus Binatia bacterium]	diamond	153	45.4	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);;