metadata: contig_metadata: 26 rows where bioproject = "PRJNA741997" and tax

26 rows where bioproject = "PRJNA741997" 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
7100349	7100349	PRJNA741997_P_NODE_74066_length_250_cov_0.870056_g72946_i0	PRJNA741997	74066	250	0.870056	2.17514	Treponema socranskii	53419	Bacteria	Bacteria	392	1.1699999999999999e-104	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g72946	i0	95.161	2.976	248	12	99	0	3	250	2418307	2418060	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	744	392	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
26767764	26767764	PRJNA741997_P_NODE_80761_length_246_cov_0.890173_g79641_i0	PRJNA741997	80761	246	0.890173	2.18982558	Spirochaetia bacterium	2053615	Bacteria	Bacteria	44.3	0.0108	NR	MFO8063133.1	2053615	g79641	i0	37.2	1.14634146341463	94	34	84.1	4	20	226	111	204	MFO8063133.1 citramalate synthase [Spirochaetia bacterium]	diamond	282	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27188904	27188904	PRJNA741997_P_NODE_20342_length_508_cov_1.593103_g19227_i0	PRJNA741997	20342	508	1.593103	8.09296324	Bacteria	2	Bacteria	Bacteria	108	6.1e-26	NR	WP_304243006.1	215591	g19227	i0	42.4	11.8877952755906	132	70	78	2	2	397	92	217	WP_304243006.1 CAP domain-containing protein [Gracilinema caldarium]	diamond	6039	109	0.990825688073395	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
27188917	27188917	PRJNA741997_P_NODE_75742_length_249_cov_0.875000_g74622_i0	PRJNA741997	75742	249	0.875	2.17875	Spirochaetales	136	Bacteria	Bacteria	90.9	2.23e-19	NR	MDR1636004.1	166	g74622	i0	58.6	6.20481927710843	70	28	84.3	1	210	1	63	131	MDR1636004.1 NAD-dependent malic enzyme [Treponema sp.]	diamond	1545	91.7	0.991275899672846	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27252233	27252233	PRJNA741997_P_NODE_32883_length_380_cov_1.003257_g31763_i0	PRJNA741997	32883	380	1.003257	3.8123766	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	58.9	2.26e-7	NR	MEE0352004.1	166	g31763	i0	36.9	2.77894736842105	122	70	96.3	4	9	374	124	238	MEE0352004.1 CAP domain-containing protein [Treponema sp.]	diamond	1056	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27347306	27347306	PRJNA741997_P_NODE_80363_length_246_cov_1.335260_g79243_i0	PRJNA741997	80363	246	1.33526	3.2847396	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	1.31e-9	NR	MCB1173069.1	2026757	g79243	i0	40.5	1.86585365853659	79	45	93.9	1	16	246	317	395	MCB1173069.1 ion transporter [Leptospiraceae bacterium]	diamond	459	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27652964	27652964	PRJNA741997_P_NODE_66464_length_263_cov_1.215789_g65344_i0	PRJNA741997	66464	263	1.215789	3.19752507	Spirochaetes bacterium RIFOXYC1_FULL_54_7	1802198	Bacteria	Bacteria	84.7	5.94e-17	NR	OHD82390.1	1802198	g65344	i0	48.2	4.84790874524715	85	44	97	0	256	2	307	391	OHD82390.1 MAG: hypothetical protein A3J97_09330 [Spirochaetes bacterium RIFOXYC1_FULL_54_7]	diamond	1275	84.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium RIFOXYC1_FULL_54_7
27684724	27684724	PRJNA741997_P_NODE_60644_length_276_cov_1.517241_g59524_i0	PRJNA741997	60644	276	1.517241	4.18758516	Spirochaetes bacterium RBG_16_67_19	1802196	Bacteria	Bacteria	69.3	2.41e-11	NR	OHD76513.1	1802196	g59524	i0	42	5.79347826086957	88	51	95.7	0	1	264	334	421	OHD76513.1 MAG: hypothetical protein A2V99_04525 [Spirochaetes bacterium RBG_16_67_19]	diamond	1599	69.3	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium RBG_16_67_19
27779215	27779215	PRJNA741997_P_NODE_36284_length_360_cov_2.386760_g35164_i0	PRJNA741997	36284	360	2.38676	8.592336	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	48.5	6.87e-5	NR	MCB1177358.1	2026757	g35164	i0	41.5	0.441666666666667	53	29	42.5	1	161	9	1	53	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	159	48.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27978610	27978610	PRJNA741997_P_NODE_88945_length_241_cov_0.916667_g87825_i0	PRJNA741997	88945	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	90.5	7.580000000000001e-21	NR	NNM66752.1	2026792	g87825	i0	50	3.89626556016598	78	39	97.1	0	5	238	74	151	NNM66752.1 isoprenylcysteine carboxylmethyltransferase family protein [Spirochaetales bacterium]	diamond	939	90.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28262646	28262646	PRJNA741997_P_NODE_57746_length_283_cov_1.128571_g56626_i0	PRJNA741997	57746	283	1.128571	3.19385593	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	75.5	1.86e-13	NR	MCZ8156159.1	178	g56626	i0	44.1	5.9469964664311	93	51	97.5	1	4	279	543	635	MCZ8156159.1 guanylate cyclase [Leptospira sp.]	diamond	1683	75.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
28694941	28694941	PRJNA741997_P_NODE_34267_length_371_cov_1.808725_g33147_i0	PRJNA741997	34267	371	1.808725	6.71036975	Spirochaetales bacterium	2026792	Bacteria	Bacteria	70.9	6.27e-12	NR	MBN2874962.1	2026792	g33147	i0	39.6	1.8355795148248	111	62	89.8	2	371	39	109	214	MBN2874962.1 CAP domain-containing protein [Spirochaetales bacterium]	diamond	681	70.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28704954	28704954	PRJNA741997_P_NODE_4647_length_1280_cov_3.833471_g4057_i0	PRJNA741997	4647	1280	3.833471	49.0684288	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	4.8e-14	NR	MDR2632347.1	166	g4057	i0	27.5	1.77421875	193	116	41.5	5	45	575	80	264	MDR2632347.1 CAP domain-containing protein [Treponema sp.]	diamond	2271	84	0.995238095238095	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28757787	28757787	PRJNA741997_P_NODE_30727_length_394_cov_3.146417_g29607_i0	PRJNA741997	30727	394	3.146417	12.396882980000001	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	58.2	2.84e-7	NR	OHD18884.1	1802176	g29607	i0	37.3	1.91878172588832	118	64	82.2	2	21	344	14	131	OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5]	diamond	756	58.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
28789317	28789317	PRJNA741997_P_NODE_83527_length_244_cov_1.801170_g82407_i0	PRJNA741997	83527	244	1.80117	4.3948548	Leptospira santarosai	28183	Bacteria	Bacteria	42.4	0.0498	NR	WP_282970977.1	28183	g82407	i0	42.3	0.639344262295082	52	29	62.7	1	170	18	260	311	WP_282970977.1 phage tail protein [Leptospira santarosai]	diamond	156	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira santarosai
28852370	28852370	PRJNA741997_P_NODE_26208_length_433_cov_1.497222_g25088_i0	PRJNA741997	26208	433	1.497222	6.48297126	Leptospira sp.	178	Bacteria	Bacteria	150	1.5399999999999999e-43	NR	MCU0824711.1	178	g25088	i0	58.9	0.859122401847575	124	51	85.9	0	372	1	1	124	MCU0824711.1 MFS transporter [Leptospira sp.]	diamond	372	150	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
28884096	28884096	PRJNA741997_P_NODE_45968_length_320_cov_1.145749_g44848_i0	PRJNA741997	45968	320	1.145749	3.6663968	Leptospira perolatii	2023191	Bacteria	Bacteria	75.9	1.96e-13	NR	WP_100714444.1	2023191	g44848	i0	36.8	0.815625	87	55	81.6	0	30	290	183	269	WP_100714444.1 ion transporter [Leptospira perolatii]	diamond	261	75.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira perolatii
29714878	29714878	PRJNA741997_P_NODE_53030_length_295_cov_1.040541_g51910_i0	PRJNA741997	53030	295	1.040541	3.06959595	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	2.44e-19	NR	WP_100786390.1	2023186	g51910	i0	48.5	6.86440677966102	97	50	98.6	0	292	2	303	399	WP_100786390.1 PAS domain S-box protein [Leptospira adleri]	diamond	2025	93.2	0.991416309012876	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira adleri
30210321	30210321	PRJNA741997_P_NODE_88652_length_241_cov_1.636905_g87532_i0	PRJNA741997	88652	241	1.636905	3.94494105	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	52	2.04e-5	NR	MDR2481964.1	1898206	g87532	i0	36.4	0.821576763485477	66	42	82.2	0	4	201	323	388	MDR2481964.1 ankyrin repeat domain-containing protein [Spirochaetaceae bacterium]	diamond	198	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30631226	30631226	PRJNA741997_P_NODE_69353_length_256_cov_1.584699_g68233_i0	PRJNA741997	69353	256	1.584699	4.05682944	Bacteria	2	Bacteria	Bacteria	58.9	8.7e-8	NR	WP_255822795.1	221027	g68233	i0	37.7	9.26953125	69	43	80.9	0	13	219	319	387	WP_255822795.1 ABC transporter ATP-binding protein [Treponema putidum]	diamond	2373	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
30684306	30684306	PRJNA741997_P_NODE_48453_length_311_cov_0.957983_g47333_i0	PRJNA741997	48453	311	0.957983	2.97932713	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	82.8	9.64e-17	NR	MCY1151088.1	2791017	g47333	i0	49	0.983922829581994	102	48	98.4	1	308	3	50	147	MCY1151088.1 SIMPL domain-containing protein [Sphaerochaetaceae bacterium]	diamond	306	82.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
30968990	30968990	PRJNA741997_P_NODE_53914_length_292_cov_1.054795_g52794_i0	PRJNA741997	53914	292	1.054795	3.0800014	Leptospira ainlahdjerensis	2810033	Bacteria	Bacteria	58.2	1.89e-7	NR	WP_205280276.1	2810033	g52794	i0	48.3	1.84931506849315	60	31	61.6	0	193	14	96	155	WP_205280276.1 hypothetical protein [Leptospira ainlahdjerensis]	diamond	540	58.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ainlahdjerensis
31538069	31538069	PRJNA741997_P_NODE_61256_length_275_cov_1.331683_g60136_i0	PRJNA741997	61256	275	1.331683	3.66212825	Spirochaetales bacterium	2026792	Bacteria	Bacteria	117	1.13e-29	NR	MDC7239990.1	2026792	g60136	i0	58.2	0.992727272727273	91	38	99.3	0	275	3	126	216	MDC7239990.1 NAD(P)-dependent oxidoreductase [Spirochaetales bacterium]	diamond	273	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31790722	31790722	PRJNA741997_P_NODE_20597_length_504_cov_1.429234_g19481_i0	PRJNA741997	20597	504	1.429234	7.20333936	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	66.2	2.48e-9	NR	MCB1190498.1	2026757	g19481	i0	32.9	0.976190476190476	164	102	97	6	495	7	147	303	MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium]	diamond	492	66.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32307611	32307611	PRJNA741997_P_NODE_84979_length_244_cov_0.900585_g83859_i0	PRJNA741997	84979	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	4.83e-4	NR	HOV94740.1	2026792	g83859	i0	51.1	4.11885245901639	45	22	55.3	0	244	110	881	925	HOV94740.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium]	diamond	1005	48.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32644498	32644498	PRJNA741997_P_NODE_35680_length_363_cov_4.555172_g34560_i0	PRJNA741997	35680	363	4.555172	16.53527436	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	66.6	6.02e-12	NR	MCB1177358.1	2026757	g34560	i0	49.1	0.43801652892562	53	25	42.1	1	164	12	1	53	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	159	66.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae 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);;