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

27 rows where analysis = "blastn", bioproject = "PRJNA1031674" 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
166576	166576	PRJNA1031674_P_NODE_14241_length_279_cov_3.004854_g14030_i0	PRJNA1031674	14241	279	3.004854	8.38354266	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	126	1.49e-24	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g14030	i0	81.41	1.18279569892473	156	27	56	2	3	157	395387	395541	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	330	126	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
166834	166834	PRJNA1031674_P_NODE_4541_length_389_cov_1.462025_g4331_i0	PRJNA1031674	4541	389	1.462025	5.68727725	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	241	7.39e-59	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g4331	i0	78.005	1.00514138817481	391	80	99	6	1	388	148864	148477	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	391	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
1441340	1441340	PRJNA1031674_P_NODE_14482_length_279_cov_1.300971_g14271_i0	PRJNA1031674	14482	279	1.300971	3.62970909	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	231	3.0699999999999996e-56	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g14271	i0	81.915	1.01075268817204	282	44	99	6	1	277	500048	500327	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	282	231	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
1441619	1441619	PRJNA1031674_P_NODE_6402_length_344_cov_1.018450_g6191_i0	PRJNA1031674	6402	344	1.01845	3.503468	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	436	7.689999999999999e-118	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g6191	i0	90.058	0.994186046511628	342	26	99	8	1	340	603461	603796	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	342	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
3993137	3993137	PRJNA1031674_P_NODE_15764_length_274_cov_2.636816_g15553_i0	PRJNA1031674	15764	274	2.636816	7.22487584	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	207	5.08e-49	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g15553	i0	80.364	2.9963503649635	275	52	100	2	1	274	867315	867042	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	821	207	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
3993425	3993425	PRJNA1031674_P_NODE_8004_length_313_cov_3.337500_g7793_i0	PRJNA1031674	8004	313	3.3375	10.446375	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	154	7.8e-33	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g7793	i0	97.778	27.0351437699681	90	1	29	1	111	200	922079	921991	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	8462	154	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
5269455	5269455	PRJNA1031674_P_NODE_15305_length_276_cov_1.517241_g15094_i0	PRJNA1031674	15305	276	1.517241	4.18758516	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	207	5.12e-49	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g15094	i0	80.435	25.1268115942029	276	50	99	4	1	274	481807	482080	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	6935	207	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
5269695	5269695	PRJNA1031674_P_NODE_2965_length_456_cov_2.412533_g2755_i0	PRJNA1031674	2965	456	2.412533	11.00115048	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	396	1.77e-105	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g2755	i0	82.379	7.60964912280702	454	80	99	0	1	454	753539	753992	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	3470	396	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
6544665	6544665	PRJNA1031674_P_NODE_13366_length_282_cov_1.995215_g13155_i0	PRJNA1031674	13366	282	1.995215	5.6265063	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	250	8.589999999999999e-62	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g13155	i0	84.314	0.904255319148936	255	40	90	0	2	256	950432	950686	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	255	250	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
6544730	6544730	PRJNA1031674_P_NODE_17206_length_269_cov_2.637755_g16995_i0	PRJNA1031674	17206	269	2.637755	7.09556095	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	99	3.12e-16	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g16995	i0	95.161	22.4052044609665	62	3	23	0	1	62	721534	721473	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	6027	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
7819223	7819223	PRJNA1031674_P_NODE_13167_length_283_cov_1.466667_g12956_i0	PRJNA1031674	13167	283	1.466667	4.15066761	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	372	1.76e-98	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g12956	i0	91.209	0.964664310954064	273	24	96	0	1	273	1013991	1013719	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	273	372	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
9094466	9094466	PRJNA1031674_P_NODE_8808_length_310_cov_0.974684_g8597_i0	PRJNA1031674	8808	310	0.974684	3.0215204	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	259	1.5900000000000002e-64	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g8597	i0	82.237	0.980645161290323	304	51	98	3	8	310	1029445	1029144	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	304	259	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12920309	12920309	PRJNA1031674_P_NODE_12751_length_284_cov_1.872038_g12540_i0	PRJNA1031674	12751	284	1.872038	5.31658792	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	143	1.51e-29	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g12540	i0	100	10.5950704225352	77	0	27	0	82	158	830685	830609	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	3009	143	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12920595	12920595	PRJNA1031674_P_NODE_6531_length_341_cov_2.858209_g6320_i0	PRJNA1031674	6531	341	2.858209	9.74649269	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	134	1.12e-26	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g6320	i0	97.436	11.841642228739	78	2	38	0	1	78	391948	391871	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	4038	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
14195207	14195207	PRJNA1031674_P_NODE_13692_length_281_cov_1.870192_g13481_i0	PRJNA1031674	13692	281	1.870192	5.25523952	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	279	1.09e-70	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g13481	i0	84.752	12.0747330960854	282	39	99	4	2	281	558325	558604	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	3393	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
14195358	14195358	PRJNA1031674_P_NODE_25072_length_246_cov_0.890173_g24861_i0	PRJNA1031674	25072	246	0.890173	2.18982558	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	143	1.28e-29	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g24861	i0	85.816	23.130081300813	141	13	56	7	110	246	453461	453324	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	5690	143	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
14195439	14195439	PRJNA1031674_P_NODE_4572_length_388_cov_1.466667_g4362_i0	PRJNA1031674	4572	388	1.466667	5.69066796	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	139	2.7699999999999993e-28	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g4362	i0	95.455	26.1211340206186	88	3	22	1	82	168	18995	19082	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	10135	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14195485	14195485	PRJNA1031674_P_NODE_7332_length_326_cov_0.913043_g7121_i0	PRJNA1031674	7332	326	0.913043	2.97652018	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	287	7.72e-73	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g7121	i0	83.178	6.58895705521472	321	46	98	6	5	322	568410	568725	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	2148	287	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
16743631	16743631	PRJNA1031674_P_NODE_20954_length_255_cov_1.642857_g20743_i0	PRJNA1031674	20954	255	1.642857	4.18928535	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	134	8.040000000000001e-27	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g20743	i0	91	1.27450980392157	100	7	39	2	157	255	449957	450055	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	325	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
16743670	16743670	PRJNA1031674_P_NODE_23134_length_249_cov_1.301136_g22923_i0	PRJNA1031674	23134	249	1.301136	3.23982864	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	224	4.5099999999999996e-54	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g22923	i0	82.996	0.991967871485944	247	42	99	0	3	249	585892	586138	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	247	224	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18018409	18018409	PRJNA1031674_P_NODE_12275_length_286_cov_1.244131_g12064_i0	PRJNA1031674	12275	286	1.244131	3.55821466	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	230	1.1399999999999998e-55	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g12064	i0	81.588	7.25874125874126	277	51	97	0	10	286	751386	751110	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	2076	230	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18018721	18018721	PRJNA1031674_P_NODE_7095_length_330_cov_2.361868_g6884_i0	PRJNA1031674	7095	330	2.361868	7.7941644	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	383	9.699999999999998e-102	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g6884	i0	87.576	1	330	41	100	0	1	330	1028690	1028361	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	330	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
19292599	19292599	PRJNA1031674_P_NODE_26816_length_243_cov_0.905882_g26605_i0	PRJNA1031674	26816	243	0.905882	2.20129326	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	161	3.4899999999999997e-35	NTclustered	gi\|1805658607\|gb\|CP047918.1\|	2572087	g26605	i0	79.06	0.962962962962963	234	49	96	0	1	234	409420	409653	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome	blastn	234	161	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
21843739	21843739	PRJNA1031674_P_NODE_4818_length_381_cov_1.337662_g4608_i0	PRJNA1031674	4818	381	1.337662	5.09649222	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	113	1.64e-20	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g4608	i0	95.775	13.3779527559055	71	1	18	2	1	69	1076555	1076625	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	5097	113	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
23119047	23119047	PRJNA1031674_P_NODE_28319_length_237_cov_2.792683_g28108_i0	PRJNA1031674	28319	237	2.792683	6.61865871	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	372	1.44e-98	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g28108	i0	94.958	1.0042194092827	238	10	100	2	1	237	1019996	1019760	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	238	372	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
24392918	24392918	PRJNA1031674_P_NODE_5400_length_365_cov_2.630137_g5190_i0	PRJNA1031674	5400	365	2.630137	9.60000005	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	307	6.7e-79	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g5190	i0	82.703	43.5068493150685	370	40	100	17	1	365	964718	965068	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	15880	307	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
25233054	25233054	PRJNA1031674_P_NODE_20000_length_259_cov_1.365591_g19789_i0	PRJNA1031674	20000	259	1.365591	3.53688069	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	411	3.379999999999999e-110	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g19789	i0	95.703	80.7644787644788	256	9	99	2	1	256	151104	151357	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	20918	411	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488

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