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

6 rows where bioproject = "PRJNA897077", 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
3424388	3424388	PRJNA897077_P_NODE_15743_length_252_cov_0.871508_g15616_i0	PRJNA897077	15743	252	0.871508	2.19620016	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	160	1.16e-45	NR	HEY6364415.1	2838779	g15616	i0	96.4	0.988095238095238	83	3	98.8	0	250	2	101	183	HEY6364415.1 hydantoinase/oxoprolinase family protein [Candidatus Binatia bacterium]	diamond	249	160	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
3424413	3424413	PRJNA897077_P_NODE_17243_length_248_cov_0.891429_g17116_i0	PRJNA897077	17243	248	0.891429	2.21074392	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	152	2.94e-42	NR	HJQ83281.1	2838779	g17116	i0	92.7	0.991935483870968	82	6	99.2	0	247	2	295	376	HJQ83281.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Candidatus Binatia bacterium]	diamond	246	152	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
12352553	12352553	PRJNA897077_P_NODE_17530_length_248_cov_0.891429_g17403_i0	PRJNA897077	17530	248	0.891429	2.21074392	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	126	1.64e-31	NR	HSF59085.1	2838779	g17403	i0	86.4	1.95967741935484	81	11	98	0	4	246	144	224	HSF59085.1 putative monovalent cation/H+ antiporter subunit A [Candidatus Binatia bacterium]	diamond	486	126	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30213538	30213538	PRJNA897077_P_NODE_18972_length_244_cov_0.912281_g18845_i0	PRJNA897077	18972	244	0.912281	2.22596564	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	131	3.21e-36	NR	HEX9662780.1	2838779	g18845	i0	97	0.811475409836066	66	2	81.1	0	45	242	1	66	HEX9662780.1 ferritin-like domain-containing protein [Candidatus Binatia bacterium]	diamond	198	131	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31066980	31066980	PRJNA897077_P_NODE_18095_length_246_cov_0.901734_g17968_i0	PRJNA897077	18095	246	0.901734	2.21826564	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	164	3e-48	NR	HEY7559357.1	2838779	g17968	i0	92.6	0.98780487804878	81	6	98.8	0	2	244	52	132	HEY7559357.1 polysaccharide deacetylase family protein [Candidatus Binatia bacterium]	diamond	243	164	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31635885	31635885	PRJNA897077_P_NODE_15676_length_252_cov_0.871508_g15549_i0	PRJNA897077	15676	252	0.871508	2.19620016	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	107	4.57e-25	NR	HEY2389091.1	2838779	g15549	i0	66.7	2	84	26	100	1	1	252	353	434	HEY2389091.1 sigma-54 dependent transcriptional regulator [Candidatus Binatia bacterium]	diamond	504	107	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);;