metadata: contig_metadata: 11 rows where bioproject = "PRJNA285816", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA285816", 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
27611348	27611348	PRJNA285816_S_NODE_13584_length_207_cov_1.297468_g13482_i0	PRJNA285816	13584	207	1.297468	2.68575876	Treponema sp.	166	Bacteria	Bacteria	42.7	0.0237	NR	MCL2212044.1	166	g13482	i0	52.5	0.579710144927536	40	19	58	0	146	27	1313	1352	MCL2212044.1 alpha-2-macroglobulin [Treponema sp.]	diamond	120	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27674590	27674590	PRJNA285816_S_NODE_24684_length_168_cov_0.924370_g24582_i0	PRJNA285816	24684	168	0.92437	1.5529416	Spirochaetales bacterium	2026792	Bacteria	Bacteria	48.5	1.2e-4	NR	MBO5288316.1	2026792	g24582	i0	40.4	1.69642857142857	52	31	92.9	0	157	2	55	106	MBO5288316.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium]	diamond	285	48.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28368909	28368909	PRJNA285816_S_NODE_16826_length_192_cov_1.076923_g16724_i0	PRJNA285816	16826	192	1.076923	2.06769216	Spirochaetia bacterium	2053615	Bacteria	Bacteria	47	5.74e-4	NR	MFP4564145.1	2053615	g16724	i0	52.5	0.625	40	19	62.5	0	34	153	135	174	MFP4564145.1 lipase family protein [Spirochaetia bacterium]	diamond	120	47	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28463873	28463873	PRJNA285816_S_NODE_23846_length_169_cov_1.300000_g23744_i0	PRJNA285816	23846	169	1.3	2.197	Spirochaetia bacterium	2053615	Bacteria	Bacteria	97.8	2.3699999999999998e-23	NR	MDH5657334.1	2053615	g23744	i0	70.9	0.976331360946746	55	16	97.6	0	5	169	151	205	MDH5657334.1 M15 family metallopeptidase [Spirochaetia bacterium]	diamond	165	97.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29112955	29112955	PRJNA285816_S_NODE_26268_length_166_cov_0.888889_g26166_i0	PRJNA285816	26268	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	46.2	7.99e-4	NR	MCG8568742.1	2202144	g26166	i0	37.7	3.81325301204819	53	32	95.8	1	163	5	683	734	MCG8568742.1 hypothetical protein [Spirochaetota bacterium]	diamond	633	46.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29284449	29284449	PRJNA285816_S_NODE_13589_length_207_cov_1.284810_g13487_i0	PRJNA285816	13589	207	1.28481	2.6595567	Spirochaetia bacterium	2053615	Bacteria	Bacteria	60.1	1.72e-8	NR	MCE9597629.1	2053615	g13487	i0	50.8	0.855072463768116	59	29	85.5	0	178	2	40	98	MCE9597629.1 aldehyde dehydrogenase family protein [Spirochaetia bacterium]	diamond	177	60.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29473814	29473814	PRJNA285816_S_NODE_20210_length_180_cov_1.099237_g20108_i0	PRJNA285816	20210	180	1.099237	1.9786266	Gracilinema caldarium	215591	Bacteria	Bacteria	41.6	0.0408	NR	WP_304240174.1	215591	g20108	i0	43.5	0.766666666666667	46	26	76.7	0	18	155	385	430	WP_304240174.1 MFS transporter [Gracilinema caldarium]	diamond	138	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
30755357	30755357	PRJNA285816_S_NODE_4214_length_332_cov_1.169611_g4112_i0	PRJNA285816	4214	332	1.169611	3.88310852	Pseudomonadati	3379134	Bacteria	Bacteria	87	1.18e-19	NR	MCE9500584.1	178	g4112	i0	58.5	5.24096385542169	65	27	58.7	0	99	293	33	97	MCE9500584.1 diaminopimelate decarboxylase [Leptospira sp.]	diamond	1740	87	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
32065561	32065561	PRJNA285816_S_NODE_13998_length_205_cov_1.000000_g13896_i0	PRJNA285816	13998	205	1	2.05	Treponema sp.	166	Bacteria	Bacteria	46.6	9.89e-4	NR	HAH63561.1	166	g13896	i0	48.8	0.6	41	21	60	0	204	82	169	209	HAH63561.1 restriction endonuclease [Treponema sp.]	diamond	123	46.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32445593	32445593	PRJNA285816_S_NODE_6479_length_275_cov_1.084071_g6377_i0	PRJNA285816	6479	275	1.084071	2.98119525	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	43.1	0.0379	NR	MBR3813678.1	1898206	g6377	i0	38.2	0.6	55	34	60	0	39	203	132	186	MBR3813678.1 ROK family transcriptional regulator [Spirochaetaceae bacterium]	diamond	165	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
32841237	32841237	PRJNA285816_S_NODE_12800_length_211_cov_1.635802_g12698_i0	PRJNA285816	12800	211	1.635802	3.45154222	Pseudomonadati	3379134	Bacteria	Bacteria	94.4	2.41e-22	NR	TVR89658.1	1898206	g12698	i0	53.6	5.85781990521327	69	32	98.1	0	209	3	54	122	TVR89658.1 MAG: type 1 glutamine amidotransferase [Spirochaetaceae bacterium]	diamond	1236	95.1	0.992639327024185	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae 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);;