metadata: contig_metadata: 12 rows where bioproject = "PRJNA270367", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA270367", 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
2333479	2333479	PRJNA270367_P_NODE_36362_length_179_cov_1.200000_g36157_i0	PRJNA270367	36362	179	1.2	2.148	root	1	Root_unresolved	Root_unresolved	105	1.71e-24	NR	HIW36787.1	2838769	g36157	i0	74.1	15.6368715083799	58	15	97.2	0	178	5	43	100	HIW36787.1 methionine--tRNA ligase [Candidatus Treponema faecavium]	diamond	2799	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Candidatus Treponema faecavium
26630887	26630887	PRJNA270367_P_NODE_10241_length_415_cov_2.846995_g10039_i0	PRJNA270367	10241	415	2.846995	11.81502925	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	67.8	3.69e-12	NR	MCB1177358.1	2026757	g10039	i0	49.1	0.412048192771084	57	27	41.2	1	202	372	2	56	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	171	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
26979080	26979080	PRJNA270367_P_NODE_19802_length_272_cov_1.170404_g19597_i0	PRJNA270367	19802	272	1.170404	3.18349888	Spirochaetia bacterium	2053615	Bacteria	Bacteria	43.5	0.0269	NR	GHV56008.1	2053615	g19597	i0	42.9	0.540441176470588	49	28	54	0	25	171	233	281	GHV56008.1 hypothetical protein AGMMS49579_20070 [Spirochaetia bacterium]	diamond	147	43.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27958446	27958446	PRJNA270367_P_NODE_22345_length_249_cov_1.030000_g22140_i0	PRJNA270367	22345	249	1.03	2.5647	Spirochaetales bacterium	2026792	Bacteria	Bacteria	82.8	3.04e-17	NR	MCK5673392.1	2026792	g22140	i0	48.5	4.18072289156626	68	35	81.9	0	205	2	42	109	MCK5673392.1 bifunctional nicotinamidase/pyrazinamidase [Spirochaetales bacterium]	diamond	1041	82.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29649197	29649197	PRJNA270367_P_NODE_20010_length_270_cov_0.941176_g19805_i0	PRJNA270367	20010	270	0.941176	2.5411752	Bacteria	2	Bacteria	Bacteria	44.7	0.00994	NR	WP_020985739.1	408139	g19805	i0	56.3	1.81111111111111	32	14	35.6	0	5	100	286	317	WP_020985739.1 alpha/beta fold hydrolase [Leptospira kmetyi]	diamond	489	44.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kmetyi
29979252	29979252	PRJNA270367_P_NODE_11551_length_388_cov_0.861357_g11349_i0	PRJNA270367	11551	388	0.861357	3.34206516	Spirochaetia bacterium	2053615	Bacteria	Bacteria	193	1.39e-59	NR	GHU57880.1	2053615	g11349	i0	87.3	0.850515463917526	110	13	84.3	1	60	386	10	119	GHU57880.1 3-methyladenine DNA glycosylase [Spirochaetia bacterium]	diamond	330	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29979274	29979274	PRJNA270367_P_NODE_45391_length_163_cov_0.912281_g45186_i0	PRJNA270367	45391	163	0.912281	1.48701803	Exilispira sp.	2699745	Bacteria	Bacteria	97.4	6.0400000000000005e-22	NR	HPC38989.1	2699745	g45186	i0	90.6	12.6625766871166	53	5	97.5	0	3	161	458	510	HPC38989.1 aldehyde dehydrogenase family protein [Exilispira sp.]	diamond	2064	97.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Exilispira	Exilispira sp.
30358903	30358903	PRJNA270367_P_NODE_31812_length_196_cov_1.061224_g31607_i0	PRJNA270367	31812	196	1.061224	2.07999904	Spirochaetia bacterium	2053615	Bacteria	Bacteria	139	2.48e-39	NR	GHT92957.1	2053615	g31607	i0	98.5	0.994897959183674	65	1	99.5	0	2	196	15	79	GHT92957.1 hypothetical protein FACS1894140_5680 [Spirochaetia bacterium]	diamond	195	139	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30642603	30642603	PRJNA270367_P_NODE_13653_length_352_cov_1.033003_g13448_i0	PRJNA270367	13653	352	1.033003	3.63617056	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	53.5	1.8e-5	NR	MCB1190498.1	2026757	g13448	i0	36.3	2.89772727272727	113	65	95.5	5	341	6	197	303	MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium]	diamond	1020	53.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30737413	30737413	PRJNA270367_P_NODE_29994_length_204_cov_0.883871_g29789_i0	PRJNA270367	29994	204	0.883871	1.80309684	Treponema sp.	166	Bacteria	Bacteria	65.9	7.18e-11	NR	MBQ9205232.1	166	g29789	i0	51.7	5.22058823529412	60	29	88.2	0	1	180	186	245	MBQ9205232.1 CAP domain-containing protein [Treponema sp.]	diamond	1065	65.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31369876	31369876	PRJNA270367_P_NODE_45776_length_163_cov_0.912281_g45571_i0	PRJNA270367	45776	163	0.912281	1.48701803	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	45.8	9.02e-5	NR	MCB1177358.1	2026757	g45571	i0	60.6	0.607361963190184	33	11	60.7	1	100	2	1	31	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	99	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32634469	32634469	PRJNA270367_P_NODE_37820_length_174_cov_1.104000_g37615_i0	PRJNA270367	37820	174	1.104	1.92096	Leptospira adleri	2023186	Bacteria	Bacteria	42.7	0.0143	NR	WP_135690460.1	2023186	g37615	i0	35	1.03448275862069	60	35	98.3	2	2	172	161	219	WP_135690460.1 aldose 1-epimerase [Leptospira adleri]	diamond	180	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira adleri

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