metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax

29 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
131564	131564	PRJEB66218_P_NODE_158481_length_235_cov_1.758621_g156051_i0	PRJEB66218	158481	235	1.758621	4.13275935	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	412	8.39e-111	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g156051	i0	98.298	71.3489361702128	235	4	100	0	1	235	113096	112862	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	16767	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
134207	134207	PRJEB66218_P_NODE_71981_length_377_cov_4.547468_g69556_i0	PRJEB66218	71981	377	4.547468	17.14395436	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	178	5.68e-40	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g69556	i0	88.079	77.42175066313	151	17	40	1	183	332	664652	664802	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	29188	178	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
2682244	2682244	PRJEB66218_P_NODE_191943_length_214_cov_1.274510_g189513_i0	PRJEB66218	191943	214	1.27451	2.7274514	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	379	7.609999999999999e-101	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g189513	i0	98.598	74.1635514018692	214	3	100	0	1	214	111359	111572	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	15871	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
3958961	3958961	PRJEB66218_P_NODE_242864_length_200_cov_2.438849_g240433_i0	PRJEB66218	242864	200	2.438849	4.877698	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	287	4.38e-73	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g240433	i0	92.5	58.215	200	15	100	0	1	200	127175	127374	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	11643	287	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
6508703	6508703	PRJEB66218_P_NODE_107366_length_293_cov_7.215517_g104937_i0	PRJEB66218	107366	293	7.215517	21.14146481	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	416	8.359999999999998e-112	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g104937	i0	93.286	132.921501706485	283	17	96	2	12	293	138377	138096	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	38946	416	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
7787068	7787068	PRJEB66218_P_NODE_93167_length_320_cov_2.011583_g90739_i0	PRJEB66218	93167	320	2.011583	6.4370656	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	244	4.61e-60	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g90739	i0	86.222	5.265625	225	31	70	0	96	320	813659	813883	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	1685	244	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9059447	9059447	PRJEB66218_P_NODE_197808_length_211_cov_0.866667_g195378_i0	PRJEB66218	197808	211	0.866667	1.82866737	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	335	1.6399999999999994e-87	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g195378	i0	95.261	2	211	10	100	0	1	211	777707	777917	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	422	335	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
9061596	9061596	PRJEB66218_P_NODE_78428_length_357_cov_61.094595_g76002_i0	PRJEB66218	78428	357	61.094595	218.10770415	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	124	7.06e-24	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g76002	i0	89.216	36.0924369747899	102	7	29	3	39	140	2165631	2165728	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	12885	124	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
10337532	10337532	PRJEB66218_P_NODE_84929_length_340_cov_1.394265_g82502_i0	PRJEB66218	84929	340	1.394265	4.740501	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	368	2.81e-97	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g82502	i0	86.176	99.4941176470588	340	47	100	0	1	340	1294979	1295318	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	33828	368	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
11197933	11197933	PRJEB66218_P_NODE_212349_length_208_cov_0.884354_g209919_i0	PRJEB66218	212349	208	0.884354	1.83945632	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	363	7.409999999999998e-96	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g209919	i0	98.077	3.99038461538462	208	4	100	0	1	208	89663	89870	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	830	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
11609151	11609151	PRJEB66218_P_NODE_11430_length_1276_cov_12.934979_g9886_i0	PRJEB66218	11430	1276	12.934979	165.05033204	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	2006	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g9886	i0	95.004	299.16144200627	1281	58	100	6	1	1276	799591	800870	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	381730	2006	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
11612062	11612062	PRJEB66218_P_NODE_4870_length_2107_cov_5.282502_g4093_i0	PRJEB66218	4870	2107	5.282502	111.30231714	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	80.5	9.99e-10	NTclustered	gi\|2546137836\|emb\|OY282383.1\|	265321	g4093	i0	83.158	0.540579022306597	95	8	4	7	439	526	5322570	5322477	MAG: uncultured Poribacteria bacterium isolate 7c199f84-8048-4b63-b208-6e17c6421a0a genome assembly, chromosome: 1	blastn	1139	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					uncultured Poribacteria bacterium
12473616	12473616	PRJEB66218_P_NODE_22610_length_809_cov_6.312834_g20463_i0	PRJEB66218	22610	809	6.312834	51.07082706	Bacteria	2	Bacteria	Bacteria	1109	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g20463	i0	93.894	139.313967861557	737	42	91	3	74	808	851947	852682	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	112705	1114	0.995511669658887	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
14160689	14160689	PRJEB66218_P_NODE_203092_length_210_cov_0.872483_g200662_i0	PRJEB66218	203092	210	0.872483	1.8322143	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	228	2.849999999999999e-55	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g200662	i0	86.449	53.2809523809524	214	21	100	7	1	210	2305664	2305455	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	11189	228	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
14160839	14160839	PRJEB66218_P_NODE_213632_length_207_cov_8.102740_g211202_i0	PRJEB66218	213632	207	8.10274	16.7726718	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	278	2.75e-70	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g211202	i0	90.821	57.4444444444444	207	19	100	0	1	207	801410	801204	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11891	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14161456	14161456	PRJEB66218_P_NODE_27912_length_704_cov_1.237947_g25633_i0	PRJEB66218	27912	704	1.237947	8.71514688	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	643	9.119999999999999e-180	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g25633	i0	83.24	72.4744318181818	716	105	100	8	1	704	776510	775798	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	51022	643	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
15435419	15435419	PRJEB66218_P_NODE_248193_length_190_cov_2.015504_g245761_i0	PRJEB66218	248193	190	2.015504	3.8294576	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	176	9.28e-40	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g245761	i0	83.77	5.05789473684211	191	25	98	4	4	190	813312	813500	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	961	176	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
16707581	16707581	PRJEB66218_P_NODE_125714_length_267_cov_1.674757_g123285_i0	PRJEB66218	125714	267	1.674757	4.47160119	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	171	6.46e-38	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g123285	i0	79.026	79.6554307116105	267	43	97	12	8	267	2068925	2068665	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	21268	171	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
16711129	16711129	PRJEB66218_P_NODE_84334_length_341_cov_3.457143_g81907_i0	PRJEB66218	84334	341	3.457143	11.78885763	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	361	4.709999999999999e-95	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g81907	i0	87.948	171.642228739003	307	36	90	1	33	338	126091	125785	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	58530	361	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
18846231	18846231	PRJEB66218_P_NODE_207155_length_209_cov_0.878378_g204725_i0	PRJEB66218	207155	209	0.878378	1.83581002	Bacteria	2	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|402243566\|gb\|JX294352.1\|	1226338	g204725	i0	100	101.454545454545	209	0	100	0	1	209	225	17	GN02 bacterium oral taxon 871 clone 4L02 16S ribosomal RNA gene, partial sequence	blastn	21204	387	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Gracilibacteria bacterium oral taxon 871
18846691	18846691	PRJEB66218_P_NODE_62775_length_413_cov_0.701705_g60354_i0	PRJEB66218	62775	413	0.701705	2.89804165	Bacteria	2	Bacteria	Bacteria	531	4.18e-146	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g60354	i0	89.88	158.912832929782	415	38	100	4	1	413	658609	659021	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	65631	536	0.990671641791045	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
19258810	19258810	PRJEB66218_P_NODE_34536_length_612_cov_2.490018_g32162_i0	PRJEB66218	34536	612	2.490018	15.23891016	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	832	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g32162	i0	91.205	402.735294117647	614	50	100	3	1	612	110762	111373	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	246474	832	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
20535098	20535098	PRJEB66218_P_NODE_70857_length_381_cov_2.853125_g68433_i0	PRJEB66218	70857	381	2.853125	10.87040625	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	172	2.67e-38	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g68433	i0	83.42	16.1522309711286	193	24	50	8	1	189	1250890	1250702	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	6154	172	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
21396615	21396615	PRJEB66218_P_NODE_191077_length_214_cov_1.934641_g188647_i0	PRJEB66218	191077	214	1.934641	4.14013174	Candidatus Southlakia	3350975	Bacteria	Bacteria	333	6.009999999999999e-87	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g188647	i0	97.436	110.593457943925	195	5	91	0	20	214	905000	905194	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	23667	333	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
23084486	23084486	PRJEB66218_P_NODE_226679_length_205_cov_0.902778_g224249_i0	PRJEB66218	226679	205	0.902778	1.8506949	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	196	7.819999999999999e-46	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g224249	i0	84.135	1.99512195121951	208	27	100	5	1	205	798004	798208	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	409	196	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
23084660	23084660	PRJEB66218_P_NODE_238339_length_202_cov_1.730496_g235908_i0	PRJEB66218	238339	202	1.730496	3.49560192	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	363	7.149999999999999e-96	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g235908	i0	99.01	232.613861386139	202	2	100	0	1	202	111143	110942	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	46988	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23084675	23084675	PRJEB66218_P_NODE_239059_length_202_cov_1.241135_g236628_i0	PRJEB66218	239059	202	1.241135	2.5070927	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	217	5.89e-52	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g236628	i0	86.275	24.0742574257426	204	23	100	5	1	202	75426	75226	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	4863	217	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
23084787	23084787	PRJEB66218_P_NODE_246879_length_192_cov_2.274809_g244447_i0	PRJEB66218	246879	192	2.274809	4.36763328	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	60.2	9.88e-5	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g244447	i0	89.362	0.244791666666667	47	5	24	0	1	47	1527872	1527918	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	47	60.2	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
24359572	24359572	PRJEB66218_P_NODE_54840_length_450_cov_9.195373_g52421_i0	PRJEB66218	54840	450	9.195373	41.3791785	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	113	1.97e-20	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g52421	i0	82.222	0.3	135	20	30	2	283	416	938659	938528	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	135	113	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium

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