metadata: contig_metadata: 15 rows where bioproject = "PRJNA770361", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJNA770361", 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
4574537	4574537	PRJNA770361_P_NODE_12164_length_269_cov_1.520408_g12069_i0	PRJNA770361	12164	269	1.520408	4.08989752	Spirochaetes bacterium GWC2_52_13	1802181	Bacteria	Bacteria	160	7.4e-46	NR	OHD31754.1	1802181	g12069	i0	95.5	1.98513011152416	89	4	99.3	0	268	2	217	305	OHD31754.1 MAG: DNA-directed RNA polymerase subunit alpha [Spirochaetes bacterium GWC2_52_13]	diamond	534	160	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWC2_52_13
5849987	5849987	PRJNA770361_P_NODE_6645_length_363_cov_2.744828_g6550_i0	PRJNA770361	6645	363	2.744828	9.96372564	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	289	2.41e-73	NTclustered	gi\|2621785465\|emb\|OY781923.1\|	2791017	g6550	i0	81.522	14.9862258953168	368	52	99	14	3	362	1663172	1662813	MAG: Sphaerochaetaceae bacterium isolate 77f26d43-b2b0-4d0d-8c29-067165085957 genome assembly, chromosome: 1	blastn	5440	289	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
7125084	7125084	PRJNA770361_P_NODE_16686_length_247_cov_0.896552_g16591_i0	PRJNA770361	16686	247	0.896552	2.21448344	Spirochaetia bacterium	2053615	Bacteria	Bacteria	162	2.39e-46	NR	MCE1159502.1	2053615	g16591	i0	100	0.995951417004049	82	0	99.6	0	1	246	245	326	MCE1159502.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Spirochaetia bacterium]	diamond	246	162	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
18598071	18598071	PRJNA770361_P_NODE_14695_length_251_cov_0.876404_g14600_i0	PRJNA770361	14695	251	0.876404	2.19977404	Sphaerochaeta associata	1129264	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g14600	i0	100	1.99601593625498	251	0	100	0	1	251	3268986	3268736	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	501	464	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
19873179	19873179	PRJNA770361_P_NODE_19336_length_217_cov_4.319444_g19241_i0	PRJNA770361	19336	217	4.319444	9.37319348	Sphaerochaeta associata	1129264	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g19241	i0	100	131.073732718894	217	0	100	0	1	217	1401672	1401456	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	28443	401	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
21148920	21148920	PRJNA770361_P_NODE_15817_length_249_cov_0.886364_g15722_i0	PRJNA770361	15817	249	0.886364	2.20704636	Sphaerochaeta associata	1129264	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g15722	i0	100	7.15261044176707	249	0	100	0	1	249	3300705	3300953	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	1781	460	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
26958119	26958119	PRJNA770361_P_NODE_18142_length_244_cov_0.912281_g18047_i0	PRJNA770361	18142	244	0.912281	2.22596564	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	164	1.07e-47	NR	HOE85190.1	1972642	g18047	i0	100	0.983606557377049	80	0	98.4	0	242	3	185	264	HOE85190.1 dihydroorotase [Sphaerochaeta sp.]	diamond	240	164	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
27062792	27062792	PRJNA770361_P_NODE_17522_length_245_cov_0.906977_g17427_i0	PRJNA770361	17522	245	0.906977	2.22209365	Exilispira	568400	Bacteria	Bacteria	147	5.52e-39	NR	MBP7030242.1	2202144	g17427	i0	94.7	2.79183673469388	76	4	93.1	0	2	229	738	813	MBP7030242.1 transporter substrate-binding domain-containing protein [Spirochaetota bacterium]	diamond	684	147	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27094399	27094399	PRJNA770361_P_NODE_18222_length_244_cov_0.906433_g18127_i0	PRJNA770361	18222	244	0.906433	2.21169652	Sphaerochaeta	399320	Bacteria	Bacteria	122	9.679999999999999e-32	NR	MEA5033699.1	1972642	g18127	i0	85.1	1.81967213114754	74	11	91	0	23	244	1	74	MEA5033699.1 FtsH protease activity modulator HflK [Sphaerochaeta sp.]	diamond	444	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
27590556	27590556	PRJNA770361_P_NODE_6404_length_370_cov_1.313131_g6309_i0	PRJNA770361	6404	370	1.313131	4.8585847	Leptospirales bacterium	2604146	Bacteria	Bacteria	112	4.76e-28	NR	MEQ9363317.1	2604146	g6309	i0	40	3.95675675675676	125	73	99.7	1	369	1	24	148	MEQ9363317.1 TRAP transporter TatT component family protein [Leptospirales bacterium]	diamond	1464	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales bacterium
28389231	28389231	PRJNA770361_P_NODE_2566_length_591_cov_1.113900_g2472_i0	PRJNA770361	2566	591	1.1139	6.583149	Pseudomonadati	3379134	Bacteria	Bacteria	173	2.64e-46	NR	HNF27341.1	2026757	g2472	i0	49.7	8.05583756345178	199	96	99.5	3	588	1	465	662	HNF27341.1 hypothetical protein [Leptospiraceae bacterium]	diamond	4761	173	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29232301	29232301	PRJNA770361_P_NODE_17609_length_245_cov_0.906977_g17514_i0	PRJNA770361	17609	245	0.906977	2.22209365	Spirochaetota bacterium	2202144	Bacteria	Bacteria	167	1.45e-50	NR	MDI9386965.1	2202144	g17514	i0	97.5	0.991836734693878	81	2	99.2	0	1	243	128	208	MDI9386965.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Spirochaetota bacterium]	diamond	243	167	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30442100	30442100	PRJNA770361_P_NODE_12913_length_260_cov_1.251337_g12818_i0	PRJNA770361	12913	260	1.251337	3.2534762	Bacteria	2	Bacteria	Bacteria	116	1.07e-29	NR	MBO4759740.1	1898206	g12818	i0	61.6	8.87307692307692	86	33	99.2	0	260	3	86	171	MBO4759740.1 glucosamine-6-phosphate deaminase [Spirochaetaceae bacterium]	diamond	2307	117	0.991452991452991	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30811482	30811482	PRJNA770361_P_NODE_13134_length_257_cov_1.695652_g13039_i0	PRJNA770361	13134	257	1.695652	4.35782564	Spirochaetota bacterium	2202144	Bacteria	Bacteria	139	3.69e-40	NR	MEW6547871.1	2202144	g13039	i0	80	0.992217898832685	85	17	99.2	0	3	257	28	112	MEW6547871.1 hypothetical protein [Spirochaetota bacterium]	diamond	255	139	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32519604	32519604	PRJNA770361_P_NODE_17679_length_245_cov_0.906977_g17584_i0	PRJNA770361	17679	245	0.906977	2.22209365	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	166	1.14e-47	NR	MDY0304069.1	1972642	g17584	i0	100	0.991836734693878	81	0	99.2	0	3	245	87	167	MDY0304069.1 ATP-binding protein [Sphaerochaeta sp.]	diamond	243	166	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta 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);;