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

5 rows where bioproject = "PRJNA533114", 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
28246089	28246089	PRJNA533114_P_NODE_88486_length_258_cov_1.632432_g88234_i0	PRJNA533114	88486	258	1.632432	4.21167456	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	75.1	1.65e-13	NR	HEV8343262.1	2838779	g88234	i0	47	0.965116279069767	83	44	96.5	0	9	257	302	384	HEV8343262.1 APC family permease [Candidatus Binatia bacterium]	diamond	249	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29288041	29288041	PRJNA533114_P_NODE_29729_length_419_cov_1.326590_g29477_i0	PRJNA533114	29729	419	1.32659	5.5584121	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	49.7	8.61e-4	NR	HUY38613.1	2785449	g29477	i0	37.7	0.494033412887828	69	43	49.4	0	212	418	404	472	HUY38613.1 tetratricopeptide repeat protein [Candidatus Binataceae bacterium]	diamond	207	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
30551422	30551422	PRJNA533114_P_NODE_19753_length_509_cov_1.211009_g19504_i0	PRJNA533114	19753	509	1.211009	6.16403581	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	51.2	6.1e-4	NR	MFI5364735.1	2838779	g19504	i0	31.6	1.39685658153242	136	80	80.2	5	52	459	52	174	MFI5364735.1 proprotein convertase P-domain-containing protein [Candidatus Binatia bacterium]	diamond	711	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31151508	31151508	PRJNA533114_P_NODE_37535_length_377_cov_1.105263_g37283_i0	PRJNA533114	37535	377	1.105263	4.16684151	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	47.8	0.00271	NR	HEY7322682.1	2838779	g37283	i0	42.3	0.413793103448276	52	30	41.4	0	359	204	409	460	HEY7322682.1 MmgE/PrpD family protein [Candidatus Binatia bacterium]	diamond	156	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32512574	32512574	PRJNA533114_P_NODE_83399_length_266_cov_1.284974_g83147_i0	PRJNA533114	83399	266	1.284974	3.41803084	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	50.8	6.98e-5	NR	HEY2772621.1	2838779	g83147	i0	69.7	0.733082706766917	33	10	37.2	0	144	46	295	327	HEY2772621.1 DUF4215 domain-containing protein [Candidatus Binatia bacterium]	diamond	195	50.8	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);;