metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA976345" 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
26772864	26772864	PRJNA976345_P_NODE_16701_length_414_cov_2.034301_g15112_i0	PRJNA976345	16701	414	2.034301	8.42200614	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	170	2.75e-49	NR	MFA6734489.1	2791017	g15112	i0	63	0.978260869565217	135	50	97.8	0	2	406	138	272	MFA6734489.1 DUF932 domain-containing protein [Sphaerochaetaceae bacterium]	diamond	405	170	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
26962601	26962601	PRJNA976345_P_NODE_21862_length_360_cov_2.378462_g20262_i0	PRJNA976345	21862	360	2.378462	8.5624632	Spirochaetia bacterium	2053615	Bacteria	Bacteria	189	1.9e-55	NR	HRV29226.1	2053615	g20262	i0	89.7	0.891666666666667	107	11	89.2	0	323	3	200	306	HRV29226.1 hypothetical protein [Spirochaetia bacterium]	diamond	321	189	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27374057	27374057	PRJNA976345_P_NODE_79563_length_206_cov_2.222222_g77955_i0	PRJNA976345	79563	206	2.222222	4.57777732	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	42.7	0.0222	NR	MCX7811863.1	2026757	g77955	i0	55.6	0.655339805825243	45	18	65.5	1	188	54	114	156	MCX7811863.1 alpha/beta hydrolase [Leptospiraceae bacterium]	diamond	135	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30152181	30152181	PRJNA976345_P_NODE_19552_length_381_cov_2.387283_g17955_i0	PRJNA976345	19552	381	2.387283	9.09554823	Spirochaetia bacterium	2053615	Bacteria	Bacteria	179	9.219999999999999e-54	NR	HRS66228.1	2053615	g17955	i0	78.1	0.826771653543307	105	23	82.7	0	379	65	144	248	HRS66228.1 hypothetical protein [Spirochaetia bacterium]	diamond	315	179	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30247428	30247428	PRJNA976345_P_NODE_151072_length_166_cov_1.221374_g149464_i0	PRJNA976345	151072	166	1.221374	2.02748084	Spirochaetia bacterium	2053615	Bacteria	Bacteria	100	7.879999999999999e-23	NR	HRV29560.1	2053615	g149464	i0	100	0.975903614457831	54	0	97.6	0	164	3	300	353	HRV29560.1 Rho termination factor N-terminal domain-containing protein [Spirochaetia bacterium]	diamond	162	100	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30374049	30374049	PRJNA976345_P_NODE_75972_length_210_cov_1.525714_g74364_i0	PRJNA976345	75972	210	1.525714	3.2039994	Leptospira brenneri	2023182	Bacteria	Bacteria	42	0.0414	NR	WP_100792319.1	2023182	g74364	i0	38.9	0.771428571428571	54	32	77.1	1	162	1	3	55	WP_100792319.1 hypothetical protein [Leptospira brenneri]	diamond	162	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira brenneri
30380183	30380183	PRJNA976345_P_NODE_181292_length_155_cov_1.708333_g179684_i0	PRJNA976345	181292	155	1.708333	2.64791615	Bacteria	2	Bacteria	Bacteria	65.1	6.93e-11	NR	MCL2180279.1	166	g179684	i0	82.5	9.29032258064516	40	7	77.4	0	120	1	15	54	MCL2180279.1 NAD(+) synthase [Treponema sp.]	diamond	1440	65.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32175916	32175916	PRJNA976345_P_NODE_175178_length_157_cov_1.622951_g173570_i0	PRJNA976345	175178	157	1.622951	2.54803307	Spirochaetia bacterium	2053615	Bacteria	Bacteria	91.3	6.04e-20	NR	HRS66670.1	2053615	g173570	i0	92.3	2.98089171974522	52	4	99.4	0	2	157	292	343	HRS66670.1 hypothetical protein [Spirochaetia bacterium]	diamond	468	91.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32428886	32428886	PRJNA976345_P_NODE_115579_length_180_cov_1.917241_g113971_i0	PRJNA976345	115579	180	1.917241	3.4510338	Treponema sp. OMZ 799	2563668	Bacteria	Bacteria	42	0.0295	NR	WP_253707661.1	2563668	g113971	i0	42.6	0.783333333333333	47	21	78.3	1	170	30	208	248	WP_253707661.1 JAB domain-containing protein [Treponema sp. OMZ 799]	diamond	141	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 799
32524038	32524038	PRJNA976345_P_NODE_15939_length_424_cov_3.776350_g14352_i0	PRJNA976345	15939	424	3.77635	16.011724	Spirochaetia bacterium	2053615	Bacteria	Bacteria	57	2.47e-6	NR	GHV60830.1	2053615	g14352	i0	61	0.290094339622642	41	16	29	0	420	298	153	193	GHV60830.1 hypothetical protein AGMMS49587_03450 [Spirochaetia bacterium]	diamond	123	57	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32524046	32524046	PRJNA976345_P_NODE_175219_length_157_cov_1.614754_g173611_i0	PRJNA976345	175219	157	1.614754	2.53516378	Spirochaetia bacterium	2053615	Bacteria	Bacteria	38.9	0.0446	NR	HRV29504.1	2053615	g173611	i0	100	0.32484076433121	17	0	32.5	0	107	157	1	17	HRV29504.1 hypothetical protein [Spirochaetia bacterium]	diamond	51	38.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32712862	32712862	PRJNA976345_P_NODE_72280_length_214_cov_1.530726_g70672_i0	PRJNA976345	72280	214	1.530726	3.27575364	Spirochaetia bacterium	2053615	Bacteria	Bacteria	122	1.5199999999999998e-31	NR	HRS66611.1	2053615	g70672	i0	87.9	1.85046728971963	66	8	92.5	0	2	199	247	312	HRS66611.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Spirochaetia bacterium]	diamond	396	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32870316	32870316	PRJNA976345_P_NODE_92180_length_195_cov_2.762500_g90572_i0	PRJNA976345	92180	195	2.7625	5.386875	Treponema sp.	166	Bacteria	Bacteria	122	6.679999999999999e-32	NR	MFC2602318.1	166	g90572	i0	89.2	1	65	7	100	0	195	1	56	120	MFC2602318.1 tRNA pseudouridine(55) synthase TruB [Treponema sp.]	diamond	195	122	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);;