metadata: contig_metadata: 24 rows where bioproject = "PRJDB9741" and tax

24 rows where bioproject = "PRJDB9741" 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
11013	11013	PRJDB9741_P_NODE_36721_length_162_cov_2.628319_g36404_i0	PRJDB9741	36721	162	2.628319	4.25787678	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g36404	i0	100	0.172839506172839	28	0	17	0	1	28	1046402	1046429	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
1285092	1285092	PRJDB9741_P_NODE_1042_length_842_cov_3.702396_g802_i0	PRJDB9741	1042	842	3.702396	31.17417432	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	922	0	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g802	i0	86.518	117.897862232779	853	98	100	16	1	842	161513	162359	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	99270	922	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
2257133	2257133	PRJDB9741_P_NODE_4502_length_304_cov_4.529412_g4186_i0	PRJDB9741	4502	304	4.529412	13.76941248	Bacteria	2	Bacteria	Bacteria	496	1.09e-135	NTclustered	gi\|1118703743\|gb\|KX123656.1\|	1618923	g4186	i0	96.066	86.5921052631579	305	10	100	2	1	304	739	1042	Parcubacteria group bacterium GW2011_GWC2_40_10 16S ribosomal RNA gene, partial sequence	blastn	26324	496	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWC2_40_10
8938027	8938027	PRJDB9741_P_NODE_648_length_1099_cov_3.271429_g474_i0	PRJDB9741	648	1099	3.271429	35.95300471	Parcubacteria group bacterium GW2011_GWE1_40_20	1618946	Bacteria	Bacteria	1552	0	NTclustered	gi\|1118703522\|gb\|KX123435.1\|	1618946	g474	i0	93.84	88.8644222020018	1039	44	94	13	2	1037	1238	217	Parcubacteria group bacterium GW2011_GWE1_40_20 16S ribosomal RNA gene, partial sequence	blastn	97662	1552	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWE1_40_20
11488944	11488944	PRJDB9741_P_NODE_35690_length_163_cov_0.894737_g35373_i0	PRJDB9741	35690	163	0.894737	1.45842131	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	99.8	1.07e-22	NR	MBI4011948.1	2053607	g35373	i0	100	0.993865030674847	54	0	99.4	0	2	163	597	650	MBI4011948.1 branched-chain amino acid ABC transporter ATP-binding protein/permease [Candidatus Rokuibacteriota bacterium]	diamond	162	99.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
12764478	12764478	PRJDB9741_P_NODE_26451_length_168_cov_1.630252_g26134_i0	PRJDB9741	26451	168	1.630252	2.73882336	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g26134	i0	97.024	8.92857142857143	168	5	100	0	1	168	93239	93072	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1500	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
14038977	14038977	PRJDB9741_P_NODE_26432_length_168_cov_1.663866_g26115_i0	PRJDB9741	26432	168	1.663866	2.79529488	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26115	i0	90.533	11.1488095238095	169	15	100	1	1	168	221451	221619	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	1873	222	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
14039171	14039171	PRJDB9741_P_NODE_8772_length_213_cov_3.329268_g8455_i0	PRJDB9741	8772	213	3.329268	7.09134084	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.15e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8455	i0	94.811	77.4084507042254	212	11	99	0	1	212	221191	221402	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	16488	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
16284451	16284451	PRJDB9741_P_NODE_2233_length_500_cov_2.847007_g1920_i0	PRJDB9741	2233	500	2.847007	14.235035	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	763	0	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g1920	i0	94.223	216.902	502	25	100	4	1	500	146310	146809	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	108451	763	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
16587970	16587970	PRJDB9741_P_NODE_8954_length_211_cov_3.845679_g8637_i0	PRJDB9741	8954	211	3.845679	8.11438269	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	368	1.6200000000000002e-97	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8637	i0	98.104	64.0947867298578	211	4	100	0	1	211	222683	222473	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	13524	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17862810	17862810	PRJDB9741_P_NODE_35735_length_163_cov_0.894737_g35418_i0	PRJDB9741	35735	163	0.894737	1.45842131	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	113	6.14e-21	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g35418	i0	83.077	0.797546012269939	130	16	79	4	23	151	440664	440540	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	130	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
21687408	21687408	PRJDB9741_P_NODE_16978_length_183_cov_1.522388_g16661_i0	PRJDB9741	16978	183	1.522388	2.78597004	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	163	6.899999999999999e-36	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g16661	i0	83.243	63.8251366120219	185	23	98	6	1	180	720568	720387	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	11680	163	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
23934321	23934321	PRJDB9741_P_NODE_5719_length_263_cov_1.471963_g5403_i0	PRJDB9741	5719	263	1.471963	3.87126269	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	363	9.769999999999999e-96	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g5403	i0	91.76	80.7490494296578	267	13	100	6	1	263	142474	142213	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	21237	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
27506710	27506710	PRJDB9741_P_NODE_30523_length_166_cov_0.871795_g30206_i0	PRJDB9741	30523	166	0.871795	1.4471797	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	57	1.17e-7	NR	MCX5922709.1	2030827	g30206	i0	53.7	0.975903614457831	54	24	95.8	1	164	6	138	191	MCX5922709.1 DUF4804 domain-containing protein [Candidatus Dependentiae bacterium]	diamond	162	57	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
27569614	27569614	PRJDB9741_P_NODE_9404_length_210_cov_2.875776_g9087_i0	PRJDB9741	9404	210	2.875776	6.0391296	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	47	8.02e-4	NR	PYO20021.1	2053607	g9087	i0	60.5	1.95714285714286	38	15	54.3	0	114	1	208	245	PYO20021.1 MAG: hypothetical protein DMD88_13365 [Candidatus Rokuibacteriota bacterium]	diamond	411	47	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
27790800	27790800	PRJDB9741_P_NODE_7564_length_228_cov_2.033520_g7247_i0	PRJDB9741	7564	228	2.03352	4.6364256	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	49.7	1.94e-5	NR	MDR3570671.1	2053589	g7247	i0	75	0.421052631578947	32	8	42.1	0	12	107	76	107	MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	96	49.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28043293	28043293	PRJDB9741_P_NODE_36225_length_163_cov_0.894737_g35908_i0	PRJDB9741	36225	163	0.894737	1.45842131	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	66.2	6.49e-11	NR	MBP7760746.1	2026720	g35908	i0	55.6	0.993865030674847	54	24	99.4	0	2	163	24	77	MBP7760746.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	162	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28611648	28611648	PRJDB9741_P_NODE_25047_length_170_cov_1.644628_g24730_i0	PRJDB9741	25047	170	1.644628	2.7958676	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	47.8	2.14e-4	NR	MDO8479189.1	2053607	g24730	i0	80.8	1.30588235294118	26	5	45.9	0	4	81	232	257	MDO8479189.1 methyltransferase domain-containing protein [Candidatus Rokuibacteriota bacterium]	diamond	222	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
30664430	30664430	PRJDB9741_P_NODE_43413_length_151_cov_2.500000_g43096_i0	PRJDB9741	43413	151	2.5	3.775	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	99	8.19e-25	NR	MBB1567657.1	2026720	g43096	i0	95.9	0.973509933774834	49	2	97.4	0	149	3	97	145	MBB1567657.1 septum formation initiator family protein [Candidatus Saccharibacteria bacterium]	diamond	147	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31201136	31201136	PRJDB9741_P_NODE_31235_length_165_cov_1.508621_g30918_i0	PRJDB9741	31235	165	1.508621	2.48922465	Candidatus Magasanikbacteria bacterium RIFOXYC2_FULL_42_28	1798704	Bacteria	Bacteria	89	5.77e-19	NR	OGH88075.1	1798704	g30918	i0	81.1	2.90909090909091	53	10	96.4	0	6	164	422	474	OGH88075.1 MAG: adenosylhomocysteinase [Candidatus Magasanikbacteria bacterium RIFOXYC2_FULL_42_28]	diamond	480	89	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium RIFOXYC2_FULL_42_28
32403782	32403782	PRJDB9741_P_NODE_7639_length_227_cov_1.932584_g7322_i0	PRJDB9741	7639	227	1.932584	4.38696568	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	90.1	6.36e-19	NR	MDD4995818.1	2052139	g7322	i0	59.1	0.872246696035242	66	27	87.2	0	227	30	825	890	MDD4995818.1 hypothetical protein [Patescibacteria group bacterium]	diamond	198	90.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32435630	32435630	PRJDB9741_P_NODE_25319_length_170_cov_1.239669_g25002_i0	PRJDB9741	25319	170	1.239669	2.1074373	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	112	1.46e-27	NR	RKW01118.1	1917697	g25002	i0	96.4	0.970588235294118	55	2	97.1	0	5	169	309	363	RKW01118.1 MAG: hypothetical protein D8B38_04740 [Candidatus Saccharimonas sp.]	diamond	165	112	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
32556228	32556228	PRJDB9741_P_NODE_9659_length_210_cov_2.472050_g9342_i0	PRJDB9741	9659	210	2.47205	5.191305	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	64.3	4.79e-10	NR	RKW04463.1	1917697	g9342	i0	96.9	1.47142857142857	32	1	45.7	0	208	113	2	33	RKW04463.1 MAG: pyridine nucleotide-disulfide oxidoreductase, partial [Candidatus Saccharimonas sp.]	diamond	309	64.7	0.993817619783617	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
32902186	32902186	PRJDB9741_P_NODE_34200_length_164_cov_0.886957_g33883_i0	PRJDB9741	34200	164	0.886957	1.45460948	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	104	1.11e-24	NR	HPQ82428.1	1917697	g33883	i0	94.4	1.97560975609756	54	3	98.8	0	164	3	181	234	HPQ82428.1 HAD-IC family P-type ATPase [Candidatus Saccharimonas sp.]	diamond	324	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.

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