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

13 rows where analysis = "diamond", bioproject = "PRJNA928559" 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
7281283	7281283	PRJNA928559_P_NODE_193526_length_250_cov_3.988701_g191957_i0	PRJNA928559	193526	250	3.988701	9.9717525	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	129	5.27e-36	NR	HNO24933.1	2026757	g191957	i0	78	0.984	82	18	98.4	0	1	246	52	133	HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium]	diamond	246	129	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
14932375	14932375	PRJNA928559_P_NODE_76052_length_405_cov_3.602410_g74483_i0	PRJNA928559	76052	405	3.60241	14.5897605	Pseudomonadati	3379134	Bacteria	Bacteria	213	1.7999999999999996e-68	NR	MCC5815248.1	178	g74483	i0	73.1	12.8888888888889	134	35	99.3	1	403	2	20	152	MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.]	diamond	5220	213	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
17480409	17480409	PRJNA928559_P_NODE_130074_length_311_cov_2.378151_g128505_i0	PRJNA928559	130074	311	2.378151	7.39604961	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	156	2.77e-46	NR	HNO24933.1	2026757	g128505	i0	78.4	0.983922829581994	102	22	98.4	0	310	5	43	144	HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium]	diamond	306	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27189887	27189887	PRJNA928559_P_NODE_76522_length_404_cov_3.009063_g74953_i0	PRJNA928559	76522	404	3.009063	12.15661452	Treponema	157	Bacteria	Bacteria	65.5	1.19e-9	NR	MDR1307607.1	166	g74953	i0	33.6	1.67821782178218	107	67	79.5	2	334	14	138	240	MDR1307607.1 CAP domain-containing protein [Treponema sp.]	diamond	678	65.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27316638	27316638	PRJNA928559_P_NODE_197823_length_249_cov_0.886364_g196254_i0	PRJNA928559	197823	249	0.886364	2.20704636	root	1	Root_unresolved	Root_unresolved	62.4	4.76e-9	NR	MBR5645669.1	166	g196254	i0	43.4	2.89156626506024	76	42	90.4	1	232	8	52	127	MBR5645669.1 ankyrin repeat domain-containing protein [Treponema sp.]	diamond	720	62.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28667210	28667210	PRJNA928559_P_NODE_214347_length_242_cov_1.248521_g212778_i0	PRJNA928559	214347	242	1.248521	3.02142082	Leptospira sp.	178	Bacteria	Bacteria	84	2.84e-18	NR	MCU0824711.1	178	g212778	i0	63.3	0.743801652892562	60	22	74.4	0	63	242	1	60	MCU0824711.1 MFS transporter [Leptospira sp.]	diamond	180	84	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
29684257	29684257	PRJNA928559_P_NODE_72750_length_413_cov_5.335294_g71181_i0	PRJNA928559	72750	413	5.335294	22.03476422	Treponema	157	Bacteria	Bacteria	62.8	1.08e-8	NR	MBR4599524.1	166	g71181	i0	51.9	2.35351089588378	54	26	39.2	0	410	249	191	244	MBR4599524.1 CAP domain-containing protein [Treponema sp.]	diamond	972	63.2	0.993670886075949	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30309693	30309693	PRJNA928559_P_NODE_213012_length_243_cov_0.888235_g211443_i0	PRJNA928559	213012	243	0.888235	2.15841105	Leptospira ryugenii	1917863	Bacteria	Bacteria	172	3.81e-49	NR	WP_108973102.1	1917863	g211443	i0	96.3	0.987654320987654	80	3	98.8	0	242	3	91	170	WP_108973102.1 glycosyltransferase family 2 protein [Leptospira ryugenii]	diamond	240	172	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ryugenii
30404367	30404367	PRJNA928559_P_NODE_110833_length_339_cov_1.304511_g109264_i0	PRJNA928559	110833	339	1.304511	4.42229229	Spirochaetales bacterium	2026792	Bacteria	Bacteria	91.7	1.9e-19	NR	MBQ2259257.1	2026792	g109264	i0	55.1	1.51327433628319	89	36	78.8	2	23	289	167	251	MBQ2259257.1 ATP-dependent 6-phosphofructokinase [Spirochaetales bacterium]	diamond	513	91.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
30561686	30561686	PRJNA928559_P_NODE_209113_length_244_cov_1.192982_g207544_i0	PRJNA928559	209113	244	1.192982	2.91087608	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	93.2	6.4e-20	NR	MBU45571.1	1898206	g207544	i0	56.4	0.959016393442623	78	34	95.9	0	9	242	521	598	MBU45571.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	234	93.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30909581	30909581	PRJNA928559_P_NODE_155414_length_282_cov_1.755981_g153845_i0	PRJNA928559	155414	282	1.755981	4.95186642	Spirochaetota bacterium	2202144	Bacteria	Bacteria	47.8	9.28e-4	NR	MCK5094154.1	2202144	g153845	i0	40.6	2.76595744680851	64	37	68.1	1	249	58	221	283	MCK5094154.1 translation elongation factor Ts [Spirochaetota bacterium]	diamond	780	47.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31106098	31106098	PRJNA928559_P_NODE_172315_length_266_cov_1.430052_g170746_i0	PRJNA928559	172315	266	1.430052	3.80393832	Pseudomonadati	3379134	Bacteria	Bacteria	104	1.0799999999999999e-23	NR	MDE0024630.1	1898206	g170746	i0	50	3.53007518796993	80	40	90.2	0	25	264	15	94	MDE0024630.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	939	104	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
32427681	32427681	PRJNA928559_P_NODE_188099_length_253_cov_0.866667_g186530_i0	PRJNA928559	188099	253	0.866667	2.19266751	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.5	0.0236	NR	MBN2546275.1	2202144	g186530	i0	37.7	0.723320158102767	61	35	68.8	1	1	174	1330	1390	MBN2546275.1 AAA family ATPase [Spirochaetota bacterium]	diamond	183	43.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;