metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA558770" 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
540598	540598	PRJNA558770_P_NODE_290861_length_234_cov_1.552764_g288856_i0	PRJNA558770	290861	234	1.552764	3.63346776	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	141	4.35e-29	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g288856	i0	100	0.944444444444444	76	0	65	0	159	234	149529	149454	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	221	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
541358	541358	PRJNA558770_P_NODE_366121_length_232_cov_2.335025_g364116_i0	PRJNA558770	366121	232	2.335025	5.417258	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	130	9.32e-26	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g364116	i0	97.368	2.88362068965517	76	2	65	0	1	76	240769	240694	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	669	130	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
4367034	4367034	PRJNA558770_P_NODE_230124_length_234_cov_2.798995_g228119_i0	PRJNA558770	230124	234	2.798995	6.5496483	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	78.7	3.46e-10	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g228119	i0	86.111	0.307692307692308	72	10	31	0	163	234	579375	579304	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	72	78.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6233294	6233294	PRJNA558770_P_NODE_337865_length_233_cov_4.267677_g335860_i0	PRJNA558770	337865	233	4.267677	9.94368741	Candidatus Southlakia	3350975	Bacteria	Bacteria	124	4.36e-24	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g335860	i0	98.571	1.78111587982833	70	1	62	0	159	228	543558	543489	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	415	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6916794	6916794	PRJNA558770_P_NODE_180466_length_234_cov_4.623116_g178461_i0	PRJNA558770	180466	234	4.623116	10.81809144	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	137	5.62e-28	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g178461	i0	100	5.05555555555556	74	0	32	0	160	233	832630	832557	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	1183	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
6921386	6921386	PRJNA558770_P_NODE_97686_length_234_cov_13.015075_g95681_i0	PRJNA558770	97686	234	13.015075	30.4552755	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	134	7.28e-27	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g95681	i0	98.667	0.641025641025641	75	1	32	0	1	75	190656	190582	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	150	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
10057251	10057251	PRJNA558770_P_NODE_138028_length_234_cov_7.356784_g136023_i0	PRJNA558770	138028	234	7.356784	17.21487456	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	141	4.35e-29	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g136023	i0	100	5.78205128205128	76	0	65	0	1	76	142187	142262	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	1353	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
10741575	10741575	PRJNA558770_P_NODE_117229_length_234_cov_9.562814_g115224_i0	PRJNA558770	117229	234	9.562814	22.37698476	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	126	1.22e-24	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g115224	i0	96.104	0.931623931623932	77	3	64	0	158	234	768836	768760	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	218	126	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
10742692	10742692	PRJNA558770_P_NODE_167349_length_234_cov_5.316583_g165344_i0	PRJNA558770	167349	234	5.316583	12.44080422	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g165344	i0	100	0.58547008547008506	75	0	32	0	160	234	736937	736863	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	137	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
10743490	10743490	PRJNA558770_P_NODE_207409_length_234_cov_3.502513_g205404_i0	PRJNA558770	207409	234	3.502513	8.19588042	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	87.9	5.74e-13	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g205404	i0	88	4.04273504273504	75	7	32	2	159	232	883687	883760	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	946	87.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
10744777	10744777	PRJNA558770_P_NODE_280289_length_234_cov_1.728643_g278284_i0	PRJNA558770	280289	234	1.728643	4.04502462	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	110	1.23e-19	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g278284	i0	93.243	0.316239316239316	74	5	32	0	2	75	169924	169851	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	74	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11332146	11332146	PRJNA558770_P_NODE_193009_length_234_cov_4.060302_g191004_i0	PRJNA558770	193009	234	4.060302	9.50110668	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g191004	i0	100	3.84615384615385	75	0	32	0	1	75	698163	698089	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	900	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
12019518	12019518	PRJNA558770_P_NODE_279310_length_234_cov_1.743719_g277305_i0	PRJNA558770	279310	234	1.743719	4.08030246	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	102	2.05e-17	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g277305	i0	94.03	0.286324786324786	67	4	29	0	9	75	801985	802051	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	67	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
12608907	12608907	PRJNA558770_P_NODE_397170_length_152_cov_1.606838_g395165_i0	PRJNA558770	397170	152	1.606838	2.44239376	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	237	3.2e-58	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g395165	i0	94.737	124.546052631579	152	8	100	0	1	152	150611	150460	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	18931	237	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
15843254	15843254	PRJNA558770_P_NODE_277353_length_234_cov_1.773869_g275348_i0	PRJNA558770	277353	234	1.773869	4.15085346	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	117	7.33e-22	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g275348	i0	94.667	1.23076923076923	75	4	32	0	160	234	546173	546099	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	288	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18390821	18390821	PRJNA558770_P_NODE_186735_length_234_cov_4.326633_g184730_i0	PRJNA558770	186735	234	4.326633	10.12432122	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	126	1.22e-24	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g184730	i0	100	37.9017094017094	68	0	29	0	8	75	938730	938797	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	8869	126	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
20942782	20942782	PRJNA558770_P_NODE_291037_length_234_cov_1.547739_g289032_i0	PRJNA558770	291037	234	1.547739	3.62170926	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	122	1.5699999999999994e-23	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g289032	i0	96	1.44871794871795	75	3	64	0	160	234	787481	787555	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	339	122	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
23492710	23492710	PRJNA558770_P_NODE_267379_length_234_cov_1.959799_g265374_i0	PRJNA558770	267379	234	1.959799	4.58592966	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|1805660319\|gb\|CP047920.1\|	713059	g265374	i0	100	5.71794871794872	75	0	63	0	1	75	462216	462290	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS07P chromosome, complete genome	blastn	1338	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
25355367	25355367	PRJNA558770_P_NODE_204340_length_234_cov_3.618090_g202335_i0	PRJNA558770	204340	234	3.61809	8.4663306	root	1	Root_unresolved	Root_unresolved	58.4	4.5e-4	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g202335	i0	100	0.388888888888889	31	0	13	0	1	31	443507	443537	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	91	58.4	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);;