metadata: contig_metadata: 31 rows where bioproject = "PRJNA1144090" and tax

31 rows where bioproject = "PRJNA1144090" 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
1561842	1561842	PRJNA1144090_P_NODE_34202_length_445_cov_4.540323_g33667_i0	PRJNA1144090	34202	445	4.540323	20.20443735	Thiospirochaeta perfilievii	252967	Bacteria	Bacteria	219	4.01e-52	NTclustered	gi\|1735508175\|gb\|CP035807.1\|	252967	g33667	i0	78.723	62.038202247191	329	68	74	2	118	445	580066	579739	Thiospirochaeta perfilievii strain P chromosome, complete genome	blastn	27607	219	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Thiospirochaeta	Thiospirochaeta perfilievii
5390654	5390654	PRJNA1144090_P_NODE_56225_length_339_cov_1.466165_g55690_i0	PRJNA1144090	56225	339	1.466165	4.97029935	Entomospira entomophila	2719988	Bacteria	Bacteria	65.8	4.11e-6	NTclustered	gi\|2446642546\|gb\|CP118174.1\|	2719988	g55690	i0	95.122	0.12094395280236	41	2	12	0	35	75	107783	107743	Entomospira entomophila strain BR193 chromosome	blastn	41	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Entomospira	Entomospira entomophila
12511763	12511763	PRJNA1144090_P_NODE_96510_length_255_cov_1.203297_g95975_i0	PRJNA1144090	96510	255	1.203297	3.06840735	Borreliella	64895	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2561334454\|gb\|CP116883.1\|	62088	g95975	i0	100	0.43921568627451	28	0	11	0	167	194	13953	13980	Borreliella valaisiana strain 89B13 plasmid p_lp36, complete sequence	blastn	112	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella valaisiana
15590312	15590312	PRJNA1144090_P_NODE_53633_length_347_cov_4.675182_g53098_i0	PRJNA1144090	53633	347	4.675182	16.22288154	Spirochaetia bacterium	2053615	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2621700913\|emb\|OY759747.1\|	2053615	g53098	i0	100	0.0806916426512968	28	0	8	0	79	106	2846437	2846410	MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
20689405	20689405	PRJNA1144090_P_NODE_98717_length_251_cov_2.280899_g98182_i0	PRJNA1144090	98717	251	2.280899	5.72505649	Brachyspira intermedia	84377	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g98182	i0	100	0.111553784860558	28	0	11	0	218	245	1324487	1324514	Brachyspira intermedia PWS/A, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
26964427	26964427	PRJNA1144090_P_NODE_119782_length_229_cov_2.948718_g119247_i0	PRJNA1144090	119782	229	2.948718	6.75256422	root	1	Root_unresolved	Root_unresolved	102	5.63e-24	NR	WP_002772915.1	183	g119247	i0	60.8	4.87336244541485	74	29	96.9	0	225	4	248	321	WP_002772915.1 SAM-dependent methyltransferase [Leptonema illini]	diamond	1116	102	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptonema	Leptonema illini
27607751	27607751	PRJNA1144090_P_NODE_83224_length_276_cov_1.517241_g82689_i0	PRJNA1144090	83224	276	1.517241	4.18758516	Spirochaetota bacterium	2202144	Bacteria	Bacteria	120	5.489999999999999e-31	NR	TXH10724.1	2202144	g82689	i0	63	1	92	34	100	0	1	276	95	186	TXH10724.1 MAG: hypothetical protein E6R04_04500 [Spirochaetota bacterium]	diamond	276	120	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28259409	28259409	PRJNA1144090_P_NODE_16586_length_677_cov_2.299669_g16072_i0	PRJNA1144090	16586	677	2.299669	15.56875913	Leptospira	171	Bacteria	Bacteria	213	1.91e-63	NR	WP_016551333.1	48782	g16072	i0	45.9	7.68833087149188	218	112	95.3	3	677	33	187	401	WP_016551333.1 zinc metallochaperone GTPase ZigA [Leptospira fainei]	diamond	5205	213	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira fainei
28701756	28701756	PRJNA1144090_P_NODE_94047_length_258_cov_2.162162_g93512_i0	PRJNA1144090	94047	258	2.162162	5.57837796	Pseudomonadati	3379134	Bacteria	Bacteria	43.1	0.031	NR	WP_135766052.1	2484901	g93512	i0	43.1	1.34883720930233	58	23	67.4	2	178	5	204	251	WP_135766052.1 catalase family protein [Leptospira ilyithenensis]	diamond	348	43.5	0.990804597701149	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ilyithenensis
29028750	29028750	PRJNA1144090_P_NODE_76428_length_289_cov_1.138889_g75893_i0	PRJNA1144090	76428	289	1.138889	3.29138921	Treponema sp. OMZ 9	166	Bacteria	Bacteria	44.7	0.0119	NR	WP_253824213.1	2563662	g75893	i0	32.4	0.737024221453287	71	47	73.7	1	28	240	115	184	WP_253824213.1 hypothetical protein [Treponema sp. OMZ 906]	diamond	213	44.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
29060123	29060123	PRJNA1144090_P_NODE_8728_length_958_cov_10.538983_g8341_i0	PRJNA1144090	8728	958	10.538983	100.96345714	Brachyspira alvinipulli	84379	Bacteria	Bacteria	47	0.0289	NR	WP_028330714.1	84379	g8341	i0	31.1	0.651356993736952	119	78	37.3	2	376	732	52	166	WP_028330714.1 ATP synthase F1 subunit delta [Brachyspira alvinipulli]	diamond	624	47	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira alvinipulli
29155022	29155022	PRJNA1144090_P_NODE_86509_length_270_cov_2.345178_g85974_i0	PRJNA1144090	86509	270	2.345178	6.3319806	Brucepastera parasyntrophica	2880008	Bacteria	Bacteria	100	2.52e-22	NR	WP_255947135.1	2880008	g85974	i0	57.3	0.988888888888889	89	38	98.9	0	269	3	427	515	WP_255947135.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Brucepastera parasyntrophica]	diamond	267	100	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Brucepastera	Brucepastera parasyntrophica
29207037	29207037	PRJNA1144090_P_NODE_41269_length_401_cov_1.914634_g40734_i0	PRJNA1144090	41269	401	1.914634	7.67768234	Brachyspira	29521	Bacteria	Bacteria	55.5	7.56e-6	NR	WP_144106202.1	159	g40734	i0	39.2	10.6384039900249	79	44	56.1	2	29	253	446	524	WP_144106202.1 ankyrin repeat domain-containing protein [Brachyspira hyodysenteriae]	diamond	4266	55.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
29585405	29585405	PRJNA1144090_P_NODE_74650_length_292_cov_2.392694_g74115_i0	PRJNA1144090	74650	292	2.392694	6.98666648	root	1	Root_unresolved	Root_unresolved	62.8	4.47e-9	NR	TVR91436.1	1898206	g74115	i0	40	2.77397260273973	100	45	90.4	4	287	24	106	202	TVR91436.1 MAG: glycerophosphodiester phosphodiesterase [Spirochaetaceae bacterium]	diamond	810	62.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30217356	30217356	PRJNA1144090_P_NODE_71772_length_298_cov_2.311111_g71237_i0	PRJNA1144090	71772	298	2.311111	6.88711078	Bacteria	2	Bacteria	Bacteria	104	1.05e-25	NR	KPJ85360.1	1704237	g71237	i0	63.2	5.21476510067114	87	30	87.6	1	290	30	85	169	KPJ85360.1 MAG: dihydroxyacetone kinase [Spirochaetes bacterium DG_61]	diamond	1554	104	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium DG_61
30281039	30281039	PRJNA1144090_P_NODE_111152_length_244_cov_0.900585_g110617_i0	PRJNA1144090	111152	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	54.3	1.1e-6	NR	MDH5655743.1	2053615	g110617	i0	39.4	3.31967213114754	71	42	87.3	1	6	218	13	82	MDH5655743.1 ankyrin repeat domain-containing protein [Spirochaetia bacterium]	diamond	810	54.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30512813	30512813	PRJNA1144090_P_NODE_79913_length_282_cov_1.473684_g79378_i0	PRJNA1144090	79913	282	1.473684	4.15578888	Spirochaetales bacterium	2026792	Bacteria	Bacteria	107	4.83e-26	NR	MBR1919224.1	2026792	g79378	i0	58.7	4.90425531914894	92	35	97.9	1	280	5	104	192	MBR1919224.1 serine--tRNA ligase [Spirochaetales bacterium]	diamond	1383	107	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
30607514	30607514	PRJNA1144090_P_NODE_83613_length_275_cov_2.178218_g83078_i0	PRJNA1144090	83613	275	2.178218	5.9900995	Spirochaetota bacterium	2202144	Bacteria	Bacteria	56.2	8.99e-7	NR	MDH4128744.1	2202144	g83078	i0	38.9	1.96363636363636	90	49	98.2	2	272	3	45	128	MDH4128744.1 hypothetical protein [Spirochaetota bacterium]	diamond	540	56.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30786143	30786143	PRJNA1144090_P_NODE_43854_length_388_cov_1.577778_g43319_i0	PRJNA1144090	43854	388	1.577778	6.12177864	Bacteria	2	Bacteria	Bacteria	107	1.64e-26	NR	WP_028974787.1	504483	g43319	i0	43.4	2.81443298969072	122	68	94.3	1	368	3	42	162	WP_028974787.1 glutathione peroxidase [Spirochaeta cellobiosiphila]	diamond	1092	107	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta cellobiosiphila
30828728	30828728	PRJNA1144090_P_NODE_31374_length_469_cov_3.250000_g30839_i0	PRJNA1144090	31374	469	3.25	15.2425	Treponema sp.	166	Bacteria	Bacteria	45.4	0.0356	NR	MDR0456879.1	166	g30839	i0	32.8	0.780383795309168	122	67	69.7	6	127	453	63	182	MDR0456879.1 glycosyltransferase family 2 protein [Treponema sp.]	diamond	366	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31081686	31081686	PRJNA1144090_P_NODE_94955_length_257_cov_1.668478_g94420_i0	PRJNA1144090	94955	257	1.668478	4.28798846	Spirochaetota bacterium	2202144	Bacteria	Bacteria	53.5	5.22e-6	NR	HPO49233.1	2202144	g94420	i0	44.2	0.607003891050584	52	29	60.7	0	156	1	39	90	HPO49233.1 hypothetical protein [Spirochaetota bacterium]	diamond	156	53.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31133438	31133438	PRJNA1144090_P_NODE_116775_length_241_cov_0.916667_g116240_i0	PRJNA1144090	116775	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	55.1	8.18e-7	NR	MCB1157371.1	2026757	g116240	i0	66.7	5.76348547717842	36	12	44.8	0	134	241	2	37	MCB1157371.1 histidine phosphatase family protein [Leptospiraceae bacterium]	diamond	1389	55.5	0.992792792792793	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31429290	31429290	PRJNA1144090_P_NODE_72476_length_297_cov_1.375000_g71941_i0	PRJNA1144090	72476	297	1.375	4.08375	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	43.1	0.0473	NR	MCB1140760.1	2026757	g71941	i0	31.4	0.707070707070707	70	48	70.7	0	236	27	42	111	MCB1140760.1 ankyrin repeat domain-containing protein [Leptospiraceae bacterium]	diamond	210	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31619060	31619060	PRJNA1144090_P_NODE_336_length_3225_cov_10.199556_g294_i0	PRJNA1144090	336	3225	10.199556	328.935681	Thermospira aquatica	2828656	Bacteria	Bacteria	72.4	3.34e-9	NR	WP_271434675.1	2828656	g294	i0	58.8	0.0632558139534884	68	27	6.3	1	466	263	1	67	WP_271434675.1 molecular chaperone DnaJ [Thermospira aquatica]	diamond	204	72.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Thermospiraceae	Thermospira	Thermospira aquatica
31840317	31840317	PRJNA1144090_P_NODE_13297_length_767_cov_4.775216_g12832_i0	PRJNA1144090	13297	767	4.775216	36.62590672	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	244	1.05e-77	NR	MBK8397234.1	2026757	g12832	i0	55.7	0.856584093872229	219	91	84.5	4	116	763	3	218	MBK8397234.1 DUF4334 domain-containing protein [Leptospiraceae bacterium]	diamond	657	244	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31840358	31840358	PRJNA1144090_P_NODE_50637_length_358_cov_3.073684_g50102_i0	PRJNA1144090	50637	358	3.073684	11.00378872	Spirochaeta cellobiosiphila	504483	Bacteria	Bacteria	91.7	2.78e-19	NR	WP_028975075.1	504483	g50102	i0	49	2.31284916201117	96	48	79.6	1	69	353	2	97	WP_028975075.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaeta cellobiosiphila]	diamond	828	91.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta cellobiosiphila
31840381	31840381	PRJNA1144090_P_NODE_67717_length_308_cov_1.038298_g67182_i0	PRJNA1144090	67717	308	1.038298	3.19795784	Spirochaetota bacterium	2202144	Bacteria	Bacteria	126	3.09e-34	NR	MBN8216262.1	2202144	g67182	i0	61.8	1.94805194805195	102	39	99.4	0	308	3	54	155	MBN8216262.1 acyltransferase [Spirochaetota bacterium]	diamond	600	126	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32050936	32050936	PRJNA1144090_P_NODE_110358_length_244_cov_1.771930_g109823_i0	PRJNA1144090	110358	244	1.77193	4.3235092	Pseudomonadati	3379134	Bacteria	Bacteria	64.7	6.75e-10	NR	MFN3605423.1	2046886	g109823	i0	48	4.45081967213115	75	37	92.2	1	239	15	843	915	MFN3605423.1 ATP-binding protein [Leptonema sp. (in: bacteria)]	diamond	1086	64.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptonema	Leptonema sp. (in: bacteria)
32050946	32050946	PRJNA1144090_P_NODE_37358_length_424_cov_2.028490_g36823_i0	PRJNA1144090	37358	424	2.02849	8.6007976	Pseudomonadati	3379134	Bacteria	Bacteria	47.4	0.00549	NR	MBR0033136.1	166	g36823	i0	38.4	1.9811320754717	73	40	50.9	2	209	424	157	225	MBR0033136.1 TraB/GumN family protein [Treponema sp.]	diamond	840	47.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32061893	32061893	PRJNA1144090_P_NODE_118878_length_233_cov_2.318750_g118343_i0	PRJNA1144090	118878	233	2.31875	5.4026875	Leptospira ryugenii	1917863	Bacteria	Bacteria	43.1	0.0219	NR	WP_108976763.1	1917863	g118343	i0	36	0.643776824034335	50	32	64.4	0	36	185	190	239	WP_108976763.1 adenosylcobinamide-GDP ribazoletransferase [Leptospira ryugenii]	diamond	150	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ryugenii
32820180	32820180	PRJNA1144090_P_NODE_84160_length_274_cov_2.298507_g83625_i0	PRJNA1144090	84160	274	2.298507	6.29790918	Spirochaetia bacterium	2053615	Bacteria	Bacteria	86.3	1.21e-17	NR	MCF7944466.1	2053615	g83625	i0	46.7	2.03649635036496	90	44	97.4	2	273	7	248	334	MCF7944466.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetia bacterium]	diamond	558	86.3	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);;