metadata: contig_metadata: 9 rows where bioproject = "PRJNA929922", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA929922", 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_genus	tax_species
9833513	9833513	PRJNA929922_P_NODE_112448_length_250_cov_0.870056_g111908_i0	PRJNA929922	112448	250	0.870056	2.17514	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	103	1.3799999999999998e-23	NR	MEO6026039.1	2838779	g111908	i0	71.8	14.748	78	22	93.6	0	245	12	83	160	MEO6026039.1 amidohydrolase [Candidatus Binatia bacterium]	diamond	3687	103	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
26676390	26676390	PRJNA929922_P_NODE_145921_length_244_cov_0.900585_g145381_i0	PRJNA929922	145921	244	0.900585	2.1974274	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	118	7.249999999999999e-32	NR	HEV7730895.1	2838779	g145381	i0	74.7	0.971311475409836	79	20	97.1	0	244	8	81	159	HEV7730895.1 chemotaxis protein CheX [Candidatus Binatia bacterium]	diamond	237	118	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
26961433	26961433	PRJNA929922_P_NODE_126542_length_248_cov_0.880000_g126002_i0	PRJNA929922	126542	248	0.88	2.1824	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	83.6	4.74e-19	NR	HEY1851577.1	2785449	g126002	i0	76.6	0.568548387096774	47	11	56.9	0	1	141	29	75	HEY1851577.1 tail protein X [Candidatus Binataceae bacterium]	diamond	141	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
28414673	28414673	PRJNA929922_P_NODE_120506_length_249_cov_0.875000_g119966_i0	PRJNA929922	120506	249	0.875	2.17875	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	109	1.55e-25	NR	HWX22170.1	2838779	g119966	i0	67.1	0.987951807228916	82	27	98.8	0	1	246	388	469	HWX22170.1 LamG-like jellyroll fold domain-containing protein [Candidatus Binatia bacterium]	diamond	246	109	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29961738	29961738	PRJNA929922_P_NODE_153271_length_243_cov_0.905882_g152731_i0	PRJNA929922	153271	243	0.905882	2.20129326	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	96.3	2.51e-21	NR	HYZ01223.1	2838779	g152731	i0	77.2	0.703703703703704	57	13	70.4	0	232	62	342	398	HYZ01223.1 FAD-binding oxidoreductase [Candidatus Binatia bacterium]	diamond	171	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30056362	30056362	PRJNA929922_P_NODE_117791_length_249_cov_0.875000_g117251_i0	PRJNA929922	117791	249	0.875	2.17875	Candidatus Binatus sp.	2811406	Bacteria	Bacteria	68.2	4.38e-11	NR	HSY93907.1	2811406	g117251	i0	55.9	0.710843373493976	59	26	71.1	0	178	2	524	582	HSY93907.1 ABC transporter permease [Candidatus Binatus sp.]	diamond	177	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
30341382	30341382	PRJNA929922_P_NODE_112712_length_250_cov_0.870056_g112172_i0	PRJNA929922	112712	250	0.870056	2.17514	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	75.5	2.31e-15	NR	HKN01241.1	2785449	g112172	i0	57.3	0.9	75	31	90	1	246	22	16	89	HKN01241.1 DUF2924 domain-containing protein [Candidatus Binataceae bacterium]	diamond	225	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30719928	30719928	PRJNA929922_P_NODE_155854_length_242_cov_0.911243_g155314_i0	PRJNA929922	155854	242	0.911243	2.20520806	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	48.1	1.16e-4	NR	HVB82914.1	2785449	g155314	i0	52.1	1.83471074380165	48	23	59.5	0	227	84	60	107	HVB82914.1 FCD domain-containing protein [Candidatus Binataceae bacterium]	diamond	444	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
32142979	32142979	PRJNA929922_P_NODE_150318_length_243_cov_0.905882_g149778_i0	PRJNA929922	150318	243	0.905882	2.20129326	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	144	2.49e-40	NR	HEX9263297.1	2838779	g149778	i0	86.1	1.96296296296296	79	11	97.5	0	2	238	30	108	HEX9263297.1 amidohydrolase family protein [Candidatus Binatia bacterium]	diamond	477	144	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);;