metadata: contig_metadata: 6 rows where bioproject = "PRJNA826497", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA826497", 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
13982055	13982055	PRJNA826497_S_NODE_9351_length_191_cov_3.208861_g9311_i0	PRJNA826497	9351	191	3.208861	6.12892451	Treponema	157	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g9311	i0	99.476	186.277486910995	191	1	100	0	1	191	1014928	1015118	Treponema medium strain T19 chromosome, complete genome	blastn	35579	348	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
26651370	26651370	PRJNA826497_S_NODE_8601_length_196_cov_1.453988_g8561_i0	PRJNA826497	8601	196	1.453988	2.84981648	Pseudomonadati	3379134	Bacteria	Bacteria	57	1.49e-7	NR	WP_411047269.1	88058	g8561	i0	44.4	3.84183673469388	63	35	96.4	0	4	192	28	90	WP_411047269.1 NUMOD3 domain-containing DNA-binding protein [Treponema primitia]	diamond	753	57.4	0.993031358885017	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema primitia
29896618	29896618	PRJNA826497_S_NODE_11471_length_179_cov_28.315068_g11431_i0	PRJNA826497	11471	179	28.315068	50.68397172	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	46.6	6.63e-4	NR	MCI6674114.1	1898206	g11431	i0	47.2	0.888268156424581	53	21	88.8	2	175	17	206	251	MCI6674114.1 Rpn family recombination-promoting nuclease/putative transposase [Spirochaetaceae bacterium]	diamond	159	46.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30654661	30654661	PRJNA826497_S_NODE_2513_length_270_cov_4.725738_g2473_i0	PRJNA826497	2513	270	4.725738	12.7594926	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	118	1.19e-28	NR	MBP9889803.1	2026757	g2473	i0	59.4	1.06666666666667	96	26	92.2	2	1	249	1019	1114	MBP9889803.1 hypothetical protein [Leptospiraceae bacterium]	diamond	288	118	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31191567	31191567	PRJNA826497_S_NODE_18875_length_153_cov_4.666667_g18835_i0	PRJNA826497	18875	153	4.666667	7.14000051	Leptospira langatensis	2484983	Bacteria	Bacteria	41.6	0.0278	NR	WP_135646546.1	2484983	g18835	i0	48.7	0.764705882352941	39	20	76.5	0	36	152	130	168	WP_135646546.1 hypothetical protein [Leptospira langatensis]	diamond	117	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira langatensis
32236167	32236167	PRJNA826497_S_NODE_78_length_837_cov_13.829602_g66_i0	PRJNA826497	78	837	13.829602	115.75376874	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	270	7.43e-79	NR	MBP9889803.1	2026757	g66	i0	55.5	1.04659498207885	292	108	99.3	3	7	837	313	597	MBP9889803.1 hypothetical protein [Leptospiraceae bacterium]	diamond	876	270	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae 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);;