metadata: contig_metadata: 16 rows where bioproject = "PRJNA890871", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA890871", 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
4692532	4692532	PRJNA890871_P_NODE_2784_length_942_cov_3.245109_g2663_i0	PRJNA890871	2784	942	3.245109	30.56892678	Bacteria	2	Bacteria	Bacteria	185	1.71e-51	NR	WP_078933021.1	157	g2663	i0	44.1	3.93630573248408	254	120	76.4	5	722	3	1	246	WP_078933021.1 MULTISPECIES: ATP-dependent Clp protease ATP-binding subunit ClpX [Treponema]	diamond	3708	186	0.99462365591397806	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
4693387	4693387	PRJNA890871_P_NODE_6524_length_592_cov_2.452794_g6389_i0	PRJNA890871	6524	592	2.452794	14.52054048	Turneriella parva	29510	Bacteria	Bacteria	89.8	4.46e-13	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g6389	i0	93.443	2.34966216216216	61	2	10	2	491	549	3860064	3860004	Turneriella parva DSM 21527, complete genome	blastn	1391	89.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
11446434	11446434	PRJNA890871_P_NODE_68209_length_249_cov_0.875000_g68074_i0	PRJNA890871	68209	249	0.875	2.17875	Treponema	157	Bacteria	Bacteria	117	7.88e-22	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g68074	i0	86.667	3.4136546184739	105	14	42	0	145	249	179635	179531	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	850	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
17443261	17443261	PRJNA890871_P_NODE_70074_length_248_cov_0.880000_g69939_i0	PRJNA890871	70074	248	0.88	2.1824	Leptospira cinconiae	3235173	Bacteria	Bacteria	353	5.49e-93	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g69939	i0	92.339	1	248	19	100	0	1	248	2365374	2365127	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	248	353	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
25091055	25091055	PRJNA890871_P_NODE_67740_length_249_cov_0.875000_g67605_i0	PRJNA890871	67740	249	0.875	2.17875	Leptospira cinconiae	3235173	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g67605	i0	88.755	1	249	28	100	0	1	249	65357	65605	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	249	305	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
26992094	26992094	PRJNA890871_P_NODE_57662_length_256_cov_3.398907_g57527_i0	PRJNA890871	57662	256	3.398907	8.70120192	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	70.9	4.68e-12	NR	MBP7283358.1	2026757	g57527	i0	43.1	1.67578125	72	41	84.4	0	256	41	126	197	MBP7283358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	429	70.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28097781	28097781	PRJNA890871_P_NODE_59085_length_255_cov_1.439560_g58950_i0	PRJNA890871	59085	255	1.43956	3.670878	Treponema sp.	166	Bacteria	Bacteria	122	1.96e-32	NR	MFC2330827.1	166	g58950	i0	73.2	0.964705882352941	82	22	96.5	0	251	6	146	227	MFC2330827.1 ribonuclease III [Treponema sp.]	diamond	246	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28129521	28129521	PRJNA890871_P_NODE_81905_length_243_cov_0.905882_g81770_i0	PRJNA890871	81905	243	0.905882	2.20129326	Treponema sp. Marseille-Q4523	2810610	Bacteria	Bacteria	165	3.5899999999999996e-48	NR	WP_205075182.1	2810610	g81770	i0	100	1	81	0	100	0	1	243	195	275	WP_205075182.1 TAXI family TRAP transporter solute-binding subunit [Treponema sp. Marseille-Q4523]	diamond	243	165	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4523
29076773	29076773	PRJNA890871_P_NODE_1148_length_2053_cov_4.826768_g1074_i0	PRJNA890871	1148	2053	4.826768	99.09354704	Leptospira noguchii serovar Autumnalis str. ZUN142	1085540	Bacteria	Bacteria	48.5	0.00785	NR	EMO39858.1	1085540	g1074	i0	31.9	0.137359961032635	94	62	13.7	1	88	369	28	119	EMO39858.1 transposase DDE domain protein [Leptospira noguchii serovar Autumnalis str. ZUN142]	diamond	282	48.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira noguchii
29234589	29234589	PRJNA890871_P_NODE_41449_length_279_cov_3.427184_g41314_i0	PRJNA890871	41449	279	3.427184	9.56184336	Leptospira sp. 'Mane'	3387407	Bacteria	Bacteria	120	9.98e-31	NR	WP_411823413.1	3387407	g41314	i0	58.7	0.989247311827957	92	38	98.9	0	278	3	25	116	WP_411823413.1 RNA ligase family protein [Leptospira sp. 'Mane']	diamond	276	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. 'Mane'
29455108	29455108	PRJNA890871_P_NODE_2270_length_1098_cov_5.903415_g2154_i0	PRJNA890871	2270	1098	5.903415	64.8194967	Brachyspira pulli	310721	Bacteria	Bacteria	129	2.77e-31	NR	WP_297298798.1	310721	g2154	i0	39.3	1.80327868852459	219	120	58.5	8	1097	456	30	240	WP_297298798.1 hypothetical protein [Brachyspira pulli]	diamond	1980	129	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pulli
29676203	29676203	PRJNA890871_P_NODE_59590_length_254_cov_1.933702_g59455_i0	PRJNA890871	59590	254	1.933702	4.91160308	Spirochaetota bacterium	2202144	Bacteria	Bacteria	102	4.58e-25	NR	MFA5518791.1	2202144	g59455	i0	56.6	2.91732283464567	83	34	98	1	250	2	31	111	MFA5518791.1 nicotinamidase [Spirochaetota bacterium]	diamond	741	102	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29707678	29707678	PRJNA890871_P_NODE_73410_length_246_cov_1.780347_g73275_i0	PRJNA890871	73410	246	1.780347	4.37965362	Treponema maltophilum	51160	Bacteria	Bacteria	137	1.9399999999999997e-37	NR	WP_016525992.1	51160	g73275	i0	82.5	0.975609756097561	80	14	97.6	0	242	3	212	291	WP_016525992.1 LacI family DNA-binding transcriptional regulator [Treponema maltophilum]	diamond	240	137	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
30063248	30063248	PRJNA890871_P_NODE_76911_length_245_cov_0.895349_g76776_i0	PRJNA890871	76911	245	0.895349	2.19360505	Leptospira	171	Bacteria	Bacteria	162	1.5199999999999998e-47	NR	WP_135650366.1	2484943	g76776	i0	96.3	1.98367346938776	81	3	99.2	0	243	1	60	140	WP_135650366.1 alpha/beta fold hydrolase [Leptospira sarikeiensis]	diamond	486	162	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sarikeiensis
30316643	30316643	PRJNA890871_P_NODE_4472_length_714_cov_3.396256_g4338_i0	PRJNA890871	4472	714	3.396256	24.24926784	Pseudomonadati	3379134	Bacteria	Bacteria	229	1.52e-66	NR	OQB67099.1	1852909	g4338	i0	50.6	14.1176470588235	239	115	99.2	3	710	3	231	469	OQB67099.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpA [Spirochaetes bacterium ADurb.Bin133]	diamond	10080	229	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium ADurb.Bin133
32647485	32647485	PRJNA890871_P_NODE_67180_length_249_cov_1.340909_g67045_i0	PRJNA890871	67180	249	1.340909	3.33886341	Treponema sp.	166	Bacteria	Bacteria	90.9	1.94e-20	NR	MDR1837624.1	166	g67045	i0	51.3	1.81927710843373	78	37	92.8	1	236	6	20	97	MDR1837624.1 hypothetical protein [Treponema sp.]	diamond	453	90.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.

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