metadata: contig_metadata: 10 rows where bioproject = "PRJNA734348", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA734348", 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
10921532	10921532	PRJNA734348_P_NODE_149569_length_200_cov_4.732283_g148871_i0	PRJNA734348	149569	200	4.732283	9.464566	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	122	7.169999999999999e-31	NR	MBY0275353.1	2838779	g148871	i0	98.5	1.98	66	1	99	0	199	2	391	456	MBY0275353.1 NADH-quinone oxidoreductase subunit N [Candidatus Binatia bacterium]	diamond	396	122	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
12676987	12676987	PRJNA734348_P_NODE_59190_length_280_cov_2.207729_g58493_i0	PRJNA734348	59190	280	2.207729	6.1816412	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	174	1.3499999999999999e-48	NR	HVQ78328.1	2838779	g58493	i0	81.7	2.97857142857143	93	17	99.6	0	279	1	10	102	HVQ78328.1 glycogen debranching protein GlgX [Candidatus Binatia bacterium]	diamond	834	174	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
23671679	23671679	PRJNA734348_P_NODE_63199_length_276_cov_2.197044_g62502_i0	PRJNA734348	63199	276	2.197044	6.06384144	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	58.4	5.45e-4	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g62502	i0	87.755	0.652173913043478	49	6	18	0	1	49	498811	498859	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	180	58.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
26704020	26704020	PRJNA734348_P_NODE_41881_length_310_cov_2.379747_g41185_i0	PRJNA734348	41881	310	2.379747	7.3772157	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	74.3	6.18e-13	NR	HJY85046.1	2838779	g41185	i0	68.1	0.454838709677419	47	15	45.5	0	166	306	250	296	HJY85046.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	141	74.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28031684	28031684	PRJNA734348_P_NODE_149085_length_202_cov_4.627907_g148387_i0	PRJNA734348	149085	202	4.627907	9.34837214	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	73.9	1.9e-13	NR	HEX2229593.1	2838779	g148387	i0	58.2	0.995049504950495	67	28	99.5	0	201	1	69	135	HEX2229593.1 FIST N-terminal domain-containing protein [Candidatus Binatia bacterium]	diamond	201	73.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28852307	28852307	PRJNA734348_P_NODE_54228_length_285_cov_2.655660_g53531_i0	PRJNA734348	54228	285	2.65566	7.568631	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	130	1.6199999999999998e-35	NR	MFI5395478.1	2838779	g53531	i0	62.8	1.18947368421053	113	24	100	1	1	285	67	179	MFI5395478.1 Smr/MutS family protein [Candidatus Binatia bacterium]	diamond	339	130	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29768032	29768032	PRJNA734348_P_NODE_128651_length_242_cov_0.911243_g127953_i0	PRJNA734348	128651	242	0.911243	2.20520806	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	164	1.09e-48	NR	HET9881412.1	2838779	g127953	i0	98.8	1.98347107438017	80	1	99.2	0	2	241	102	181	HET9881412.1 glycosyltransferase [Candidatus Binatia bacterium]	diamond	480	164	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29831253	29831253	PRJNA734348_P_NODE_137331_length_236_cov_2.822086_g136633_i0	PRJNA734348	137331	236	2.822086	6.66012296	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	153	1.8299999999999994e-42	NR	HET9297552.1	2838779	g136633	i0	89.7	0.991525423728814	78	8	99.2	0	236	3	74	151	HET9297552.1 glycogen synthase GlgA [Candidatus Binatia bacterium]	diamond	234	153	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30789319	30789319	PRJNA734348_P_NODE_150034_length_198_cov_6.112000_g149336_i0	PRJNA734348	150034	198	6.112	12.10176	Pseudomonadati	3379134	Bacteria	Bacteria	94	6.38e-23	NR	MEX0805367.1	2838779	g149336	i0	83.6	2.5	55	8	83.3	1	2	166	67	120	MEX0805367.1 VOC family protein [Candidatus Binatia bacterium]	diamond	495	94	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31032163	31032163	PRJNA734348_P_NODE_64655_length_275_cov_1.400990_g63958_i0	PRJNA734348	64655	275	1.40099	3.8527225	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	139	4.469999999999999e-40	NR	HXV79750.1	2838779	g63958	i0	85.7	1.65818181818182	77	11	84	0	3	233	48	124	HXV79750.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	456	139	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);;