metadata: contig_metadata: 57 rows where bioproject = "PRJEB28062", tax_kingdom = "Pseudomonadati" and tax

57 rows where bioproject = "PRJEB28062", tax_kingdom = "Pseudomonadati" 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
2573658	2573658	PRJEB28062_P_NODE_115383_length_272_cov_1.688442_g113020_i0	PRJEB28062	115383	272	1.688442	4.59256224	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	488	1.6099999999999996e-133	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g113020	i0	99.259	15.0919117647059	270	2	99	0	1	270	1107462	1107193	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	4105	488	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
8952156	8952156	PRJEB28062_P_NODE_60428_length_450_cov_7.286472_g58068_i0	PRJEB28062	60428	450	7.286472	32.789124	Treponema medium	58231	Bacteria	Bacteria	174	8.92e-39	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g58068	i0	83.163	2.60888888888889	196	28	43	4	34	227	877449	877257	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	1174	174	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
10226460	10226460	PRJEB28062_P_NODE_113849_length_276_cov_2.083744_g111486_i0	PRJEB28062	113849	276	2.083744	5.75113344	Treponema	157	Bacteria	Bacteria	140	1.85e-36	NR	WP_385981414.1	166	g111486	i0	79.8	1.82608695652174	84	17	91.3	0	256	5	624	707	WP_385981414.1 acyl-CoA dehydratase activase-related protein, partial [Treponema sp.]	diamond	504	140	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
10227837	10227837	PRJEB28062_P_NODE_56929_length_466_cov_15.613232_g54575_i0	PRJEB28062	56929	466	15.613232	72.75766112	Treponema vincentii	69710	Bacteria	Bacteria	444	6.39e-120	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g54575	i0	85.446	6.33047210300429	426	62	91	0	23	448	897367	896942	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	2950	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
11502072	11502072	PRJEB28062_P_NODE_133130_length_232_cov_5.371069_g130766_i0	PRJEB28062	133130	232	5.371069	12.46088008	Treponema denticola	158	Bacteria	Bacteria	233	6.899999999999999e-57	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g130766	i0	86.854	147.560344827586	213	23	91	5	1	211	1101327	1101118	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	34234	233	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
12777779	12777779	PRJEB28062_P_NODE_17371_length_908_cov_13.196407_g15419_i0	PRJEB28062	17371	908	13.196407	119.82337556	Treponema vincentii	69710	Bacteria	Bacteria	1580	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g15419	i0	99.427	13.374449339207	872	2	96	3	19	889	592217	593086	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	12144	1580	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
15326928	15326928	PRJEB28062_P_NODE_41613_length_562_cov_5.335378_g39278_i0	PRJEB28062	41613	562	5.335378	29.98482436	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	54.7	4.76e-5	NR	TVQ98860.1	1898206	g39278	i0	59.2	0.51779359430605	49	16	24	1	146	12	62	110	TVQ98860.1 MAG: DUF362 domain-containing protein [Spirochaetaceae bacterium]	diamond	291	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
16289797	16289797	PRJEB28062_P_NODE_136913_length_209_cov_4.948529_g134549_i0	PRJEB28062	136913	209	4.948529	10.34242561	Treponema	157	Bacteria	Bacteria	200	6.18e-47	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g134549	i0	86.316	55.511961722488	190	19	89	7	1	186	430015	429829	Treponema brennaborense DSM 12168, complete genome	blastn	11602	200	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
17875862	17875862	PRJEB28062_P_NODE_18875_length_867_cov_5.593199_g16869_i0	PRJEB28062	18875	867	5.593199	48.49303533	Spirochaetales	136	Bacteria	Bacteria	391	1.45e-133	NR	MEL3906746.1	166	g16869	i0	70.3	10.7612456747405	283	84	97.9	0	9	857	39	321	MEL3906746.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Treponema sp.]	diamond	9330	394	0.99238578680203	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
20425307	20425307	PRJEB28062_P_NODE_35557_length_614_cov_114.334566_g33236_i0	PRJEB28062	35557	614	114.334566	702.01423524	Treponema vincentii	69710	Bacteria	Bacteria	787	0	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g33236	i0	92.559	4.48208469055375	551	38	90	2	23	573	161601	161054	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	2752	787	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
21702498	21702498	PRJEB28062_P_NODE_91858_length_339_cov_4.473684_g89496_i0	PRJEB28062	91858	339	4.473684	15.16578876	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	512	1.22e-140	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g89496	i0	97.039	4.43362831858407	304	9	90	0	13	316	304330	304027	Treponema sp. OMZ 305 chromosome, complete genome	blastn	1503	512	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
22977071	22977071	PRJEB28062_P_NODE_55779_length_472_cov_6.817043_g53425_i0	PRJEB28062	55779	472	6.817043	32.17644296	Spirochaetia bacterium	2053615	Bacteria	Bacteria	285	4.16e-72	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g53425	i0	78.96	2.25635593220339	423	85	89	4	24	444	396400	395980	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	1065	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
26621610	26621610	PRJEB28062_P_NODE_117221_length_267_cov_3.701031_g114858_i0	PRJEB28062	117221	267	3.701031	9.88175277	Treponema vincentii	69710	Bacteria	Bacteria	99.8	4.21e-22	NR	WP_016517831.1	69710	g114858	i0	53.1	1.82022471910112	81	38	91	0	1	243	37	117	WP_016517831.1 transglutaminase domain-containing protein [Treponema vincentii]	diamond	486	99.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
26653053	26653053	PRJEB28062_P_NODE_112661_length_279_cov_2.859223_g110298_i0	PRJEB28062	112661	279	2.859223	7.97723217	Spirochaetota bacterium	2202144	Bacteria	Bacteria	168	2.9699999999999993e-46	NR	HPF05901.1	2202144	g110298	i0	98.8	0.924731182795699	86	1	92.5	0	259	2	446	531	HPF05901.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Spirochaetota bacterium]	diamond	258	168	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
26906658	26906658	PRJEB28062_P_NODE_54862_length_477_cov_3.475248_g52509_i0	PRJEB28062	54862	477	3.475248	16.57693296	Treponema sp.	166	Bacteria	Bacteria	252	1.08e-77	NR	MEE0886360.1	166	g52509	i0	80.1	1.9622641509434	156	31	98.1	0	10	477	388	543	MEE0886360.1 flagellar hook-associated protein FlgK [Treponema sp.]	diamond	936	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27127648	27127648	PRJEB28062_P_NODE_84582_length_362_cov_5.027682_g82220_i0	PRJEB28062	84582	362	5.027682	18.20020884	Treponema socranskii	53419	Bacteria	Bacteria	179	1.09e-53	NR	WP_180486363.1	53419	g82220	i0	75.9	0.92817679558011	112	27	92.8	0	360	25	40	151	WP_180486363.1 lipase family alpha/beta hydrolase [Treponema socranskii]	diamond	336	179	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
27381055	27381055	PRJEB28062_P_NODE_22423_length_789_cov_28.731844_g20261_i0	PRJEB28062	22423	789	28.731844	226.69424916	Spirochaetota bacterium	2202144	Bacteria	Bacteria	325	2.48e-108	NR	HRX47452.1	2202144	g20261	i0	85.4	0.752851711026616	198	29	75.3	0	595	2	1	198	HRX47452.1 metalloregulator ArsR/SmtB family transcription factor [Spirochaetota bacterium]	diamond	594	325	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27469304	27469304	PRJEB28062_P_NODE_95543_length_328_cov_3.721569_g93181_i0	PRJEB28062	95543	328	3.721569	12.20674632	Bacteria	2	Bacteria	Bacteria	147	4.81e-40	NR	PKL39026.1	2013832	g93181	i0	72.8	1.88414634146341	103	28	94.2	0	310	2	221	323	PKL39026.1 MAG: MFS transporter [Spirochaetae bacterium HGW-Spirochaetae-1]	diamond	618	147	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-1
27475636	27475636	PRJEB28062_P_NODE_80563_length_375_cov_4.705298_g78201_i0	PRJEB28062	80563	375	4.705298	17.6448675	Treponema	157	Bacteria	Bacteria	183	1.7799999999999995e-55	NR	WP_212566030.1	157	g78201	i0	81.7	1.784	109	20	87.2	0	328	2	27	135	WP_212566030.1 MULTISPECIES: tetratricopeptide repeat protein [Treponema]	diamond	669	183	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
27563598	27563598	PRJEB28062_P_NODE_73784_length_398_cov_3.670769_g71422_i0	PRJEB28062	73784	398	3.670769	14.60966062	root	1	Root_unresolved	Root_unresolved	145	6.44e-39	NR	WP_230974626.1	69710	g71422	i0	62.7	4.74874371859296	126	40	89.7	2	366	10	179	304	WP_230974626.1 glycosyltransferase [Treponema vincentii]	diamond	1890	146	0.993150684931507	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27728567	27728567	PRJEB28062_P_NODE_27764_length_703_cov_61.096825_g25506_i0	PRJEB28062	27764	703	61.096825	429.51067975	Spirochaetia bacterium	2053615	Bacteria	Bacteria	281	2.58e-83	NR	GHU70841.1	2053615	g25506	i0	68.1	0.92176386913229	216	69	92.2	0	21	668	940	1155	GHU70841.1 hypothetical protein FACS189450_05930 [Spirochaetia bacterium]	diamond	648	281	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27917527	27917527	PRJEB28062_P_NODE_129805_length_242_cov_2.455621_g127441_i0	PRJEB28062	129805	242	2.455621	5.94260282	Treponema pedis	409322	Bacteria	Bacteria	65.9	1e-10	NR	WP_024468134.1	409322	g127441	i0	49.2	0.78099173553719	63	32	78.1	0	242	54	26	88	WP_024468134.1 hypothetical protein [Treponema pedis]	diamond	189	65.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
27980865	27980865	PRJEB28062_P_NODE_81925_length_371_cov_1.382550_g79563_i0	PRJEB28062	81925	371	1.38255	5.1292605	Spirochaetota bacterium	2202144	Bacteria	Bacteria	193	1.08e-60	NR	HOP31019.1	2202144	g79563	i0	85.3	0.881401617250674	109	16	88.1	0	329	3	3	111	HOP31019.1 HyaD/HybD family hydrogenase maturation endopeptidase [Spirochaetota bacterium]	diamond	327	193	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28069015	28069015	PRJEB28062_P_NODE_41685_length_561_cov_40.577869_g39350_i0	PRJEB28062	41685	561	40.577869	227.64184509	Bacteria	2	Bacteria	Bacteria	249	6.920000000000001e-79	NR	PKL07630.1	2013839	g39350	i0	74.2	3.28342245989305	155	40	82.9	0	530	66	11	165	PKL07630.1 MAG: galactitol-1-phosphate 5-dehydrogenase [Spirochaetae bacterium HGW-Spirochaetae-7]	diamond	1842	249	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-7
28170240	28170240	PRJEB28062_P_NODE_123346_length_253_cov_1.466667_g120982_i0	PRJEB28062	123346	253	1.466667	3.71066751	Spirochaetota bacterium	2202144	Bacteria	Bacteria	76.3	6.38e-14	NR	HOP28035.1	2202144	g120982	i0	50	0.901185770750988	76	38	90.1	0	253	26	376	451	HOP28035.1 hypothetical protein [Spirochaetota bacterium]	diamond	228	76.3	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28264784	28264784	PRJEB28062_P_NODE_103146_length_305_cov_8.508621_g100783_i0	PRJEB28062	103146	305	8.508621	25.95129405	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	70.9	9.93e-12	NR	MCK9599440.1	1972642	g100783	i0	57.4	1.05245901639344	54	23	53.1	0	129	290	87	140	MCK9599440.1 hypothetical protein [Sphaerochaeta sp.]	diamond	321	70.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
28264836	28264836	PRJEB28062_P_NODE_98506_length_319_cov_3.873984_g96144_i0	PRJEB28062	98506	319	3.873984	12.35800896	Spirochaetota bacterium	2202144	Bacteria	Bacteria	184	3.38e-54	NR	HOP28831.1	2202144	g96144	i0	92.8	0.912225705329154	97	7	91.2	0	311	21	187	283	HOP28831.1 phosphoribosylamine--glycine ligase [Spirochaetota bacterium]	diamond	291	184	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28391268	28391268	PRJEB28062_P_NODE_90586_length_343_cov_4.033333_g88224_i0	PRJEB28062	90586	343	4.033333	13.83433219	Candidatus Thalassospirochaeta sargassi	3119039	Bacteria	Bacteria	63.9	3.89e-9	NR	MDC7226541.1	3119039	g88224	i0	28.4	0.9533527696793	109	77	95.3	1	13	339	86	193	MDC7226541.1 glycosyltransferase family 4 protein [Candidiatus Thalassospirochaeta sargassi]	diamond	327	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Candidatus Thalassospirochaeta	Candidatus Thalassospirochaeta sargassi
28542899	28542899	PRJEB28062_P_NODE_49267_length_509_cov_5.284404_g46919_i0	PRJEB28062	49267	509	5.284404	26.89761636	Treponema	157	Bacteria	Bacteria	239	1.06e-69	NR	MCR5401627.1	166	g46919	i0	72.7	3.72495088408644	154	41	90.8	1	2	463	519	671	MCR5401627.1 type I pullulanase [Treponema sp.]	diamond	1896	239	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28801549	28801549	PRJEB28062_P_NODE_71348_length_406_cov_19.672673_g68987_i0	PRJEB28062	71348	406	19.672673	79.87105238	Spirochaetota bacterium	2202144	Bacteria	Bacteria	198	6.469999999999999e-61	NR	HPR38453.1	2202144	g68987	i0	81.1	1.80295566502463	122	23	90.1	0	19	384	82	203	HPR38453.1 hypothetical protein [Spirochaetota bacterium]	diamond	732	198	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28833279	28833279	PRJEB28062_P_NODE_58648_length_458_cov_6.929870_g56289_i0	PRJEB28062	58648	458	6.92987	31.7388046	Oceanispirochaeta crateris	2518645	Bacteria	Bacteria	91.3	2.68e-19	NR	WP_149487666.1	2518645	g56289	i0	65.6	0.399563318777293	61	21	40	0	191	9	1	61	WP_149487666.1 ABC transporter permease [Oceanispirochaeta crateris]	diamond	183	91.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Oceanispirochaeta	Oceanispirochaeta crateris
28864825	28864825	PRJEB28062_P_NODE_63168_length_438_cov_7.969863_g60807_i0	PRJEB28062	63168	438	7.969863	34.90799994	Treponemataceae bacterium	2854022	Bacteria	Bacteria	87.4	2.8e-17	NR	MCQ2579721.1	2854022	g60807	i0	39.7	0.863013698630137	126	68	82.2	2	20	379	70	193	MCQ2579721.1 AraC family transcriptional regulator [Treponemataceae bacterium]	diamond	378	87.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
28896323	28896323	PRJEB28062_P_NODE_137028_length_208_cov_4.237037_g134664_i0	PRJEB28062	137028	208	4.237037	8.81303696	Spirochaetota bacterium	2202144	Bacteria	Bacteria	70.1	8.46e-14	NR	HPF05317.1	2202144	g134664	i0	96.7	0.432692307692308	30	1	43.3	0	91	2	1	30	HPF05317.1 hypothetical protein [Spirochaetota bacterium]	diamond	90	70.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28896335	28896335	PRJEB28062_P_NODE_50568_length_501_cov_6.446262_g48219_i0	PRJEB28062	50568	501	6.446262	32.29577262	Spirochaetota bacterium	2202144	Bacteria	Bacteria	300	1.919999999999999e-96	NR	HOP29525.1	2202144	g48219	i0	90.6	0.952095808383233	159	15	95.2	0	499	23	436	594	HOP29525.1 PAS domain S-box protein [Spirochaetota bacterium]	diamond	477	300	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29306829	29306829	PRJEB28062_P_NODE_131209_length_240_cov_2.107784_g128845_i0	PRJEB28062	131209	240	2.107784	5.0586816	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	43.1	0.0129	NR	MCR5760452.1	2791017	g128845	i0	36.2	1.175	47	30	58.8	0	200	60	54	100	MCR5760452.1 RpiB/LacA/LacB family sugar-phosphate isomerase [Sphaerochaetaceae bacterium]	diamond	282	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
29370137	29370137	PRJEB28062_P_NODE_60249_length_451_cov_3.722222_g57889_i0	PRJEB28062	60249	451	3.722222	16.78722122	Treponema sp.	166	Bacteria	Bacteria	167	3.939999999999999e-48	NR	NLJ45030.1	166	g57889	i0	100	0.552106430155211	83	0	55.2	0	269	21	181	263	NLJ45030.1 zinc ABC transporter solute-binding protein [Treponema sp.]	diamond	249	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29432878	29432878	PRJEB28062_P_NODE_124770_length_250_cov_1.661017_g122406_i0	PRJEB28062	124770	250	1.661017	4.1525425	Spirochaetota bacterium	2202144	Bacteria	Bacteria	128	4.34e-34	NR	HOP29018.1	2202144	g122406	i0	80.8	1.752	73	14	87.6	0	32	250	1	73	HOP29018.1 MBL fold metallo-hydrolase [Spirochaetota bacterium]	diamond	438	128	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29521439	29521439	PRJEB28062_P_NODE_40570_length_570_cov_16.496982_g38236_i0	PRJEB28062	40570	570	16.496982	94.0327974	Pseudomonadati	3379134	Bacteria	Bacteria	124	6.98e-30	NR	TXH08468.1	2202144	g38236	i0	40.2	1.72631578947368	164	91	85.3	2	1	486	241	399	TXH08468.1 MAG: hypothetical protein E6R04_10600 [Spirochaetota bacterium]	diamond	984	124	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29653862	29653862	PRJEB28062_P_NODE_8770_length_1319_cov_80.401284_g7277_i0	PRJEB28062	8770	1319	80.401284	1060.49293596	Spirochaetota bacterium	2202144	Bacteria	Bacteria	281	1.78e-85	NR	HOP30955.1	2202144	g7277	i0	92.9	0.350265352539803	154	11	35	0	22	483	392	545	HOP30955.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Spirochaetota bacterium]	diamond	462	281	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29748680	29748680	PRJEB28062_P_NODE_70491_length_409_cov_49.514881_g68130_i0	PRJEB28062	70491	409	49.514881	202.51586329	Spirochaetota bacterium	2202144	Bacteria	Bacteria	161	4.85e-46	NR	HPF06547.1	2202144	g68130	i0	88.6	0.579462102689487	79	9	57.9	0	391	155	234	312	HPF06547.1 acyltransferase [Spirochaetota bacterium]	diamond	237	161	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29875348	29875348	PRJEB28062_P_NODE_49591_length_507_cov_2.981567_g47243_i0	PRJEB28062	49591	507	2.981567	15.11654469	Spirochaetota bacterium	2202144	Bacteria	Bacteria	280	8.9e-85	NR	HOP30433.1	2202144	g47243	i0	87	0.952662721893491	161	21	95.3	0	2	484	359	519	HOP30433.1 PAS domain S-box protein [Spirochaetota bacterium]	diamond	483	280	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29906971	29906971	PRJEB28062_P_NODE_137931_length_200_cov_5.409449_g135567_i0	PRJEB28062	137931	200	5.409449	10.818898	Spirochaetota bacterium	2202144	Bacteria	Bacteria	39.7	0.0456	NR	HOP64218.1	2202144	g135567	i0	88.9	0.27	18	2	27	0	132	185	1	18	HOP64218.1 cold shock domain-containing protein [Spirochaetota bacterium]	diamond	54	39.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30064704	30064704	PRJEB28062_P_NODE_45612_length_532_cov_13.505447_g43272_i0	PRJEB28062	45612	532	13.505447	71.84897804	Spirochaetota bacterium	2202144	Bacteria	Bacteria	225	7.91e-65	NR	HOP28708.1	2202144	g43272	i0	68.7	0.919172932330827	163	51	91.9	0	17	505	391	553	HOP28708.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium]	diamond	489	225	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30127704	30127704	PRJEB28062_P_NODE_114472_length_274_cov_5.159204_g112109_i0	PRJEB28062	114472	274	5.159204	14.13621896	Spirochaetales bacterium	2026792	Bacteria	Bacteria	69.3	6.96e-13	NR	RPI97193.1	2026792	g112109	i0	38.2	0.832116788321168	76	47	83.2	0	21	248	18	93	RPI97193.1 MAG: hypothetical protein EHM32_01980 [Spirochaetales bacterium]	diamond	228	69.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
30191097	30191097	PRJEB28062_P_NODE_99732_length_315_cov_21.161157_g97370_i0	PRJEB28062	99732	315	21.161157	66.65764455	Spirochaetota bacterium	2202144	Bacteria	Bacteria	166	4.1799999999999997e-47	NR	HPF07287.1	2202144	g97370	i0	78.9	1.80952380952381	95	20	90.5	0	310	26	24	118	HPF07287.1 putative glycoside hydrolase [Spirochaetota bacterium]	diamond	570	166	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30254649	30254649	PRJEB28062_P_NODE_111692_length_282_cov_1.425837_g109329_i0	PRJEB28062	111692	282	1.425837	4.02086034	Spirochaetota bacterium	2202144	Bacteria	Bacteria	95.5	2.85e-21	NR	HOP28955.1	2202144	g109329	i0	82.8	0.617021276595745	58	10	61.7	0	199	26	104	161	HOP28955.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Spirochaetota bacterium]	diamond	174	95.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30444074	30444074	PRJEB28062_P_NODE_106033_length_297_cov_2.941964_g103670_i0	PRJEB28062	106033	297	2.941964	8.73763308	Spirochaetota bacterium	2202144	Bacteria	Bacteria	167	1.1399999999999999e-48	NR	HOP29110.1	2202144	g103670	i0	90.5	0.95959595959596	95	9	96	0	5	289	212	306	HOP29110.1 branched-chain amino acid ABC transporter permease [Spirochaetota bacterium]	diamond	285	167	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30658655	30658655	PRJEB28062_P_NODE_102093_length_308_cov_27.029787_g99730_i0	PRJEB28062	102093	308	27.029787	83.25174396	Bacteria	2	Bacteria	Bacteria	55.1	3.75e-6	NR	MCK9601122.1	1972642	g99730	i0	38.8	3.35064935064935	80	43	72.1	2	263	42	689	768	MCK9601122.1 DNA polymerase [Sphaerochaeta sp.]	diamond	1032	55.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
30791471	30791471	PRJEB28062_P_NODE_105094_length_300_cov_1.480176_g102731_i0	PRJEB28062	105094	300	1.480176	4.440528	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	187	2.17e-58	NR	MFA6690227.1	2791017	g102731	i0	91.8	0.97	97	8	97	0	293	3	37	133	MFA6690227.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	291	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
30981300	30981300	PRJEB28062_P_NODE_78354_length_382_cov_13.042071_g75992_i0	PRJEB28062	78354	382	13.042071	49.82071122	Spirochaetota bacterium	2202144	Bacteria	Bacteria	133	8.97e-35	NR	HPK45277.1	2202144	g75992	i0	56.8	0.871727748691099	111	45	87.2	1	36	368	58	165	HPK45277.1 kelch repeat-containing protein [Spirochaetota bacterium]	diamond	333	133	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31012684	31012684	PRJEB28062_P_NODE_93195_length_335_cov_3.618321_g90833_i0	PRJEB28062	93195	335	3.618321	12.12137535	Spirochaetota bacterium	2202144	Bacteria	Bacteria	145	1.18e-37	NR	HPJ43259.1	2202144	g90833	i0	63.1	1.84477611940299	103	38	92.2	0	3	311	189	291	HPJ43259.1 ABC transporter substrate binding protein [Spirochaetota bacterium]	diamond	618	145	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31392185	31392185	PRJEB28062_P_NODE_132596_length_234_cov_5.378882_g130232_i0	PRJEB28062	132596	234	5.378882	12.58658388	Spirochaetota bacterium	2202144	Bacteria	Bacteria	108	1.1e-26	NR	HQO39032.1	2202144	g130232	i0	72	4.61538461538461	75	21	96.2	0	3	227	94	168	HQO39032.1 NADH-quinone oxidoreductase subunit H [Spirochaetota bacterium]	diamond	1080	108	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31929714	31929714	PRJEB28062_P_NODE_84037_length_364_cov_2.735395_g81675_i0	PRJEB28062	84037	364	2.735395	9.9568378	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	219	1.29e-69	NR	MFA6935580.1	2791017	g81675	i0	95.5	0.914835164835165	111	5	91.5	0	343	11	22	132	MFA6935580.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	333	219	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32467916	32467916	PRJEB28062_P_NODE_67599_length_420_cov_11.829971_g65238_i0	PRJEB28062	67599	420	11.829971	49.6858782	Treponema vincentii	69710	Bacteria	Bacteria	89.7	1.59e-20	NR	WP_253807517.1	69710	g65238	i0	83.3	0.385714285714286	54	9	38.6	0	339	178	9	62	WP_253807517.1 hypothetical protein [Treponema vincentii]	diamond	162	89.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
32562851	32562851	PRJEB28062_P_NODE_97899_length_321_cov_2.959677_g95537_i0	PRJEB28062	97899	321	2.959677	9.50056317	uncultured spirochete	156406	Bacteria	Bacteria	82.8	2.36e-17	NR	SLM18075.1	156406	g95537	i0	73.6	0.495327102803738	53	14	49.5	0	317	159	103	155	SLM18075.1 Phosphinothricin N-acetyltransferase [uncultured spirochete]	diamond	159	82.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			uncultured spirochete
32656721	32656721	PRJEB28062_P_NODE_80880_length_374_cov_4.056478_g78518_i0	PRJEB28062	80880	374	4.056478	15.17122772	Treponema denticola	158	Bacteria	Bacteria	179	8.479999999999999e-52	NR	WP_002666054.1	158	g78518	i0	89.3	0.898395721925134	112	12	89.8	0	17	352	222	333	WP_002666054.1 APC family permease [Treponema denticola]	diamond	336	179	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
32751496	32751496	PRJEB28062_P_NODE_53940_length_482_cov_3.286064_g51587_i0	PRJEB28062	53940	482	3.286064	15.83882848	Spirochaetota bacterium	2202144	Bacteria	Bacteria	125	8.989999999999998e-30	NR	MBN2401414.1	2202144	g51587	i0	45.9	4.49377593360996	146	79	90.9	0	18	455	495	640	MBN2401414.1 PAS domain S-box protein [Spirochaetota bacterium]	diamond	2166	125	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;