metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB39643" 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
57439	57439	PRJEB39643_P_NODE_130141_length_248_cov_1.760000_g129948_i0	PRJEB39643	130141	248	1.76	4.3648	Treponema vincentii	69710	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g129948	i0	97.984	5.84274193548387	248	5	100	0	1	248	2225818	2225571	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	1449	431	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
58337	58337	PRJEB39643_P_NODE_71601_length_275_cov_1.524752_g71408_i0	PRJEB39643	71601	275	1.524752	4.193068	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g71408	i0	100	1	275	0	100	0	1	275	1053092	1053366	Treponema sp. OMZ 305 chromosome, complete genome	blastn	275	508	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
1332011	1332011	PRJEB39643_P_NODE_156842_length_226_cov_2.013072_g156648_i0	PRJEB39643	156842	226	2.013072	4.54954272	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	401	1.7299999999999993e-107	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g156648	i0	98.673	11.9778761061947	226	3	100	0	1	226	1022867	1022642	Treponema sp. OMZ 838, complete genome	blastn	2707	401	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
2607184	2607184	PRJEB39643_P_NODE_117923_length_253_cov_1.711111_g117730_i0	PRJEB39643	117923	253	1.711111	4.32911083	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	191	4.66e-44	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g117730	i0	80.545	54.6442687747036	257	42	100	7	1	253	126794	126542	Leptospira sp. severe_002 chromosome 1	blastn	13825	191	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
2607586	2607586	PRJEB39643_P_NODE_15663_length_467_cov_3.352792_g15471_i0	PRJEB39643	15663	467	3.352792	15.65753864	Borreliella garinii	29519	Bacteria	Bacteria	52.8	0.045	NTclustered	gi\|2592016991\|gb\|CP117904.1\|	29519	g15471	i0	100	0.0599571734475375	28	0	6	0	308	335	6364	6337	Borreliella garinii strain FNG-1Z4 plasmid lp17, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
4817368	4817368	PRJEB39643_P_NODE_44824_length_289_cov_1.425926_g44631_i0	PRJEB39643	44824	289	1.425926	4.12092614	Treponema	157	Bacteria	Bacteria	158	5.51e-34	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g44631	i0	94.231	0.719723183391003	104	5	36	1	1	104	129804	129702	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	208	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
6092656	6092656	PRJEB39643_P_NODE_62125_length_280_cov_1.487923_g61932_i0	PRJEB39643	62125	280	1.487923	4.1661844	Treponema	157	Bacteria	Bacteria	440	4.709999999999998e-119	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g61932	i0	95	3	280	14	100	0	1	280	2536363	2536084	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	840	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
8985332	8985332	PRJEB39643_P_NODE_58488_length_282_cov_1.425837_g58295_i0	PRJEB39643	58488	282	1.425837	4.02086034	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	394	3.75e-105	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g58295	i0	97.021	3.37943262411348	235	6	83	1	1	235	1206824	1206591	Treponema sp. OMZ 906 chromosome, complete genome	blastn	953	394	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
8985424	8985424	PRJEB39643_P_NODE_67788_length_277_cov_1.509804_g67595_i0	PRJEB39643	67788	277	1.509804	4.18215708	Treponema vincentii	69710	Bacteria	Bacteria	496	9.8e-136	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g67595	i0	98.917	3	277	3	100	0	1	277	94672	94948	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	831	496	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
8985731	8985731	PRJEB39643_P_NODE_99628_length_261_cov_1.638298_g99435_i0	PRJEB39643	99628	261	1.638298	4.27595778	Treponema medium	58231	Bacteria	Bacteria	399	7.379999999999998e-107	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g99435	i0	94.253	14.0344827586207	261	15	100	0	1	261	2262446	2262186	Treponema medium strain T19 chromosome, complete genome	blastn	3663	399	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
11192865	11192865	PRJEB39643_P_NODE_44789_length_289_cov_1.425926_g44596_i0	PRJEB39643	44789	289	1.425926	4.12092614	Treponema	157	Bacteria	Bacteria	228	4.139999999999999e-55	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g44596	i0	80.969	2	289	53	99	2	1	288	1085521	1085234	Treponema sp. OMZ 838, complete genome	blastn	578	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
15359367	15359367	PRJEB39643_P_NODE_109053_length_257_cov_1.673913_g108860_i0	PRJEB39643	109053	257	1.673913	4.30195641	Treponema denticola	158	Bacteria	Bacteria	390	4.359999999999999e-104	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g108860	i0	95.142	0.961089494163424	247	12	96	0	11	257	2611426	2611180	Treponema denticola strain CD-1 chromosome, complete genome	blastn	247	390	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15359553	15359553	PRJEB39643_P_NODE_1273_length_1537_cov_8.334699_g1218_i0	PRJEB39643	1273	1537	8.334699	128.10432363	Leptospira gorisiae	3235175	Bacteria	Bacteria	54.7	0.044	NTclustered	gi\|2777199593\|gb\|CP162130.1\|	3235175	g1218	i0	100	0.0188679245283019	29	0	2	0	498	526	2735777	2735749	Leptospira gorisiae strain WS92.C1 chromosome 1, complete sequence	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira gorisiae
15360373	15360373	PRJEB39643_P_NODE_56533_length_283_cov_1.466667_g56340_i0	PRJEB39643	56533	283	1.466667	4.15066761	Treponema socranskii	53419	Bacteria	Bacteria	440	4.769999999999998e-119	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g56340	i0	94.7	3.00706713780919	283	15	100	0	1	283	2479366	2479084	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	851	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
16635207	16635207	PRJEB39643_P_NODE_76534_length_272_cov_1.547739_g76341_i0	PRJEB39643	76534	272	1.547739	4.20985008	Leadbettera azotonutricia	150829	Bacteria	Bacteria	87.9	6.84e-13	NTclustered	gi\|333734099\|gb\|CP001841.1\|	545695	g76341	i0	98.039	0.1875	51	0	18	1	186	235	3229953	3230003	Treponema azotonutricium ZAS-9, complete genome	blastn	51	87.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Leadbettera	Leadbettera azotonutricia
17567155	17567155	PRJEB39643_P_NODE_115694_length_254_cov_1.701657_g115501_i0	PRJEB39643	115694	254	1.701657	4.32220878	Treponema	157	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g115501	i0	99.606	7.97637795275591	254	1	100	0	1	254	1677123	1676870	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	2026	464	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
17567370	17567370	PRJEB39643_P_NODE_70974_length_275_cov_1.524752_g70781_i0	PRJEB39643	70974	275	1.524752	4.193068	Treponema	157	Bacteria	Bacteria	418	2.1599999999999995e-112	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g70781	i0	96.443	2.70181818181818	253	9	92	0	23	275	2479899	2479647	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	743	418	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
17910011	17910011	PRJEB39643_P_NODE_81575_length_270_cov_1.563452_g81382_i0	PRJEB39643	81575	270	1.563452	4.2213204	Treponema socranskii	53419	Bacteria	Bacteria	416	7.619999999999998e-112	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g81382	i0	95.185	1.12962962962963	270	2	100	1	1	270	2777309	2777567	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	305	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
19183014	19183014	PRJEB39643_P_NODE_140676_length_244_cov_1.801170_g140483_i0	PRJEB39643	140676	244	1.80117	4.3948548	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	315	2.5399999999999992e-81	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g140483	i0	91.304	7.63114754098361	230	20	94	0	3	232	1284424	1284653	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	1862	315	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
19184084	19184084	PRJEB39643_P_NODE_93416_length_264_cov_1.612565_g93223_i0	PRJEB39643	93416	264	1.612565	4.2571716	Treponema vincentii	69710	Bacteria	Bacteria	438	1.5799999999999996e-118	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g93223	i0	96.591	13.0037878787879	264	9	100	0	1	264	135311	135574	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	3433	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
20458058	20458058	PRJEB39643_P_NODE_114917_length_254_cov_1.701657_g114724_i0	PRJEB39643	114917	254	1.701657	4.32220878	Treponema denticola	158	Bacteria	Bacteria	442	1.1699999999999995e-119	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g114724	i0	98.031	50.9763779527559	254	5	100	0	1	254	1489233	1489486	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	12948	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20458616	20458616	PRJEB39643_P_NODE_24317_length_370_cov_2.074074_g24124_i0	PRJEB39643	24317	370	2.074074	7.6740738	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	374	6.6099999999999995e-99	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g24124	i0	85.794	96.7054054054054	359	43	96	6	16	370	251313	251667	Leptospira sp. severe_002 chromosome 1	blastn	35781	374	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
21734918	21734918	PRJEB39643_P_NODE_57098_length_282_cov_1.473684_g56905_i0	PRJEB39643	57098	282	1.473684	4.15578888	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	449	7.89e-122	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g56905	i0	95.39	19.6737588652482	282	13	100	0	1	282	628651	628370	Treponema sp. OMZ 838, complete genome	blastn	5548	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
23009590	23009590	PRJEB39643_P_NODE_145799_length_242_cov_1.822485_g145606_i0	PRJEB39643	145799	242	1.822485	4.4104137	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g145606	i0	99.587	2.65289256198347	242	1	100	0	1	242	917135	916894	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	642	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
23009961	23009961	PRJEB39643_P_NODE_35079_length_314_cov_3.634855_g34886_i0	PRJEB39643	35079	314	3.634855	11.4134447	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	202	2.7599999999999996e-47	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g34886	i0	90.26	21.8980891719745	154	15	49	0	161	314	350412	350565	Leptospira sp. severe_002 chromosome 1	blastn	6876	202	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002

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