metadata: contig_metadata: 43 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax

43 rows where analysis = "diamond", bioproject = "PRJNA900028" 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
1244832	1244832	PRJNA900028_P_NODE_157201_length_164_cov_0.886957_g156452_i0	PRJNA900028	157201	164	0.886957	1.45460948	Spirochaetales bacterium	2026792	Bacteria	Bacteria	93.6	1.56e-20	NR	MDA3832159.1	2026792	g156452	i0	81.5	2.92682926829268	54	10	98.8	0	162	1	139	192	MDA3832159.1 asparagine synthase (glutamine-hydrolyzing) [Spirochaetales bacterium]	diamond	480	93.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
16178736	16178736	PRJNA900028_P_NODE_84413_length_183_cov_1.231343_g83664_i0	PRJNA900028	84413	183	1.231343	2.25335769	Treponema socranskii	53419	Bacteria	Bacteria	122	6.109999999999999e-31	NR	WP_021329476.1	53419	g83664	i0	98.4	2	61	1	100	0	183	1	398	458	WP_021329476.1 sugar ABC transporter ATP-binding protein [Treponema socranskii]	diamond	366	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
17822394	17822394	PRJNA900028_P_NODE_159434_length_164_cov_0.886957_g158685_i0	PRJNA900028	159434	164	0.886957	1.45460948	Treponema medium	58231	Bacteria	Bacteria	91.7	7.06e-20	NR	WP_206181641.1	58231	g158685	i0	84.9	1.9390243902439	53	8	97	0	3	161	204	256	WP_206181641.1 ATP-binding protein [Treponema medium]	diamond	318	91.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
26644100	26644100	PRJNA900028_P_NODE_180861_length_162_cov_0.902655_g180112_i0	PRJNA900028	180861	162	0.902655	1.4623011	Treponema sp.	166	Bacteria	Bacteria	99.8	9.8e-23	NR	MFC2603888.1	166	g180112	i0	100	1.96296296296296	53	0	98.1	0	161	3	317	369	MFC2603888.1 SpoIIE family protein phosphatase [Treponema sp.]	diamond	318	99.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
26960703	26960703	PRJNA900028_P_NODE_193462_length_161_cov_0.910714_g192713_i0	PRJNA900028	193462	161	0.910714	1.46624954	Treponema sp. OMZ 789	2563670	Bacteria	Bacteria	69.3	5.11e-12	NR	UTC68434.1	2563670	g192713	i0	66	0.987577639751553	53	18	98.8	0	160	2	292	344	UTC68434.1 HAMP domain-containing protein [Treponema sp. OMZ 789]	diamond	159	69.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 789
27213611	27213611	PRJNA900028_P_NODE_129442_length_166_cov_1.735043_g128693_i0	PRJNA900028	129442	166	1.735043	2.88017138	Treponema vincentii	69710	Bacteria	Bacteria	108	8.59e-26	NR	WP_253818592.1	69710	g128693	i0	89.1	0.993975903614458	55	6	99.4	0	1	165	496	550	WP_253818592.1 4-alpha-glucanotransferase [Treponema vincentii]	diamond	165	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27284689	27284689	PRJNA900028_P_NODE_77243_length_186_cov_1.489051_g76494_i0	PRJNA900028	77243	186	1.489051	2.76963486	Treponema	157	Bacteria	Bacteria	50.4	3.21e-5	NR	WP_016522627.1	58231	g76494	i0	58.5	1.70967741935484	53	19	83.9	2	157	2	207	257	WP_016522627.1 zinc ribbon domain-containing protein [Treponema medium]	diamond	318	50.8	0.992125984251969	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
27348098	27348098	PRJNA900028_P_NODE_179043_length_162_cov_0.902655_g178294_i0	PRJNA900028	179043	162	0.902655	1.4623011	Candidatus Gallitreponema	2840652	Bacteria	Bacteria	78.6	2.98e-15	NR	MBE6350791.1	1898206	g178294	i0	67.9	2.94444444444444	53	17	98.1	0	4	162	405	457	MBE6350791.1 ATPase [Spirochaetaceae bacterium]	diamond	477	78.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
27372167	27372167	PRJNA900028_P_NODE_125863_length_167_cov_0.864407_g125114_i0	PRJNA900028	125863	167	0.864407	1.44355969	Treponema	157	Bacteria	Bacteria	67.4	2.53e-11	NR	WP_002676219.1	157	g125114	i0	58.9	1.0059880239521	56	22	98.8	1	3	167	212	267	WP_002676219.1 MULTISPECIES: FGGY-family carbohydrate kinase [Treponema]	diamond	168	67.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
27624619	27624619	PRJNA900028_P_NODE_178104_length_162_cov_0.902655_g177355_i0	PRJNA900028	178104	162	0.902655	1.4623011	Treponema lecithinolyticum	53418	Bacteria	Bacteria	99.8	9.46e-23	NR	WP_021687821.1	53418	g177355	i0	96.2	0.981481481481482	53	2	98.1	0	3	161	45	97	WP_021687821.1 apolipoprotein N-acyltransferase [Treponema lecithinolyticum]	diamond	159	99.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema lecithinolyticum
28003546	28003546	PRJNA900028_P_NODE_134725_length_166_cov_0.871795_g133976_i0	PRJNA900028	134725	166	0.871795	1.4471797	Treponema vincentii	69710	Bacteria	Bacteria	87.4	2.76e-19	NR	WP_253818270.1	69710	g133976	i0	72.7	0.993975903614458	55	15	99.4	0	2	166	15	69	WP_253818270.1 tetratricopeptide repeat protein [Treponema vincentii]	diamond	165	87.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28011221	28011221	PRJNA900028_P_NODE_166245_length_163_cov_0.894737_g165496_i0	PRJNA900028	166245	163	0.894737	1.45842131	Treponema	157	Bacteria	Bacteria	98.2	4.09e-24	NR	WP_230977751.1	69710	g165496	i0	83.3	1.98773006134969	54	9	99.4	0	1	162	48	101	WP_230977751.1 hypothetical protein [Treponema vincentii]	diamond	324	98.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28066445	28066445	PRJNA900028_P_NODE_117345_length_167_cov_1.728814_g116596_i0	PRJNA900028	117345	167	1.728814	2.88711938	Treponema phagedenis	162	Bacteria	Bacteria	67	3.61e-11	NR	WP_024752088.1	162	g116596	i0	62.5	1.72455089820359	48	18	86.2	0	165	22	429	476	WP_024752088.1 carbon starvation protein A [Treponema phagedenis]	diamond	288	67	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
28192548	28192548	PRJNA900028_P_NODE_124486_length_167_cov_0.864407_g123737_i0	PRJNA900028	124486	167	0.864407	1.44355969	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	94.4	6.160000000000001e-22	NR	MFA6733422.1	1972642	g123737	i0	90.9	0.988023952095808	55	5	98.8	0	167	3	141	195	MFA6733422.1 hypothetical protein [Sphaerochaeta sp.]	diamond	165	94.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
28571615	28571615	PRJNA900028_P_NODE_181927_length_162_cov_0.902655_g181178_i0	PRJNA900028	181927	162	0.902655	1.4623011	Spirochaetia bacterium	2053615	Bacteria	Bacteria	49.7	3.79e-5	NR	GHU44176.1	2053615	g181178	i0	52.2	2.74074074074074	46	22	85.2	0	151	14	42	87	GHU44176.1 hypothetical protein FACS1894190_15330 [Spirochaetia bacterium]	diamond	444	49.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28603352	28603352	PRJNA900028_P_NODE_186507_length_161_cov_3.151786_g185758_i0	PRJNA900028	186507	161	3.151786	5.07437546	Treponema vincentii	69710	Bacteria	Bacteria	50.8	1.7e-5	NR	WP_038076631.1	69710	g185758	i0	100	0.46583850931677	25	0	46.6	0	161	87	1026	1050	WP_038076631.1 tetratricopeptide repeat protein [Treponema vincentii]	diamond	75	50.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28674081	28674081	PRJNA900028_P_NODE_132767_length_166_cov_0.871795_g132018_i0	PRJNA900028	132767	166	0.871795	1.4471797	Treponema	157	Bacteria	Bacteria	67.4	2.54e-11	NR	PIE99050.1	166	g132018	i0	50	3.90361445783133	54	27	97.6	0	164	3	122	175	PIE99050.1 MAG: flagellar hook protein FliD [Treponema sp.]	diamond	648	67.8	0.994100294985251	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28887293	28887293	PRJNA900028_P_NODE_172168_length_163_cov_0.894737_g171419_i0	PRJNA900028	172168	163	0.894737	1.45842131	Treponema sp.	166	Bacteria	Bacteria	103	4.059999999999999e-24	NR	MCR5400772.1	166	g171419	i0	81.5	3.97546012269939	54	10	99.4	0	1	162	17	70	MCR5400772.1 MBL fold metallo-hydrolase [Treponema sp.]	diamond	648	103	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28918789	28918789	PRJNA900028_P_NODE_156568_length_164_cov_0.886957_g155819_i0	PRJNA900028	156568	164	0.886957	1.45460948	Treponema pedis	409322	Bacteria	Bacteria	67	2.24e-11	NR	WP_024469247.1	409322	g155819	i0	64.6	0.878048780487805	48	17	87.8	0	164	21	152	199	WP_024469247.1 peptide ABC transporter ATPase [Treponema pedis]	diamond	144	67	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
29108556	29108556	PRJNA900028_P_NODE_161148_length_164_cov_0.886957_g160399_i0	PRJNA900028	161148	164	0.886957	1.45460948	Treponema maltophilum	51160	Bacteria	Bacteria	105	6.08e-26	NR	WP_016524440.1	51160	g160399	i0	98.1	0.969512195121951	53	1	97	0	161	3	83	135	WP_016524440.1 TrmH family RNA methyltransferase [Treponema maltophilum]	diamond	159	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
29203364	29203364	PRJNA900028_P_NODE_181829_length_162_cov_0.902655_g181080_i0	PRJNA900028	181829	162	0.902655	1.4623011	Treponema sp.	166	Bacteria	Bacteria	58.9	2.21e-8	NR	MBR1405042.1	166	g181080	i0	50.9	0.981481481481482	53	26	98.1	0	3	161	172	224	MBR1405042.1 acyltransferase family protein [Treponema sp.]	diamond	159	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29266105	29266105	PRJNA900028_P_NODE_113269_length_169_cov_1.700000_g112520_i0	PRJNA900028	113269	169	1.7	2.873	Treponema sp. OMZ 799	2563668	Bacteria	Bacteria	104	1.9e-26	NR	WP_253709755.1	2563668	g112520	i0	91.1	0.994082840236686	56	5	99.4	0	168	1	29	84	WP_253709755.1 MptD family putative ECF transporter S component [Treponema sp. OMZ 799]	diamond	168	104	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 799
29305443	29305443	PRJNA900028_P_NODE_76809_length_186_cov_1.489051_g76060_i0	PRJNA900028	76809	186	1.489051	2.76963486	FCB group	1783270	Bacteria	Bacteria	85.1	2.62e-19	NR	MCL2721606.1	166	g76060	i0	65.6	12.8225806451613	61	21	98.4	0	184	2	3	63	MCL2721606.1 hypothetical protein [Treponema sp.]	diamond	2385	85.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29361107	29361107	PRJNA900028_P_NODE_75129_length_187_cov_1.442029_g74380_i0	PRJNA900028	75129	187	1.442029	2.69659423	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	53.9	1.98e-6	NR	MBQ3024183.1	1898206	g74380	i0	52.2	0.737967914438503	46	22	73.8	0	1	138	186	231	MBQ3024183.1 ankyrin repeat domain-containing protein [Spirochaetaceae bacterium]	diamond	138	53.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29423955	29423955	PRJNA900028_P_NODE_136009_length_166_cov_0.871795_g135260_i0	PRJNA900028	136009	166	0.871795	1.4471797	Leptospira licerasiae	447106	Bacteria	Bacteria	110	1.3500000000000002e-26	NR	WP_008589896.1	447106	g135260	i0	98.1	0.975903614457831	54	1	97.6	0	5	166	26	79	WP_008589896.1 sensor histidine kinase [Leptospira licerasiae]	diamond	162	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira licerasiae
29771311	29771311	PRJNA900028_P_NODE_109471_length_171_cov_1.672131_g108722_i0	PRJNA900028	109471	171	1.672131	2.85934401	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	89.7	1.43e-19	NR	WP_044014048.1	1539298	g108722	i0	66.1	0.982456140350877	56	19	98.2	0	169	2	111	166	WP_044014048.1 RnfABCDGE type electron transport complex subunit D [Treponema sp. OMZ 838]	diamond	168	89.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
30094863	30094863	PRJNA900028_P_NODE_166332_length_163_cov_0.894737_g165583_i0	PRJNA900028	166332	163	0.894737	1.45842131	Treponema	157	Bacteria	Bacteria	107	7.32e-26	NR	WP_016518312.1	69710	g165583	i0	90.7	2.98159509202454	54	5	99.4	0	163	2	328	381	WP_016518312.1 ABC transporter substrate-binding protein [Treponema vincentii]	diamond	486	107	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
30150343	30150343	PRJNA900028_P_NODE_196212_length_161_cov_0.910714_g195463_i0	PRJNA900028	196212	161	0.910714	1.46624954	Treponema sp.	166	Bacteria	Bacteria	96.3	2.67e-22	NR	MFC2603709.1	166	g195463	i0	100	1.90062111801242	51	0	95	0	155	3	1	51	MFC2603709.1 FAD-dependent oxidoreductase [Treponema sp.]	diamond	306	96.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30372130	30372130	PRJNA900028_P_NODE_124032_length_167_cov_0.864407_g123283_i0	PRJNA900028	124032	167	0.864407	1.44355969	Treponema sp.	166	Bacteria	Bacteria	105	5.56e-28	NR	WP_318691445.1	166	g123283	i0	90.9	0.988023952095808	55	5	98.8	0	167	3	47	101	WP_318691445.1 hypothetical protein [Treponema sp.]	diamond	165	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30466817	30466817	PRJNA900028_P_NODE_138233_length_166_cov_0.871795_g137484_i0	PRJNA900028	138233	166	0.871795	1.4471797	uncultured spirochete	156406	Bacteria	Bacteria	75.9	6.92e-15	NR	SLM17633.1	156406	g137484	i0	75.5	0.957831325301205	53	13	95.8	0	3	161	193	245	SLM17633.1 Uncharacterized membrane protein jhp_1251 [uncultured spirochete]	diamond	159	75.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			uncultured spirochete
31232274	31232274	PRJNA900028_P_NODE_70335_length_189_cov_1.457143_g69586_i0	PRJNA900028	70335	189	1.457143	2.75400027	Treponema	157	Bacteria	Bacteria	123	9.13e-31	NR	WP_147623961.1	158	g69586	i0	93.5	1.98412698412698	62	4	98.4	0	4	189	596	657	WP_147623961.1 hypothetical protein [Treponema denticola]	diamond	375	123	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
31256421	31256421	PRJNA900028_P_NODE_115655_length_168_cov_1.714286_g114906_i0	PRJNA900028	115655	168	1.714286	2.88000048	Treponema medium	58231	Bacteria	Bacteria	99.4	1.7e-24	NR	WP_016523824.1	58231	g114906	i0	92.7	0.982142857142857	55	4	98.2	0	3	167	94	148	WP_016523824.1 ribosome recycling factor [Treponema medium]	diamond	165	99.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
31383142	31383142	PRJNA900028_P_NODE_90076_length_180_cov_1.557252_g89327_i0	PRJNA900028	90076	180	1.557252	2.8030536	Spirochaetia bacterium	2053615	Bacteria	Bacteria	83.2	5.99e-17	NR	MFP4382712.1	2053615	g89327	i0	57.9	1.8	57	24	95	0	179	9	139	195	MFP4382712.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Spirochaetia bacterium]	diamond	324	83.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31414660	31414660	PRJNA900028_P_NODE_81876_length_184_cov_1.444444_g81127_i0	PRJNA900028	81876	184	1.444444	2.65777696	Treponema	157	Bacteria	Bacteria	95.9	2.5e-21	NR	WP_212565151.1	157	g81127	i0	79.7	0.96195652173913	59	12	96.2	0	3	179	231	289	WP_212565151.1 MULTISPECIES: 6-hydroxymethylpterin diphosphokinase MptE-like protein [Treponema]	diamond	177	95.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
31889005	31889005	PRJNA900028_P_NODE_95057_length_178_cov_1.395349_g94308_i0	PRJNA900028	95057	178	1.395349	2.48372122	Treponema maltophilum	51160	Bacteria	Bacteria	115	3.4600000000000003e-29	NR	WP_016525778.1	51160	g94308	i0	98.3	0.99438202247191	59	1	99.4	0	177	1	93	151	WP_016525778.1 protease modulator HflC [Treponema maltophilum]	diamond	177	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
31983859	31983859	PRJNA900028_P_NODE_107158_length_172_cov_1.658537_g106409_i0	PRJNA900028	107158	172	1.658537	2.85268364	Treponema sp.	166	Bacteria	Bacteria	77	1.13e-14	NR	MDR3173226.1	166	g106409	i0	69.6	2.93023255813953	56	17	97.7	0	3	170	275	330	MDR3173226.1 pyruvate, phosphate dikinase [Treponema sp.]	diamond	504	77	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32181604	32181604	PRJNA900028_P_NODE_94598_length_178_cov_1.581395_g93849_i0	PRJNA900028	94598	178	1.581395	2.8148831	Treponema	157	Bacteria	Bacteria	119	1.1e-29	NR	MBQ7753353.1	166	g93849	i0	98.3	18.876404494382	59	1	99.4	0	178	2	274	332	MBQ7753353.1 alanine--tRNA ligase [Treponema sp.]	diamond	3360	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32522165	32522165	PRJNA900028_P_NODE_136999_length_166_cov_0.871795_g136250_i0	PRJNA900028	136999	166	0.871795	1.4471797	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	90.5	1.85e-19	NR	MCB1177415.1	2026757	g136250	i0	80	0.993975903614458	55	11	99.4	0	165	1	150	204	MCB1177415.1 NACHT domain-containing protein [Leptospiraceae bacterium]	diamond	165	90.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32522170	32522170	PRJNA900028_P_NODE_149559_length_165_cov_0.879310_g148810_i0	PRJNA900028	149559	165	0.87931	1.4508615	Spirochaetota bacterium	2202144	Bacteria	Bacteria	60.5	7.03e-9	NR	HOG65006.1	2202144	g148810	i0	49.1	1.92727272727273	53	27	96.4	0	3	161	174	226	HOG65006.1 PAS domain S-box protein [Spirochaetota bacterium]	diamond	318	60.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32553824	32553824	PRJNA900028_P_NODE_170099_length_163_cov_0.894737_g169350_i0	PRJNA900028	170099	163	0.894737	1.45842131	Brachyspira hyodysenteriae	159	Bacteria	Bacteria	54.7	6.9e-7	NR	WP_269985515.1	159	g169350	i0	77.8	1.52760736196319	27	6	49.7	0	82	2	1	27	WP_269985515.1 type II restriction endonuclease [Brachyspira hyodysenteriae]	diamond	249	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
32585266	32585266	PRJNA900028_P_NODE_171519_length_163_cov_0.894737_g170770_i0	PRJNA900028	171519	163	0.894737	1.45842131	Treponema vincentii	69710	Bacteria	Bacteria	70.5	1.27e-12	NR	WP_253807826.1	69710	g170770	i0	90.2	1.50920245398773	41	4	75.5	0	3	125	43	83	WP_253807826.1 DEAD/DEAH box helicase family protein [Treponema vincentii]	diamond	246	70.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
32624079	32624079	PRJNA900028_P_NODE_93720_length_179_cov_1.038462_g92971_i0	PRJNA900028	93720	179	1.038462	1.85884698	Bacteria	2	Bacteria	Bacteria	58.5	4.21e-8	NR	OQA99607.1	1852906	g92971	i0	55.1	1.64245810055866	49	22	82.1	0	32	178	913	961	OQA99607.1 MAG: Blue-light-activated protein [Spirochaetes bacterium ADurb.Bin218]	diamond	294	58.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium ADurb.Bin218
32868378	32868378	PRJNA900028_P_NODE_142620_length_165_cov_0.879310_g141871_i0	PRJNA900028	142620	165	0.87931	1.4508615	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	70.1	2.86e-12	NR	WP_044016522.1	1539298	g141871	i0	71.2	0.945454545454545	52	14	94.5	1	2	157	762	812	WP_044016522.1 ATP-dependent Clp protease ATP-binding subunit [Treponema sp. OMZ 838]	diamond	156	70.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838

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