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

5 rows where bioproject = "PRJNA928559", 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
20029787	20029787	PRJNA928559_P_NODE_191656_length_251_cov_2.056180_g190087_i0	PRJNA928559	191656	251	2.05618	5.1610118	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	80.9	9.88e-17	NR	HVN64654.1	2785449	g190087	i0	57.7	0.932270916334661	78	33	93.2	0	244	11	78	155	HVN64654.1 tetratricopeptide repeat protein [Candidatus Binataceae bacterium]	diamond	234	80.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
27877718	27877718	PRJNA928559_P_NODE_225845_length_212_cov_9.158273_g224276_i0	PRJNA928559	225845	212	9.158273	19.41553876	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	63.9	2.82e-11	NR	HTD85300.1	2838779	g224276	i0	71.4	0.693396226415094	49	12	66.5	1	8	148	46	94	HTD85300.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	147	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28446199	28446199	PRJNA928559_P_NODE_62226_length_442_cov_3.073171_g60657_i0	PRJNA928559	62226	442	3.073171	13.58341582	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	127	1.6199999999999996e-34	NR	HJX09685.1	2838779	g60657	i0	53.3	0.828054298642534	122	54	80.8	2	400	44	4	125	HJX09685.1 DUF1902 domain-containing protein [Candidatus Binatia bacterium]	diamond	366	127	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28737392	28737392	PRJNA928559_P_NODE_195267_length_250_cov_0.881356_g193698_i0	PRJNA928559	195267	250	0.881356	2.20339	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	1.89e-7	NR	MEO6026403.1	2838779	g193698	i0	44.2	4.74	77	41	92.4	1	236	6	166	240	MEO6026403.1 IPT/TIG domain-containing protein [Candidatus Binatia bacterium]	diamond	1185	58.2	0.993127147766323	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29677072	29677072	PRJNA928559_P_NODE_25710_length_636_cov_3.941385_g24203_i0	PRJNA928559	25710	636	3.941385	25.0672086	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	224	2.2e-71	NR	HKY07843.1	2838779	g24203	i0	65.1	1.43867924528302	152	53	71.7	0	595	140	4	155	HKY07843.1 M15 family metallopeptidase [Candidatus Binatia bacterium]	diamond	915	224	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);;