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

12 rows where bioproject = "PRJNA906294", 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
5076824	5076824	PRJNA906294_P_NODE_210344_length_248_cov_0.880000_g206228_i0	PRJNA906294	210344	248	0.88	2.1824	Sphaerochaeta	399320	Bacteria	Bacteria	303	5.61e-78	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g206228	i0	88.98	263.217741935484	245	27	99	0	4	248	1402245	1402001	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	65278	303	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
26707483	26707483	PRJNA906294_P_NODE_231641_length_241_cov_0.904762_g227525_i0	PRJNA906294	231641	241	0.904762	2.18047642	Leptospira barantonii	2023184	Bacteria	Bacteria	42.7	0.0365	NR	WP_135670860.1	2023184	g227525	i0	31.3	0.83402489626556	67	45	82.2	1	202	5	202	268	WP_135670860.1 hypothetical protein [Leptospira barantonii]	diamond	201	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira barantonii
27688177	27688177	PRJNA906294_P_NODE_211124_length_248_cov_0.868571_g207008_i0	PRJNA906294	211124	248	0.868571	2.15405608	Spirochaetales bacterium	2026792	Bacteria	Bacteria	42	0.0385	NR	HEB11973.1	2026792	g207008	i0	37.8	0.895161290322581	74	39	81	2	8	208	31	104	HEB11973.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Spirochaetales bacterium]	diamond	222	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27719782	27719782	PRJNA906294_P_NODE_112964_length_380_cov_0.807818_g108849_i0	PRJNA906294	112964	380	0.807818	3.0697084	Spirochaetia bacterium	2053615	Bacteria	Bacteria	67	5.19e-11	NR	MFP4563676.1	2053615	g108849	i0	63.6	1.20789473684211	44	16	34.7	0	68	199	75	118	MFP4563676.1 ribonuclease HI [Spirochaetia bacterium]	diamond	459	67	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28358186	28358186	PRJNA906294_P_NODE_68526_length_555_cov_2.130705_g64429_i0	PRJNA906294	68526	555	2.130705	11.82541275	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	2.73e-6	NR	MBR33690.1	1898206	g64429	i0	31.9	1.25945945945946	119	71	63.8	4	373	20	4	113	MBR33690.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	699	56.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28666683	28666683	PRJNA906294_P_NODE_182907_length_272_cov_2.035176_g178791_i0	PRJNA906294	182907	272	2.035176	5.53567872	Treponema sp.	166	Bacteria	Bacteria	58.9	9.67e-8	NR	MCQ2589478.1	166	g178791	i0	71.1	2.11764705882353	38	11	41.9	0	158	271	8	45	MCQ2589478.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Treponema sp.]	diamond	576	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30877368	30877368	PRJNA906294_P_NODE_127174_length_349_cov_1.101449_g123058_i0	PRJNA906294	127174	349	1.101449	3.84405701	Treponema sp.	166	Bacteria	Bacteria	48.9	4.56e-4	NR	MDR2717626.1	166	g123058	i0	59.5	0.318051575931232	37	14	31.8	1	49	159	8	43	MDR2717626.1 2-isopropylmalate synthase [Treponema sp.]	diamond	111	48.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31035752	31035752	PRJNA906294_P_NODE_227735_length_242_cov_0.899408_g223619_i0	PRJNA906294	227735	242	0.899408	2.17656736	Spirochaetota bacterium	2202144	Bacteria	Bacteria	68.6	2.92e-11	NR	HOP31416.1	2202144	g223619	i0	37.5	0.991735537190083	80	49	99.2	1	1	240	239	317	HOP31416.1 CocE/NonD family hydrolase [Spirochaetota bacterium]	diamond	240	68.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31129851	31129851	PRJNA906294_P_NODE_195475_length_260_cov_1.096257_g191359_i0	PRJNA906294	195475	260	1.096257	2.8502682	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	52.8	1.24e-5	NR	HNH07850.1	2026757	g191359	i0	32	1.73076923076923	75	41	76.2	2	208	11	103	176	HNH07850.1 C2 family cysteine protease [Leptospiraceae bacterium]	diamond	450	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31857466	31857466	PRJNA906294_P_NODE_150577_length_311_cov_1.075630_g146461_i0	PRJNA906294	150577	311	1.07563	3.3452093	Treponema sp.	166	Bacteria	Bacteria	45.8	0.00619	NR	MDR3335331.1	166	g146461	i0	37.9	0.636655948553055	66	36	63.7	2	37	234	154	214	MDR3335331.1 signal peptidase I [Treponema sp.]	diamond	198	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32403088	32403088	PRJNA906294_P_NODE_54019_length_665_cov_2.991554_g49997_i0	PRJNA906294	54019	665	2.991554	19.8938341	Leptospira	171	Bacteria	Bacteria	234	1.44e-74	NR	WP_012388348.1	171	g49997	i0	60.2	4.99398496240601	186	73	83.9	1	569	12	2	186	WP_012388348.1 MULTISPECIES: peroxiredoxin [Leptospira]	diamond	3321	234	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira
32899950	32899950	PRJNA906294_P_NODE_141880_length_324_cov_0.884462_g137764_i0	PRJNA906294	141880	324	0.884462	2.86565688	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	48.9	6.11e-4	NR	MCS6985098.1	2026757	g137764	i0	34.2	0.703703703703704	76	47	70.4	1	229	2	246	318	MCS6985098.1 ion transporter [Leptospiraceae bacterium]	diamond	228	48.9	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);;