metadata: contig_metadata: 7 rows where bioproject = "PRJNA1182301" and tax

7 rows where bioproject = "PRJNA1182301" 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
9969490	9969490	PRJNA1182301_P_NODE_19448_length_290_cov_1.069124_g19323_i0	PRJNA1182301	19448	290	1.069124	3.1004596	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	149	2.1499999999999993e-40	NR	MFN8542780.1	2838779	g19323	i0	70.8	6.95172413793103	96	28	99.3	0	288	1	51	146	MFN8542780.1 wax ester/triacylglycerol synthase family O-acyltransferase [Candidatus Binatia bacterium]	diamond	2016	149	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
16895515	16895515	PRJNA1182301_P_NODE_27234_length_279_cov_1.412621_g27109_i0	PRJNA1182301	27234	279	1.412621	3.94121259	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	150	1.65e-40	NR	HJW70415.1	2838779	g27109	i0	80.4	1.97849462365591	92	18	98.9	0	276	1	295	386	HJW70415.1 long-chain fatty acid--CoA ligase [Candidatus Binatia bacterium]	diamond	552	150	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28998922	28998922	PRJNA1182301_P_NODE_28848_length_276_cov_3.482759_g28723_i0	PRJNA1182301	28848	276	3.482759	9.61241484	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	155	8.45e-46	NR	MET0500083.1	2838779	g28723	i0	92.3	3.94565217391304	91	7	98.9	0	2	274	25	115	MET0500083.1 HdeD family acid-resistance protein [Candidatus Binatia bacterium]	diamond	1089	155	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30420127	30420127	PRJNA1182301_P_NODE_58133_length_244_cov_2.608187_g58008_i0	PRJNA1182301	58133	244	2.608187	6.36397628	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	142	3.68e-39	NR	HEX7226830.1	2838779	g58008	i0	98.8	0.995901639344262	81	1	99.6	0	1	243	72	152	HEX7226830.1 MFS transporter [Candidatus Binatia bacterium]	diamond	243	142	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31051968	31051968	PRJNA1182301_P_NODE_21655_length_286_cov_3.056338_g21530_i0	PRJNA1182301	21655	286	3.0563380000000002	8.74112668	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	77.8	2.82e-14	NR	HZR80713.1	2838779	g21530	i0	54.8	2.51748251748252	73	32	75.5	1	284	69	153	225	HZR80713.1 murein biosynthesis integral membrane protein MurJ [Candidatus Binatia bacterium]	diamond	720	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31114655	31114655	PRJNA1182301_P_NODE_59275_length_244_cov_0.900585_g59150_i0	PRJNA1182301	59275	244	0.900585	2.1974274	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	80.5	1.9e-15	NR	HMJ64624.1	2838779	g59150	i0	76.6	0.577868852459016	47	11	57.8	0	103	243	1	47	HMJ64624.1 aminotransferase class V-fold PLP-dependent enzyme [Candidatus Binatia bacterium]	diamond	141	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32317202	32317202	PRJNA1182301_P_NODE_65699_length_234_cov_2.453416_g65574_i0	PRJNA1182301	65699	234	2.453416	5.74099344	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	72.8	8.35e-13	NR	HEY2388140.1	2838779	g65574	i0	60.3	0.743589743589744	58	23	74.4	0	3	176	314	371	HEY2388140.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	174	72.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);;