metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

23 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Candidatus Saccharimonadota"

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
18237	18237	PRJEB11748_P_NODE_326981_length_207_cov_9.349315_g324798_i0	PRJEB11748	326981	207	9.349315	19.35308205	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	337	4.469999999999999e-88	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g324798	i0	99.459	0.893719806763285	185	1	89	0	1	185	123865	124049	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	185	337	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
1290567	1290567	PRJEB11748_P_NODE_220762_length_267_cov_2.014563_g218579_i0	PRJEB11748	220762	267	2.014563	5.37888321	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	298	2.84e-76	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g218579	i0	89.256	69.4531835205993	242	21	90	5	7	245	450302	450063	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	18544	298	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
2257795	2257795	PRJEB11748_P_NODE_102362_length_412_cov_16.136752_g100191_i0	PRJEB11748	102362	412	16.136752	66.48341824	Bacteria	2	Bacteria	Bacteria	558	1.91e-154	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g100191	i0	96.726	145.844660194175	336	10	91	1	56	390	851156	850821	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	60088	558	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
2564462	2564462	PRJEB11748_P_NODE_135243_length_355_cov_2.418367_g133065_i0	PRJEB11748	135243	355	2.418367	8.58520285	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	470	7.82e-128	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g133065	i0	92.923	187.050704225352	325	20	91	3	29	351	659026	658703	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	66403	470	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
2567209	2567209	PRJEB11748_P_NODE_274723_length_232_cov_5.573099_g272540_i0	PRJEB11748	274723	232	5.573099	12.92958968	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	204	5.4099999999999996e-48	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g272540	i0	84.615	140.655172413793	208	28	89	4	4	209	850051	849846	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	32632	204	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6087443	6087443	PRJEB11748_P_NODE_314545_length_213_cov_0.960526_g312362_i0	PRJEB11748	314545	213	0.960526	2.04592038	Bacteria	2	Bacteria	Bacteria	243	1.0400000000000001e-59	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g312362	i0	87.5	59.8779342723005	216	20	100	7	1	213	597905	598116	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	12754	244	0.995901639344262	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6393924	6393924	PRJEB11748_P_NODE_195506_length_287_cov_10.146018_g193323_i0	PRJEB11748	195506	287	10.146018	29.11907166	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	492	1.32e-134	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g193323	i0	99.628	2.04878048780488	269	1	94	0	19	287	660541	660809	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	588	492	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
6394999	6394999	PRJEB11748_P_NODE_252766_length_245_cov_2.820652_g250583_i0	PRJEB11748	252766	245	2.820652	6.9105974	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	405	1.47e-108	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g250583	i0	97.863	219.216326530612	234	5	96	0	1	234	884277	884510	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	53708	405	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
7669661	7669661	PRJEB11748_P_NODE_286347_length_226_cov_3.618182_g284164_i0	PRJEB11748	286347	226	3.618182	8.17709132	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	278	3.05e-70	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g284164	i0	91.542	419.323008849558	201	17	89	0	8	208	667162	667362	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	94767	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
8637306	8637306	PRJEB11748_P_NODE_302147_length_218_cov_7.796178_g299964_i0	PRJEB11748	302147	218	7.796178	16.99566804	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	340	3.6699999999999996e-89	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g299964	i0	94.595	293.454128440367	222	8	100	1	1	218	143228	143449	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	63973	340	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
10221373	10221373	PRJEB11748_P_NODE_34889_length_744_cov_16.467057_g32964_i0	PRJEB11748	34889	744	16.467057	122.51490408	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	248	8.86e-61	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g32964	i0	78.079	1.88306451612903	406	80	54	9	25	425	251436	251035	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	1401	248	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
11494777	11494777	PRJEB11748_P_NODE_244610_length_250_cov_4.693122_g242427_i0	PRJEB11748	244610	250	4.693122	11.732805	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	272	1.6e-68	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g242427	i0	90.047	53.724	211	19	84	2	1	211	599353	599561	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	13431	272	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11496751	11496751	PRJEB11748_P_NODE_359230_length_193_cov_2.924242_g357047_i0	PRJEB11748	359230	193	2.924242	5.64378706	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	130	7.470000000000001e-26	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g357047	i0	87.611	5.42487046632124	113	13	58	1	17	128	453251	453363	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	1047	130	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
12770490	12770490	PRJEB11748_P_NODE_256851_length_242_cov_27.585635_g254668_i0	PRJEB11748	256851	242	27.585635	66.757236700000007	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	187	5.73e-43	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g254668	i0	84.456	56.7727272727273	193	26	79	4	25	215	658856	658666	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	13739	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
14043856	14043856	PRJEB11748_P_NODE_195892_length_287_cov_3.761062_g193709_i0	PRJEB11748	195892	287	3.761062	10.79424794	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	440	4.849999999999998e-119	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g193709	i0	97.656	92.7073170731707	256	6	89	0	32	287	543230	542975	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	26607	440	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
15316582	15316582	PRJEB11748_P_NODE_124973_length_370_cov_19.203883_g122797_i0	PRJEB11748	124973	370	19.203883	71.0543671	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	427	5e-115	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g122797	i0	88.857	133.867567567568	350	35	94	4	1	348	850192	849845	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	49531	427	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
16286544	16286544	PRJEB11748_P_NODE_257433_length_242_cov_4.718232_g255250_i0	PRJEB11748	257433	242	4.718232	11.41812144	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	385	1.89e-102	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g255250	i0	98.182	150.214876033058	220	4	91	0	23	242	142203	142422	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	36352	385	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
16591496	16591496	PRJEB11748_P_NODE_139814_length_348_cov_13.041812_g137635_i0	PRJEB11748	139814	348	13.041812	45.38550576	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	540	5.77e-149	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g137635	i0	99.331	0.96264367816092	299	1	94	1	29	326	388296	388594	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	335	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
17866671	17866671	PRJEB11748_P_NODE_152435_length_332_cov_4.749077_g150253_i0	PRJEB11748	152435	332	4.749077	15.76693564	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	551	2.529999999999999e-152	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g150253	i0	98.71	119.566265060241	310	4	93	0	23	332	221976	222285	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	39696	551	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
19141457	19141457	PRJEB11748_P_NODE_203616_length_280_cov_33.429224_g201433_i0	PRJEB11748	203616	280	33.429224	93.6018272	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	302	2.32e-77	NTclustered	gi\|2890901196\|gb\|CP128407.1\|	713059	g201433	i0	91.441	109.039285714286	222	15	79	4	1	221	148154	147936	Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome	blastn	30531	302	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
21385398	21385398	PRJEB11748_P_NODE_172397_length_309_cov_17.536290_g170214_i0	PRJEB11748	172397	309	17.53629	54.1871361	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	368	2.52e-97	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g170214	i0	91.039	109.644012944984	279	16	89	6	12	287	142476	142204	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	33880	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
21693889	21693889	PRJEB11748_P_NODE_268938_length_235_cov_32.540230_g266755_i0	PRJEB11748	268938	235	32.54023	76.4695405	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	329	8.69e-86	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g266755	i0	94.419	65.7234042553192	215	11	91	1	1	214	850066	849852	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	15445	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
22970818	22970818	PRJEB11748_P_NODE_367859_length_188_cov_13.047244_g365676_i0	PRJEB11748	367859	188	13.047244	24.52881872	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	215	1.94e-51	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g365676	i0	90.303	135.047872340426	165	14	87	2	9	172	850051	849888	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	25389	215	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17

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