metadata: contig_metadata: 23 rows where bioproject = "PRJNA1137393" and tax

23 rows where bioproject = "PRJNA1137393" 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
5387923	5387923	PRJNA1137393_P_NODE_37545_length_171_cov_1.344262_g37029_i0	PRJNA1137393	37545	171	1.344262	2.29868802	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	255	1.02e-63	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g37029	i0	93.567	5.62573099415205	171	11	100	0	1	171	849915	850085	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	962	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5388013	5388013	PRJNA1137393_P_NODE_60705_length_164_cov_1.504348_g60189_i0	PRJNA1137393	60705	164	1.504348	2.46713072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g60189	i0	96.341	37.859756097561	164	6	100	0	1	164	636081	636244	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	6209	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6134925	6134925	PRJNA1137393_P_NODE_38705_length_170_cov_0.809917_g38189_i0	PRJNA1137393	38705	170	0.809917	1.3768589	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g38189	i0	95.679	61.6764705882353	162	6	95	1	1	161	694875	694714	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	10485	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
8685114	8685114	PRJNA1137393_P_NODE_12367_length_238_cov_3.079365_g11851_i0	PRJNA1137393	12367	238	3.079365	7.3288887	Bacteria	2	Bacteria	Bacteria	401	1.8399999999999994e-107	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g11851	i0	97.083	283.457983193277	240	3	100	3	1	238	800134	800371	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	67463	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
9960271	9960271	PRJNA1137393_P_NODE_8988_length_277_cov_1.592105_g8472_i0	PRJNA1137393	8988	277	1.592105	4.41013085	Bacteria	2	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g8472	i0	94.245	124.184115523466	278	14	99	2	2	277	963926	964203	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	34399	424	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
13038570	13038570	PRJNA1137393_P_NODE_72651_length_162_cov_0.920354_g72135_i0	PRJNA1137393	72651	162	0.920354	1.49097348	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	137	3.6199999999999997e-28	NTclustered	gi\|2874254063\|emb\|OY970122.1\|	2052149	g72135	i0	85.496	49.5925925925926	131	19	81	0	1	131	1387023	1387153	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.13 genome assembly, chromosome: 1	blastn	8034	137	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
14313579	14313579	PRJNA1137393_P_NODE_11012_length_250_cov_2.965174_g10496_i0	PRJNA1137393	11012	250	2.965174	7.412935	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	246	9.679999999999999e-61	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10496	i0	84.646	242.216	254	32	100	7	1	250	161936	162186	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	60554	246	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
14313631	14313631	PRJNA1137393_P_NODE_28732_length_183_cov_2.373134_g28216_i0	PRJNA1137393	28732	183	2.373134	4.34283522	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	3.949999999999999e-68	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g28216	i0	93.443	60.4590163934426	183	10	99	2	2	183	799953	800134	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11064	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22708900	22708900	PRJNA1137393_P_NODE_12658_length_236_cov_1.358289_g12142_i0	PRJNA1137393	12658	236	1.358289	3.20556204	Bacteria	2	Bacteria	Bacteria	387	5.11e-103	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g12142	i0	96.186	187.525423728814	236	9	100	0	1	236	850590	850825	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	44256	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23237004	23237004	PRJNA1137393_P_NODE_34159_length_175_cov_1.706349_g33643_i0	PRJNA1137393	34159	175	1.706349	2.98611075	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g33643	i0	99.419	272.811428571429	172	1	98	0	4	175	599004	598833	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	47742	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
23237165	23237165	PRJNA1137393_P_NODE_8419_length_287_cov_2.731092_g7903_i0	PRJNA1137393	8419	287	2.731092	7.83823404	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	398	2.9599999999999997e-106	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g7903	i0	91.667	274.672473867596	288	22	100	2	1	287	161101	161387	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	78831	398	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
26880723	26880723	PRJNA1137393_P_NODE_69001_length_163_cov_0.912281_g68485_i0	PRJNA1137393	69001	163	0.912281	1.48701803	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	71.2	1.08e-12	NR	HEY1063943.1	2973664	g68485	i0	66	0.975460122699387	53	18	97.5	0	1	159	237	289	HEY1063943.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	159	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27260102	27260102	PRJNA1137393_P_NODE_53123_length_166_cov_0.888889_g52607_i0	PRJNA1137393	53123	166	0.888889	1.47555574	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	45.8	3.2e-4	NR	MCA0228232.1	2052139	g52607	i0	78.1	2.33132530120482	32	7	57.8	0	1	96	86	117	MCA0228232.1 30S ribosomal protein S6 [Patescibacteria group bacterium]	diamond	387	45.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27323302	27323302	PRJNA1137393_P_NODE_68923_length_163_cov_0.912281_g68407_i0	PRJNA1137393	68923	163	0.912281	1.48701803	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	100	2.9099999999999996e-23	NR	MBP9667703.1	2026720	g68407	i0	88.9	0.993865030674847	54	6	99.4	0	2	163	363	416	MBP9667703.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	162	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27691617	27691617	PRJNA1137393_P_NODE_55924_length_165_cov_1.948276_g55408_i0	PRJNA1137393	55924	165	1.948276	3.2146554	Bacteria	2	Bacteria	Bacteria	106	4.14e-25	NR	NCC20352.1	2026720	g55408	i0	90.9	7	55	5	100	0	1	165	320	374	NCC20352.1 M1 family peptidase [Candidatus Saccharibacteria bacterium]	diamond	1155	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28965330	28965330	PRJNA1137393_P_NODE_59108_length_165_cov_0.896552_g58592_i0	PRJNA1137393	59108	165	0.896552	1.4793108	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	84.3	2.42e-18	NR	MEO5949493.1	1917697	g58592	i0	71.7	0.963636363636364	53	15	96.4	0	6	164	129	181	MEO5949493.1 phosphatase PAP2 family protein [Candidatus Saccharimonas sp.]	diamond	159	84.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29533504	29533504	PRJNA1137393_P_NODE_67610_length_163_cov_0.912281_g67094_i0	PRJNA1137393	67610	163	0.912281	1.48701803	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	75.1	4.89e-14	NR	MBW7944192.1	2052139	g67094	i0	60.4	1.95092024539877	53	21	97.5	0	163	5	132	184	MBW7944192.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Patescibacteria group bacterium]	diamond	318	75.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29691030	29691030	PRJNA1137393_P_NODE_63890_length_164_cov_0.904348_g63374_i0	PRJNA1137393	63890	164	0.904348	1.48313072	Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_	1802132	Bacteria	Bacteria	58.5	3.38e-8	NR	OGL22522.1	1802132	g63374	i0	50	0.98780487804878	54	27	98.8	0	164	3	626	679	OGL22522.1 MAG: hypothetical protein A2707_04325 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15]	diamond	162	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15
30007369	30007369	PRJNA1137393_P_NODE_28331_length_184_cov_1.451852_g27815_i0	PRJNA1137393	28331	184	1.451852	2.67140768	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	59.7	1.29e-8	NR	MBU6231627.1	2052139	g27815	i0	46.3	0.880434782608696	54	29	88	0	164	3	33	86	MBU6231627.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Patescibacteria group bacterium]	diamond	162	59.7	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31587529	31587529	PRJNA1137393_P_NODE_40216_length_169_cov_0.866667_g39700_i0	PRJNA1137393	40216	169	0.866667	1.46466723	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	101	1.3299999999999995e-23	NR	HSI63942.1	2890869	g39700	i0	80.4	3.8698224852071	56	11	99.4	0	168	1	81	136	HSI63942.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	654	101	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
31650439	31650439	PRJNA1137393_P_NODE_72697_length_162_cov_0.920354_g72181_i0	PRJNA1137393	72697	162	0.920354	1.49097348	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	71.6	3.67e-13	NR	MBA3723923.1	2052151	g72181	i0	59.3	1	54	22	100	0	162	1	50	103	MBA3723923.1 lamin tail domain-containing protein [Candidatus Levyibacteriota bacterium]	diamond	162	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
31840262	31840262	PRJNA1137393_P_NODE_70677_length_162_cov_0.920354_g70161_i0	PRJNA1137393	70677	162	0.920354	1.49097348	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	1.93e-9	NR	MBP6962308.1	2026720	g70161	i0	52.8	1.96296296296296	53	25	98.1	0	2	160	98	150	MBP6962308.1 ComEC/Rec2 family competence protein [Candidatus Saccharibacteria bacterium]	diamond	318	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32462371	32462371	PRJNA1137393_P_NODE_68859_length_163_cov_0.912281_g68343_i0	PRJNA1137393	68859	163	0.912281	1.48701803	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	89	8.18e-21	NR	WP_015641906.1	1332188	g68343	i0	84.9	2.92638036809816	53	8	97.5	0	161	3	61	113	WP_015641906.1 transcription elongation factor GreA [Candidatus Saccharimonas aalborgensis]	diamond	477	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis

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