metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA293022" 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
1648038	1648038	PRJNA293022_P_NODE_382_length_1703_cov_7.244256_g236_i0	PRJNA293022	382	1703	7.244256	123.36967968	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	2019	0	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g236	i0	94.826	219.135642982971	1295	66	76	1	1	1295	139600	138307	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	373188	2019	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
1648208	1648208	PRJNA293022_P_NODE_72822_length_166_cov_0.888889_g72085_i0	PRJNA293022	72822	166	0.888889	1.47555574	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|1995742126\|gb\|CP070993.1\|	2030810	g72085	i0	85.714	33.3855421686747	161	17	94	5	5	160	405301	405142	MAG: Candidatus Kaiserbacteria bacterium isolate FR12parc1 chromosome, complete genome	blastn	5542	165	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
2334928	2334928	PRJNA293022_P_NODE_31882_length_248_cov_1.527638_g31145_i0	PRJNA293022	31882	248	1.527638	3.78854224	Bacteria	2	Bacteria	Bacteria	422	1.48e-113	NTclustered	gi\|402243568\|gb\|JX294354.1\|	1226340	g31145	i0	99.145	100.318548387097	234	2	94	0	3	236	1234	1467	GN02 bacterium oral taxon 873 clone 4Q04 16S ribosomal RNA gene, partial sequence	blastn	24879	422	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Gracilibacteria bacterium oral taxon 873
5476777	5476777	PRJNA293022_P_NODE_4705_length_646_cov_4.698492_g4055_i0	PRJNA293022	4705	646	4.698492	30.35225832	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	828	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4055	i0	98.712	397.656346749226	466	6	72	0	2	467	907486	907021	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	256886	828	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6750889	6750889	PRJNA293022_P_NODE_23466_length_292_cov_3.469136_g22729_i0	PRJNA293022	23466	292	3.469136	10.12987712	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	248	3.22e-61	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g22729	i0	86.344	41.9178082191781	227	31	78	0	25	251	813885	813659	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	12240	248	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6750901	6750901	PRJNA293022_P_NODE_27026_length_271_cov_1.297297_g26289_i0	PRJNA293022	27026	271	1.297297	3.51567487	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	398	2.7699999999999993e-106	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g26289	i0	94.574	176.284132841328	258	13	95	1	14	271	138659	138403	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	47773	398	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
8026616	8026616	PRJNA293022_P_NODE_42567_length_214_cov_1.248485_g41830_i0	PRJNA293022	42567	214	1.248485	2.6717579	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	263	8.000000000000002e-66	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g41830	i0	89.151	54.2523364485981	212	22	99	1	1	212	543807	544017	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	11610	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
9301485	9301485	PRJNA293022_P_NODE_6888_length_543_cov_3.076923_g6178_i0	PRJNA293022	6888	543	3.076923	16.70769189	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	200	1.8e-46	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g6178	i0	74.506	37.2265193370166	557	97	99	36	4	541	628565	628035	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	20214	200	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9987911	9987911	PRJNA293022_P_NODE_7308_length_528_cov_5.054280_g6589_i0	PRJNA293022	7308	528	5.05428	26.6865984	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	905	0	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g6589	i0	97.719	139.920454545455	526	12	99	0	3	528	151807	152332	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	73878	911	0.993413830954994	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9987919	9987919	PRJNA293022_P_NODE_74748_length_164_cov_2.808696_g74011_i0	PRJNA293022	74748	164	2.808696	4.60626144	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	259	7.52e-65	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g74011	i0	95.122	105.05487804878	164	8	100	0	1	164	904988	905151	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	17229	261	0.992337164750958	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
10577148	10577148	PRJNA293022_P_NODE_24529_length_285_cov_2.207627_g23792_i0	PRJNA293022	24529	285	2.207627	6.29173695	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	405	1.75e-108	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g23792	i0	92.606	213.764912280702	284	17	99	4	1	282	890448	890167	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	60923	405	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
10577160	10577160	PRJNA293022_P_NODE_26529_length_274_cov_1.168889_g25792_i0	PRJNA293022	26529	274	1.168889	3.20275586	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	183	8.549999999999997e-42	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g25792	i0	80.816	5.34306569343066	245	37	88	10	33	272	125738	125977	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1464	183	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
10577199	10577199	PRJNA293022_P_NODE_3569_length_726_cov_2.493353_g2996_i0	PRJNA293022	3569	726	2.493353	18.10174278	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	627	9.49e-175	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g2996	i0	83.357	173.965564738292	691	101	94	12	1	683	161187	160503	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	126299	627	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
11851995	11851995	PRJNA293022_P_NODE_53270_length_191_cov_1.232394_g52533_i0	PRJNA293022	53270	191	1.232394	2.35387254	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	193	9.28e-45	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g52533	i0	85.185	255.774869109948	189	27	99	1	3	191	137670	137483	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	48853	193	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
13127109	13127109	PRJNA293022_P_NODE_42911_length_213_cov_1.554878_g42174_i0	PRJNA293022	42911	213	1.554878	3.31189014	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	250	6.19e-62	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g42174	i0	88.208	123.957746478873	212	22	99	3	1	210	125567	125357	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	26403	250	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
13127121	13127121	PRJNA293022_P_NODE_46711_length_204_cov_1.658065_g45974_i0	PRJNA293022	46711	204	1.658065	3.3824526	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	274	3.49e-69	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g45974	i0	91.176	29.7941176470588	204	15	100	3	1	204	543538	543738	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	6078	274	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
13127166	13127166	PRJNA293022_P_NODE_58251_length_182_cov_2.127820_g57514_i0	PRJNA293022	58251	182	2.12782	3.8726324	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	237	3.98e-58	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g57514	i0	90.11	64.4065934065934	182	18	100	0	1	182	161201	161382	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	11722	237	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
15676042	15676042	PRJNA293022_P_NODE_41833_length_216_cov_0.922156_g41096_i0	PRJNA293022	41833	216	0.922156	1.99185696	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	213	8.26e-51	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g41096	i0	84.793	117.060185185185	217	27	99	6	3	216	8484	8271	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	25285	213	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
16950555	16950555	PRJNA293022_P_NODE_12514_length_404_cov_1.985915_g11777_i0	PRJNA293022	12514	404	1.985915	8.0230966	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	237	9.97e-58	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g11777	i0	83.658	63.1163366336634	257	37	63	4	1	254	813237	813491	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	25499	237	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
16950775	16950775	PRJNA293022_P_NODE_65674_length_171_cov_1.508197_g64937_i0	PRJNA293022	65674	171	1.508197	2.57901687	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	189	1.0499999999999996e-43	NTclustered	gi\|2556888284\|gb\|CP129475.1\|	2099670	g64937	i0	87.135	1	171	16	98	6	4	171	510689	510522	MAG: Candidatus Dojkabacteria bacterium isolate cMAG.21 chromosome, complete genome	blastn	171	189	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
17637330	17637330	PRJNA293022_P_NODE_38394_length_225_cov_2.886364_g37657_i0	PRJNA293022	38394	225	2.886364	6.494319	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	368	1.75e-97	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g37657	i0	96.413	133.271111111111	223	8	99	0	1	223	79818	79596	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	29986	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18224871	18224871	PRJNA293022_P_NODE_20915_length_311_cov_2.400763_g20178_i0	PRJNA293022	20915	311	2.400763	7.46637293	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	540	5.09e-149	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g20178	i0	98.684	63.4951768488746	304	4	99	0	6	309	111847	111544	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	19747	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
18224876	18224876	PRJNA293022_P_NODE_2155_length_904_cov_3.389474_g1719_i0	PRJNA293022	2155	904	3.389474	30.64084496	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	625	4.289999999999999e-174	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g1719	i0	79.665	101.648230088496	895	161	98	20	11	895	125802	126685	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	91890	625	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
19499104	19499104	PRJNA293022_P_NODE_22536_length_299_cov_2.252000_g21799_i0	PRJNA293022	22536	299	2.252	6.73348	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	322	1.92e-83	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g21799	i0	86.851	5.32775919732441	289	36	96	2	4	290	126918	127206	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	1593	322	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
19499205	19499205	PRJNA293022_P_NODE_43236_length_212_cov_2.024540_g42499_i0	PRJNA293022	43236	212	2.02454	4.2920248	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	340	3.55e-89	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g42499	i0	96.585	243.27358490566	205	7	97	0	7	211	884054	883850	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	51574	340	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19499301	19499301	PRJNA293022_P_NODE_67056_length_169_cov_1.716667_g66319_i0	PRJNA293022	67056	169	1.716667	2.90116723	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	243	7.8e-60	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g66319	i0	92.857	10.0177514792899	168	11	99	1	1	167	890617	890450	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	1693	243	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
20774902	20774902	PRJNA293022_P_NODE_69957_length_167_cov_2.169492_g69220_i0	PRJNA293022	69957	167	2.169492	3.62305164	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	254	3.58e-63	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g69220	i0	94.048	3.92814371257485	168	8	99	2	1	166	891289	891122	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	656	254	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
22049638	22049638	PRJNA293022_P_NODE_21718_length_305_cov_2.503906_g20981_i0	PRJNA293022	21718	305	2.503906	7.6369133	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	409	1.46e-109	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g20981	i0	91.118	63.1606557377049	304	24	99	3	1	303	452001	451700	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	19264	409	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
22049642	22049642	PRJNA293022_P_NODE_22898_length_296_cov_3.744939_g22161_i0	PRJNA293022	22898	296	3.744939	11.08501944	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	147	1.23e-30	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g22161	i0	78.279	73.8851351351351	244	42	80	9	58	293	429346	429586	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	21870	147	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
23325466	23325466	PRJNA293022_P_NODE_72219_length_166_cov_0.888889_g71482_i0	PRJNA293022	72219	166	0.888889	1.47555574	Candidatus Peribacter riflensis	1735162	Bacteria	Bacteria	69.4	1.38e-7	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g71482	i0	82.143	2.53012048192771	84	11	49	4	15	96	1195085	1195004	MAG: Candidatus Peribacter riflensis, complete genome	blastn	420	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacter	Candidatus Peribacter riflensis

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