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

25 rows where bioproject = "PRJNA1158727" and tax_clade = "Bacteria candidate phyla"

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_genus	tax_species
12516270	12516270	PRJNA1158727_P_NODE_151750_length_245_cov_0.895349_g144288_i0	PRJNA1158727	151750	245	0.895349	2.19360505	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	127	2.51e-33	NR	MBN9398159.1	2026720	g144288	i0	72.8	1.98367346938776	81	22	99.2	0	1	243	122	202	MBN9398159.1 glycosyltransferase family 4 protein [Candidatus Saccharibacteria bacterium]	diamond	486	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14333224	14333224	PRJNA1158727_P_NODE_157532_length_243_cov_0.905882_g150070_i0	PRJNA1158727	157532	243	0.905882	2.20129326	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	137	1.13e-35	NR	HEX5774536.1	2053589	g150070	i0	83.8	2.96296296296296	80	13	98.8	0	242	3	190	269	HEX5774536.1 UvrD-helicase domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	720	137	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27609139	27609139	PRJNA1158727_P_NODE_106784_length_283_cov_1.961905_g99323_i0	PRJNA1158727	106784	283	1.961905	5.55219115	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	119	9.8e-29	NR	MBX9830659.1	2803731	g99323	i0	91.4	0.985865724381625	93	8	98.6	0	281	3	528	620	MBX9830659.1 hypothetical protein [Candidatus Babeliales bacterium]	diamond	279	119	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
27798675	27798675	PRJNA1158727_P_NODE_116544_length_271_cov_1.772727_g109083_i0	PRJNA1158727	116544	271	1.772727	4.80409017	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	178	4.119999999999999e-52	NR	HMI50737.1	2973664	g109083	i0	88.8	0.985239852398524	89	10	98.5	0	3	269	333	421	HMI50737.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Candidatus Saccharimonadales bacterium]	diamond	267	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27987984	27987984	PRJNA1158727_P_NODE_155265_length_244_cov_0.900585_g147803_i0	PRJNA1158727	155265	244	0.900585	2.1974274	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.1	0.0275	NR	MBP7773760.1	2044595	g147803	i0	63.3	0.368852459016393	30	11	36.9	0	153	242	107	136	MBP7773760.1 DNA-directed RNA polymerase subunit beta [Candidatus Altimarinota bacterium]	diamond	90	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
28461780	28461780	PRJNA1158727_P_NODE_80106_length_339_cov_1.447368_g72645_i0	PRJNA1158727	80106	339	1.447368	4.90657752	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	149	4.07e-43	NR	MEX0596344.1	2053589	g72645	i0	67.9	0.938053097345133	106	34	93.8	0	8	325	1	106	MEX0596344.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	318	149	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29333410	29333410	PRJNA1158727_P_NODE_150549_length_245_cov_1.790698_g143087_i0	PRJNA1158727	150549	245	1.790698	4.3872101	Bacteria	2	Bacteria	Bacteria	116	4.86e-28	NR	OGZ63703.1	1802202	g143087	i0	73.8	4.89795918367347	80	21	98	0	242	3	226	305	OGZ63703.1 MAG: sodium-translocating pyrophosphatase [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25]	diamond	1200	116	1	Bacteria	Bacteria candidate phyla	Candidatus Staskawicziibacteriota					Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25
29977131	29977131	PRJNA1158727_P_NODE_154671_length_244_cov_0.900585_g147209_i0	PRJNA1158727	154671	244	0.900585	2.1974274	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	43.5	0.0191	NR	PYO03433.1	2053607	g147209	i0	37.3	1.02049180327869	59	37	72.5	0	15	191	330	388	PYO03433.1 MAG: formyl-CoA transferase [Candidatus Rokuibacteriota bacterium]	diamond	249	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
30640497	30640497	PRJNA1158727_P_NODE_110333_length_279_cov_1.436893_g102872_i0	PRJNA1158727	110333	279	1.436893	4.00893147	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	74.3	4.3e-15	NR	RTL06915.1	2030827	g102872	i0	70.2	0.505376344086022	47	14	50.5	0	210	70	37	83	RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium]	diamond	141	74.3	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
30640514	30640514	PRJNA1158727_P_NODE_163953_length_241_cov_0.916667_g156491_i0	PRJNA1158727	163953	241	0.916667	2.20916747	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	114	4.9e-28	NR	HMI52778.1	2973664	g156491	i0	74	0.95850622406639	77	20	95.9	0	3	233	122	198	HMI52778.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	231	114	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30881124	30881124	PRJNA1158727_P_NODE_160694_length_242_cov_0.911243_g153232_i0	PRJNA1158727	160694	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	137	8.85e-36	NR	UTX51628.1	2980174	g153232	i0	78.8	1.98347107438017	80	17	99.2	0	241	2	569	648	UTX51628.1 TIGR00730 family Rossman fold protein [Candidatus Saccharibacteria bacterium TM7i]	diamond	480	138	0.992753623188406	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
30893533	30893533	PRJNA1158727_P_NODE_104094_length_287_cov_1.257009_g96633_i0	PRJNA1158727	104094	287	1.257009	3.60761583	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	112	2.15e-27	NR	HTR18381.1	2053589	g96633	i0	60	0.940766550522648	90	36	94.1	0	270	1	1	90	HTR18381.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Paceibacterota bacterium]	diamond	270	112	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31051694	31051694	PRJNA1158727_P_NODE_159675_length_242_cov_0.911243_g152213_i0	PRJNA1158727	159675	242	0.911243	2.20520806	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	127	8.279999999999998e-32	NR	MBI4136581.1	2282149	g152213	i0	72.5	0.991735537190083	80	22	99.2	0	1	240	611	690	MBI4136581.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	240	127	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
31114369	31114369	PRJNA1158727_P_NODE_119755_length_267_cov_2.902062_g112294_i0	PRJNA1158727	119755	267	2.902062	7.74850554	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	107	2.5e-27	NR	MEX0596343.1	2053589	g112294	i0	60.2	0.98876404494382	88	35	98.9	0	266	3	8	95	MEX0596343.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	264	107	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31272647	31272647	PRJNA1158727_P_NODE_105675_length_285_cov_1.169811_g98214_i0	PRJNA1158727	105675	285	1.169811	3.33396135	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	69.7	2.07e-11	NR	MFA6263945.1	2803731	g98214	i0	46.3	1	95	24	83.2	2	21	257	605	688	MFA6263945.1 hypothetical protein [Candidatus Babeliales bacterium]	diamond	285	69.7	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
31557520	31557520	PRJNA1158727_P_NODE_109356_length_280_cov_1.487923_g101895_i0	PRJNA1158727	109356	280	1.487923	4.1661844	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	72.4	2.19e-13	NR	MEN9921563.1	2762014	g101895	i0	55.6	0.675	63	25	64.3	1	182	3	1	63	MEN9921563.1 Synechococcus phage [Candidatus Parcubacteria bacterium]	diamond	189	72.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
31905173	31905173	PRJNA1158727_P_NODE_111057_length_278_cov_1.502439_g103596_i0	PRJNA1158727	111057	278	1.502439	4.17678042	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	64.3	1.44e-9	NR	MDE2022518.1	2052139	g103596	i0	49.5	0.982014388489209	91	45	97.1	1	275	6	170	260	MDE2022518.1 hypothetical protein [Patescibacteria group bacterium]	diamond	273	64.3	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32031888	32031888	PRJNA1158727_P_NODE_143298_length_248_cov_0.880000_g135836_i0	PRJNA1158727	143298	248	0.88	2.1824	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	68.6	6.2e-12	NR	MFA7253837.1	2052139	g135836	i0	40.5	0.955645161290323	79	42	95.6	1	10	246	43	116	MFA7253837.1 hypothetical protein [Patescibacteria group bacterium]	diamond	237	68.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32190054	32190054	PRJNA1158727_P_NODE_103958_length_287_cov_1.425234_g96497_i0	PRJNA1158727	103958	287	1.425234	4.09042158	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	43.1	0.0455	NR	MFQ5658600.1	3159508	g96497	i0	40.4	0.491289198606272	47	28	49.1	0	136	276	59	105	MFQ5658600.1 IS1634 family transposase [Candidatus Methylomirabilales bacterium]	diamond	141	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales			Candidatus Methylomirabilales bacterium
32411642	32411642	PRJNA1158727_P_NODE_60659_length_421_cov_2.313218_g53198_i0	PRJNA1158727	60659	421	2.313218	9.73864778	Parcubacteria group bacterium ADurb.Bin216	1852939	Bacteria	Bacteria	116	3.27e-30	NR	OQB10721.1	1852939	g53198	i0	51.4	0.762470308788599	107	51	76.2	1	419	99	49	154	OQB10721.1 MAG: hypothetical protein BWY21_00004 [Parcubacteria group bacterium ADurb.Bin216]	diamond	321	116	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium ADurb.Bin216
32443448	32443448	PRJNA1158727_P_NODE_90939_length_311_cov_1.504202_g83478_i0	PRJNA1158727	90939	311	1.504202	4.67806822	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	177	2.63e-51	NR	HMI52332.1	2973664	g83478	i0	88.3	0.993569131832797	103	12	99.4	0	1	309	102	204	HMI52332.1 nodulation protein NfeD [Candidatus Saccharimonadales bacterium]	diamond	309	177	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32462635	32462635	PRJNA1158727_P_NODE_162619_length_241_cov_0.916667_g155157_i0	PRJNA1158727	162619	241	0.916667	2.20916747	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	58.5	3.76e-8	NR	WP_129693482.1	1986206	g155157	i0	100	0.647302904564315	26	0	32.4	0	163	240	1	26	WP_129693482.1 ATP-dependent Clp protease proteolytic subunit [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	156	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
32601224	32601224	PRJNA1158727_P_NODE_147700_length_246_cov_1.780347_g140238_i0	PRJNA1158727	147700	246	1.780347	4.37965362	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	127	4.4899999999999997e-32	NR	OJU87407.1	1895829	g140238	i0	87.2	0.951219512195122	78	10	95.1	0	2	235	543	620	OJU87407.1 MAG: cell division protein FtsH [Candidatus Saccharibacteria bacterium 49-20]	diamond	234	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
32727178	32727178	PRJNA1158727_P_NODE_135340_length_251_cov_0.865169_g127878_i0	PRJNA1158727	135340	251	0.865169	2.17157419	Candidatus Daviesbacteria bacterium	2053542	Bacteria	Bacteria	43.9	0.0015	NR	MBI2593872.1	2053542	g127878	i0	44.9	0.585657370517928	49	27	58.6	0	88	234	7	55	MBI2593872.1 hypothetical protein [Candidatus Daviesbacteria bacterium]	diamond	147	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Daviesiibacteriota					Candidatus Daviesbacteria bacterium
32884408	32884408	PRJNA1158727_P_NODE_121020_length_266_cov_1.595855_g113559_i0	PRJNA1158727	121020	266	1.595855	4.2449743	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	153	9.81e-44	NR	WP_164998023.1	1986206	g113559	i0	94.8	0.868421052631579	77	4	86.8	0	265	35	235	311	WP_164998023.1 WxL protein peptidoglycan domain-containing protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	231	153	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1

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);;