metadata: contig_metadata: 12 rows where bioproject = "PRJNA674308", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA674308", 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
5748128	5748128	PRJNA674308_P_NODE_20325_length_218_cov_1.857988_g20090_i0	PRJNA674308	20325	218	1.857988	4.05041384	Treponema medium	58231	Bacteria	Bacteria	381	2.1599999999999994e-101	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g20090	i0	98.165	206.821100917431	218	4	100	0	1	218	1013888	1014105	Treponema medium strain T19 chromosome, complete genome	blastn	45087	381	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
11370100	11370100	PRJNA674308_P_NODE_27789_length_191_cov_1.098592_g27554_i0	PRJNA674308	27789	191	1.098592	2.09831072	root	1	Root_unresolved	Root_unresolved	110	2.63e-26	NR	MDR2071749.1	166	g27554	i0	79.4	44.5287958115183	63	13	99	0	2	190	326	388	MDR2071749.1 glucose-6-phosphate isomerase [Treponema sp.]	diamond	8505	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
12124259	12124259	PRJNA674308_P_NODE_70_length_2739_cov_12.728625_g54_i0	PRJNA674308	70	2739	12.728625	348.63703875	Spirochaetota bacterium	2202144	Bacteria	Bacteria	145	4.56e-29	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g54	i0	81.714	6.65717415115005	175	31	6	1	1955	2128	74373	74547	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	18234	145	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
26745186	26745186	PRJNA674308_P_NODE_24541_length_201_cov_2.052632_g24306_i0	PRJNA674308	24541	201	2.052632	4.12579032	root	1	Root_unresolved	Root_unresolved	54.3	1.73e-6	NR	MCL2792704.1	1898206	g24306	i0	52.5	15.0746268656716	59	21	88.1	2	178	2	225	276	MCL2792704.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Spirochaetaceae bacterium]	diamond	3030	54.7	0.992687385740402	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
27662525	27662525	PRJNA674308_P_NODE_43264_length_166_cov_0.888889_g43029_i0	PRJNA674308	43264	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	65.5	1.21e-10	NR	TXH08342.1	2202144	g43029	i0	51.9	1.95180722891566	54	26	97.6	0	3	164	81	134	TXH08342.1 MAG: hypothetical protein E6R04_10880 [Spirochaetota bacterium]	diamond	324	65.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28534727	28534727	PRJNA674308_P_NODE_33907_length_174_cov_1.248000_g33672_i0	PRJNA674308	33907	174	1.248	2.17152	Spirochaetales bacterium	2026792	Bacteria	Bacteria	42.4	0.0194	NR	MBN2625421.1	2026792	g33672	i0	40.9	0.758620689655172	44	26	75.9	0	133	2	234	277	MBN2625421.1 tetratricopeptide repeat protein [Spirochaetales bacterium]	diamond	132	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29607629	29607629	PRJNA674308_P_NODE_14150_length_256_cov_1.497585_g13915_i0	PRJNA674308	14150	256	1.497585	3.8338176	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	46.2	0.00252	NR	MBQ5781749.1	1898206	g13915	i0	34.1	1.03125	88	33	89.1	4	25	252	140	214	MBQ5781749.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	264	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29840990	29840990	PRJNA674308_P_NODE_27811_length_191_cov_1.098592_g27576_i0	PRJNA674308	27811	191	1.098592	2.09831072	Leptospira	171	Bacteria	Bacteria	55.5	5.87e-7	NR	WP_001185031.1	173	g27576	i0	45	3.7696335078534	60	33	94.2	0	189	10	286	345	WP_001185031.1 ankyrin repeat domain-containing protein, partial [Leptospira interrogans]	diamond	720	55.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
30871631	30871631	PRJNA674308_P_NODE_32094_length_179_cov_1.046154_g31859_i0	PRJNA674308	32094	179	1.046154	1.87261566	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	41.6	0.0373	NR	MCY4375990.1	1898206	g31859	i0	53.6	0.46927374301676	28	11	43.6	1	83	6	189	216	MCY4375990.1 phytanoyl-CoA dioxygenase family protein [Spirochaetaceae bacterium]	diamond	84	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
32231772	32231772	PRJNA674308_P_NODE_36218_length_169_cov_0.866667_g35983_i0	PRJNA674308	36218	169	0.866667	1.46466723	Leptospira wolffii	409998	Bacteria	Bacteria	99	1.35e-22	NR	WP_016543503.1	409998	g35983	i0	82.1	0.994082840236686	56	10	99.4	0	2	169	374	429	WP_016543503.1 class I SAM-dependent RNA methyltransferase [Leptospira wolffii]	diamond	168	99	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolffii
32496709	32496709	PRJNA674308_P_NODE_5259_length_415_cov_1.117486_g5024_i0	PRJNA674308	5259	415	1.117486	4.6375669	Bacteria	2	Bacteria	Bacteria	53.1	4.58e-5	NR	MBO5287845.1	2026792	g5024	i0	64.9	0.780722891566265	37	13	26.7	0	8	118	18	54	MBO5287845.1 SEL1-like repeat protein [Spirochaetales bacterium]	diamond	324	53.5	0.992523364485981	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32654022	32654022	PRJNA674308_P_NODE_36760_length_169_cov_0.866667_g36525_i0	PRJNA674308	36760	169	0.866667	1.46466723	Bacteria	2	Bacteria	Bacteria	85.1	1.62e-17	NR	MDR3139614.1	166	g36525	i0	70.4	16.3668639053254	54	16	95.9	0	162	1	528	581	MDR3139614.1 pyruvate, phosphate dikinase [Treponema sp.]	diamond	2766	85.9	0.990686845168801	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);;