metadata: contig_metadata: 21 rows where bioproject = "PRJNA812715", tax_kingdom = "Pseudomonadati" and tax

21 rows where bioproject = "PRJNA812715", 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
3776578	3776578	PRJNA812715_P_NODE_102963_length_250_cov_2.757062_g101162_i0	PRJNA812715	102963	250	2.757062	6.892655	Treponema	157	Bacteria	Bacteria	147	3.65e-41	NR	WP_022932973.1	163	g101162	i0	87.8	7.944	82	9	98.4	1	4	249	145	225	WP_022932973.1 prolipoprotein diacylglyceryl transferase [Treponema bryantii]	diamond	1986	148	0.993243243243243	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
25451874	25451874	PRJNA812715_P_NODE_76600_length_290_cov_1.235023_g74800_i0	PRJNA812715	76600	290	1.235023	3.5815667	Spirochaetales	136	Bacteria	Bacteria	316	8.62e-82	NTclustered	gi\|470485587\|ref\|NR_076708.1\|	150829	g74800	i0	86.505	144.524137931034	289	38	99	1	2	290	1762	1475	Treponema azotonutricium strain ZAS-9 23S ribosomal RNA gene, complete sequence	blastn	41912	318	0.993710691823899	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Leadbettera	Leadbettera azotonutricia
26801073	26801073	PRJNA812715_P_NODE_67581_length_313_cov_1.004167_g65781_i0	PRJNA812715	67581	313	1.004167	3.14304271	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	121	2.64e-30	NR	MFA5513435.1	2791017	g65781	i0	64.4	0.833865814696486	87	31	83.4	0	309	49	182	268	MFA5513435.1 tryptophan synthase subunit beta [Sphaerochaetaceae bacterium]	diamond	261	121	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
26832869	26832869	PRJNA812715_P_NODE_65601_length_319_cov_1.552846_g63801_i0	PRJNA812715	65601	319	1.552846	4.95357874	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	47.4	0.0021	NR	MCS7204469.1	2026757	g63801	i0	26.4	0.855799373040752	91	62	85.6	1	22	294	394	479	MCS7204469.1 glutamate--tRNA ligase [Leptospiraceae bacterium]	diamond	273	47.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
26896348	26896348	PRJNA812715_P_NODE_96081_length_259_cov_1.655914_g94280_i0	PRJNA812715	96081	259	1.655914	4.28881726	Spirochaetia bacterium	2053615	Bacteria	Bacteria	47.8	1.26e-4	NR	MFO7729640.1	2053615	g94280	i0	46.9	0.567567567567568	49	20	49.8	1	163	35	49	97	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	147	47.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27631825	27631825	PRJNA812715_P_NODE_106384_length_249_cov_0.875000_g104583_i0	PRJNA812715	106384	249	0.875	2.17875	Spirochaetales	136	Bacteria	Bacteria	131	2.52e-36	NR	MDR2803827.1	166	g104583	i0	85.4	1.97590361445783	82	12	98.8	0	247	2	85	166	MDR2803827.1 glutamine synthetase type III [Treponema sp.]	diamond	492	131	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27758380	27758380	PRJNA812715_P_NODE_32824_length_517_cov_8.858108_g31047_i0	PRJNA812715	32824	517	8.858108	45.79641836	Bacteria candidate phyla	1783234	Bacteria	Bacteria	93.2	1.4e-18	NR	WP_149566754.1	252967	g31047	i0	41.2	9.49323017408124	114	64	66.2	1	448	107	6	116	WP_149566754.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Thiospirochaeta perfilievii]	diamond	4908	93.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Thiospirochaeta	Thiospirochaeta perfilievii
27970244	27970244	PRJNA812715_P_NODE_106445_length_249_cov_0.875000_g104644_i0	PRJNA812715	106445	249	0.875	2.17875	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	128	1.3499999999999999e-34	NR	MDR2630671.1	1898206	g104644	i0	76.3	1.92771084337349	80	19	96.4	0	247	8	148	227	MDR2630671.1 IS5 family transposase [Spirochaetaceae bacterium]	diamond	480	128	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28317606	28317606	PRJNA812715_P_NODE_106486_length_249_cov_0.875000_g104685_i0	PRJNA812715	106486	249	0.875	2.17875	Spirochaetia bacterium	2053615	Bacteria	Bacteria	137	7.29e-38	NR	GHV17761.1	2053615	g104685	i0	81.7	1.97590361445783	82	15	98.8	0	2	247	19	100	GHV17761.1 sugar ABC transporter permease [Spirochaetia bacterium]	diamond	492	137	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28507124	28507124	PRJNA812715_P_NODE_113307_length_245_cov_0.895349_g111506_i0	PRJNA812715	113307	245	0.895349	2.19360505	Treponema sp.	166	Bacteria	Bacteria	48.9	2.48e-4	NR	MDR0388414.1	166	g111506	i0	51.7	0.73469387755102	60	26	73.5	2	8	187	73	129	MDR0388414.1 InlB B-repeat-containing protein [Treponema sp.]	diamond	180	48.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28538856	28538856	PRJNA812715_P_NODE_46267_length_403_cov_1.418182_g44471_i0	PRJNA812715	46267	403	1.418182	5.71527346	Spirochaetota bacterium	2202144	Bacteria	Bacteria	71.6	8.89e-12	NR	MEM7184312.1	2202144	g44471	i0	54.4	0.424317617866005	57	26	42.4	0	401	231	225	281	MEM7184312.1 hypothetical protein [Spirochaetota bacterium]	diamond	171	71.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28822551	28822551	PRJNA812715_P_NODE_92948_length_264_cov_1.209424_g91147_i0	PRJNA812715	92948	264	1.209424	3.19287936	Treponema sp.	166	Bacteria	Bacteria	85.9	9.84e-19	NR	MCL2237674.1	166	g91147	i0	50	2.94318181818182	86	43	97.7	0	259	2	65	150	MCL2237674.1 polysaccharide deacetylase family protein [Treponema sp.]	diamond	777	85.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29526281	29526281	PRJNA812715_P_NODE_77170_length_289_cov_1.393519_g75370_i0	PRJNA812715	77170	289	1.393519	4.02726991	Candidatus Gallitreponema	2840652	Bacteria	Bacteria	73.2	1.15e-12	NR	NCC12829.1	2053615	g75370	i0	47.4	6.91349480968858	76	40	78.9	0	60	287	2	77	NCC12829.1 tryptophan synthase subunit beta [Spirochaetia bacterium]	diamond	1998	73.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29801481	29801481	PRJNA812715_P_NODE_104211_length_250_cov_0.870056_g102410_i0	PRJNA812715	104211	250	0.870056	2.17514	Spirochaetales bacterium	2026792	Bacteria	Bacteria	85.9	5.92e-19	NR	MBN2510775.1	2026792	g102410	i0	47	0.996	83	37	99.6	2	1	249	13	88	MBN2510775.1 glutathione S-transferase N-terminal domain-containing protein [Spirochaetales bacterium]	diamond	249	85.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29801524	29801524	PRJNA812715_P_NODE_83251_length_279_cov_1.495146_g81451_i0	PRJNA812715	83251	279	1.495146	4.17145734	Spirochaetae bacterium HGW-Spirochaetae-6	2013838	Bacteria	Bacteria	44.7	0.0119	NR	PKL15127.1	2013838	g81451	i0	37.1	0.752688172043011	70	40	74.2	2	12	218	168	234	PKL15127.1 MAG: hypothetical protein CVV50_01140, partial [Spirochaetae bacterium HGW-Spirochaetae-6]	diamond	210	44.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-6
29864769	29864769	PRJNA812715_P_NODE_79691_length_285_cov_1.202830_g77891_i0	PRJNA812715	79691	285	1.20283	3.4280655	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	146	1.99e-38	NR	MFP4429666.1	1898206	g77891	i0	72.3	0.989473684210526	94	26	98.9	0	282	1	130	223	MFP4429666.1 pyruvate, phosphate dikinase [Spirochaetaceae bacterium]	diamond	282	146	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30094521	30094521	PRJNA812715_P_NODE_114512_length_244_cov_2.403509_g112711_i0	PRJNA812715	114512	244	2.403509	5.86456196	Pseudomonadati	3379134	Bacteria	Bacteria	46.2	6.31e-4	NR	HCX96120.1	1898206	g112711	i0	69	2.16393442622951	29	9	35.7	0	132	46	4	32	HCX96120.1 beta-aspartyl-peptidase [Spirochaetaceae bacterium]	diamond	528	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30180644	30180644	PRJNA812715_P_NODE_90512_length_268_cov_1.030769_g88711_i0	PRJNA812715	90512	268	1.030769	2.76246092	Thermospira aquatica	2828656	Bacteria	Bacteria	68.2	4.79e-11	NR	WP_271434675.1	2828656	g88711	i0	58.5	0.727611940298508	65	26	72.8	1	196	2	1	64	WP_271434675.1 molecular chaperone DnaJ [Thermospira aquatica]	diamond	195	68.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Thermospiraceae	Thermospira	Thermospira aquatica
30916324	30916324	PRJNA812715_P_NODE_116534_length_243_cov_1.811765_g114733_i0	PRJNA812715	116534	243	1.811765	4.40258895	Pseudomonadati	3379134	Bacteria	Bacteria	48.9	2.4e-4	NR	HUI72187.1	2053615	g114733	i0	38.1	2.4320987654321	63	39	77.8	0	44	232	117	179	HUI72187.1 hypothetical protein [Spirochaetia bacterium]	diamond	591	49.3	0.991886409736308	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31738016	31738016	PRJNA812715_P_NODE_113077_length_245_cov_1.186047_g111276_i0	PRJNA812715	113077	245	1.186047	2.90581515	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	3.91e-7	NR	MBX7059560.1	2604146	g111276	i0	38.8	3.23265306122449	80	46	94.3	1	4	234	132	211	MBX7059560.1 lysophospholipase [Leptospirales bacterium]	diamond	792	56.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales bacterium
32866910	32866910	PRJNA812715_P_NODE_113780_length_245_cov_0.895349_g111979_i0	PRJNA812715	113780	245	0.895349	2.19360505	Leptospira interrogans	173	Bacteria	Bacteria	42	0.00798	NR	WP_218015996.1	173	g111979	i0	37.5	1.17551020408163	48	30	58.8	0	236	93	12	59	WP_218015996.1 hypothetical protein, partial [Leptospira interrogans]	diamond	288	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans

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);;