metadata: contig_metadata: 32 rows where bioproject = "PRJNA415856" and tax

32 rows where bioproject = "PRJNA415856" and tax_phylum = "Spirochaetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1083603	1083603	PRJNA415856_P_NODE_6181_length_381_cov_1.710843_g5920_i0	PRJNA415856	6181	381	1.710843	6.51831183	Gracilinema	2951106	Bacteria	Bacteria	634	2.8399999999999995e-177	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g5920	i0	96.834	186.419947506562	379	12	99	0	3	381	733	1111	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	71026	634	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
2359000	2359000	PRJNA415856_P_NODE_45842_length_163_cov_0.894737_g45581_i0	PRJNA415856	45842	163	0.894737	1.45842131	Treponema	157	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g45581	i0	98.773	6.96319018404908	163	2	100	0	1	163	614897	614735	Treponema sp. OMZ 838, complete genome	blastn	1135	291	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
3634339	3634339	PRJNA415856_P_NODE_33323_length_169_cov_1.666667_g33062_i0	PRJNA415856	33323	169	1.666667	2.81666723	Treponema	157	Bacteria	Bacteria	296	5.9e-76	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g33062	i0	98.225	9.00591715976331	169	3	100	0	1	169	2090613	2090781	Treponema sp. OMZ 838, complete genome	blastn	1522	296	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
4246500	4246500	PRJNA415856_P_NODE_49904_length_162_cov_0.902655_g49643_i0	PRJNA415856	49904	162	0.902655	1.4623011	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	233	4.49e-57	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g49643	i0	92.593	1	162	12	100	0	1	162	1835519	1835358	Treponema sp. OMZ 857 chromosome, complete genome	blastn	162	233	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
4246523	4246523	PRJNA415856_P_NODE_52784_length_161_cov_0.910714_g52523_i0	PRJNA415856	52784	161	0.910714	1.46624954	Treponema vincentii	69710	Bacteria	Bacteria	65.8	1.72e-6	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g52523	i0	84.848	0.819875776397516	66	8	40	2	97	161	2675026	2675090	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	132	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7461606	7461606	PRJNA415856_P_NODE_9026_length_299_cov_2.776000_g8765_i0	PRJNA415856	9026	299	2.776	8.30024	root	1	Root_unresolved	Root_unresolved	547	2.9099999999999987e-151	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g8765	i0	99.666	127.685618729097	299	1	100	0	1	299	2036981	2037279	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	38178	547	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
8072750	8072750	PRJNA415856_P_NODE_48227_length_162_cov_1.707965_g47966_i0	PRJNA415856	48227	162	1.707965	2.7669033	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g47966	i0	100	6.92592592592593	162	0	100	0	1	162	2409152	2409313	Treponema sp. OMZ 838, complete genome	blastn	1122	300	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
8736388	8736388	PRJNA415856_P_NODE_4067_length_488_cov_3.874715_g3813_i0	PRJNA415856	4067	488	3.874715	18.9086092	Treponema	157	Bacteria	Bacteria	686	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g3813	i0	92.041	194.122950819672	490	35	100	4	1	488	2079372	2079859	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	94732	686	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
12562198	12562198	PRJNA415856_P_NODE_35990_length_167_cov_0.864407_g35729_i0	PRJNA415856	35990	167	0.864407	1.44355969	Treponema	157	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g35729	i0	98.204	8.92814371257485	167	3	100	0	1	167	2688799	2688633	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	1491	292	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
13173032	13173032	PRJNA415856_P_NODE_26231_length_181_cov_1.462121_g25970_i0	PRJNA415856	26231	181	1.462121	2.64643901	Treponema denticola	158	Bacteria	Bacteria	252	1.41e-62	NTclustered	gi\|2265178430\|gb\|CP051633.1\|	158	g25970	i0	91.713	1	181	15	100	0	1	181	1674332	1674152	Treponema denticola strain OMZ 898 chromosome, complete genome	blastn	181	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
13836947	13836947	PRJNA415856_P_NODE_34471_length_167_cov_2.355932_g34210_i0	PRJNA415856	34471	167	2.355932	3.93440644	Treponema	157	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g34210	i0	98.802	28.7185628742515	167	2	100	0	1	167	2144460	2144626	Treponema medium strain T19 chromosome, complete genome	blastn	4796	298	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
14448283	14448283	PRJNA415856_P_NODE_43632_length_164_cov_0.886957_g43371_i0	PRJNA415856	43632	164	0.886957	1.45460948	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g43371	i0	96.933	10.8353658536585	163	3	99	2	2	164	307793	307633	Treponema sp. OMZ 305 chromosome, complete genome	blastn	1777	272	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
16996829	16996829	PRJNA415856_P_NODE_45494_length_163_cov_1.692982_g45233_i0	PRJNA415856	45494	163	1.692982	2.75956066	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g45233	i0	100	2	163	0	100	0	1	163	611308	611146	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	326	302	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
18935009	18935009	PRJNA415856_P_NODE_455_length_1317_cov_6.314669_g369_i0	PRJNA415856	455	1317	6.314669	83.16419073	Treponema	157	Bacteria	Bacteria	2145	0	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g369	i0	96.064	197.940774487472	1321	45	100	7	1	1317	1015837	1014520	Treponema medium strain T19 chromosome, complete genome	blastn	260688	2145	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
18935032	18935032	PRJNA415856_P_NODE_4975_length_436_cov_1.617571_g4714_i0	PRJNA415856	4975	436	1.617571	7.05260956	Gracilinema	2951106	Bacteria	Bacteria	527	5.739999999999998e-145	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g4714	i0	90.37	193.497706422018	405	34	92	5	1	401	651	248	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	84365	527	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
20821056	20821056	PRJNA415856_P_NODE_33237_length_169_cov_1.700000_g32976_i0	PRJNA415856	33237	169	1.7	2.873	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g32976	i0	95.858	1	169	7	100	0	1	169	2271410	2271242	Treponema sp. Marseille-Q4132 chromosome	blastn	169	274	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
21485149	21485149	PRJNA415856_P_NODE_27157_length_179_cov_1.569231_g26896_i0	PRJNA415856	27157	179	1.569231	2.80892349	Treponema	157	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g26896	i0	98.324	3.64245810055866	179	3	100	0	1	179	246594	246416	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	652	315	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
21485186	21485186	PRJNA415856_P_NODE_33197_length_169_cov_1.700000_g32936_i0	PRJNA415856	33197	169	1.7	2.873	Treponema	157	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g32936	i0	98.817	8.92899408284024	169	2	100	0	1	169	355701	355869	Treponema sp. OMZ 838, complete genome	blastn	1509	302	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
22095863	22095863	PRJNA415856_P_NODE_47678_length_163_cov_0.894737_g47417_i0	PRJNA415856	47678	163	0.894737	1.45842131	Treponema sp. OMZ 855	1643512	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|2265125022\|gb\|CP051194.1\|	1643512	g47417	i0	98.16	10	163	3	100	0	1	163	1196597	1196759	Treponema sp. OMZ 855 chromosome, complete genome	blastn	1630	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 855
22095903	22095903	PRJNA415856_P_NODE_52118_length_161_cov_0.910714_g51857_i0	PRJNA415856	52118	161	0.910714	1.46624954	Treponema vincentii	69710	Bacteria	Bacteria	281	1.57e-71	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g51857	i0	98.137	9	161	3	100	0	1	161	795118	794958	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	1449	281	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22760332	22760332	PRJNA415856_P_NODE_16818_length_212_cov_1.993865_g16557_i0	PRJNA415856	16818	212	1.993865	4.2269938	root	1	Root_unresolved	Root_unresolved	392	9.67e-105	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g16557	i0	100	125.617924528302	212	0	100	0	1	212	2037447	2037236	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	26631	392	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
24035298	24035298	PRJNA415856_P_NODE_45719_length_163_cov_1.342105_g45458_i0	PRJNA415856	45719	163	1.342105	2.18763115	Treponema	157	Bacteria	Bacteria	246	5.8099999999999995e-61	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g45458	i0	93.865	12.0920245398773	163	10	100	0	1	163	201362	201524	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	1971	246	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
24035311	24035311	PRJNA415856_P_NODE_48339_length_162_cov_1.557522_g48078_i0	PRJNA415856	48339	162	1.557522	2.52318564	Treponema	157	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g48078	i0	96.296	12	162	6	100	0	1	162	135404	135565	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	1944	267	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
24035313	24035313	PRJNA415856_P_NODE_48519_length_162_cov_1.345133_g48258_i0	PRJNA415856	48519	162	1.345133	2.17911546	Treponema	157	Bacteria	Bacteria	226	7.509999999999998e-55	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g48258	i0	91.925	2.96296296296296	161	13	99	0	2	162	328193	328353	Treponema sp. OMZ 838, complete genome	blastn	480	226	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
28180761	28180761	PRJNA415856_P_NODE_36526_length_167_cov_0.864407_g36265_i0	PRJNA415856	36526	167	0.864407	1.44355969	Treponema sp. J25	2094121	Bacteria	Bacteria	66.2	5.3e-11	NR	WP_132781733.1	2094121	g36265	i0	88.2	0.610778443113772	34	4	61.1	0	103	2	1	34	WP_132781733.1 GDP-L-fucose synthase family protein [Treponema sp. J25]	diamond	102	66.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. J25
28387024	28387024	PRJNA415856_P_NODE_47766_length_163_cov_0.894737_g47505_i0	PRJNA415856	47766	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	65.5	1.02e-10	NR	MDR1318682.1	166	g47505	i0	60.4	1.96932515337423	53	21	97.5	0	160	2	240	292	MDR1318682.1 ABC transporter permease [Treponema sp.]	diamond	321	65.9	0.993930197268589	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28623182	28623182	PRJNA415856_P_NODE_26047_length_181_cov_1.810606_g25786_i0	PRJNA415856	26047	181	1.810606	3.27719686	Treponema sp.	166	Bacteria	Bacteria	69.3	2.72e-12	NR	MDD7451654.1	166	g25786	i0	57.7	0.861878453038674	52	21	84.5	1	2	154	180	231	MDD7451654.1 hypothetical protein [Treponema sp.]	diamond	156	69.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28812159	28812159	PRJNA415856_P_NODE_27248_length_179_cov_1.461538_g26987_i0	PRJNA415856	27248	179	1.461538	2.61615302	Treponema denticola	158	Bacteria	Bacteria	120	1.9799999999999996e-31	NR	WP_002669777.1	158	g26987	i0	94.9	0.988826815642458	59	3	98.9	0	1	177	223	281	WP_002669777.1 ABC transporter permease [Treponema denticola]	diamond	177	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
30423488	30423488	PRJNA415856_P_NODE_42193_length_165_cov_0.879310_g41932_i0	PRJNA415856	42193	165	0.87931	1.4508615	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	42	0.0148	NR	WP_044016175.1	1539298	g41932	i0	54.3	2.41818181818182	35	16	63.6	0	1	105	118	152	WP_044016175.1 hypothetical protein [Treponema sp. OMZ 838]	diamond	399	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
31261326	31261326	PRJNA415856_P_NODE_30275_length_174_cov_1.400000_g30014_i0	PRJNA415856	30275	174	1.4	2.436	Spirochaetales	136	Bacteria	Bacteria	112	4.17e-28	NR	WP_132781559.1	2094121	g30014	i0	94.7	1.96551724137931	57	3	98.3	0	172	2	28	84	WP_132781559.1 aspartate-semialdehyde dehydrogenase [Treponema sp. J25]	diamond	342	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. J25
31466239	31466239	PRJNA415856_P_NODE_46436_length_163_cov_0.894737_g46175_i0	PRJNA415856	46436	163	0.894737	1.45842131	Treponema sp. OMZ 9	166	Bacteria	Bacteria	61.2	3.53e-9	NR	WP_253824014.1	2563662	g46175	i0	64.8	0.993865030674847	54	19	99.4	0	163	2	286	339	WP_253824014.1 hypothetical protein [Treponema sp. OMZ 906]	diamond	162	61.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
31908891	31908891	PRJNA415856_P_NODE_38117_length_166_cov_0.871795_g37856_i0	PRJNA415856	38117	166	0.871795	1.4471797	Spirochaetota bacterium	2202144	Bacteria	Bacteria	41.2	0.0453	NR	MBN2547256.1	2202144	g37856	i0	42.9	1.73493975903614	49	24	88.6	1	18	164	147	191	MBN2547256.1 hypothetical protein [Spirochaetota bacterium]	diamond	288	41.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;