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

6 rows where bioproject = "PRJNA703759", 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
26607805	26607805	PRJNA703759_P_NODE_40081_length_249_cov_0.886364_g39605_i0	PRJNA703759	40081	249	0.886364	2.20704636	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	92	5.48e-20	NR	HKA28844.1	2838779	g39605	i0	58.3	1.01204819277108	84	31	96.4	2	3	242	168	251	HKA28844.1 RNA polymerase sigma factor [Candidatus Binatia bacterium]	diamond	252	92	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
27588433	27588433	PRJNA703759_P_NODE_39024_length_250_cov_0.881356_g38548_i0	PRJNA703759	39024	250	0.881356	2.20339	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	87.4	6.95e-18	NR	HZP43943.1	2838779	g38548	i0	55	1.908	80	36	96	0	1	240	397	476	HZP43943.1 ammonium transporter [Candidatus Binatia bacterium]	diamond	477	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31694647	31694647	PRJNA703759_P_NODE_46317_length_245_cov_0.906977_g45841_i0	PRJNA703759	46317	245	0.906977	2.22209365	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	121	1.8e-30	NR	HMJ64301.1	2838779	g45841	i0	66.7	0.991836734693878	81	24	99.2	1	1	243	67	144	HMJ64301.1 molybdopterin-dependent oxidoreductase [Candidatus Binatia bacterium]	diamond	243	121	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32148843	32148843	PRJNA703759_P_NODE_35078_length_253_cov_0.866667_g34602_i0	PRJNA703759	35078	253	0.866667	2.19266751	Pseudomonadati	3379134	Bacteria	Bacteria	163	1.88e-47	NR	HME61353.1	2838779	g34602	i0	88.1	6.97233201581028	84	10	99.6	0	252	1	165	248	HME61353.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium]	diamond	1764	163	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32422399	32422399	PRJNA703759_P_NODE_33699_length_255_cov_1.148352_g33223_i0	PRJNA703759	33699	255	1.148352	2.9282976	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	145	1.26e-40	NR	HYD73276.1	2838779	g33223	i0	78.6	1.97647058823529	84	18	98.8	0	254	3	147	230	HYD73276.1 complex I NDUFA9 subunit family protein [Candidatus Binatia bacterium]	diamond	504	145	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32674808	32674808	PRJNA703759_P_NODE_42560_length_247_cov_1.775862_g42084_i0	PRJNA703759	42560	247	1.775862	4.38637914	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	58.2	1.36e-7	NR	MFN8546050.1	2838779	g42084	i0	52.3	0.534412955465587	44	21	53.4	0	244	113	313	356	MFN8546050.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	132	58.2	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);;