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

11 rows where bioproject = "PRJNA1226487", 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
334972	334972	PRJNA1226487_P_NODE_5641_length_535_cov_2.543290_g5548_i0	PRJNA1226487	5641	535	2.54329	13.6066015	Treponema denticola	158	Bacteria	Bacteria	968	0	NTclustered	gi\|2265178430\|gb\|CP051633.1\|	158	g5548	i0	99.623	20.4785046728972	530	2	99	0	6	535	211754	212283	Treponema denticola strain OMZ 898 chromosome, complete genome	blastn	10956	968	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4161964	4161964	PRJNA1226487_P_NODE_46824_length_277_cov_9.093137_g46722_i0	PRJNA1226487	46824	277	9.093137	25.18798949	Treponema putidum	221027	Bacteria	Bacteria	472	1.65e-128	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g46722	i0	98.155	23.9819494584838	271	3	97	2	3	272	2830278	2830547	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	6643	472	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
5438277	5438277	PRJNA1226487_P_NODE_65725_length_250_cov_0.870056_g65623_i0	PRJNA1226487	65725	250	0.870056	2.17514	Treponema socranskii	53419	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g65623	i0	95.2	3	250	12	100	0	1	250	734248	733999	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	750	396	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
9974961	9974961	PRJNA1226487_P_NODE_9168_length_459_cov_9.417098_g9068_i0	PRJNA1226487	9168	459	9.417098	43.22447982	Treponema	157	Bacteria	Bacteria	621	2.7099999999999997e-173	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g9068	i0	91.741	9.74291938997821	448	36	98	1	4	451	2267142	2267588	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	4472	621	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
11250198	11250198	PRJNA1226487_P_NODE_70169_length_247_cov_0.885057_g70067_i0	PRJNA1226487	70169	247	0.885057	2.18609079	Treponema	157	Bacteria	Bacteria	265	2.63e-66	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g70067	i0	86.42	8.91497975708502	243	32	98	1	2	244	386840	387081	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	2202	267	0.99250936329588	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
13800208	13800208	PRJNA1226487_P_NODE_71631_length_246_cov_0.890173_g71529_i0	PRJNA1226487	71631	246	0.890173	2.18982558	Treponema	157	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2265178430\|gb\|CP051633.1\|	158	g71529	i0	97.154	22	246	7	100	0	1	246	2498866	2499111	Treponema denticola strain OMZ 898 chromosome, complete genome	blastn	5412	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
19461038	19461038	PRJNA1226487_P_NODE_68616_length_248_cov_0.880000_g68514_i0	PRJNA1226487	68616	248	0.88	2.1824	Spirochaetales bacterium	2026792	Bacteria	Bacteria	169	3.28e-49	NR	MBR6085079.1	2026792	g68514	i0	90.2	7.93548387096774	82	8	99.2	0	2	247	260	341	MBR6085079.1 YgeY family selenium metabolism-linked hydrolase [Spirochaetales bacterium]	diamond	1968	169	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
19461056	19461056	PRJNA1226487_P_NODE_75436_length_243_cov_0.905882_g75334_i0	PRJNA1226487	75436	243	0.905882	2.20129326	Treponema medium	58231	Bacteria	Bacteria	344	3.23e-90	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g75334	i0	92.181	9.95061728395062	243	19	100	0	1	243	215397	215155	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	2418	344	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
26756043	26756043	PRJNA1226487_P_NODE_74661_length_244_cov_0.900585_g74559_i0	PRJNA1226487	74661	244	0.900585	2.1974274	Treponema porcinum	261392	Bacteria	Bacteria	88.6	1.22e-18	NR	WP_078932975.1	261392	g74559	i0	55.6	1.99180327868852	81	36	99.6	0	2	244	31	111	WP_078932975.1 CdaR family protein [Treponema porcinum]	diamond	486	88.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema porcinum
28557200	28557200	PRJNA1226487_P_NODE_67587_length_249_cov_0.875000_g67485_i0	PRJNA1226487	67587	249	0.875	2.17875	Treponema denticola	158	Bacteria	Bacteria	153	5.46e-41	NR	WP_253731885.1	158	g67485	i0	91.5	3.95180722891566	82	7	98.8	0	3	248	360	441	WP_253731885.1 helicase-related protein [Treponema denticola]	diamond	984	153	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
29630205	29630205	PRJNA1226487_P_NODE_65970_length_250_cov_0.870056_g65868_i0	PRJNA1226487	65970	250	0.870056	2.17514	Treponema sp.	166	Bacteria	Bacteria	116	1.72e-28	NR	MEL3905997.1	166	g65868	i0	75.6	0.984	82	20	98.4	0	248	3	228	309	MEL3905997.1 methyl-accepting chemotaxis protein [Treponema sp.]	diamond	246	116	1	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);;