metadata: contig_metadata: 14 rows where bioproject = "PRJEB20058", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJEB20058", 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
25924127	25924127	PRJEB20058_P_NODE_171356_length_286_cov_1.297778_g168533_i0	PRJEB20058	171356	286	1.297778	3.71164508	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	92	1.54e-20	NR	MDG2304878.1	2838779	g168533	i0	53.2	0.986013986013986	94	43	97.6	1	7	285	118	211	MDG2304878.1 alkylhydroperoxidase-related (seleno)protein [Candidatus Binatia bacterium]	diamond	282	92	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
25927830	25927830	PRJEB20058_P_NODE_37404_length_688_cov_2.146730_g34800_i0	PRJEB20058	37404	688	2.14673	14.7695024	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	204	4.03e-62	NR	MFN8602053.1	2838779	g34800	i0	65.8	0.688953488372093	158	54	68.9	0	195	668	1	158	MFN8602053.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	474	204	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
26332056	26332056	PRJEB20058_P_NODE_167879_length_290_cov_2.209607_g165056_i0	PRJEB20058	167879	290	2.209607	6.4078603	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	89.8	2.05e-13	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g165056	i0	87.342	16.3275862068966	79	9	27	1	88	166	1858179	1858256	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	4735	89.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32945070	32945070	PRJEB20058_P_NODE_174690_length_282_cov_1.737557_g171867_i0	PRJEB20058	174690	282	1.737557	4.89991074	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	55.8	1.07e-6	NR	HUS24874.1	2838779	g171867	i0	45.6	2.77659574468085	68	31	72.3	1	79	282	6	67	HUS24874.1 sulfotransferase family 2 domain-containing protein [Candidatus Binatia bacterium]	diamond	783	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32962118	32962118	PRJEB20058_P_NODE_140010_length_328_cov_66.363296_g137189_i0	PRJEB20058	140010	328	66.363296	217.67161088	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	48.5	2.57e-4	NR	HEY2774668.1	2838779	g137189	i0	38.5	0.594512195121951	65	36	57.6	2	56	244	74	136	HEY2774668.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	195	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32979960	32979960	PRJEB20058_P_NODE_54355_length_570_cov_5.308448_g51611_i0	PRJEB20058	54355	570	5.308448	30.2581536	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	195	4.79e-59	NR	HSF56590.1	2838779	g51611	i0	93.4	2.78947368421053	106	7	55.8	0	553	236	156	261	HSF56590.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	1590	195	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
32995964	32995964	PRJEB20058_P_NODE_121211_length_362_cov_4.421927_g118394_i0	PRJEB20058	121211	362	4.421927	16.00737574	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	69.3	6.47e-11	NR	HEV8716976.1	2838779	g118394	i0	35.3	0.961325966850829	116	70	92.8	2	337	2	118	232	HEV8716976.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	348	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33048048	33048048	PRJEB20058_P_NODE_65421_length_517_cov_1.603070_g62654_i0	PRJEB20058	65421	517	1.60307	8.2878719	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	142	1.72e-39	NR	HEY7558553.1	2838779	g62654	i0	91.3	0.400386847195358	69	6	40	0	1	207	101	169	HEY7558553.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	207	142	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33064263	33064263	PRJEB20058_P_NODE_133845_length_339_cov_3.525180_g131025_i0	PRJEB20058	133845	339	3.52518	11.9503602	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	209	1.13e-65	NR	HEX6173119.1	2838779	g131025	i0	96.3	1.92920353982301	109	4	96.5	0	329	3	157	265	HEX6173119.1 CoA ester lyase [Candidatus Binatia bacterium]	diamond	654	209	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33098760	33098760	PRJEB20058_P_NODE_192942_length_262_cov_2.283582_g190118_i0	PRJEB20058	192942	262	2.283582	5.98298484	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52	2.41e-5	NR	HEY2774881.1	2838779	g190118	i0	55.8	0.49236641221374	43	15	49.2	2	251	123	342	380	HEY2774881.1 S8 family serine peptidase [Candidatus Binatia bacterium]	diamond	129	52	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33116485	33116485	PRJEB20058_P_NODE_94039_length_422_cov_7.850416_g91239_i0	PRJEB20058	94039	422	7.850416	33.12875552	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	119	3.18e-28	NR	HEY8514658.1	2838779	g91239	i0	53.1	7.07345971563981	128	47	91	2	36	419	104	218	HEY8514658.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	2985	119	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33132947	33132947	PRJEB20058_P_NODE_193143_length_262_cov_1.592040_g190319_i0	PRJEB20058	193143	262	1.59204	4.1711448	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	87	1.19e-17	NR	HEX7410465.1	2838779	g190319	i0	56.4	0.893129770992366	78	34	89.3	0	3	236	628	705	HEX7410465.1 beta-L-arabinofuranosidase domain-containing protein [Candidatus Binatia bacterium]	diamond	234	87	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33167327	33167327	PRJEB20058_P_NODE_44720_length_629_cov_2.047535_g42038_i0	PRJEB20058	44720	629	2.047535	12.87899515	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	163	1.91e-42	NR	HTM69060.1	2838779	g42038	i0	53	1.60254372019078	168	79	80.1	0	25	528	986	1153	HTM69060.1 class I tRNA ligase family protein [Candidatus Binatia bacterium]	diamond	1008	163	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
33179036	33179036	PRJEB20058_P_NODE_151592_length_311_cov_4.836000_g148769_i0	PRJEB20058	151592	311	4.836	15.03996	Bacillati	1783272	Bacteria	Bacteria	200	2.46e-58	NR	HET7004870.1	2838779	g148769	i0	91.7	2.77813504823151	96	8	92.6	0	2	289	382	477	HET7004870.1 alpha/beta hydrolase domain-containing protein [Candidatus Binatia bacterium]	diamond	864	202	0.99009900990099	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);;