metadata: contig_metadata: 10 rows where bioproject = "PRJNA577580", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA577580", 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
4391534	4391534	PRJNA577580_P_NODE_6044_length_365_cov_2.075342_g5966_i0	PRJNA577580	6044	365	2.075342	7.5749983	Pseudomonadati	3379134	Bacteria	Bacteria	162	2.19e-43	NR	MBI3395799.1	2053615	g5966	i0	65.8	21.1068493150685	120	27	96.2	2	360	10	618	726	MBI3395799.1 2-oxoglutarate dehydrogenase E1 component [Spirochaetia bacterium]	diamond	7704	162	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
6241739	6241739	PRJNA577580_P_NODE_8965_length_304_cov_1.285714_g8887_i0	PRJNA577580	8965	304	1.285714	3.90857056	Turneriella	338321	Bacteria	Bacteria	496	1.09e-135	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g8887	i0	96.066	470.720394736842	305	11	100	1	1	304	803	499	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	143099	496	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
27346206	27346206	PRJNA577580_P_NODE_5543_length_380_cov_1.234528_g5465_i0	PRJNA577580	5543	380	1.234528	4.6912064000000004	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	2.11e-8	NR	MDC7238825.1	2026792	g5465	i0	50.9	3.00789473684211	53	26	41.8	0	184	26	3	55	MDC7238825.1 50S ribosomal protein L30 [Spirochaetales bacterium]	diamond	1143	58.2	0.993127147766323	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28703875	28703875	PRJNA577580_P_NODE_8187_length_316_cov_1.925926_g8109_i0	PRJNA577580	8187	316	1.925926	6.08592616	Pseudomonadati	3379134	Bacteria	Bacteria	60.5	3.06e-8	NR	MCG8569087.1	2202144	g8109	i0	39.2	1.44303797468354	79	46	75	1	302	66	114	190	MCG8569087.1 hypothetical protein [Spirochaetota bacterium]	diamond	456	60.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28721932	28721932	PRJNA577580_P_NODE_2507_length_571_cov_6.857430_g2429_i0	PRJNA577580	2507	571	6.85743	39.1559253	Brachyspira hyodysenteriae	159	Bacteria	Bacteria	58.2	3.05e-6	NR	WP_144151951.1	159	g2429	i0	48.6	0.378283712784588	72	34	37.3	2	53	265	25	94	WP_144151951.1 ankyrin repeat domain-containing protein [Brachyspira hyodysenteriae]	diamond	216	58.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
28861513	28861513	PRJNA577580_P_NODE_17128_length_227_cov_2.311688_g17050_i0	PRJNA577580	17128	227	2.311688	5.24753176	Bacteria	2	Bacteria	Bacteria	82.8	1.54e-16	NR	MCP5453857.1	1898206	g17050	i0	60.9	3.42290748898678	64	25	84.6	0	27	218	5	68	MCP5453857.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Spirochaetaceae bacterium]	diamond	777	83.2	0.995192307692308	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29605567	29605567	PRJNA577580_P_NODE_13810_length_252_cov_0.871508_g13732_i0	PRJNA577580	13810	252	0.871508	2.19620016	Spirochaetota bacterium	2202144	Bacteria	Bacteria	53.9	4.98e-6	NR	MEI6388767.1	2202144	g13732	i0	38	4.64285714285714	79	43	89.3	2	246	22	797	873	MEI6388767.1 Ig-like domain-containing protein [Spirochaetota bacterium]	diamond	1170	53.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30743158	30743158	PRJNA577580_P_NODE_5314_length_388_cov_0.990476_g5236_i0	PRJNA577580	5314	388	0.990476	3.84304688	Leptospira sarikeiensis	2484943	Bacteria	Bacteria	92	2.1e-19	NR	WP_135650366.1	2484943	g5236	i0	42.5	5.21907216494845	106	55	82	2	70	387	46	145	WP_135650366.1 alpha/beta fold hydrolase [Leptospira sarikeiensis]	diamond	2025	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sarikeiensis
31059451	31059451	PRJNA577580_P_NODE_8135_length_317_cov_1.819672_g8057_i0	PRJNA577580	8135	317	1.819672	5.76836024	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.9	0.0327	NR	MBN1500445.1	2202144	g8057	i0	39.2	0.747634069400631	79	39	72.9	2	86	316	6	77	MBN1500445.1 helix-hairpin-helix domain-containing protein [Spirochaetota bacterium]	diamond	237	43.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32102766	32102766	PRJNA577580_P_NODE_10238_length_287_cov_1.168224_g10160_i0	PRJNA577580	10238	287	1.168224	3.35280288	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	79.7	6.49e-15	NR	MCB1194083.1	2026757	g10160	i0	51.8	4.30662020905923	85	36	88.9	2	286	32	75	154	MCB1194083.1 serine/threonine-protein kinase PknK [Leptospiraceae bacterium]	diamond	1236	79.7	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);;