metadata: contig_metadata: 19 rows where bioproject = "PRJNA770826", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA770826", 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
746811	746811	PRJNA770826_P_NODE_12121_length_231_cov_1.631868_g11950_i0	PRJNA770826	12121	231	1.631868	3.76961508	Leptospira meyeri	29508	Bacteria	Bacteria	96.3	9.32e-22	NR	WP_004787616.1	29508	g11950	i0	67.6	7.06493506493506	68	21	88.3	1	11	214	219	285	WP_004787616.1 ribonucleoside-diphosphate reductase subunit alpha [Leptospira meyeri]	diamond	1632	96.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira meyeri
8400176	8400176	PRJNA770826_P_NODE_5447_length_363_cov_1.710191_g5276_i0	PRJNA770826	5447	363	1.710191	6.20799333	Leptospira tipperaryensis	2564040	Bacteria	Bacteria	115	4.33e-21	NTclustered	gi\|1066933105\|gb\|CP015217.1\|	2564040	g5276	i0	77.949	0.71900826446281	195	35	53	3	171	361	1721297	1721107	Leptospira tipperaryensis strain GWTS #1 chromosome 1, complete sequence	blastn	261	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira tipperaryensis
22424164	22424164	PRJNA770826_P_NODE_16918_length_197_cov_1.054054_g16747_i0	PRJNA770826	16918	197	1.054054	2.07648638	Spirochaetia bacterium	2053615	Bacteria	Bacteria	116	1.05e-29	NR	HKJ85400.1	2053615	g16747	i0	81.5	4.9492385786802	65	11	99	1	3	197	176	239	HKJ85400.1 aldo/keto reductase [Spirochaetia bacterium]	diamond	975	116	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27432751	27432751	PRJNA770826_P_NODE_1983_length_616_cov_1.985891_g1823_i0	PRJNA770826	1983	616	1.985891	12.23308856	Treponema sp.	166	Bacteria	Bacteria	59.3	1.12e-6	NR	MDR2632347.1	166	g1823	i0	31.7	0.506493506493506	104	66	50.2	3	3	311	165	264	MDR2632347.1 CAP domain-containing protein [Treponema sp.]	diamond	312	59.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27527219	27527219	PRJNA770826_P_NODE_6643_length_323_cov_1.518248_g6472_i0	PRJNA770826	6643	323	1.518248	4.90394104	Spirochaetota bacterium	2202144	Bacteria	Bacteria	46.2	0.0029	NR	MBP7736474.1	2202144	g6472	i0	48.8	0.39938080495356	43	21	39.9	1	56	184	122	163	MBP7736474.1 hypothetical protein [Spirochaetota bacterium]	diamond	129	46.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27874519	27874519	PRJNA770826_P_NODE_585_length_1051_cov_1.771457_g495_i0	PRJNA770826	585	1051	1.771457	18.61801307	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	57	8.9e-6	NR	MCB1309187.1	2026757	g495	i0	33	0.842055185537583	100	56	27.4	3	184	471	47	139	MCB1309187.1 hypothetical protein [Leptospiraceae bacterium]	diamond	885	57	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28853117	28853117	PRJNA770826_P_NODE_17008_length_196_cov_1.414966_g16837_i0	PRJNA770826	17008	196	1.414966	2.77333336	Spirochaetota bacterium	2202144	Bacteria	Bacteria	45.8	0.00124	NR	MDY6934043.1	2202144	g16837	i0	40.3	1.02551020408163	67	37	98	1	196	5	93	159	MDY6934043.1 GNAT family N-acetyltransferase [Spirochaetota bacterium]	diamond	201	45.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28948319	28948319	PRJNA770826_P_NODE_42328_length_162_cov_0.920354_g42157_i0	PRJNA770826	42328	162	0.920354	1.49097348	Brevinematales bacterium	2614249	Bacteria	Bacteria	68.9	7.32e-12	NR	NPV01556.1	2614249	g42157	i0	53.7	1	54	25	100	0	162	1	34	87	NPV01556.1 glutamate synthase large subunit [Brevinematales bacterium]	diamond	162	68.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales			Brevinematales bacterium
29042986	29042986	PRJNA770826_P_NODE_508_length_1111_cov_2.480226_g428_i0	PRJNA770826	508	1111	2.480226	27.55531086	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	65.5	8.65e-8	NR	MCB1190498.1	2026757	g428	i0	32.9	0.442844284428443	164	102	44	6	502	14	147	303	MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium]	diamond	492	65.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29042987	29042987	PRJNA770826_P_NODE_5168_length_374_cov_1.424615_g4997_i0	PRJNA770826	5168	374	1.424615	5.3280601	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	185	1.01e-51	NR	MFP4429666.1	1898206	g4997	i0	70.2	4.96524064171123	124	37	99.5	0	2	373	135	258	MFP4429666.1 pyruvate, phosphate dikinase [Spirochaetaceae bacterium]	diamond	1857	185	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29304859	29304859	PRJNA770826_P_NODE_33709_length_165_cov_0.896552_g33538_i0	PRJNA770826	33709	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	64.7	2.26e-10	NR	MFP4179365.1	1898206	g33538	i0	57.7	3.81818181818182	52	22	94.5	0	164	9	443	494	MFP4179365.1 IMP dehydrogenase [Spirochaetaceae bacterium]	diamond	630	64.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30211032	30211032	PRJNA770826_P_NODE_13752_length_217_cov_1.238095_g13581_i0	PRJNA770826	13752	217	1.238095	2.68666615	Spirochaetales bacterium	2026792	Bacteria	Bacteria	51.6	1.91e-5	NR	MBN2874899.1	2026792	g13581	i0	41.7	3.92626728110599	72	41	99.5	1	2	217	239	309	MBN2874899.1 hypothetical protein [Spirochaetales bacterium]	diamond	852	51.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
30252602	30252602	PRJNA770826_P_NODE_9892_length_257_cov_0.918269_g9721_i0	PRJNA770826	9892	257	0.918269	2.35995133	Pseudomonadati	3379134	Bacteria	Bacteria	61.6	7.4e-9	NR	GIX42281.1	2026757	g9721	i0	49.1	1.9727626459144	55	28	64.2	0	7	171	218	272	GIX42281.1 MAG: oxidoreductase [Leptospiraceae bacterium]	diamond	507	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30338082	30338082	PRJNA770826_P_NODE_14612_length_211_cov_1.283951_g14441_i0	PRJNA770826	14612	211	1.283951	2.70913661	Spirochaetales bacterium	2026792	Bacteria	Bacteria	71.2	1.46e-12	NR	MBT3276029.1	2026792	g14441	i0	55.1	0.981042654028436	69	31	98.1	0	3	209	4	72	MBT3276029.1 hydroxyacid dehydrogenase [Spirochaetales bacterium]	diamond	207	71.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
30599843	30599843	PRJNA770826_P_NODE_6153_length_337_cov_2.753472_g5982_i0	PRJNA770826	6153	337	2.753472	9.2792006400000009	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	3.31e-11	NR	MFO1471037.1	2717305	g5982	i0	41.4	3.65875370919881	87	48	77.4	1	270	10	68	151	MFO1471037.1 CAP domain-containing protein [Turneriella sp.]	diamond	1233	68.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella sp.
30843261	30843261	PRJNA770826_P_NODE_29534_length_167_cov_0.881356_g29363_i0	PRJNA770826	29534	167	0.881356	1.47186452	Spirochaetota bacterium	2202144	Bacteria	Bacteria	92.8	2.51e-20	NR	MCX7024513.1	2202144	g29363	i0	76.4	0.988023952095808	55	13	98.8	0	2	166	219	273	MCX7024513.1 hypothetical protein [Spirochaetota bacterium]	diamond	165	92.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31475497	31475497	PRJNA770826_P_NODE_5036_length_379_cov_2.521212_g4865_i0	PRJNA770826	5036	379	2.521212	9.55539348	Treponema sp.	166	Bacteria	Bacteria	58.9	2.21e-8	NR	MBR1613865.1	166	g4865	i0	54.2	1.5197889182058	48	22	38	0	2	145	58	105	MBR1613865.1 CAP domain-containing protein [Treponema sp.]	diamond	576	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32551299	32551299	PRJNA770826_P_NODE_16059_length_202_cov_1.019608_g15888_i0	PRJNA770826	16059	202	1.019608	2.05960816	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	42.4	0.0299	NR	MCX7811654.1	2026757	g15888	i0	34.3	0.995049504950495	67	34	99.5	3	1	201	141	197	MCX7811654.1 ATP-binding protein [Leptospiraceae bacterium]	diamond	201	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32551304	32551304	PRJNA770826_P_NODE_19599_length_183_cov_1.179104_g19428_i0	PRJNA770826	19599	183	1.179104	2.15776032	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	54.7	1.01e-6	NR	MDY0290502.1	1972642	g19428	i0	48.1	2.60655737704918	52	27	85.2	0	12	167	1109	1160	MDY0290502.1 YDG domain-containing protein [Sphaerochaeta sp.]	diamond	477	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta 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);;