metadata: contig_metadata: 29 rows where bioproject = "PRJNA940501", tax_kingdom = "Pseudomonadati" and tax

29 rows where bioproject = "PRJNA940501", 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
920812	920812	PRJNA940501_S_NODE_353021_length_157_cov_1.236842_g352203_i0	PRJNA940501	353021	157	1.236842	1.94184194	Treponema rectale	744512	Bacteria	Bacteria	147	5.78e-31	NTclustered	gi\|1919550644\|gb\|CP031517.1\|	744512	g352203	i0	83.439	1	157	26	100	0	1	157	1269446	1269290	Treponema rectale strain CHPA chromosome, complete genome	blastn	157	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema rectale
6023440	6023440	PRJNA940501_S_NODE_292325_length_169_cov_1.119048_g291507_i0	PRJNA940501	292325	169	1.119048	1.89119112	Brachyspira pilosicoli	52584	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|404429427\|emb\|HE793032.1\|	1161918	g291507	i0	91.892	0.218934911242604	37	3	22	0	79	115	2815687	2815723	Brachyspira pilosicoli WesB complete genome	blastn	37	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
9846153	9846153	PRJNA940501_S_NODE_141388_length_215_cov_2.075581_g140570_i0	PRJNA940501	141388	215	2.075581	4.46249915	Treponema succinifaciens	167	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|328447254\|gb\|CP002631.1\|	869209	g140570	i0	98.14	2	215	4	100	0	1	215	1740372	1740586	Treponema succinifaciens DSM 2489, complete genome	blastn	430	375	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
9846506	9846506	PRJNA940501_S_NODE_162768_length_206_cov_1.595092_g161950_i0	PRJNA940501	162768	206	1.595092	3.28588952	Treponema bryantii	163	Bacteria	Bacteria	58.4	3.87e-4	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g161950	i0	100	0.150485436893204	31	0	15	0	82	112	2322952	2322982	Treponema bryantii JCM 32280 DNA, complete genome	blastn	31	58.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
16560136	16560136	PRJNA940501_S_NODE_204233_length_191_cov_25.108108_g203415_i0	PRJNA940501	204233	191	25.108108	47.95648628	Borrelia	138	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g203415	i0	100	0.293193717277487	28	0	15	0	40	67	11655	11682	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
16560405	16560405	PRJNA940501_S_NODE_260713_length_176_cov_1.413534_g259895_i0	PRJNA940501	260713	176	1.413534	2.48781984	Leptospira	171	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1464599676\|gb\|CP030142.1\|	1137606	g259895	i0	100	0.795454545454545	28	0	16	0	6	33	352889	352862	Leptospira mayottensis strain VS2413 chromosome I, complete sequence	blastn	140	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mayottensis
21660732	21660732	PRJNA940501_S_NODE_78077_length_254_cov_2.227488_g77259_i0	PRJNA940501	78077	254	2.227488	5.65781952	Treponema	157	Bacteria	Bacteria	429	9.119999999999999e-116	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g77259	i0	97.244	194.07874015748	254	6	100	1	1	254	2079449	2079701	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	49296	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22596875	22596875	PRJNA940501_S_NODE_261298_length_176_cov_1.330827_g260480_i0	PRJNA940501	261298	176	1.330827	2.34225552	Treponema peruense	2787628	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g260480	i0	100	0.159090909090909	28	0	16	0	63	90	265934	265907	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
22935570	22935570	PRJNA940501_S_NODE_233758_length_183_cov_1.342857_g232940_i0	PRJNA940501	233758	183	1.342857	2.45742831	Treponema	157	Bacteria	Bacteria	333	4.97e-87	NTclustered	gi\|3132611\|gb\|AF061347.1\|AF061347	76133	g232940	i0	99.454	104.098360655738	183	1	100	0	1	183	264	82	Treponema sp. I:Q:AT20 16S ribosomal RNA gene, complete sequence	blastn	19050	333	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:Q:AT20
26803570	26803570	PRJNA940501_S_NODE_264981_length_175_cov_1.424242_g264163_i0	PRJNA940501	264981	175	1.424242	2.4924235	Spirochaetia bacterium	2053615	Bacteria	Bacteria	117	4.06e-29	NR	MCI6316349.1	2053615	g264163	i0	100	0.977142857142857	57	0	97.7	0	3	173	397	453	MCI6316349.1 pallilysin-related adhesin [Spirochaetia bacterium]	diamond	171	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27341419	27341419	PRJNA940501_S_NODE_213583_length_189_cov_0.965753_g212765_i0	PRJNA940501	213583	189	0.965753	1.82527317	Leptospira borgpetersenii	174	Bacteria	Bacteria	45.1	0.00122	NR	WP_228029286.1	174	g212765	i0	43.2	0.698412698412698	44	25	69.8	0	187	56	99	142	WP_228029286.1 hypothetical protein, partial [Leptospira borgpetersenii]	diamond	132	45.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira borgpetersenii
27720677	27720677	PRJNA940501_S_NODE_211784_length_189_cov_1.931507_g210966_i0	PRJNA940501	211784	189	1.931507	3.65054823	Treponema vincentii	69710	Bacteria	Bacteria	45.1	0.00284	NR	WP_016519616.1	69710	g210966	i0	39.1	1.01587301587302	64	33	98.4	2	189	4	61	120	WP_016519616.1 lipopolysaccharide biosynthesis protein [Treponema vincentii]	diamond	192	45.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28004603	28004603	PRJNA940501_S_NODE_183505_length_198_cov_2.393548_g182687_i0	PRJNA940501	183505	198	2.393548	4.73922504	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	43.1	0.0151	NR	MCY4378190.1	1898206	g182687	i0	41.9	1.83333333333333	43	25	65.2	0	70	198	69	111	MCY4378190.1 Gfo/Idh/MocA family oxidoreductase [Spirochaetaceae bacterium]	diamond	363	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28193627	28193627	PRJNA940501_S_NODE_261546_length_176_cov_1.097744_g260728_i0	PRJNA940501	261546	176	1.097744	1.93202944	Treponema sp.	166	Bacteria	Bacteria	108	7.3e-26	NR	MBR0545917.1	166	g260728	i0	98.3	0.988636363636364	58	1	98.9	0	174	1	134	191	MBR0545917.1 heavy metal translocating P-type ATPase [Treponema sp.]	diamond	174	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28225137	28225137	PRJNA940501_S_NODE_148786_length_212_cov_1.390533_g147968_i0	PRJNA940501	148786	212	1.390533	2.94792996	Treponema sp.	166	Bacteria	Bacteria	92	7.379999999999999e-23	NR	WP_318695208.1	166	g147968	i0	94	0.707547169811321	50	3	70.8	0	1	150	4	53	WP_318695208.1 hypothetical protein [Treponema sp.]	diamond	150	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28320040	28320040	PRJNA940501_S_NODE_144666_length_214_cov_1.251462_g143848_i0	PRJNA940501	144666	214	1.251462	2.67812868	Treponema bryantii	163	Bacteria	Bacteria	73.2	4.09e-13	NR	WP_338368548.1	163	g143848	i0	53.5	0.995327102803738	71	33	99.5	0	214	2	168	238	WP_338368548.1 ankyrin repeat domain-containing protein [Treponema bryantii]	diamond	213	73.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
28572635	28572635	PRJNA940501_S_NODE_101527_length_237_cov_1.453608_g100709_i0	PRJNA940501	101527	237	1.453608	3.44505096	Spirochaetia bacterium	2053615	Bacteria	Bacteria	157	3.0199999999999996e-45	NR	MCI7036282.1	2053615	g100709	i0	100	1.9746835443038	78	0	98.7	0	3	236	26	103	MCI7036282.1 acetate kinase [Spirochaetia bacterium]	diamond	468	157	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28730643	28730643	PRJNA940501_S_NODE_62487_length_269_cov_2.269912_g61669_i0	PRJNA940501	62487	269	2.269912	6.10606328	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	42.7	0.0338	NR	MDR1096389.1	1898206	g61669	i0	36.4	0.613382899628253	55	31	58	2	84	239	107	160	MDR1096389.1 YkgJ family cysteine cluster protein [Spirochaetaceae bacterium]	diamond	165	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29109617	29109617	PRJNA940501_S_NODE_58108_length_274_cov_2.670996_g57290_i0	PRJNA940501	58108	274	2.670996	7.31852904	Rectinemataceae bacterium	3064674	Bacteria	Bacteria	43.1	0.0381	NR	HUX39726.1	3064674	g57290	i0	39.6	0.58029197080292	53	27	55.8	2	5	157	260	309	HUX39726.1 hypothetical protein [Rectinemataceae bacterium]	diamond	159	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Rectinemataceae		Rectinemataceae bacterium
29393697	29393697	PRJNA940501_S_NODE_204689_length_191_cov_2.452703_g203871_i0	PRJNA940501	204689	191	2.452703	4.68466273	Treponema sp.	166	Bacteria	Bacteria	130	1.46e-33	NR	MEE1167355.1	166	g203871	i0	100	0.989528795811518	63	0	99	0	190	2	166	228	MEE1167355.1 EAL domain-containing protein [Treponema sp.]	diamond	189	130	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29835623	29835623	PRJNA940501_S_NODE_357711_length_156_cov_1.451327_g356893_i0	PRJNA940501	357711	156	1.451327	2.26407012	Alkalispirochaeta sp.	2024959	Bacteria	Bacteria	41.6	0.0301	NR	MFO8043336.1	2024959	g356893	i0	36.4	0.846153846153846	44	26	80.8	1	135	10	190	233	MFO8043336.1 serine hydrolase domain-containing protein [Alkalispirochaeta sp.]	diamond	132	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Alkalispirochaeta	Alkalispirochaeta sp.
30025373	30025373	PRJNA940501_S_NODE_269171_length_174_cov_1.435115_g268353_i0	PRJNA940501	269171	174	1.435115	2.4971001	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	81.3	2.71e-16	NR	HMV45331.1	2026757	g268353	i0	65.5	2	58	20	100	0	174	1	45	102	HMV45331.1 SpoIID/LytB domain-containing protein [Leptospiraceae bacterium]	diamond	348	81.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30278325	30278325	PRJNA940501_S_NODE_185052_length_198_cov_1.212903_g184234_i0	PRJNA940501	185052	198	1.212903	2.40154794	Borreliella garinii	29519	Bacteria	Bacteria	43.9	0.00206	NR	WP_234932126.1	29519	g184234	i0	31.3	1.95454545454545	64	44	97	0	197	6	33	96	WP_234932126.1 hypothetical protein, partial [Borreliella garinii]	diamond	387	43.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
30530631	30530631	PRJNA940501_S_NODE_295933_length_168_cov_1.504000_g295115_i0	PRJNA940501	295933	168	1.504	2.52672	Leptospira sp. GIMC2	178	Bacteria	Bacteria	71.6	7.43e-13	NR	WP_272532568.1	1513297	g295115	i0	63.6	0.982142857142857	55	20	98.2	0	3	167	47	101	WP_272532568.1 tetraacyldisaccharide 4'-kinase [Leptospira sp. GIMC2001]	diamond	165	71.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. GIMC2001
30758814	30758814	PRJNA940501_S_NODE_188694_length_197_cov_0.915584_g187876_i0	PRJNA940501	188694	197	0.915584	1.80370048	Treponema	157	Bacteria	Bacteria	123	4.44e-33	NR	MCR4900662.1	166	g187876	i0	92.3	10.8883248730964	65	5	99	0	2	196	147	211	MCR4900662.1 AAA family ATPase [Treponema sp.]	diamond	2145	124	0.991935483870968	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31169274	31169274	PRJNA940501_S_NODE_373475_length_153_cov_1.709091_g372657_i0	PRJNA940501	373475	153	1.709091	2.61490923	root	1	Root_unresolved	Root_unresolved	112	8.39e-29	NR	MBQ1629163.1	166	g372657	i0	100	6	51	0	100	0	1	153	174	224	MBQ1629163.1 winged helix DNA-binding domain-containing protein [Treponema sp.]	diamond	918	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31636978	31636978	PRJNA940501_S_NODE_312316_length_165_cov_1.155738_g311498_i0	PRJNA940501	312316	165	1.155738	1.9069677	Spirochaetia bacterium	2053615	Bacteria	Bacteria	59.7	1.31e-8	NR	NBU99293.1	2053615	g311498	i0	56.6	0.963636363636364	53	23	96.4	0	163	5	345	397	NBU99293.1 hypothetical protein [Spirochaetia bacterium]	diamond	159	59.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32079890	32079890	PRJNA940501_S_NODE_353938_length_157_cov_1.236842_g353120_i0	PRJNA940501	353938	157	1.236842	1.94184194	Treponema sp.	166	Bacteria	Bacteria	102	6.92e-24	NR	MBQ5907057.1	166	g353120	i0	94.1	0.974522292993631	51	3	97.5	0	155	3	208	258	MBQ5907057.1 hypothetical protein [Treponema sp.]	diamond	153	102	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32743681	32743681	PRJNA940501_S_NODE_390800_length_151_cov_0.870370_g389982_i0	PRJNA940501	390800	151	0.87037	1.3142587	Spirochaetia bacterium	2053615	Bacteria	Bacteria	106	9.31e-26	NR	MCI7440436.1	2053615	g389982	i0	98	0.993377483443709	50	1	99.3	0	150	1	130	179	MCI7440436.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetia bacterium]	diamond	150	106	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia 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);;