metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
384672	384672	PRJNA315399_S_NODE_167121_length_156_cov_8.344538_g166920_i0	PRJNA315399	167121	156	8.344538	13.01747928	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621786375\|emb\|OY782833.1\|	2791017	g166920	i0	94.444	0.230769230769231	36	2	23	0	87	122	1467325	1467290	MAG: Sphaerochaetaceae bacterium isolate 4316afa4-75a5-40cd-90fd-6a37d92e054f genome assembly, chromosome: 1	blastn	36	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
1658510	1658510	PRJNA315399_P_NODE_61962_length_225_cov_2.473404_g61514_i0	PRJNA315399	61962	225	2.473404	5.565159	Treponema sp.	166	Bacteria	Bacteria	139	1.49e-28	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g61514	i0	88.136	2.44888888888889	118	12	52	2	11	127	1390236	1390352	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	551	139	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
2341328	2341328	PRJNA315399_P_NODE_402402_length_161_cov_5.032258_g401954_i0	PRJNA315399	402402	161	5.032258	8.10193538	Brachyspira	29521	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2021755399\|gb\|CP046930.1\|	159	g401954	i0	96.97	1.22981366459627	33	1	20	0	40	72	2679242	2679210	Brachyspira hyodysenteriae strain BHZ375 chromosome, complete genome	blastn	198	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
2341889	2341889	PRJNA315399_S_NODE_143322_length_163_cov_1.412698_g143121_i0	PRJNA315399	143322	163	1.412698	2.30269774	Treponema	157	Bacteria	Bacteria	104	3.7e-18	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g143121	i0	78.75	4.9079754601227	160	30	97	4	6	163	223	66	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	800	104	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
4211702	4211702	PRJNA315399_S_NODE_136704_length_165_cov_1.218750_g136503_i0	PRJNA315399	136704	165	1.21875	2.0109375	Leptospira kmetyi	408139	Bacteria	Bacteria	67.6	4.93e-7	NTclustered	gi\|1511924597\|gb\|CP033614.1\|	408139	g136503	i0	90.196	0.309090909090909	51	5	31	0	93	143	3885422	3885472	Leptospira kmetyi strain LS 001/16 chromosome 1, complete sequence	blastn	51	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kmetyi
4894136	4894136	PRJNA315399_P_NODE_506124_length_150_cov_9.601770_g505676_i0	PRJNA315399	506124	150	9.60177	14.402655	Treponema	157	Bacteria	Bacteria	126	7.1e-25	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g505676	i0	97.297	8.99333333333333	74	2	49	0	76	149	120131	120204	Treponema medium strain T19 chromosome, complete genome	blastn	1349	126	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
4894382	4894382	PRJNA315399_S_NODE_127384_length_168_cov_1.114504_g127183_i0	PRJNA315399	127384	168	1.114504	1.87236672	Treponema	157	Bacteria	Bacteria	252	1.3e-62	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g127183	i0	97.297	164.333333333333	148	4	88	0	10	157	513774	513627	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	27608	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5485248	5485248	PRJNA315399_P_NODE_193905_length_185_cov_4.729730_g193457_i0	PRJNA315399	193905	185	4.72973	8.7500005	Treponema socranskii	53419	Bacteria	Bacteria	143	9.11e-30	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g193457	i0	84.906	0.859459459459459	159	5	86	1	15	173	2204901	2205040	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	159	143	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
5485671	5485671	PRJNA315399_P_NODE_258825_length_181_cov_3.812500_g258377_i0	PRJNA315399	258825	181	3.8125	6.900625	Leptospira kobayashii	1917830	Bacteria	Bacteria	67.6	5.49e-7	NTclustered	gi\|2091879162\|dbj\|AP025028.1\|	1917830	g258377	i0	88.889	0.298342541436464	54	6	30	0	23	76	1292324	1292271	Leptospira kobayashii E30 DNA, chromosome 1, complete genome	blastn	54	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kobayashii
5487060	5487060	PRJNA315399_P_NODE_474845_length_153_cov_7.681034_g474397_i0	PRJNA315399	474845	153	7.681034	11.75198202	Leadbettera azotonutricia	150829	Bacteria	Bacteria	69.4	1.24e-7	NTclustered	gi\|333734099\|gb\|CP001841.1\|	545695	g474397	i0	97.5	0.496732026143791	40	1	26	0	12	51	368808	368847	Treponema azotonutricium ZAS-9, complete genome	blastn	76	69.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Leadbettera	Leadbettera azotonutricia
6169251	6169251	PRJNA315399_P_NODE_93025_length_204_cov_6.754491_g92577_i0	PRJNA315399	93025	204	6.754491	13.77916164	Borrelia	138	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2452986412\|gb\|CP036557.2\|	47466	g92577	i0	100	3.98039215686275	29	0	14	0	80	108	825436	825408	Borrelia miyamotoi strain Yekat-76 chromosome, complete genome	blastn	812	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia miyamotoi
6762007	6762007	PRJNA315399_S_NODE_124326_length_169_cov_1.333333_g124125_i0	PRJNA315399	124326	169	1.333333	2.25333277	Borreliella japonica	34095	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2537440514\|gb\|CP124066.1\|	34095	g124125	i0	100	0.343195266272189	29	0	17	0	98	126	650209	650237	Borreliella japonica strain H014 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella japonica
9309763	9309763	PRJNA315399_P_NODE_191868_length_185_cov_5.945946_g191420_i0	PRJNA315399	191868	185	5.945946	11.0000001	Treponemataceae bacterium	2854022	Bacteria	Bacteria	76.8	9.37e-10	NTclustered	gi\|2814788384\|emb\|OY762953.2\|	2854022	g191420	i0	100	5.25945945945946	41	0	32	0	39	79	925929	925969	MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1	blastn	973	76.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
10587068	10587068	PRJNA315399_P_NODE_434929_length_158_cov_2.561983_g434481_i0	PRJNA315399	434929	158	2.561983	4.04793314	Turneriella parva	29510	Bacteria	Bacteria	100	4.6e-17	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g434481	i0	88.889	0.512658227848101	81	9	51	0	5	85	3166620	3166700	Turneriella parva DSM 21527, complete genome	blastn	81	100	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
10587166	10587166	PRJNA315399_P_NODE_454469_length_156_cov_1.159664_g454021_i0	PRJNA315399	454469	156	1.159664	1.80907584	Leptospira kirschneri	29507	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2419262725\|gb\|CP085134.1\|	29507	g454021	i0	100	0.179487179487179	28	0	18	0	127	154	77265	77292	Leptospira kirschneri strain RedPanda1 chromosome 2, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kirschneri
11269545	11269545	PRJNA315399_P_NODE_53169_length_234_cov_3.258883_g52721_i0	PRJNA315399	53169	234	3.258883	7.62578622	Treponema	157	Bacteria	Bacteria	183	7.119999999999998e-42	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g52721	i0	96.396	6.66666666666667	111	4	77	0	74	184	2268900	2269010	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	1560	183	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
11862339	11862339	PRJNA315399_P_NODE_507870_length_150_cov_5.778761_g507422_i0	PRJNA315399	507870	150	5.778761	8.6681415	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	252	1.12e-62	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g507422	i0	100	3.64666666666667	136	0	91	0	15	150	1443366	1443231	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	547	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
12544185	12544185	PRJNA315399_P_NODE_239270_length_182_cov_6.075862_g238822_i0	PRJNA315399	239270	182	6.075862	11.05806884	Treponema	157	Bacteria	Bacteria	132	1.93e-26	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g238822	i0	98.649	9.87362637362637	74	1	79	0	101	174	2301783	2301856	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	1797	132	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
14411101	14411101	PRJNA315399_P_NODE_258732_length_181_cov_3.847222_g258284_i0	PRJNA315399	258732	181	3.847222	6.96347182	Treponema denticola	158	Bacteria	Bacteria	171	4.0699999999999997e-38	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g258284	i0	96.19	13.3977900552486	105	3	93	1	64	168	1588807	1588910	Treponema denticola strain OT2B chromosome, complete genome	blastn	2425	171	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
16369572	16369572	PRJNA315399_S_NODE_55393_length_209_cov_2.377907_g55192_i0	PRJNA315399	55393	209	2.377907	4.96982563	Treponema	157	Bacteria	Bacteria	370	4.45e-98	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g55192	i0	100	9.56937799043062	200	0	96	0	10	209	512430	512231	Treponema medium strain T19 chromosome, complete genome	blastn	2000	370	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
17643366	17643366	PRJNA315399_P_NODE_26374_length_279_cov_4.219008_g25929_i0	PRJNA315399	26374	279	4.219008	11.77103232	Treponema	157	Bacteria	Bacteria	239	1.84e-58	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g25929	i0	98.519	1.44086021505376	135	2	48	0	21	155	861984	862118	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	402	239	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18233134	18233134	PRJNA315399_P_NODE_151095_length_189_cov_2.052632_g150647_i0	PRJNA315399	151095	189	2.052632	3.87947448	Treponema denticola	158	Bacteria	Bacteria	250	5.36e-62	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g150647	i0	95.513	19.2539682539683	156	7	83	0	21	176	259813	259658	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	3639	250	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18918547	18918547	PRJNA315399_S_NODE_70835_length_195_cov_8.405063_g70634_i0	PRJNA315399	70835	195	8.405063	16.38987285	Treponema	157	Bacteria	Bacteria	300	5.4500000000000004e-77	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g70634	i0	96.216	181.471794871795	185	4	95	3	11	195	2078692	2078511	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	35387	300	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
19507359	19507359	PRJNA315399_P_NODE_133636_length_191_cov_4.779221_g133188_i0	PRJNA315399	133636	191	4.779221	9.12831211	Treponema phagedenis	162	Bacteria	Bacteria	134	5.7e-27	NTclustered	gi\|1732613418\|gb\|CP042814.1\|	162	g133188	i0	95.349	2.01570680628272	86	1	43	3	97	179	830409	830494	Treponema phagedenis strain S8.5 chromosome	blastn	385	134	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
19509456	19509456	PRJNA315399_P_NODE_473676_length_153_cov_12.646552_g473228_i0	PRJNA315399	473676	153	12.646552	19.34922456	Leptospira mgodei	3235172	Bacteria	Bacteria	224	2.5099999999999998e-54	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g473228	i0	98.425	0.830065359477124	127	2	83	0	19	145	1939986	1940112	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	127	224	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
20192494	20192494	PRJNA315399_P_NODE_89776_length_206_cov_3.213018_g89328_i0	PRJNA315399	89776	206	3.213018	6.61881708	Treponema	157	Bacteria	Bacteria	196	7.86e-46	NTclustered	gi\|375244454\|gb\|JQ654180.1\|	162155	g89328	i0	99.083	67.4902912621359	109	1	78	0	98	206	93	201	Uncultured Treponema sp. clone 3:6P47 16S ribosomal RNA gene, partial sequence	blastn	13903	196	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
21467657	21467657	PRJNA315399_P_NODE_31717_length_268_cov_3.285714_g31271_i0	PRJNA315399	31717	268	3.285714	8.80571352	Bacteria	2	Bacteria	Bacteria	446	9.63e-121	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g31271	i0	100	73.3134328358209	241	0	90	0	18	258	322239	321999	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	19648	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
23333735	23333735	PRJNA315399_P_NODE_189039_length_185_cov_9.054054_g188591_i0	PRJNA315399	189039	185	9.054054	16.7499999	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	141	3.28e-29	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g188591	i0	100	4.90810810810811	76	0	41	0	98	173	2029834	2029909	Treponema sp. OMZ 838, complete genome	blastn	908	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
23335929	23335929	PRJNA315399_P_NODE_76119_length_213_cov_10.994318_g75671_i0	PRJNA315399	76119	213	10.994318	23.41789734	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2907625910\|emb\|OZ223470.1\|	2791017	g75671	i0	100	0.131455399061033	28	0	13	0	124	151	810784	810811	MAG: Sphaerochaetaceae bacterium isolate cd985c71-0469-48ce-9ce8-6ec3774ccd9a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
24608400	24608400	PRJNA315399_P_NODE_271340_length_180_cov_4.923077_g270892_i0	PRJNA315399	271340	180	4.923077	8.8615386	Brachyspira hampsonii	1287055	Bacteria	Bacteria	82.4	1.95e-11	NTclustered	gi\|1214564172\|gb\|CP019914.1\|	1287055	g270892	i0	90.323	0.688888888888889	62	6	34	0	106	167	2822082	2822021	Brachyspira hampsonii strain NSH-16 chromosome, complete genome	blastn	124	82.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hampsonii
24608412	24608412	PRJNA315399_P_NODE_272980_length_180_cov_4.202797_g272532_i0	PRJNA315399	272980	180	4.202797	7.5650346	Gracilinema caldarium	215591	Bacteria	Bacteria	130	6.86e-26	NTclustered	gi\|338832994\|gb\|CP002868.1\|	744872	g272532	i0	94.118	0.472222222222222	85	5	47	0	3	87	507022	506938	Gracilinema caldarium DSM 7334 chromosome, complete genome	blastn	85	130	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium

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