metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
5941139	5941139	PRJNA849172_P_NODE_96745_length_248_cov_0.891429_g96385_i0	PRJNA849172	96745	248	0.891429	2.21074392	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1805658607\|gb\|CP047918.1\|	2572087	g96385	i0	99.597	6	248	1	100	0	1	248	177609	177856	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome	blastn	1488	453	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
8886041	8886041	PRJNA849172_P_NODE_82987_length_257_cov_2.130435_g82627_i0	PRJNA849172	82987	257	2.130435	5.47521795	Candidatus Southlakia	3350975	Bacteria	Bacteria	117	8.17e-22	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g82627	i0	100	16.4591439688716	63	0	25	0	195	257	227419	227357	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	4230	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
9765072	9765072	PRJNA849172_P_NODE_65188_length_275_cov_1.534653_g64828_i0	PRJNA849172	65188	275	1.534653	4.22029575	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	230	1.0899999999999995e-55	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g64828	i0	95.775	1.04727272727273	142	6	52	0	134	275	737441	737582	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	288	230	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
9765917	9765917	PRJNA849172_P_NODE_94488_length_249_cov_1.772727_g94128_i0	PRJNA849172	94488	249	1.772727	4.41409023	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g94128	i0	97.189	1	249	7	100	0	1	249	185398	185150	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	249	422	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
13588073	13588073	PRJNA849172_P_NODE_111851_length_239_cov_3.024096_g111491_i0	PRJNA849172	111851	239	3.024096	7.22758944	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	84.2	7.62e-12	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g111491	i0	87.838	0.543933054393305	74	5	31	3	167	239	780795	780725	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	130	84.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13589843	13589843	PRJNA849172_P_NODE_36831_length_339_cov_6.898496_g36472_i0	PRJNA849172	36831	339	6.898496	23.38590144	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	549	9.309999999999997e-152	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g36472	i0	95.87	26.3451327433628	339	14	100	0	1	339	390503	390165	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	8931	549	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
13591014	13591014	PRJNA849172_P_NODE_75751_length_263_cov_56.105263_g75391_i0	PRJNA849172	75751	263	56.105263	147.55684169	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	320	5.96e-83	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g75391	i0	89.96	117.197718631179	249	24	95	1	15	263	220141	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	30823	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
13591432	13591432	PRJNA849172_P_NODE_89831_length_252_cov_0.865922_g89471_i0	PRJNA849172	89831	252	0.865922	2.18212344	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	303	5.71e-78	NTclustered	gi\|2890901196\|gb\|CP128407.1\|	713059	g89471	i0	88.755	9.72619047619048	249	26	98	2	1	248	291783	292030	Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome	blastn	2451	303	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
14862499	14862499	PRJNA849172_P_NODE_118012_length_233_cov_5.856250_g117652_i0	PRJNA849172	118012	233	5.85625	13.6450625	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	392	1.08e-104	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g117652	i0	96.996	80.2489270386266	233	7	100	0	1	233	906674	906442	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	18698	392	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
14864880	14864880	PRJNA849172_P_NODE_62892_length_277_cov_6.122549_g62532_i0	PRJNA849172	62892	277	6.122549	16.95946073	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	496	9.8e-136	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g62532	i0	98.917	144.646209386282	277	3	100	0	1	277	452996	452720	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	40067	496	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
17413141	17413141	PRJNA849172_P_NODE_131554_length_219_cov_4.273973_g131194_i0	PRJNA849172	131554	219	4.273973	9.36000087	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	303	4.84e-78	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g131194	i0	92.823	1.91780821917808	209	15	95	0	6	214	739765	739973	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	420	303	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
18685792	18685792	PRJNA849172_P_NODE_115495_length_235_cov_13.098765_g115135_i0	PRJNA849172	115495	235	13.098765	30.78209775	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.42e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g115135	i0	94.444	85.2893617021277	216	11	92	1	1	216	220108	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	20043	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
18687071	18687071	PRJNA849172_P_NODE_26535_length_399_cov_2.521472_g26176_i0	PRJNA849172	26535	399	2.521472	10.06067328	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	737	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g26176	i0	100	2	399	0	100	0	1	399	178397	177999	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	798	737	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
18689113	18689113	PRJNA849172_P_NODE_9335_length_707_cov_24.195584_g8989_i0	PRJNA849172	9335	707	24.195584	171.06277888	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	1035	0	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g8989	i0	93.457	108.349363507779	703	36	99	7	10	707	666644	667341	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	76603	1035	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
19962479	19962479	PRJNA849172_P_NODE_33956_length_352_cov_10.193548_g33597_i0	PRJNA849172	33956	352	10.193548	35.88128896	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	182	4.069999999999999e-41	NTclustered	gi\|2877945256\|gb\|CP127222.1\|	2572087	g33597	i0	77.888	7.66761363636364	303	60	86	5	18	318	385765	385468	Candidatus Saccharibacteria bacterium oral taxon 955 strain 103.1.1 chromosome, complete genome	blastn	2699	182	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
21238563	21238563	PRJNA849172_P_NODE_48657_length_300_cov_3.207048_g48297_i0	PRJNA849172	48657	300	3.207048	9.621144	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	204	7.28e-48	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g48297	i0	79.125	6.56	297	60	99	2	2	297	174754	175049	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	1968	204	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
22514095	22514095	PRJNA849172_P_NODE_75598_length_264_cov_1.623037_g75238_i0	PRJNA849172	75598	264	1.623037	4.28481768	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	449	7.320000000000001e-122	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g75238	i0	97.348	2.97727272727273	264	7	100	0	1	264	599273	599010	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	786	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
25459315	25459315	PRJNA849172_P_NODE_50660_length_294_cov_6.859729_g50300_i0	PRJNA849172	50660	294	6.859729	20.16760326	Bacteria	2	Bacteria	Bacteria	492	1.36e-134	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g50300	i0	96.939	249	294	8	100	1	1	294	851075	850783	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	73206	492	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);;