metadata: contig_metadata: 25 rows where bioproject = "PRJEB64798" and tax

25 rows where bioproject = "PRJEB64798" 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
3952536	3952536	PRJEB64798_P_NODE_106524_length_211_cov_4.432099_g104758_i0	PRJEB64798	106524	211	4.432099	9.35172889	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	143	1.07e-29	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g104758	i0	93.684	131.886255924171	95	6	45	0	18	112	5535691	5535785	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	27828	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			uncultured Candidatus Binatia bacterium
5231828	5231828	PRJEB64798_P_NODE_60825_length_249_cov_54.340000_g59060_i0	PRJEB64798	60825	249	54.34	135.3066	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g59060	i0	93.562	157.068273092369	233	12	93	3	3	233	3739320	3739551	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	39110	344	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
6505176	6505176	PRJEB64798_P_NODE_138166_length_194_cov_5.917241_g136400_i0	PRJEB64798	138166	194	5.917241	11.47944754	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	145	2.69e-30	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g136400	i0	81.053	218.721649484536	190	28	96	7	1	186	2263404	2263219	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	42432	145	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			uncultured Candidatus Binatia bacterium
16703088	16703088	PRJEB64798_P_NODE_10594_length_614_cov_10.938053_g9079_i0	PRJEB64798	10594	614	10.938053	67.15964542	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	259	3.34e-64	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g9079	i0	75.812	83.1938110749186	554	110	88	17	1	540	2070541	2069998	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	51081	259	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			uncultured Candidatus Binatia bacterium
16703206	16703206	PRJEB64798_P_NODE_113894_length_209_cov_5.781250_g112128_i0	PRJEB64798	113894	209	5.78125	12.0828125	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	115	2.3e-21	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g112128	i0	89.13	18.3205741626794	92	10	44	0	115	206	2711633	2711542	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	3829	115	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
16703805	16703805	PRJEB64798_P_NODE_151054_length_188_cov_1.971223_g149288_i0	PRJEB64798	151054	188	1.971223	3.70589924	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	134	5.59e-27	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g149288	i0	80.22	5.37234042553191	182	32	96	4	5	184	1446120	1445941	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	1010	134	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			uncultured Candidatus Binatia bacterium
19252335	19252335	PRJEB64798_P_NODE_130116_length_198_cov_4.744966_g128350_i0	PRJEB64798	130116	198	4.744966	9.39503268	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	143	9.9e-30	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g128350	i0	84.354	17.1969696969697	147	22	74	1	1	146	3394669	3394523	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	3405	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
20120305	20120305	PRJEB64798_P_NODE_81716_length_213_cov_22.073171_g79950_i0	PRJEB64798	81716	213	22.073171	47.01585423	Bacteria	2	Bacteria	Bacteria	252	1.72e-62	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g79950	i0	88.517	262.023474178404	209	22	98	2	3	210	3738947	3739154	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	55811	252	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
21395061	21395061	PRJEB64798_P_NODE_15857_length_500_cov_14.321508_g14164_i0	PRJEB64798	15857	500	14.321508	71.60754	Bacteria	2	Bacteria	Bacteria	468	4.09e-127	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g14164	i0	88.191	120.396	398	40	79	6	4	397	2238880	2239274	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	60198	468	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
23081084	23081084	PRJEB64798_P_NODE_53539_length_267_cov_5.825688_g51774_i0	PRJEB64798	53539	267	5.825688	15.55458696	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	226	1.36e-54	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g51774	i0	84.848	252.906367041199	231	28	85	7	35	262	594436	594210	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	67526	226	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
24354833	24354833	PRJEB64798_P_NODE_46580_length_287_cov_30.529412_g44815_i0	PRJEB64798	46580	287	30.529412	87.61941244	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	429	1.05e-115	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g44815	i0	94.014	189.689895470383	284	16	99	1	1	283	3738964	3738681	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	54441	429	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
26748349	26748349	PRJEB64798_P_NODE_132821_length_197_cov_3.398649_g131055_i0	PRJEB64798	132821	197	3.398649	6.69533853	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	44.3	0.00536	NR	HEY1371210.1	2838779	g131055	i0	39.3	2.75634517766497	61	36	91.4	1	194	15	193	253	HEY1371210.1 NRDE family protein [Candidatus Binatia bacterium]	diamond	543	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27413157	27413157	PRJEB64798_P_NODE_103903_length_212_cov_2.386503_g102137_i0	PRJEB64798	103903	212	2.386503	5.05938636	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	49.7	4.25e-5	NR	MFQ5667925.1	2838779	g102137	i0	66.7	0.466981132075472	33	11	46.7	0	100	2	44	76	MFQ5667925.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	99	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27943006	27943006	PRJEB64798_P_NODE_95105_length_212_cov_4.300613_g93339_i0	PRJEB64798	95105	212	4.300613	9.11729956	Pseudomonadati	3379134	Bacteria	Bacteria	106	2.51e-26	NR	MFI5365444.1	2838779	g93339	i0	69.6	2.23584905660377	79	13	96.2	1	206	3	55	133	MFI5365444.1 glycosyltransferase family 2 protein [Candidatus Binatia bacterium]	diamond	474	106	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27949735	27949735	PRJEB64798_P_NODE_114025_length_209_cov_5.250000_g112259_i0	PRJEB64798	114025	209	5.25	10.9725	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	44.7	0.00484	NR	HZZ08861.1	2785449	g112259	i0	67.7	0.889952153110048	31	10	44.5	0	209	117	65	95	HZZ08861.1 ATP-binding cassette domain-containing protein [Candidatus Binataceae bacterium]	diamond	186	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28518171	28518171	PRJEB64798_P_NODE_172747_length_177_cov_8.609375_g170981_i0	PRJEB64798	172747	177	8.609375	15.23859375	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	45.8	0.00124	NR	MBF6560548.1	2785449	g170981	i0	45.7	0.779661016949153	46	24	76.3	1	9	143	344	389	MBF6560548.1 phage portal protein [Candidatus Binataceae bacterium]	diamond	138	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28896953	28896953	PRJEB64798_P_NODE_28728_length_367_cov_7.106918_g26972_i0	PRJEB64798	28728	367	7.106918	26.08238906	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52	8.39e-5	NR	MFN2375181.1	2838779	g26972	i0	32.8	1.09536784741144	67	44	54.8	1	5	205	143	208	MFN2375181.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	402	52	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30002264	30002264	PRJEB64798_P_NODE_151631_length_187_cov_13.144928_g149865_i0	PRJEB64798	151631	187	13.144928	24.58101536	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	85.5	4.06e-19	NR	HEU4340999.1	2838779	g149865	i0	72.4	0.93048128342246	58	14	89.8	1	3	170	107	164	HEU4340999.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	174	85.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30381853	30381853	PRJEB64798_P_NODE_80333_length_214_cov_24.909091_g78567_i0	PRJEB64798	80333	214	24.909091	53.30545474	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	48.5	2.27e-4	NR	HEY8514733.1	2838779	g78567	i0	60.6	0.911214953271028	33	13	46.3	0	212	114	303	335	HEY8514733.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	195	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31234149	31234149	PRJEB64798_P_NODE_110415_length_210_cov_5.236025_g108649_i0	PRJEB64798	110415	210	5.236025	10.9956525	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	77.8	2.22e-15	NR	HEV3114261.1	2785449	g108649	i0	52.9	2.04285714285714	70	28	92.9	1	197	3	87	156	HEV3114261.1 dipeptidase PepE [Candidatus Binataceae bacterium]	diamond	429	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31487616	31487616	PRJEB64798_P_NODE_142036_length_192_cov_6.510490_g140270_i0	PRJEB64798	142036	192	6.51049	12.5001408	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	100	4.12e-23	NR	HVI10214.1	2838779	g140270	i0	72.6	0.96875	62	17	96.9	0	192	7	101	162	HVI10214.1 DUF2184 domain-containing protein [Candidatus Binatia bacterium]	diamond	186	100	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31582569	31582569	PRJEB64798_P_NODE_252116_length_151_cov_4.235294_g250350_i0	PRJEB64798	252116	151	4.235294	6.39529394	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	62.8	8.68e-10	NR	HEY2104751.1	2785449	g250350	i0	60.4	1.90728476821192	48	19	95.4	0	146	3	544	591	HEY2104751.1 CDC48 family AAA ATPase [Candidatus Binataceae bacterium]	diamond	288	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
32056895	32056895	PRJEB64798_P_NODE_252678_length_150_cov_11.683168_g250912_i0	PRJEB64798	252678	150	11.683168	17.524752	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42.4	0.0148	NR	MFN8601370.1	2838779	g250912	i0	80	1.38	20	4	40	0	132	73	73	92	MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	207	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32625960	32625960	PRJEB64798_P_NODE_180120_length_174_cov_4.616000_g178354_i0	PRJEB64798	180120	174	4.616	8.03184	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	43.1	0.0107	NR	MFN8601370.1	2838779	g178354	i0	65.5	1.36206896551724	29	9	48.3	1	9	92	64	92	MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	237	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32846486	32846486	PRJEB64798_P_NODE_238660_length_155_cov_11.424528_g236894_i0	PRJEB64798	238660	155	11.424528	17.7080184	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	61.2	1.13e-9	NR	MET0153585.1	2838779	g236894	i0	72.3	0.909677419354839	47	13	91	0	14	154	152	198	MET0153585.1 cysteine hydrolase family protein [Candidatus Binatia bacterium]	diamond	141	61.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);;