metadata: contig_metadata: 11 rows where bioproject = "PRJNA1011844", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA1011844", 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
1431630	1431630	PRJNA1011844_P_NODE_27802_length_1013_cov_41.302128_g21421_i0	PRJNA1011844	27802	1013	41.302128	418.39055664	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	167	5.5e-47	NR	HTW87353.1	2785449	g21421	i0	43.2	3.75518262586377	213	98	63.1	6	267	905	5	194	HTW87353.1 superoxide dismutase [Candidatus Binataceae bacterium]	diamond	3804	167	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
9084153	9084153	PRJNA1011844_P_NODE_18128_length_1328_cov_7.400000_g13401_i0	PRJNA1011844	18128	1328	7.4	98.272	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	152	1.37e-36	NR	HLH78251.1	2785449	g13401	i0	40.3	0.510542168674699	226	127	50.6	4	113	784	311	530	HLH78251.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Binataceae bacterium]	diamond	678	152	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
27066255	27066255	PRJNA1011844_P_NODE_169822_length_229_cov_2.288462_g161241_i0	PRJNA1011844	169822	229	2.288462	5.24057798	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	143	6.74e-41	NR	HEY6364904.1	2838779	g161241	i0	100	0.956331877729258	73	0	95.6	0	221	3	103	175	HEY6364904.1 GntR family transcriptional regulator [Candidatus Binatia bacterium]	diamond	219	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28771636	28771636	PRJNA1011844_P_NODE_152227_length_247_cov_0.885057_g143648_i0	PRJNA1011844	152227	247	0.885057	2.18609079	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	69.3	1.23e-11	NR	HJU12034.1	2785449	g143648	i0	68.1	0.57085020242915	47	15	57.1	0	91	231	101	147	HJU12034.1 ABC transporter substrate-binding protein [Candidatus Binataceae bacterium]	diamond	141	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28866380	28866380	PRJNA1011844_P_NODE_160048_length_242_cov_0.911243_g151468_i0	PRJNA1011844	160048	242	0.911243	2.20520806	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	110	5.09e-27	NR	HEV7734299.1	2838779	g151468	i0	82.3	0.768595041322314	62	11	76.9	0	241	56	96	157	HEV7734299.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	186	110	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29024743	29024743	PRJNA1011844_P_NODE_71608_length_444_cov_2.207547_g63130_i0	PRJNA1011844	71608	444	2.207547	9.80150868	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	62.4	4.51e-8	NR	MET0153165.1	2838779	g63130	i0	53.1	0.331081081081081	49	23	33.1	0	428	282	483	531	MET0153165.1 CHASE2 domain-containing protein [Candidatus Binatia bacterium]	diamond	147	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29908539	29908539	PRJNA1011844_P_NODE_149371_length_249_cov_0.875000_g140792_i0	PRJNA1011844	149371	249	0.875	2.17875	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	67.8	3.38e-12	NR	HZR82383.1	2838779	g140792	i0	59.6	1.26506024096386	52	21	62.7	0	243	88	80	131	HZR82383.1 Hsp20/alpha crystallin family protein [Candidatus Binatia bacterium]	diamond	315	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30034885	30034885	PRJNA1011844_P_NODE_36971_length_815_cov_10.336927_g29468_i0	PRJNA1011844	36971	815	10.336927	84.24595505	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	72	1.83e-11	NR	HEX4211227.1	2785449	g29468	i0	31.9	0.680981595092024	185	57	68.1	5	751	197	2	117	HEX4211227.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	555	72	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
30097831	30097831	PRJNA1011844_P_NODE_147752_length_250_cov_0.870056_g139173_i0	PRJNA1011844	147752	250	0.870056	2.17514	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	50.8	5.31e-5	NR	HEY2772704.1	2838779	g139173	i0	36.4	0.924	77	40	92.4	1	18	248	94	161	HEY2772704.1 IPT/TIG domain-containing protein [Candidatus Binatia bacterium]	diamond	231	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30438077	30438077	PRJNA1011844_P_NODE_125093_length_276_cov_2.256158_g116516_i0	PRJNA1011844	125093	276	2.256158	6.22699608	Bacillati	1783272	Bacteria	Bacteria	52	2.99e-5	NR	HKM99832.1	2785449	g116516	i0	39.1	3.72826086956522	64	37	69.6	1	231	40	276	337	HKM99832.1 CaiB/BaiF CoA-transferase family protein [Candidatus Binataceae bacterium]	diamond	1029	52	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31962884	31962884	PRJNA1011844_P_NODE_163018_length_239_cov_2.656627_g154437_i0	PRJNA1011844	163018	239	2.656627	6.34933853	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	74.7	1.96e-13	NR	HVM83582.1	2838779	g154437	i0	53.3	0.941422594142259	75	33	91.6	2	221	3	1090	1164	HVM83582.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	225	74.7	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);;