metadata: contig_metadata: 7 rows where bioproject = "PRJEB14803", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJEB14803", 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_order	tax_family	tax_species
14049575	14049575	PRJEB14803_P_NODE_28632_length_204_cov_1.242604_g28166_i0	PRJEB14803	28632	204	1.242604	2.53491216	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	60.2	1.06e-4	NTclustered	gi\|2518550926\|emb\|OX638322.1\|	2838779	g28166	i0	100	0.299019607843137	32	0	16	0	163	194	141491	141522	MAG: Candidatus Binatia bacterium isolate fc306077-a6e0-4751-8727-9b45b52cfb09 genome assembly, chromosome: 1	blastn	61	60.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29559309	29559309	PRJEB14803_P_NODE_7450_length_490_cov_1.347253_g6995_i0	PRJEB14803	7450	490	1.347253	6.6015397	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	125	7.13e-32	NR	HKN02187.1	2785449	g6995	i0	46	0.997959183673469	163	69	99.8	4	490	2	142	285	HKN02187.1 alpha/beta hydrolase [Candidatus Binataceae bacterium]	diamond	489	125	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31138626	31138626	PRJEB14803_P_NODE_25495_length_220_cov_1.297297_g25029_i0	PRJEB14803	25495	220	1.297297	2.8540534	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	44.7	0.00554	NR	HJY83607.1	2838779	g25029	i0	35.9	4.28181818181818	78	39	91.4	3	17	217	129	206	HJY83607.1 peptidyl-alpha-hydroxyglycine alpha-amidating lyase family protein [Candidatus Binatia bacterium]	diamond	942	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31233576	31233576	PRJEB14803_P_NODE_25095_length_222_cov_1.994652_g24629_i0	PRJEB14803	25095	222	1.994652	4.42812744	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	68.6	2.26e-11	NR	HUS24813.1	2838779	g24629	i0	50.7	0.959459459459459	71	32	91.9	2	209	6	1495	1565	HUS24813.1 phosphatidylinositol-specific phospholipase C domain-containing protein [Candidatus Binatia bacterium]	diamond	213	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31550322	31550322	PRJEB14803_P_NODE_3956_length_707_cov_2.684524_g3590_i0	PRJEB14803	3956	707	2.684524	18.97958468	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	211	3.13e-64	NR	HXZ87062.1	2785449	g3590	i0	51.1	3	235	104	99.3	6	5	706	45	269	HXZ87062.1 alpha/beta hydrolase [Candidatus Binataceae bacterium]	diamond	2121	211	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
32404385	32404385	PRJEB14803_P_NODE_45619_length_153_cov_1.694915_g45153_i0	PRJEB14803	45619	153	1.694915	2.59321995	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	65.1	8.08e-11	NR	HVA40319.1	2785449	g45153	i0	67.4	3.56862745098039	46	15	90.2	0	4	141	177	222	HVA40319.1 class I SAM-dependent methyltransferase [Candidatus Binataceae bacterium]	diamond	546	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
32461259	32461259	PRJEB14803_P_NODE_7659_length_482_cov_2.192394_g7203_i0	PRJEB14803	7659	482	2.192394	10.56733908	Pseudomonadati	3379134	Bacteria	Bacteria	206	2.48e-64	NR	HEY1849592.1	2785449	g7203	i0	59.6	3.00622406639004	161	64	99.6	1	480	1	47	207	HEY1849592.1 DJ-1/PfpI family protein [Candidatus Binataceae bacterium]	diamond	1449	208	0.990384615384615	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);;