metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA1145997" 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
4116583	4116583	PRJNA1145997_P_NODE_42244_length_253_cov_0.866667_g39625_i0	PRJNA1145997	42244	253	0.866667	2.19266751	Treponema sp.	166	Bacteria	Bacteria	153	2.04e-44	NR	MFC2331347.1	166	g39625	i0	96.4	0.99604743083004	84	3	99.6	0	2	253	119	202	MFC2331347.1 hypothetical protein [Treponema sp.]	diamond	252	153	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
26943904	26943904	PRJNA1145997_P_NODE_43042_length_252_cov_0.871508_g40423_i0	PRJNA1145997	43042	252	0.871508	2.19620016	Treponema sp.	166	Bacteria	Bacteria	99.4	3.919999999999999e-23	NR	MBR6192798.1	166	g40423	i0	56	1.78571428571429	75	33	89.3	0	2	226	166	240	MBR6192798.1 DUF1566 domain-containing protein [Treponema sp.]	diamond	450	99.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27196816	27196816	PRJNA1145997_P_NODE_43362_length_251_cov_0.876404_g40743_i0	PRJNA1145997	43362	251	0.876404	2.19977404	Treponema maltophilum	51160	Bacteria	Bacteria	117	4.4199999999999997e-32	NR	WP_016526190.1	51160	g40743	i0	98.4	0.729083665338645	61	1	72.9	0	68	250	1	61	WP_016526190.1 50S ribosomal protein L24 [Treponema maltophilum]	diamond	183	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
27323483	27323483	PRJNA1145997_P_NODE_29563_length_394_cov_0.971963_g26945_i0	PRJNA1145997	29563	394	0.971963	3.82953422	Treponema	157	Bacteria	Bacteria	147	6.45e-38	NR	WP_212566029.1	157	g26945	i0	67.2	0.99746192893401	131	43	99.7	0	1	393	152	282	WP_212566029.1 MULTISPECIES: tetratricopeptide repeat protein [Treponema]	diamond	393	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
27670997	27670997	PRJNA1145997_P_NODE_32904_length_335_cov_1.190840_g30285_i0	PRJNA1145997	32904	335	1.19084	3.989314	Treponema medium	58231	Bacteria	Bacteria	184	4.56e-56	NR	WP_016522775.1	58231	g30285	i0	85.8	1.88059701492537	106	14	94.9	1	3	320	150	254	WP_016522775.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Treponema medium]	diamond	630	184	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
27671002	27671002	PRJNA1145997_P_NODE_42924_length_252_cov_0.871508_g40305_i0	PRJNA1145997	42924	252	0.871508	2.19620016	Treponema sp.	166	Bacteria	Bacteria	74.7	1.29e-13	NR	MFC2602923.1	166	g40305	i0	100	0.428571428571429	36	0	42.9	0	2	109	282	317	MFC2602923.1 glycosyltransferase [Treponema sp.]	diamond	108	74.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27955034	27955034	PRJNA1145997_P_NODE_43505_length_251_cov_0.876404_g40886_i0	PRJNA1145997	43505	251	0.876404	2.19977404	Treponema sp. Marseille-Q39	166	Bacteria	Bacteria	167	7.62e-48	NR	WP_370586896.1	2766703	g40886	i0	100	0.99203187250996006	83	0	99.2	0	250	2	265	347	WP_370586896.1 tetratricopeptide repeat protein [Treponema sp. Marseille-Q3903]	diamond	249	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q3903
28681355	28681355	PRJNA1145997_P_NODE_41467_length_257_cov_1.695652_g38848_i0	PRJNA1145997	41467	257	1.695652	4.35782564	Treponema sp. Marseille-Q39	166	Bacteria	Bacteria	188	1.9099999999999994e-55	NR	WP_187382825.1	2766703	g38848	i0	100	0.992217898832685	85	0	99.2	0	2	256	113	197	WP_187382825.1 BCCT family transporter [Treponema sp. Marseille-Q3903]	diamond	255	188	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q3903
29155054	29155054	PRJNA1145997_P_NODE_47589_length_244_cov_1.473684_g44970_i0	PRJNA1145997	47589	244	1.473684	3.59578896	Treponema pedis	409322	Bacteria	Bacteria	129	2.15e-33	NR	MEL5718652.1	409322	g44970	i0	78.8	1.9672131147541	80	17	98.4	0	242	3	348	427	MEL5718652.1 hypothetical protein [Treponema pedis]	diamond	480	129	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
29344326	29344326	PRJNA1145997_P_NODE_45169_length_248_cov_0.891429_g42550_i0	PRJNA1145997	45169	248	0.891429	2.21074392	Treponema sp. Marseille-Q39	166	Bacteria	Bacteria	155	2.1099999999999998e-43	NR	WP_187381621.1	2766703	g42550	i0	97.6	0.991935483870968	82	2	99.2	0	1	246	252	333	WP_187381621.1 ComEC/Rec2 family competence protein [Treponema sp. Marseille-Q3903]	diamond	246	155	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q3903
29786164	29786164	PRJNA1145997_P_NODE_44711_length_249_cov_0.886364_g42092_i0	PRJNA1145997	44711	249	0.886364	2.20704636	Treponema sp.	166	Bacteria	Bacteria	73.2	7.83e-13	NR	MCF0241240.1	166	g42092	i0	51.5	3.53012048192771	66	32	79.5	0	46	243	399	464	MCF0241240.1 TRAP transporter large permease subunit [Treponema sp.]	diamond	879	73.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30165164	30165164	PRJNA1145997_P_NODE_45172_length_248_cov_0.891429_g42553_i0	PRJNA1145997	45172	248	0.891429	2.21074392	Treponema maltophilum	51160	Bacteria	Bacteria	121	8.049999999999999e-31	NR	WP_016526057.1	51160	g42553	i0	67.1	0.991935483870968	82	27	99.2	0	2	247	157	238	WP_016526057.1 hypothetical protein [Treponema maltophilum]	diamond	246	121	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
30449954	30449954	PRJNA1145997_P_NODE_42013_length_254_cov_1.292818_g39394_i0	PRJNA1145997	42013	254	1.292818	3.28375772	Treponema maltophilum	51160	Bacteria	Bacteria	177	7.64e-52	NR	WP_016524473.1	51160	g39394	i0	100	1.98425196850394	84	0	99.2	0	3	254	194	277	WP_016524473.1 radical SAM protein [Treponema maltophilum]	diamond	504	177	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
31101985	31101985	PRJNA1145997_P_NODE_47795_length_244_cov_0.912281_g45176_i0	PRJNA1145997	47795	244	0.912281	2.22596564	Treponema	157	Bacteria	Bacteria	122	4.83e-30	NR	WP_253681399.1	158	g45176	i0	71.4	4.75819672131148	77	22	94.7	0	242	12	694	770	WP_253681399.1 DUF4625 domain-containing protein [Treponema denticola]	diamond	1161	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
31176121	31176121	PRJNA1145997_P_NODE_34955_length_310_cov_1.316456_g32336_i0	PRJNA1145997	34955	310	1.316456	4.0810136	Treponema vincentii	69710	Bacteria	Bacteria	178	6.3e-51	NR	WP_155997587.1	69710	g32336	i0	84.5	1.99354838709677	103	16	99.7	0	2	310	40	142	WP_155997587.1 hypothetical protein [Treponema vincentii]	diamond	618	178	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
31671286	31671286	PRJNA1145997_P_NODE_48537_length_243_cov_0.917647_g45918_i0	PRJNA1145997	48537	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	101	5.56e-25	NR	NLK06521.1	2026792	g45918	i0	62	1.74074074074074	71	27	87.7	0	29	241	1	71	NLK06521.1 chromate transporter [Spirochaetales bacterium]	diamond	423	102	0.990196078431373	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32019317	32019317	PRJNA1145997_P_NODE_48558_length_243_cov_0.917647_g45939_i0	PRJNA1145997	48558	243	0.917647	2.22988221	Treponema	157	Bacteria	Bacteria	136	4.27e-36	NR	WP_016523076.1	58231	g45939	i0	87.3	1.95061728395062	79	10	97.5	0	2	238	18	96	WP_016523076.1 trigger factor [Treponema medium]	diamond	474	136	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
32505236	32505236	PRJNA1145997_P_NODE_45139_length_248_cov_0.891429_g42520_i0	PRJNA1145997	45139	248	0.891429	2.21074392	Treponema maltophilum	51160	Bacteria	Bacteria	156	6.12e-44	NR	WP_016526577.1	51160	g42520	i0	97.6	1.98387096774194	82	2	99.2	0	247	2	221	302	WP_016526577.1 THUMP domain-containing class I SAM-dependent RNA methyltransferase [Treponema maltophilum]	diamond	492	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
32536898	32536898	PRJNA1145997_P_NODE_47019_length_245_cov_0.906977_g44400_i0	PRJNA1145997	47019	245	0.906977	2.22209365	Treponema maltophilum	51160	Bacteria	Bacteria	118	5.37e-29	NR	WP_016526287.1	51160	g44400	i0	82.6	1.68979591836735	69	12	84.5	0	3	209	487	555	WP_016526287.1 DUF4153 domain-containing protein [Treponema maltophilum]	diamond	414	118	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum

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