metadata: contig_metadata: 34 rows where bioproject = "PRJNA1160211", tax_phylum = "Spirochaetota" and tax

34 rows where bioproject = "PRJNA1160211", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
1584502	1584502	PRJNA1160211_S_NODE_223782_length_285_cov_12.622642_g222549_i0	PRJNA1160211	223782	285	12.622642	35.9745297	Treponema medium	58231	Bacteria	Bacteria	477	3.669999999999999e-130	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g222549	i0	98.519	182.635087719298	270	4	95	0	16	285	1845620	1845889	Treponema medium strain T19 chromosome, complete genome	blastn	52051	477	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
2313770	2313770	PRJNA1160211_S_NODE_210862_length_299_cov_1.429204_g209629_i0	PRJNA1160211	210862	299	1.429204	4.27331996	Treponema	157	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|1139274348\|emb\|LT688170.1\|	53419	g209629	i0	100	104.003344481605	299	0	100	0	1	299	660	362	Treponema socranskii partial 16S rRNA gene, isolate 467T_13585	blastn	31097	553	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
4136628	4136628	PRJNA1160211_S_NODE_212584_length_297_cov_2.000000_g211351_i0	PRJNA1160211	212584	297	2	5.94	Treponema vincentii	69710	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|960884883\|gb\|KT192169.1\|	69710	g211351	i0	99.663	2.7979797979798	297	1	100	0	1	297	997	701	Treponema vincentii strain OMZ 899 major surface protein (msp) gene, complete cds	blastn	831	544	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
4137196	4137196	PRJNA1160211_S_NODE_291984_length_229_cov_2.096154_g290751_i0	PRJNA1160211	291984	229	2.096154	4.8001926599999996	Treponema denticola	158	Bacteria	Bacteria	267	6.7e-67	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g290751	i0	88.21	168.489082969432	229	20	100	5	1	229	1644180	1644401	Treponema denticola strain OT2B chromosome, complete genome	blastn	38584	267	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5413824	5413824	PRJNA1160211_S_NODE_785_length_1487_cov_55.763791_g606_i0	PRJNA1160211	785	1487	55.763791	829.20757217	Treponema vincentii	69710	Bacteria	Bacteria	2603	0	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g606	i0	98.641	194.712844653665	1472	15	99	5	17	1487	1031835	1030368	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	289538	2603	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
6688680	6688680	PRJNA1160211_S_NODE_77686_length_503_cov_34.330233_g76471_i0	PRJNA1160211	77686	503	34.330233	172.68107199	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	843	0	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g76471	i0	99.567	163.037773359841	462	2	92	0	19	480	2591892	2591431	Treponema sp. Marseille-Q4132 chromosome	blastn	82008	843	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
7963607	7963607	PRJNA1160211_S_NODE_29887_length_652_cov_23.094991_g28793_i0	PRJNA1160211	29887	652	23.094991	150.57934132	Treponema vincentii	69710	Bacteria	Bacteria	1127	0	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g28793	i0	100	12.0122699386503	610	0	94	0	21	630	822495	823104	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	7832	1127	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
8691125	8691125	PRJNA1160211_S_NODE_1167_length_1351_cov_38.848983_g606_i1	PRJNA1160211	1167	1351	38.848983	524.84976033	Treponema	157	Bacteria	Bacteria	1351	0	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g606	i1	97.595	194.114729829756	790	16	99	3	546	1335	1031049	1031835	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	262249	1351	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
9237992	9237992	PRJNA1160211_S_NODE_249328_length_262_cov_3.708995_g248095_i0	PRJNA1160211	249328	262	3.708995	9.7175669	Leptospira stimsonii	2202203	Bacteria	Bacteria	63.9	1.04e-9	NR	WP_135685735.1	2202203	g248095	i0	62.2	0.83587786259542	45	17	51.5	0	241	107	228	272	WP_135685735.1 sterol desaturase family protein [Leptospira stimsonii]	diamond	219	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira stimsonii
9238174	9238174	PRJNA1160211_S_NODE_278568_length_243_cov_1.717647_g277335_i0	PRJNA1160211	278568	243	1.717647	4.17388221	Treponema sp.	166	Bacteria	Bacteria	182	2.68e-41	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g277335	i0	93.496	304.378600823045	123	7	51	1	58	180	1830540	1830419	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	73964	182	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
9238542	9238542	PRJNA1160211_S_NODE_56368_length_557_cov_15.830579_g55191_i0	PRJNA1160211	56368	557	15.830579	88.17632503	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	941	0	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g55191	i0	98.679	178.989228007181	530	7	95	0	6	535	2590688	2590159	Treponema sp. Marseille-Q4132 chromosome	blastn	99697	941	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
11788903	11788903	PRJNA1160211_S_NODE_282210_length_241_cov_2.410714_g280977_i0	PRJNA1160211	282210	241	2.410714	5.80982074	Treponema brennaborense	81028	Bacteria	Bacteria	171	5.74e-38	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g280977	i0	80.804	181.854771784232	224	37	93	4	19	241	429830	430048	Treponema brennaborense DSM 12168, complete genome	blastn	43827	171	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
11789170	11789170	PRJNA1160211_S_NODE_47970_length_582_cov_20.502947_g46810_i0	PRJNA1160211	47970	582	20.502947	119.32715154	Treponema brennaborense	81028	Bacteria	Bacteria	579	2.1299999999999994e-160	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g46810	i0	85.614	185.159793814433	570	60	95	13	24	578	2505912	2505350	Treponema brennaborense DSM 12168, complete genome	blastn	107763	579	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
13064139	13064139	PRJNA1160211_S_NODE_51131_length_572_cov_39.857715_g49965_i0	PRJNA1160211	51131	572	39.857715	227.9861298	Treponema socranskii	53419	Bacteria	Bacteria	968	0	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g49965	i0	99.623	176.367132867133	531	1	93	1	26	556	789694	789165	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	100882	968	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
14337885	14337885	PRJNA1160211_S_NODE_100812_length_455_cov_26.916230_g99586_i0	PRJNA1160211	100812	455	26.91623	122.4688465	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	795	0	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g99586	i0	99.769	2.85494505494506	433	1	95	0	1	433	2109305	2108873	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	1299	795	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
16886408	16886408	PRJNA1160211_S_NODE_14194_length_759_cov_17.188047_g2828_i1	PRJNA1160211	14194	759	17.188047	130.45727673	Spirochaetota bacterium	2202144	Bacteria	Bacteria	130	3.42e-25	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g2828	i1	82.667	19.0158102766798	150	23	19	3	1	148	74401	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	14433	130	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
17616288	17616288	PRJNA1160211_S_NODE_222834_length_286_cov_8.117371_g221601_i0	PRJNA1160211	222834	286	8.117371	23.21568106	Treponema	157	Bacteria	Bacteria	451	2.23e-122	NTclustered	gi\|379647714\|gb\|JF700257.1\|	158	g221601	i0	100	97.506993006993	244	0	85	0	24	267	309	552	Treponema denticola strain ATCC 700771 16S ribosomal RNA gene, partial sequence	blastn	27887	451	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17616304	17616304	PRJNA1160211_S_NODE_226414_length_283_cov_2.190476_g225181_i0	PRJNA1160211	226414	283	2.190476	6.19904708	Treponema	157	Bacteria	Bacteria	388	1.7499999999999998e-103	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g225181	i0	91.549	191.339222614841	284	20	99	3	2	283	1476004	1476285	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	54149	388	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
17616656	17616656	PRJNA1160211_S_NODE_47054_length_585_cov_211.972656_g45896_i0	PRJNA1160211	47054	585	211.972656	1240.0400376	Treponema	157	Bacteria	Bacteria	937	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g45896	i0	99.229	173.34358974359	519	4	89	0	12	530	2079373	2079891	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	101406	942	0.994692144373673	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18890483	18890483	PRJNA1160211_S_NODE_50775_length_573_cov_35.888000_g49611_i0	PRJNA1160211	50775	573	35.888	205.63824	Treponema	157	Bacteria	Bacteria	521	3.589999999999999e-143	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g49611	i0	84.586	178.685863874346	532	74	93	8	8	538	1662578	1663102	Treponema denticola strain OKA3 chromosome, complete genome	blastn	102387	521	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18890655	18890655	PRJNA1160211_S_NODE_87355_length_482_cov_34.322738_g86133_i0	PRJNA1160211	87355	482	34.322738	165.43559716	Treponema	157	Bacteria	Bacteria	817	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g86133	i0	99.335	12.0892116182573	451	3	94	0	9	459	1903874	1903424	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	5827	822	0.993917274939173	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
19435127	19435127	PRJNA1160211_S_NODE_127036_length_409_cov_33.437500_g125804_i0	PRJNA1160211	127036	409	33.4375	136.759375	Treponema vincentii	69710	Bacteria	Bacteria	682	0	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g125804	i0	99.467	5.16870415647922	375	2	92	0	24	398	2140471	2140845	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	2114	682	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
20711069	20711069	PRJNA1160211_S_NODE_194897_length_316_cov_11.444444_g193664_i0	PRJNA1160211	194897	316	11.444444	36.16444304	Treponema sp.	166	Bacteria	Bacteria	424	5.44e-114	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g193664	i0	92.857	190.613924050633	294	18	93	3	24	316	1474943	1474652	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	60234	424	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
20711417	20711417	PRJNA1160211_S_NODE_242057_length_268_cov_10.897436_g240824_i0	PRJNA1160211	242057	268	10.897436	29.20512848	Treponema sp.	166	Bacteria	Bacteria	167	8.4e-37	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g240824	i0	80.687	170.705223880597	233	29	85	10	17	245	1830495	1830715	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	45749	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
21440844	21440844	PRJNA1160211_S_NODE_51817_length_570_cov_25.672032_g50650_i0	PRJNA1160211	51817	570	25.672032	146.3305824	Treponema	157	Bacteria	Bacteria	918	0	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g50650	i0	97.403	13.4578947368421	539	14	95	0	11	549	634622	635160	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	7671	918	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
23261279	23261279	PRJNA1160211_S_NODE_121599_length_418_cov_9.744928_g120370_i0	PRJNA1160211	121599	418	9.744928	40.73379904	uncultured Treponema sp.	162155	Bacteria	Bacteria	590	6.8899999999999985e-164	NTclustered	gi\|1826584172\|gb\|MT257116.1\|	162155	g120370	i0	92.683	138.523923444976	410	29	98	1	9	418	423	15	Uncultured Treponema sp. clone CH43 23S ribosomal RNA gene, partial sequence	blastn	57903	590	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
23262140	23262140	PRJNA1160211_S_NODE_233679_length_276_cov_2.724138_g232446_i0	PRJNA1160211	233679	276	2.724138	7.51862088	Spirochaetota bacterium	2202144	Bacteria	Bacteria	148	3.1499999999999996e-31	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g232446	i0	85.135	9.98188405797101	148	19	53	3	131	276	74549	74403	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	2755	148	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
25264770	25264770	PRJNA1160211_S_NODE_207300_length_302_cov_14.733624_g206067_i0	PRJNA1160211	207300	302	14.733624	44.49554448	Treponema	157	Bacteria	Bacteria	492	1.4e-134	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g206067	i0	99.628	11.6059602649007	269	1	89	0	24	292	468476	468744	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	3505	492	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
26838395	26838395	PRJNA1160211_S_NODE_46641_length_587_cov_3.861868_g45483_i0	PRJNA1160211	46641	587	3.861868	22.66916516	Pseudomonadati	3379134	Bacteria	Bacteria	55.1	2.63e-5	NR	MCL2175558.1	166	g45483	i0	61.8	1.10902896081772	34	13	17.4	0	371	472	39	72	MCL2175558.1 sel1 repeat family protein [Treponema sp.]	diamond	651	55.5	0.992792792792793	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27704198	27704198	PRJNA1160211_S_NODE_61324_length_544_cov_2.611465_g60139_i0	PRJNA1160211	61324	544	2.611465	14.2063696	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	74.3	7.72e-12	NR	UCF97407.1	1898206	g60139	i0	53.2	1.33455882352941	62	29	34.2	0	543	358	451	512	UCF97407.1 MAG: glycerol kinase GlpK [Spirochaetaceae bacterium]	diamond	726	74.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28114161	28114161	PRJNA1160211_S_NODE_30925_length_647_cov_21.134146_g29828_i0	PRJNA1160211	30925	647	21.134146	136.73792462	Brevinematales bacterium	2614249	Bacteria	Bacteria	43.9	0.0433	NR	NPV39414.1	2614249	g29828	i0	31.3	0.384853168469861	83	56	38.5	1	223	471	3	84	NPV39414.1 YggT family protein [Brevinematales bacterium]	diamond	249	43.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales			Brevinematales bacterium
28871977	28871977	PRJNA1160211_S_NODE_24168_length_683_cov_7.944262_g23119_i0	PRJNA1160211	24168	683	7.944262	54.25930946	Spirochaetia bacterium	2053615	Bacteria	Bacteria	189	2.26e-58	NR	MFO7729640.1	2053615	g23119	i0	95.2	0.456808199121523	104	2	45.7	2	357	668	1	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	312	189	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29156461	29156461	PRJNA1160211_S_NODE_163889_length_355_cov_8.507092_g162656_i0	PRJNA1160211	163889	355	8.507092	30.2001766	Spirochaetia bacterium	2053615	Bacteria	Bacteria	149	3.57e-44	NR	MFO7729640.1	2053615	g162656	i0	91.7	0.709859154929578	84	6	71	1	272	21	3	85	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	252	149	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30198158	30198158	PRJNA1160211_S_NODE_143612_length_384_cov_2.408360_g142379_i0	PRJNA1160211	143612	384	2.40836	9.2481024	Spirochaetales bacterium	2026792	Bacteria	Bacteria	44.3	0.0233	NR	MDR2588289.1	2026792	g142379	i0	43.7	0.5546875	71	38	55.5	2	86	298	45	113	MDR2588289.1 TRAP transporter small permease [Spirochaetales bacterium]	diamond	213	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales 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);;