metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1020641" 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
9088151	9088151	PRJNA1020641_P_NODE_6888_length_244_cov_0.900585_g6845_i0	PRJNA1020641	6888	244	0.900585	2.1974274	Treponema	157	Bacteria	Bacteria	132	1.02e-36	NR	WP_033421602.1	163	g6845	i0	92	2.74180327868852	75	6	92.2	0	226	2	1	75	WP_033421602.1 hypothetical protein [Treponema bryantii]	diamond	669	132	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
11639170	11639170	PRJNA1020641_P_NODE_3690_length_318_cov_1.257143_g3647_i0	PRJNA1020641	3690	318	1.257143	3.99771474	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	145	1.68e-38	NR	HAL18115.1	1898206	g3647	i0	75.7	2.00943396226415	107	21	100	3	318	1	416	518	HAL18115.1 chaperonin GroEL [Spirochaetaceae bacterium]	diamond	639	145	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28456228	28456228	PRJNA1020641_P_NODE_7486_length_241_cov_0.916667_g7443_i0	PRJNA1020641	7486	241	0.916667	2.20916747	Spirochaetales bacterium	2026792	Bacteria	Bacteria	61.6	5.69e-9	NR	MDD6956832.1	2026792	g7443	i0	52.7	0.684647302904564	55	26	68.5	0	241	77	182	236	MDD6956832.1 NAD(+)/NADH kinase [Spirochaetales bacterium]	diamond	165	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28763960	28763960	PRJNA1020641_P_NODE_5027_length_266_cov_1.196891_g4984_i0	PRJNA1020641	5027	266	1.196891	3.18373006	Bacteria	2	Bacteria	Bacteria	138	6.31e-38	NR	HAL18300.1	1898206	g4984	i0	69	4.95112781954887	87	27	98.1	0	3	263	106	192	HAL18300.1 long-chain fatty acid--CoA ligase [Spirochaetaceae bacterium]	diamond	1317	138	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28826981	28826981	PRJNA1020641_P_NODE_6148_length_248_cov_0.880000_g6105_i0	PRJNA1020641	6148	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	57	3.4e-7	NR	WP_335858620.1	84377	g6105	i0	58.7	1.56048387096774	46	19	55.6	0	3	140	56	101	WP_335858620.1 class I SAM-dependent methyltransferase [Brachyspira intermedia]	diamond	387	57.4	0.993031358885017	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
30911925	30911925	PRJNA1020641_P_NODE_3894_length_309_cov_0.978814_g3851_i0	PRJNA1020641	3894	309	0.978814	3.02453526	Sphaerochaeta	399320	Bacteria	Bacteria	109	2.63e-25	NR	MDX9914476.1	1972642	g3851	i0	53.1	7.45631067961165	96	44	93.2	1	3	290	460	554	MDX9914476.1 nucleoside kinase [Sphaerochaeta sp.]	diamond	2304	109	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
31670532	31670532	PRJNA1020641_P_NODE_4737_length_276_cov_1.137931_g4694_i0	PRJNA1020641	4737	276	1.137931	3.14068956	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.012	NR	MCR5436203.1	166	g4694	i0	57.1	0.652173913043478	35	12	34.8	1	98	3	2	36	MCR5436203.1 hypothetical protein [Treponema sp.]	diamond	180	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32176949	32176949	PRJNA1020641_P_NODE_5998_length_249_cov_0.875000_g5955_i0	PRJNA1020641	5998	249	0.875	2.17875	Treponema	157	Bacteria	Bacteria	121	9.61e-31	NR	MDY4831857.1	166	g5955	i0	75	2.74698795180723	76	19	91.6	0	22	249	1	76	MDY4831857.1 class I SAM-dependent DNA methyltransferase [Treponema sp.]	diamond	684	121	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32847575	32847575	PRJNA1020641_P_NODE_5780_length_250_cov_0.870056_g5737_i0	PRJNA1020641	5780	250	0.870056	2.17514	Pleomorphochaeta sp.	1920505	Bacteria	Bacteria	61.6	9.06e-9	NR	MDC7238039.1	1920505	g5737	i0	36.6	0.984	82	52	98.4	0	250	5	329	410	MDC7238039.1 5'-nucleotidase C-terminal domain-containing protein [Pleomorphochaeta sp.]	diamond	246	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta 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);;