metadata: contig_metadata: 9 rows where bioproject = "PRJNA431371", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA431371", 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
26743687	26743687	PRJNA431371_P_NODE_20001_length_286_cov_1.342723_g19928_i0	PRJNA431371	20001	286	1.3427230000000001	3.84018778	Treponema	157	Bacteria	Bacteria	115	1.01e-27	NR	WP_371922239.1	2563668	g19928	i0	61.8	2.82167832167832	89	33	93.4	1	12	278	351	438	WP_371922239.1 hypothetical protein [Treponema sp. OMZ 799]	diamond	807	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 799
27044156	27044156	PRJNA431371_P_NODE_5622_length_508_cov_1.528736_g5549_i0	PRJNA431371	5622	508	1.528736	7.76597888	Spirochaetales bacterium	2026792	Bacteria	Bacteria	47.4	0.0113	NR	MBT3275166.1	2026792	g5549	i0	28.1	0.673228346456693	114	68	60.2	4	327	22	6	117	MBT3275166.1 hypothetical protein [Spirochaetales bacterium]	diamond	342	47.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27360404	27360404	PRJNA431371_P_NODE_1983_length_748_cov_2.023704_g1912_i0	PRJNA431371	1983	748	2.023704	15.13730592	Spirochaetota bacterium	2202144	Bacteria	Bacteria	58.5	2.98e-6	NR	MDK2817934.1	2202144	g1912	i0	52.9	0.204545454545455	51	24	20.5	0	155	3	60	110	MDK2817934.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium]	diamond	153	58.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28275808	28275808	PRJNA431371_P_NODE_966_length_943_cov_1.362069_g906_i0	PRJNA431371	966	943	1.362069	12.84431067	Treponema sp.	166	Bacteria	Bacteria	52.8	0.00166	NR	MDR0300936.1	166	g906	i0	25.5	0.747613997879109	153	106	46.8	5	441	881	770	920	MDR0300936.1 leucine-rich repeat protein [Treponema sp.]	diamond	705	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28718044	28718044	PRJNA431371_P_NODE_28827_length_248_cov_0.880000_g28754_i0	PRJNA431371	28827	248	0.88	2.1824	Treponema sp.	166	Bacteria	Bacteria	76.6	1.51e-14	NR	MCR5494658.1	166	g28754	i0	86	1.04032258064516	43	6	52	0	131	3	1	43	MCR5494658.1 protein-glutamate O-methyltransferase CheR [Treponema sp.]	diamond	258	76.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29744544	29744544	PRJNA431371_P_NODE_19030_length_293_cov_1.400000_g18957_i0	PRJNA431371	19030	293	1.4	4.102	Spirochaetia	203692	Bacteria	Bacteria	45.8	0.00535	NR	WP_002994148.1	28184	g18957	i0	40	1.62798634812287	55	27	56.3	1	292	128	44	92	WP_002994148.1 ankyrin repeat domain-containing protein [Leptospira weilii]	diamond	477	46.2	0.991341991341991	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira weilii
30455266	30455266	PRJNA431371_P_NODE_16133_length_319_cov_2.178862_g16060_i0	PRJNA431371	16133	319	2.178862	6.95056978	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	142	3.76e-39	NR	MBP7281757.1	2026757	g16060	i0	57.8	1.92789968652038	102	43	95.9	0	316	11	72	173	MBP7281757.1 hypothetical protein [Leptospiraceae bacterium]	diamond	615	142	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30549613	30549613	PRJNA431371_P_NODE_27693_length_249_cov_0.875000_g27620_i0	PRJNA431371	27693	249	0.875	2.17875	Treponema lecithinolyticum	53418	Bacteria	Bacteria	98.2	1.22e-21	NR	WP_021686488.1	53418	g27620	i0	55.6	0.975903614457831	81	36	97.6	0	2	244	60	140	WP_021686488.1 methyl-accepting chemotaxis protein [Treponema lecithinolyticum]	diamond	243	98.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema lecithinolyticum
32667874	32667874	PRJNA431371_P_NODE_35820_length_241_cov_0.916667_g35747_i0	PRJNA431371	35820	241	0.916667	2.20916747	Treponema sp.	166	Bacteria	Bacteria	150	5.72e-41	NR	MCR5496154.1	166	g35747	i0	93.8	3.98340248962656	80	5	99.6	0	1	240	92	171	MCR5496154.1 sodium/proline symporter PutP [Treponema sp.]	diamond	960	150	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);;