metadata: contig_metadata: 32 rows where bioproject = "PRJNA1198392", tax_phylum = "Spirochaetota" and tax

32 rows where bioproject = "PRJNA1198392", 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
2875475	2875475	PRJNA1198392_P_NODE_3263_length_419_cov_3.661850_g3122_i0	PRJNA1198392	3263	419	3.66185	15.3431515	Treponema denticola	158	Bacteria	Bacteria	763	0	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g3122	i0	99.523	194.389021479714	419	2	100	0	1	419	1480428	1480846	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	81449	763	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
3594177	3594177	PRJNA1198392_P_NODE_10283_length_281_cov_1.480769_g10142_i0	PRJNA1198392	10283	281	1.480769	4.16096089	Treponema	157	Bacteria	Bacteria	348	2.95e-91	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g10142	i0	89.007	3.01067615658363	282	30	100	1	1	281	2905314	2905033	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	846	348	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
3594194	3594194	PRJNA1198392_P_NODE_13043_length_267_cov_1.587629_g12902_i0	PRJNA1198392	13043	267	1.587629	4.23896943	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	1.39e-12	NR	MBO5730434.1	166	g12902	i0	56.3	5.07865168539326	64	28	71.9	0	53	244	180	243	MBO5730434.1 hypothetical protein [Treponema sp.]	diamond	1356	72.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
4151483	4151483	PRJNA1198392_P_NODE_16684_length_249_cov_2.579545_g16543_i0	PRJNA1198392	16684	249	2.579545	6.42306705	Treponema medium	58231	Bacteria	Bacteria	427	3.2e-115	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g16543	i0	97.6	149.357429718875	250	5	100	1	1	249	1015315	1015564	Treponema medium strain T19 chromosome, complete genome	blastn	37190	427	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
4151550	4151550	PRJNA1198392_P_NODE_19704_length_244_cov_0.900585_g19563_i0	PRJNA1198392	19704	244	0.900585	2.1974274	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g19563	i0	95.041	2.97540983606557	242	11	99	1	3	244	1405923	1405683	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	726	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
4151698	4151698	PRJNA1198392_P_NODE_6564_length_316_cov_3.654321_g6423_i0	PRJNA1198392	6564	316	3.654321	11.54765436	Treponema vincentii	69710	Bacteria	Bacteria	473	5.329999999999999e-129	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g6423	i0	93.949	42.6329113924051	314	18	99	1	1	314	484317	484005	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	13472	473	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7421646	7421646	PRJNA1198392_P_NODE_13366_length_265_cov_1.989583_g13225_i0	PRJNA1198392	13366	265	1.989583	5.27239495	Treponema	157	Bacteria	Bacteria	464	2.6299999999999994e-126	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g13225	i0	99.606	12.4339622641509	254	1	96	0	12	265	354195	353942	Treponema medium strain T19 chromosome, complete genome	blastn	3295	464	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
7421660	7421660	PRJNA1198392_P_NODE_16206_length_250_cov_1.740113_g16065_i0	PRJNA1198392	16206	250	1.740113	4.3502825	Treponema	157	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g16065	i0	93.6	10.204	250	16	100	0	1	250	2534426	2534675	Treponema sp. OMZ 838, complete genome	blastn	2551	374	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
7978098	7978098	PRJNA1198392_P_NODE_4887_length_356_cov_8.289753_g4746_i0	PRJNA1198392	4887	356	8.289753	29.51152068	Treponema socranskii	53419	Bacteria	Bacteria	152	3.2299999999999997e-32	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g4746	i0	74.932	3.08707865168539	367	74	99	11	3	356	689252	689613	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	1099	152	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
9252782	9252782	PRJNA1198392_P_NODE_9868_length_283_cov_1.423810_g9727_i0	PRJNA1198392	9868	283	1.42381	4.0293823	Treponema medium	58231	Bacteria	Bacteria	327	3.87e-85	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g9727	i0	87.589	4.84098939929329	282	35	99	0	1	282	813742	813461	Treponema medium strain T19 chromosome, complete genome	blastn	1370	327	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
9971806	9971806	PRJNA1198392_P_NODE_11928_length_273_cov_1.240000_g11787_i0	PRJNA1198392	11928	273	1.24	3.3852	Treponema	157	Bacteria	Bacteria	366	7.88e-97	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g11787	i0	90.842	3.99267399267399	273	25	100	0	1	273	2338421	2338149	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	1090	366	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
10528439	10528439	PRJNA1198392_P_NODE_20649_length_242_cov_0.911243_g20508_i0	PRJNA1198392	20649	242	0.911243	2.20520806	Treponema socranskii	53419	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g20508	i0	97.521	2	242	6	100	0	1	242	2152474	2152233	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	484	414	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
11802929	11802929	PRJNA1198392_P_NODE_10370_length_281_cov_1.129808_g10229_i0	PRJNA1198392	10370	281	1.129808	3.17476048	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	481	2.79e-131	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g10229	i0	97.509	12.1103202846975	281	7	100	0	1	281	24099	24379	Treponema sp. OMZ 857 chromosome, complete genome	blastn	3403	481	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
12522424	12522424	PRJNA1198392_P_NODE_15270_length_253_cov_5.733333_g15129_i0	PRJNA1198392	15270	253	5.733333	14.50533249	Treponema	157	Bacteria	Bacteria	340	4.379999999999999e-89	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g15129	i0	90.909	178.466403162055	253	23	100	0	1	253	909530	909278	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	45152	340	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
13797144	13797144	PRJNA1198392_P_NODE_7991_length_292_cov_1.940639_g7850_i0	PRJNA1198392	7991	292	1.940639	5.66666588	Treponema	157	Bacteria	Bacteria	204	7.06e-48	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g7850	i0	91.275	5.47945205479452	149	13	100	0	1	149	574549	574401	Treponema sp. OMZ 838, complete genome	blastn	1600	204	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
16346279	16346279	PRJNA1198392_P_NODE_12173_length_271_cov_1.944444_g12032_i0	PRJNA1198392	12173	271	1.944444	5.26944324	Treponema	157	Bacteria	Bacteria	457	4.5099999999999986e-124	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g12032	i0	97.048	13.9926199261993	271	8	100	0	1	271	1428577	1428307	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	3792	457	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
16346332	16346332	PRJNA1198392_P_NODE_4853_length_357_cov_3.253521_g4712_i0	PRJNA1198392	4853	357	3.253521	11.61506997	Treponema	157	Bacteria	Bacteria	110	1.98e-19	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g4712	i0	72.678	3.30812324929972	366	87	99	7	1	356	689608	689246	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	1181	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
19450615	19450615	PRJNA1198392_P_NODE_17596_length_248_cov_0.880000_g17455_i0	PRJNA1198392	17596	248	0.88	2.1824	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g17455	i0	100	4.56854838709677	248	0	100	0	1	248	254643	254890	Treponema sp. OMZ 906 chromosome, complete genome	blastn	1133	459	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
19450810	19450810	PRJNA1198392_P_NODE_6996_length_309_cov_2.673729_g6855_i0	PRJNA1198392	6996	309	2.673729	8.26182261	Treponema medium	58231	Bacteria	Bacteria	119	2.8000000000000004e-22	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g6855	i0	81.457	2.36893203883495	151	22	48	5	1	148	1815405	1815552	Treponema medium strain T19 chromosome, complete genome	blastn	732	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
20725750	20725750	PRJNA1198392_P_NODE_10117_length_282_cov_1.282297_g9976_i0	PRJNA1198392	10117	282	1.282297	3.61607754	Treponema vincentii	69710	Bacteria	Bacteria	505	1.6599999999999995e-138	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g9976	i0	98.936	29.2659574468085	282	3	100	0	1	282	1053304	1053585	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	8253	505	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
20725912	20725912	PRJNA1198392_P_NODE_16617_length_250_cov_0.870056_g16476_i0	PRJNA1198392	16617	250	0.870056	2.17514	Treponema denticola	158	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g16476	i0	98.8	24.988	250	3	100	0	1	250	2290900	2291149	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	6247	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20726081	20726081	PRJNA1198392_P_NODE_5637_length_338_cov_1.611321_g5496_i0	PRJNA1198392	5637	338	1.611321	5.44626498	Treponema bryantii	163	Bacteria	Bacteria	122	2.4e-23	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g5496	i0	74.847	1.26923076923077	326	54	90	20	8	310	1919761	1919441	Treponema bryantii JCM 32280 DNA, complete genome	blastn	429	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
22720658	22720658	PRJNA1198392_P_NODE_5738_length_335_cov_3.748092_g5597_i0	PRJNA1198392	5738	335	3.748092	12.5561082	Treponema	157	Bacteria	Bacteria	566	9.119999999999997e-157	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g5597	i0	99.677	203.70447761194	310	0	100	1	1	309	1662856	1663165	Treponema denticola strain OKA3 chromosome, complete genome	blastn	68241	566	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
23276920	23276920	PRJNA1198392_P_NODE_5299_length_346_cov_1.238095_g5158_i0	PRJNA1198392	5299	346	1.238095	4.2838087	Treponema vincentii	69710	Bacteria	Bacteria	188	9.05e-53	NR	WP_385902931.1	69710	g5158	i0	78.1	2.1242774566474	114	25	98.8	0	3	344	281	394	WP_385902931.1 transcription-repair coupling factor [Treponema vincentii]	diamond	735	188	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27704697	27704697	PRJNA1198392_P_NODE_15704_length_251_cov_0.865169_g15563_i0	PRJNA1198392	15704	251	0.865169	2.17157419	Treponema vincentii	69710	Bacteria	Bacteria	105	4.23e-24	NR	WP_016519212.1	69710	g15563	i0	73.7	1.81673306772908	76	20	90.8	0	228	1	1	76	WP_016519212.1 phosphoenolpyruvate--protein phosphotransferase [Treponema vincentii]	diamond	456	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27893670	27893670	PRJNA1198392_P_NODE_15905_length_251_cov_0.865169_g15764_i0	PRJNA1198392	15905	251	0.865169	2.17157419	Treponema vincentii	69710	Bacteria	Bacteria	141	1.01e-37	NR	WP_006188422.1	69710	g15764	i0	88.6	1.86454183266932	79	9	94.4	0	3	239	127	205	WP_006188422.1 alanine/glycine:cation symporter family protein [Treponema vincentii]	diamond	468	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28051642	28051642	PRJNA1198392_P_NODE_9005_length_287_cov_1.331776_g8864_i0	PRJNA1198392	9005	287	1.331776	3.82219712	Treponema sp. OMZ 3	166	Bacteria	Bacteria	173	5.030000000000001e-50	NR	WP_253675263.1	1659192	g8864	i0	90.5	1.98606271777003	95	9	99.3	0	286	2	137	231	WP_253675263.1 CobW family GTP-binding protein [Treponema sp. OMZ 305]	diamond	570	173	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
31114949	31114949	PRJNA1198392_P_NODE_17455_length_248_cov_0.880000_g17314_i0	PRJNA1198392	17455	248	0.88	2.1824	Treponema vincentii	69710	Bacteria	Bacteria	148	4.61e-41	NR	WP_006187939.1	69710	g17314	i0	91.4	0.979838709677419	81	7	98	0	245	3	1	81	WP_006187939.1 glycine/sarcosine/betaine reductase complex component C subunit alpha [Treponema vincentii]	diamond	243	148	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
31558107	31558107	PRJNA1198392_P_NODE_6196_length_325_cov_1.384921_g6055_i0	PRJNA1198392	6196	325	1.384921	4.50099325	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	222	6.29e-71	NR	MFA6935580.1	2791017	g6055	i0	99.1	0.987692307692308	107	1	98.8	0	323	3	124	230	MFA6935580.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	321	222	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32412202	32412202	PRJNA1198392_P_NODE_12299_length_271_cov_1.247475_g12158_i0	PRJNA1198392	12299	271	1.247475	3.38065725	Treponema sp.	166	Bacteria	Bacteria	153	8.6e-45	NR	MFC2602358.1	166	g12158	i0	88.8	0.985239852398524	89	9	97.4	1	1	264	117	205	MFC2602358.1 30S ribosomal protein S3 [Treponema sp.]	diamond	267	153	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32507268	32507268	PRJNA1198392_P_NODE_6679_length_314_cov_1.278008_g6538_i0	PRJNA1198392	6679	314	1.278008	4.01294512	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	201	4.3200000000000005e-58	NR	MFA6935539.1	2791017	g6538	i0	97.1	0.974522292993631	102	3	97.5	0	312	7	660	761	MFA6935539.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	306	201	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32664539	32664539	PRJNA1198392_P_NODE_20620_length_242_cov_0.911243_g20479_i0	PRJNA1198392	20620	242	0.911243	2.20520806	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	90.1	1.52e-21	NR	MFA6935545.1	2791017	g20479	i0	87	0.669421487603306	54	7	66.9	0	240	79	33	86	MFA6935545.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	162	90.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae 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);;