metadata: contig_metadata: 5 rows where bioproject = "PRJNA382357" and tax

5 rows where bioproject = "PRJNA382357" 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
29253827	29253827	PRJNA382357_P_NODE_68289_length_286_cov_1.724444_g67550_i0	PRJNA382357	68289	286	1.724444	4.93190984	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	53.5	8.01e-7	NR	HEV3111766.1	2785449	g67550	i0	72.7	0.346153846153846	33	9	34.6	0	100	2	1	33	HEV3111766.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	99	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30818745	30818745	PRJNA382357_P_NODE_106274_length_235_cov_19.379310_g105535_i0	PRJNA382357	106274	235	19.37931	45.5413785	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	3.39e-10	NR	HZV89050.1	2811406	g105535	i0	47.1	4.46808510638298	70	31	81.7	1	234	43	71	140	HZV89050.1 hypothetical protein [Candidatus Binatus sp.]	diamond	1050	64.7	0.993817619783617	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
31086117	31086117	PRJNA382357_P_NODE_118575_length_224_cov_2.582822_g117836_i0	PRJNA382357	118575	224	2.582822	5.78552128	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	68.6	1.75e-12	NR	HEY7714618.1	2838779	g117836	i0	50.9	0.736607142857143	55	27	73.7	0	2	166	59	113	HEY7714618.1 arsenate reductase [Candidatus Binatia bacterium]	diamond	165	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31324319	31324319	PRJNA382357_P_NODE_41015_length_358_cov_3.895623_g40276_i0	PRJNA382357	41015	358	3.895623	13.94633034	Pseudomonadati	3379134	Bacteria	Bacteria	53.1	1.31e-5	NR	HEY2987059.1	2838779	g40276	i0	43.4	4.27374301675978	53	28	42.7	1	331	179	44	96	HEY2987059.1 peroxiredoxin [Candidatus Binatia bacterium]	diamond	1530	53.5	0.992523364485981	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32288429	32288429	PRJNA382357_P_NODE_43939_length_348_cov_1.358885_g43200_i0	PRJNA382357	43939	348	1.358885	4.7289198	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	193	1.2799999999999999e-54	NR	HVB80755.1	2785449	g43200	i0	79.3	1.99137931034483	116	24	100	0	348	1	294	409	HVB80755.1 DUF1156 domain-containing protein [Candidatus Binataceae bacterium]	diamond	693	193	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae 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);;