metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA846086" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA846086" 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
2108334	2108334	PRJNA846086_P_NODE_4042_length_247_cov_0.885057_g3976_i0	PRJNA846086	4042	247	0.885057	2.18609079	Treponema denticola	158	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g3976	i0	97.976	19.0485829959514	247	5	100	0	1	247	1156555	1156801	Treponema denticola strain OT2B chromosome, complete genome	blastn	4705	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
2108342	2108342	PRJNA846086_P_NODE_4442_length_245_cov_1.540698_g4376_i0	PRJNA846086	4442	245	1.540698	3.7747101	Treponema vincentii	69710	Bacteria	Bacteria	329	9.12e-86	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g4376	i0	91.02	7.48571428571429	245	21	100	1	1	245	551882	551639	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	1834	329	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
3783091	3783091	PRJNA846086_P_NODE_1643_length_297_cov_0.888393_g1577_i0	PRJNA846086	1643	297	0.888393	2.63852721	Treponema	157	Bacteria	Bacteria	531	2.9099999999999992e-146	NTclustered	gi\|285184822\|gb\|GU420695.1\|	51160	g1577	i0	98.986	99.7340067340067	296	3	99	0	2	297	200	495	Treponema maltophilum clone GF004 16S ribosomal RNA gene, partial sequence	blastn	29621	531	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
5936021	5936021	PRJNA846086_P_NODE_2205_length_275_cov_1.301980_g2139_i0	PRJNA846086	2205	275	1.30198	3.580445	Brucepastera parasyntrophica	2880008	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2198899484\|gb\|CP084606.1\|	2880008	g2139	i0	100	0.221818181818182	29	0	12	0	85	113	553531	553503	Brucepastera parasyntrophica strain RmG11 chromosome, complete genome	blastn	61	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Brucepastera	Brucepastera parasyntrophica
8485744	8485744	PRJNA846086_P_NODE_727_length_433_cov_2.272222_g661_i0	PRJNA846086	727	433	2.272222	9.83872126	Treponema denticola	158	Bacteria	Bacteria	750	0	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g661	i0	97.926	182.713625866051	434	7	100	2	1	433	513806	513374	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	79115	750	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
9760899	9760899	PRJNA846086_P_NODE_2868_length_256_cov_1.327869_g2802_i0	PRJNA846086	2868	256	1.327869	3.39934464	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	374	4.369999999999998e-99	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g2802	i0	94.606	10.390625	241	13	94	0	1	241	930621	930861	Treponema sp. OMZ 906 chromosome, complete genome	blastn	2660	374	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
10159738	10159738	PRJNA846086_P_NODE_4208_length_246_cov_0.890173_g4142_i0	PRJNA846086	4208	246	0.890173	2.18982558	Treponema	157	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g4142	i0	98.374	29.8333333333333	246	4	100	0	1	246	1066361	1066116	Treponema sp. OMZ 838, complete genome	blastn	7339	433	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
11036549	11036549	PRJNA846086_P_NODE_3009_length_251_cov_1.612360_g2943_i0	PRJNA846086	3009	251	1.61236	4.0470236	Treponema vincentii	69710	Bacteria	Bacteria	176	1.2899999999999999e-39	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g2943	i0	85.294	5.02788844621514	170	25	68	0	1	170	1484938	1484769	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	1262	176	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
11435018	11435018	PRJNA846086_P_NODE_4429_length_245_cov_1.784884_g4363_i0	PRJNA846086	4429	245	1.784884	4.3729658	Treponema	157	Bacteria	Bacteria	383	6.899999999999998e-102	NTclustered	gi\|2265199313\|gb\|CP058624.1\|	158	g4363	i0	99.524	72.8326530612245	210	1	100	0	1	210	2740608	2740399	Treponema denticola strain OMZ 854 chromosome, complete genome	blastn	17844	383	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
12710838	12710838	PRJNA846086_P_NODE_4490_length_245_cov_0.895349_g4424_i0	PRJNA846086	4490	245	0.895349	2.19360505	Treponema	157	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g4424	i0	97.959	19.8448979591837	245	5	100	0	1	245	2231376	2231620	Treponema denticola strain CD-1 chromosome, complete genome	blastn	4862	425	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
13586475	13586475	PRJNA846086_P_NODE_1331_length_325_cov_2.738095_g1265_i0	PRJNA846086	1331	325	2.738095	8.89880875	Treponema socranskii	53419	Bacteria	Bacteria	475	1.53e-129	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g1265	i0	93.189	183.338461538462	323	22	99	0	3	325	790166	789844	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	59585	475	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
14860776	14860776	PRJNA846086_P_NODE_3552_length_249_cov_0.875000_g3486_i0	PRJNA846086	3552	249	0.875	2.17875	Treponema denticola	158	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g3486	i0	100	1	249	0	100	0	1	249	2753141	2752893	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	249	460	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15259190	15259190	PRJNA846086_P_NODE_1132_length_348_cov_4.349091_g1066_i0	PRJNA846086	1132	348	4.349091	15.13483668	Treponema	157	Bacteria	Bacteria	604	2.0199999999999992e-168	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g1066	i0	97.989	182.772988505747	348	7	100	0	1	348	1014322	1013975	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	63605	610	0.99016393442623	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
16135603	16135603	PRJNA846086_P_NODE_4873_length_244_cov_0.900585_g4807_i0	PRJNA846086	4873	244	0.900585	2.1974274	Treponema denticola	158	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g4807	i0	100	24.3524590163934	244	0	100	0	1	244	1161788	1162031	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	5942	451	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
16135606	16135606	PRJNA846086_P_NODE_5013_length_243_cov_0.905882_g4947_i0	PRJNA846086	5013	243	0.905882	2.20129326	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g4947	i0	93.827	2.94650205761317	243	15	100	0	1	243	791370	791612	Treponema sp. Marseille-Q4132 chromosome	blastn	716	366	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
16135621	16135621	PRJNA846086_P_NODE_5713_length_238_cov_2.181818_g5647_i0	PRJNA846086	5713	238	2.181818	5.19272684	Treponema parvum	138851	Bacteria	Bacteria	222	1.54e-53	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g5647	i0	85.714	182.90756302521	217	24	89	7	27	238	1518107	1517893	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	43532	222	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
16533805	16533805	PRJNA846086_P_NODE_2753_length_259_cov_1.435484_g2687_i0	PRJNA846086	2753	259	1.435484	3.71790356	Treponema	157	Bacteria	Bacteria	457	4.279999999999999e-124	NTclustered	gi\|2265181513\|gb\|CP051634.1\|	158	g2687	i0	98.456	9.98455598455598	259	4	100	0	1	259	93236	93494	Treponema denticola strain OMZ 850 chromosome, complete genome	blastn	2586	457	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17411037	17411037	PRJNA846086_P_NODE_2334_length_271_cov_1.252525_g2268_i0	PRJNA846086	2334	271	1.252525	3.39434275	Treponema socranskii	53419	Bacteria	Bacteria	484	2.07e-132	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g2268	i0	98.893	160.49815498155	271	3	100	0	1	271	908134	907864	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	43495	484	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
17411053	17411053	PRJNA846086_P_NODE_3394_length_250_cov_0.870056_g3328_i0	PRJNA846086	3394	250	0.870056	2.17514	Treponema denticola	158	Bacteria	Bacteria	429	8.949999999999998e-116	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g3328	i0	97.6	29.904	250	6	100	0	1	250	2019848	2019599	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	7476	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18684141	18684141	PRJNA846086_P_NODE_4055_length_247_cov_0.885057_g3989_i0	PRJNA846086	4055	247	0.885057	2.18609079	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	412	8.89e-111	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g3989	i0	96.761	2.2995951417004	247	8	100	0	1	247	2027725	2027971	Treponema sp. Marseille-Q4132 chromosome	blastn	568	412	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
19959246	19959246	PRJNA846086_P_NODE_1436_length_315_cov_2.223140_g1370_i0	PRJNA846086	1436	315	2.22314	7.002891	Treponema parvum	138851	Bacteria	Bacteria	254	7.53e-63	NTclustered	gi\|2023449428\|gb\|CP058315.1\|	138851	g1370	i0	81.935	92.9460317460317	310	47	97	9	9	315	1097575	1097272	Treponema parvum strain OMZ 843 chromosome, complete genome	blastn	29278	254	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
19959287	19959287	PRJNA846086_P_NODE_3596_length_249_cov_0.875000_g3530_i0	PRJNA846086	3596	249	0.875	2.17875	Treponema parvum	138851	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g3530	i0	99.598	3.21686746987952	249	1	100	0	1	249	2417567	2417815	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	801	455	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
19959305	19959305	PRJNA846086_P_NODE_4476_length_245_cov_0.895349_g4410_i0	PRJNA846086	4476	245	0.895349	2.19360505	Treponema vincentii	69710	Bacteria	Bacteria	300	7.15e-77	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g4410	i0	88.538	2.94285714285714	253	21	100	2	1	245	2558528	2558276	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	721	300	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
19959317	19959317	PRJNA846086_P_NODE_5216_length_242_cov_0.911243_g5150_i0	PRJNA846086	5216	242	0.911243	2.20520806	Treponema socranskii	53419	Bacteria	Bacteria	399	6.759999999999999e-107	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g5150	i0	96.667	2.98347107438017	240	8	99	0	1	240	678045	677806	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	722	399	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
21234931	21234931	PRJNA846086_P_NODE_2877_length_255_cov_2.181319_g2811_i0	PRJNA846086	2877	255	2.181319	5.56236345	Treponema sp. 5:22:BH022	105290	Bacteria	Bacteria	438	1.52e-118	NTclustered	gi\|6049690\|gb\|AF182837.1\|AF182837	105290	g2811	i0	97.647	97.1098039215686	255	6	100	0	1	255	262	8	Treponema sp. 5:22:BH022 16S ribosomal RNA gene, partial sequence	blastn	24763	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. 5:22:BH022
21234950	21234950	PRJNA846086_P_NODE_3917_length_248_cov_0.880000_g3851_i0	PRJNA846086	3917	248	0.88	2.1824	Treponema vincentii	69710	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g3851	i0	95.868	5.86693548387097	242	10	98	0	1	242	982222	982463	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	1455	392	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
21234954	21234954	PRJNA846086_P_NODE_4137_length_247_cov_0.885057_g4071_i0	PRJNA846086	4137	247	0.885057	2.18609079	Treponema vincentii	69710	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g4071	i0	100	9.85425101214575	247	0	100	0	1	247	36473	36719	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	2434	457	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22908754	22908754	PRJNA846086_P_NODE_4918_length_243_cov_1.705882_g4852_i0	PRJNA846086	4918	243	1.705882	4.14529326	Treponema	157	Bacteria	Bacteria	233	7.289999999999999e-57	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g4852	i0	84.848	14.1234567901235	231	35	95	0	7	237	2142116	2142346	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	3432	233	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
23785168	23785168	PRJNA846086_P_NODE_4659_length_245_cov_0.895349_g4593_i0	PRJNA846086	4659	245	0.895349	2.19360505	Treponema socranskii	53419	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g4593	i0	97.959	3	245	5	100	0	1	245	157435	157679	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	735	425	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
25059052	25059052	PRJNA846086_P_NODE_3900_length_248_cov_0.880000_g3834_i0	PRJNA846086	3900	248	0.88	2.1824	Treponema socranskii	53419	Bacteria	Bacteria	399	6.949999999999999e-107	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g3834	i0	95.951	4.75806451612903	247	9	99	1	1	246	2850021	2850267	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	1180	399	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
25059053	25059053	PRJNA846086_P_NODE_3920_length_248_cov_0.880000_g3854_i0	PRJNA846086	3920	248	0.88	2.1824	Treponema medium	58231	Bacteria	Bacteria	363	9.119999999999997e-96	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g3854	i0	93.548	2	248	9	100	1	1	248	517465	517225	Treponema medium strain T19 chromosome, complete genome	blastn	496	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
25457790	25457790	PRJNA846086_P_NODE_1580_length_301_cov_3.074561_g1514_i0	PRJNA846086	1580	301	3.074561	9.25442861	Treponema	157	Bacteria	Bacteria	503	6.43e-138	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g1514	i0	96.711	198.720930232558	304	7	100	2	1	301	1013377	1013680	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	59815	505	0.996039603960396	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium

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