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

27 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
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
7215213	7215213	PRJNA849172_P_NODE_68666_length_271_cov_2.111111_g68306_i0	PRJNA849172	68666	271	2.111111	5.72111081	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	76.8	1.47e-9	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g68306	i0	97.727	12.6789667896679	44	1	16	0	1	44	3812355	3812398	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	3436	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
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
9762345	9762345	PRJNA849172_P_NODE_109028_length_241_cov_38.797619_g108668_i0	PRJNA849172	109028	241	38.797619	93.50226179	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	302	1.95e-77	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g108668	i0	91.705	29.2323651452282	217	18	90	0	2	218	964632	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	7045	302	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
9764329	9764329	PRJNA849172_P_NODE_40408_length_325_cov_4.376984_g40048_i0	PRJNA849172	40408	325	4.376984	14.225198	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	76.8	1.81e-9	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g40048	i0	88.889	1.74769230769231	63	5	19	2	247	308	2539346	2539407	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	568	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
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
12314786	12314786	PRJNA849172_P_NODE_19510_length_468_cov_5.237975_g19151_i0	PRJNA849172	19510	468	5.237975	24.513723	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	536	1.0299999999999999e-147	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g19151	i0	87.474	134.724358974359	487	33	100	18	1	468	962563	963040	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	63051	536	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
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
18688609	18688609	PRJNA849172_P_NODE_76895_length_262_cov_7.465608_g76535_i0	PRJNA849172	76895	262	7.465608	19.55989296	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	97.1	1.09e-15	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g76535	i0	96.552	9.78625954198473	58	2	22	0	132	189	1156732	1156675	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	2564	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
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
22512147	22512147	PRJNA849172_P_NODE_145978_length_201_cov_4.757812_g145618_i0	PRJNA849172	145978	201	4.757812	9.56320212	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	139	1.3e-28	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g145618	i0	81.548	1.97014925373134	168	31	84	0	34	201	923967	923800	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	396	139	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
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.
23788706	23788706	PRJNA849172_P_NODE_46139_length_307_cov_6.773504_g45779_i0	PRJNA849172	46139	307	6.773504	20.79465728	uncultured Candidatus Babeliaceae bacterium	2501594	Bacteria	Bacteria	220	7.42e-53	NTclustered	gi\|2874253872\|emb\|OY969927.1\|	2501594	g45779	i0	80.333	38.1368078175896	300	52	98	3	7	306	806850	807142	MAG: uncultured Candidatus Babeliaceae bacterium isolate MFD01476.bin.c.8 genome assembly, chromosome: 1	blastn	11708	220	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		uncultured Candidatus Babeliaceae bacterium
23790202	23790202	PRJNA849172_P_NODE_97519_length_247_cov_4.097701_g97159_i0	PRJNA849172	97519	247	4.097701	10.12132147	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g97159	i0	95.51	126.024291497976	245	11	99	0	1	245	963842	964086	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	31128	392	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
25063186	25063186	PRJNA849172_P_NODE_64840_length_275_cov_2.965347_g64480_i0	PRJNA849172	64840	275	2.965347	8.15470425	uncultured bacterium pTW2	504464	Bacteria	Bacteria	135	2.4400000000000003e-27	NTclustered	gi\|168830294\|gb\|EU333168.1\|	504464	g64480	i0	87.705	26.5854545454545	122	8	44	7	4	123	16899	17015	Uncultured bacterium pTW2 RplA (rplA), RplK (rplK), NusG (nusG), SecE (secE), Tuf (tuf), YchF (ychF), Pth (pth), RplY (rplY), RpsA (rpsA), IspE (ispE), LolB (lolB), hypothetical protein, HemA (hemA), PrfA (prfA), GCN5-related N-acetyltransferase, MoaB (moaB), hypothetical protein, AcyP (acyP), YneN (yneN), Rpn (rpn), WrbA (wrbA), hypothetical proteins, AspG (aspG), hypothetical proteins, MprA (mprA), and hypothetical proteins genes, complete cds; and PtnB (ptnB) gene, partial cds	blastn	7311	135	1	Bacteria	Bacteria candidate phyla						uncultured bacterium pTW2
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);;