metadata: contig_metadata: 25 rows where bioproject = "PRJNA597223", tax_kingdom = "Pseudomonadati" and tax

25 rows where bioproject = "PRJNA597223", 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
569061	569061	PRJNA597223_P_NODE_37321_length_236_cov_13.074627_g35475_i0	PRJNA597223	37321	236	13.074627	30.85611972	Treponema vincentii	69710	Bacteria	Bacteria	409	1.09e-109	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g35475	i0	98.696	188.177966101695	230	3	97	0	4	233	325780	325551	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	44410	409	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
1140596	1140596	PRJNA597223_P_NODE_13141_length_468_cov_3.773672_g11381_i0	PRJNA597223	13141	468	3.773672	17.66078496	Treponema	157	Bacteria	Bacteria	800	0	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g11381	i0	97.845	190.938034188034	464	9	99	1	1	463	1015644	1015181	Treponema medium strain T19 chromosome, complete genome	blastn	89359	800	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
4396707	4396707	PRJNA597223_P_NODE_40724_length_223_cov_30.872340_g38878_i0	PRJNA597223	40724	223	30.87234	68.8453182	Treponema vincentii	69710	Bacteria	Bacteria	379	7.999999999999999e-101	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g38878	i0	97.309	193.695067264574	223	6	100	0	1	223	327209	327431	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	43194	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
6947495	6947495	PRJNA597223_P_NODE_53606_length_190_cov_2.561290_g51760_i0	PRJNA597223	53606	190	2.56129	4.866451	Treponema vincentii	69710	Bacteria	Bacteria	108	3.43e-19	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g51760	i0	94.286	1.10526315789474	70	4	37	0	116	185	1644834	1644903	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	210	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7518474	7518474	PRJNA597223_P_NODE_35086_length_246_cov_1140.199052_g33240_i0	PRJNA597223	35086	246	1140.199052	2804.88966792	Treponema	157	Bacteria	Bacteria	446	8.719999999999999e-121	NTclustered	gi\|6049688\|gb\|AF182835.1\|AF182835	105289	g33240	i0	99.59	99.0528455284553	244	1	99	0	3	246	1152	1395	Treponema sp. 3:G:BB003 16S ribosomal RNA gene, partial sequence	blastn	24367	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. 3:G:BB003
8222050	8222050	PRJNA597223_P_NODE_17307_length_396_cov_7.581717_g15493_i0	PRJNA597223	17307	396	7.581717	30.02359932	Treponema parvum	138851	Bacteria	Bacteria	254	9.68e-63	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g15493	i0	84.766	36.1818181818182	256	35	91	4	9	262	1516525	1516778	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	14328	254	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
9497255	9497255	PRJNA597223_P_NODE_19528_length_367_cov_146.075301_g17700_i0	PRJNA597223	19528	367	146.075301	536.09635467	uncultured Treponema sp.	162155	Bacteria	Bacteria	379	1.41e-100	NTclustered	gi\|375244454\|gb\|JQ654180.1\|	162155	g17700	i0	99.519	54.6811989100817	208	1	57	0	1	208	208	1	Uncultured Treponema sp. clone 3:6P47 16S ribosomal RNA gene, partial sequence	blastn	20068	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
10773608	10773608	PRJNA597223_P_NODE_56209_length_188_cov_2.163399_g54363_i0	PRJNA597223	56209	188	2.163399	4.06719012	Treponema denticola	158	Bacteria	Bacteria	84.2	5.71e-12	NTclustered	gi\|2265174965\|gb\|CP051523.1\|	158	g54363	i0	91.667	0.319148936170213	60	5	32	0	6	65	1833993	1834052	Treponema denticola strain OMZ 852 chromosome, complete genome	blastn	60	84.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
10773798	10773798	PRJNA597223_P_NODE_76389_length_162_cov_1.503937_g74543_i0	PRJNA597223	76389	162	1.503937	2.43637794	uncultured Treponema sp.	162155	Bacteria	Bacteria	215	1.62e-51	NTclustered	gi\|1826584143\|gb\|MT257087.1\|	162155	g74543	i0	90.741	1	162	14	99	1	1	161	305	144	Uncultured Treponema sp. clone Mbo017R1_RC 23S ribosomal RNA gene, partial sequence	blastn	162	215	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
15168748	15168748	PRJNA597223_P_NODE_12992_length_471_cov_5.655963_g11239_i0	PRJNA597223	12992	471	5.655963	26.63958573	Treponema	157	Bacteria	Bacteria	837	0	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g11239	i0	98.726	193.71974522293	471	6	100	0	1	471	1015265	1014795	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	91242	843	0.99288256227758	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
15168757	15168757	PRJNA597223_P_NODE_14632_length_440_cov_35.955556_g12843_i0	PRJNA597223	14632	440	35.955556	158.2044464	Treponema	157	Bacteria	Bacteria	793	0	NTclustered	gi\|3132611\|gb\|AF061347.1\|AF061347	76133	g12843	i0	99.769	101.127272727273	432	1	98	0	2	433	776	345	Treponema sp. I:Q:AT20 16S ribosomal RNA gene, complete sequence	blastn	44496	793	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:Q:AT20
18420949	18420949	PRJNA597223_P_NODE_34335_length_250_cov_2.488372_g32489_i0	PRJNA597223	34335	250	2.488372	6.22093	Treponema denticola	158	Bacteria	Bacteria	433	6.92e-117	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g32489	i0	99.58	6.66	238	0	95	1	8	244	1020659	1020422	Treponema denticola strain OT2B chromosome, complete genome	blastn	1665	433	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18992209	18992209	PRJNA597223_P_NODE_75075_length_163_cov_6.031250_g73229_i0	PRJNA597223	75075	163	6.03125	9.8309375	Treponema	157	Bacteria	Bacteria	278	2.06e-70	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g73229	i0	98.113	272.226993865031	159	3	98	0	2	160	216929	217087	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	44373	278	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22817816	22817816	PRJNA597223_P_NODE_13018_length_471_cov_2.461009_g11264_i0	PRJNA597223	13018	471	2.461009	11.59135239	Leptospira weilii	28184	Bacteria	Bacteria	266	5.149999999999999e-89	NR	WP_155722658.1	28184	g11264	i0	87.1	4.45859872611465	140	18	89.2	0	48	467	1	140	WP_155722658.1 catalase, partial [Leptospira weilii]	diamond	2100	266	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira weilii
22817973	22817973	PRJNA597223_P_NODE_63658_length_181_cov_6.363014_g61812_i0	PRJNA597223	63658	181	6.363014	11.51705534	Treponema	157	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|2215064721\|gb\|ON136466.1\|	59892	g61812	i0	100	99.0441988950276	181	0	100	0	1	181	244	64	Treponema amylovorum isolate Otu67 16S ribosomal RNA gene, partial sequence	blastn	17927	335	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema amylovorum
22818027	22818027	PRJNA597223_P_NODE_74298_length_164_cov_6.875969_g72452_i0	PRJNA597223	74298	164	6.875969	11.27658916	Treponema	157	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|1928027651\|gb\|CP061839.1\|	409322	g72452	i0	89.103	176.44512195122	156	14	96	3	3	156	387825	387979	Treponema pedis strain KS1 chromosome, complete genome	blastn	28937	191	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
24092622	24092622	PRJNA597223_P_NODE_27499_length_292_cov_8.194553_g25653_i0	PRJNA597223	27499	292	8.194553	23.92809476	Treponema	157	Bacteria	Bacteria	401	2.3299999999999993e-107	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g25653	i0	91.497	197.965753424658	294	22	100	3	1	292	2079655	2079363	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	57806	401	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
24092667	24092667	PRJNA597223_P_NODE_41659_length_220_cov_3.405405_g39813_i0	PRJNA597223	41659	220	3.405405	7.491891	Treponema	157	Bacteria	Bacteria	252	1.79e-62	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g39813	i0	90.625	292.863636363636	192	15	87	3	29	219	1644364	1644175	Treponema denticola strain OT2B chromosome, complete genome	blastn	64430	254	0.992125984251969	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
28311652	28311652	PRJNA597223_P_NODE_86366_length_151_cov_3.094828_g84520_i0	PRJNA597223	86366	151	3.094828	4.67319028	Treponema sp.	166	Bacteria	Bacteria	70.1	2.39e-12	NR	MEL3906214.1	166	g84520	i0	70	0.993377483443709	50	13	95.4	1	8	151	275	324	MEL3906214.1 AAA family ATPase [Treponema sp.]	diamond	150	70.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28722118	28722118	PRJNA597223_P_NODE_53527_length_190_cov_2.793548_g51681_i0	PRJNA597223	53527	190	2.793548	5.3077412	Treponema socranskii	53419	Bacteria	Bacteria	42.4	0.0236	NR	WP_021330526.1	53419	g51681	i0	87.5	0.378947368421053	24	3	37.9	0	73	2	22	45	WP_021330526.1 hypothetical protein [Treponema socranskii]	diamond	72	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
28753570	28753570	PRJNA597223_P_NODE_84887_length_153_cov_0.923729_g83041_i0	PRJNA597223	84887	153	0.923729	1.41330537	Spirochaetia bacterium	2053615	Bacteria	Bacteria	45.4	2.04e-4	NR	NCB03411.1	2053615	g83041	i0	52.5	0.784313725490196	40	19	78.4	0	123	4	1	40	NCB03411.1 hypothetical protein [Spirochaetia bacterium]	diamond	120	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29258522	29258522	PRJNA597223_P_NODE_86089_length_151_cov_4.318966_g84243_i0	PRJNA597223	86089	151	4.318966	6.52163866	Thiospirochaeta perfilievii	252967	Bacteria	Bacteria	58.5	2.35e-8	NR	WP_342781933.1	252967	g84243	i0	52.1	2.78145695364238	71	9	91.4	1	9	146	192	262	WP_342781933.1 IS3 family transposase [Thiospirochaeta perfilievii]	diamond	420	58.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Thiospirochaeta	Thiospirochaeta perfilievii
29732170	29732170	PRJNA597223_P_NODE_54890_length_189_cov_2.350649_g53044_i0	PRJNA597223	54890	189	2.350649	4.44272661	Treponema lecithinolyticum	53418	Bacteria	Bacteria	52.4	7.01e-6	NR	WP_040848258.1	53418	g53044	i0	100	0.380952380952381	24	0	38.1	0	3	74	257	280	WP_040848258.1 hypothetical protein [Treponema lecithinolyticum]	diamond	72	52.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema lecithinolyticum
31438598	31438598	PRJNA597223_P_NODE_64596_length_180_cov_1.531034_g62750_i0	PRJNA597223	64596	180	1.531034	2.7558612	Spirochaetota bacterium	2202144	Bacteria	Bacteria	112	5.1e-28	NR	TXG82032.1	2202144	g62750	i0	93.3	1	60	4	100	0	180	1	130	189	TXG82032.1 MAG: hypothetical protein E6R13_05540 [Spirochaetota bacterium]	diamond	180	112	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31723273	31723273	PRJNA597223_P_NODE_52957_length_191_cov_2.365385_g51111_i0	PRJNA597223	52957	191	2.365385	4.51788535	Treponema socranskii	53419	Bacteria	Bacteria	42.4	0.0255	NR	WP_021329944.1	53419	g51111	i0	87	0.738219895287958	23	3	36.1	0	9	77	106	128	WP_021329944.1 ComEC/Rec2 family competence protein [Treponema socranskii]	diamond	141	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii

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