metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax

26 rows where analysis = "blastn", bioproject = "PRJEB20058" 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
25517484	25517484	PRJEB20058_P_NODE_209009_length_250_cov_1.126984_g206185_i0	PRJEB20058	209009	250	1.126984	2.81746	Treponema medium	58231	Bacteria	Bacteria	171	5.99e-38	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g206185	i0	87.671	3.116	146	18	58	0	105	250	1076282	1076427	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	779	171	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
25653426	25653426	PRJEB20058_P_NODE_210786_length_249_cov_0.941489_g207962_i0	PRJEB20058	210786	249	0.941489	2.34430761	Parasphaerochaeta coccoides DSM 17374	760011	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|559134855\|tpe\|HG788974.1\|	760011	g207962	i0	100	0.112449799196787	28	0	11	0	158	185	376	349	TPA: Sphaerochaeta coccoides DSM 17374 transfer-messenger mRNA Sphae_cocco_17374, single chain mature transcript	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Parasphaerochaeta	Parasphaerochaeta coccoides
25656136	25656136	PRJEB20058_P_NODE_47946_length_607_cov_17.097070_g45235_i0	PRJEB20058	47946	607	17.09707	103.7792149	Leptospira mgodei	3235172	Bacteria	Bacteria	1020	0	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g45235	i0	99.291	4.03953871499176	564	4	93	0	19	582	2225235	2225798	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	2452	1020	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
25749866	25749866	PRJEB20058_P_NODE_215514_length_245_cov_11.282609_g212690_i0	PRJEB20058	215514	245	11.282609	27.64239205	Treponema	157	Bacteria	Bacteria	158	4.56e-34	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g212690	i0	79.821	176.555102040816	223	39	91	4	1	222	430043	429826	Treponema brennaborense DSM 12168, complete genome	blastn	43256	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
25790191	25790191	PRJEB20058_P_NODE_224651_length_238_cov_12.242938_g221826_i0	PRJEB20058	224651	238	12.242938	29.13819244	Treponema vincentii	69710	Bacteria	Bacteria	375	1.1199999999999998e-99	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g221826	i0	98.14	178.68487394958	215	4	90	0	1	215	2079678	2079892	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	42527	375	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
25791169	25791169	PRJEB20058_P_NODE_29395_length_773_cov_99.870787_g26952_i0	PRJEB20058	29395	773	99.870787000000007	772.00118351	Leptospira mgodei	3235172	Bacteria	Bacteria	1264	0	NTclustered	gi\|2777199540\|gb\|CP162141.1\|	3235172	g26952	i0	98.736	0.921086675291074	712	8	92	1	41	751	64147	64858	Leptospira mgodei strain WS4.C2 plasmid pLMGODEI, complete sequence	blastn	712	1264	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
25793617	25793617	PRJEB20058_P_NODE_74163_length_483_cov_2.232227_g71386_i0	PRJEB20058	74163	483	2.232227	10.78165641	Treponema socranskii subsp. buccale	69713	Bacteria	Bacteria	712	0	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g71386	i0	95.918	55.935817805383	441	15	91	3	23	461	906595	907034	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	27017	712	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
25883987	25883987	PRJEB20058_P_NODE_108851_length_387_cov_13.015337_g106040_i0	PRJEB20058	108851	387	13.015337	50.36935419	Treponema	157	Bacteria	Bacteria	558	1.79e-154	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g106040	i0	94.49	173.537467700258	363	19	94	1	25	387	1101873	1102234	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	67159	558	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25886035	25886035	PRJEB20058_P_NODE_247483_length_199_cov_54.601449_g244658_i0	PRJEB20058	247483	199	54.601449	108.65688351	Treponema	157	Bacteria	Bacteria	189	1.26e-43	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g244658	i0	86.111	133.321608040201	180	19	89	6	1	177	2223043	2223219	Treponema denticola strain OKA3 chromosome, complete genome	blastn	26531	189	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25926705	25926705	PRJEB20058_P_NODE_236900_length_222_cov_4.670807_g234075_i0	PRJEB20058	236900	222	4.670807	10.36919154	Treponema denticola	158	Bacteria	Bacteria	243	1.09e-59	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g234075	i0	87.324	107.810810810811	213	25	96	1	10	222	1101117	1101327	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	23934	243	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25928303	25928303	PRJEB20058_P_NODE_45348_length_624_cov_20.930728_g42656_i0	PRJEB20058	45348	624	20.930728	130.60774272	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2907625910\|emb\|OZ223470.1\|	2791017	g42656	i0	96.875	0.0512820512820513	32	1	5	0	240	271	2982773	2982742	MAG: Sphaerochaetaceae bacterium isolate cd985c71-0469-48ce-9ce8-6ec3774ccd9a genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
26059244	26059244	PRJEB20058_P_NODE_151469_length_311_cov_12.176000_g148646_i0	PRJEB20058	151469	311	12.176	37.86736	Borreliella garinii BgVir	1081646	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|365193444\|gb\|CP003151.1\|	1081646	g148646	i0	96.875	0.102893890675241	32	1	10	0	42	73	343872	343903	Borrelia garinii BgVir chromosome linear, complete sequence	blastn	32	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26063308	26063308	PRJEB20058_P_NODE_28005_length_791_cov_24.706849_g25632_i0	PRJEB20058	28005	791	24.706849	195.43117559	Leptospira mgodei	3235172	Bacteria	Bacteria	1303	0	NTclustered	gi\|2777199540\|gb\|CP162141.1\|	3235172	g25632	i0	98.381	0.975979772439949	741	12	94	0	42	782	48055	47315	Leptospira mgodei strain WS4.C2 plasmid pLMGODEI, complete sequence	blastn	772	1303	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26157945	26157945	PRJEB20058_P_NODE_205069_length_252_cov_69.486911_g202245_i0	PRJEB20058	205069	252	69.486911	175.10701572	Treponema	157	Bacteria	Bacteria	263	9.7e-66	NTclustered	gi\|1928027651\|gb\|CP061839.1\|	409322	g202245	i0	87.554	81.9166666666667	233	22	91	5	24	252	387825	388054	Treponema pedis strain KS1 chromosome, complete genome	blastn	20643	263	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
26193269	26193269	PRJEB20058_P_NODE_100974_length_405_cov_2.188953_g98167_i0	PRJEB20058	100974	405	2.188953	8.86525965	Leptospira mgodei	3235172	Bacteria	Bacteria	665	0	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g98167	i0	99.454	4.68641975308642	366	2	90	0	20	385	1438674	1439039	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	1898	665	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26193339	26193339	PRJEB20058_P_NODE_102478_length_401_cov_19.352941_g99671_i0	PRJEB20058	102478	401	19.352941	77.60529341	Leptospira mgodei	3235172	Bacteria	Bacteria	649	0	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g99671	i0	98.638	0.915211970074813	367	3	92	2	23	389	2475013	2474649	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	367	649	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26194355	26194355	PRJEB20058_P_NODE_124174_length_356_cov_12.345763_g121356_i0	PRJEB20058	124174	356	12.345763	43.95091628	Leptospira mgodei	3235172	Bacteria	Bacteria	549	9.799999999999996e-152	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g121356	i0	99.34	0.851123595505618	303	2	85	0	19	321	2955411	2955713	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	303	549	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26198401	26198401	PRJEB20058_P_NODE_218238_length_244_cov_0.972678_g215414_i0	PRJEB20058	218238	244	0.972678	2.37333432	Leptospira mgodei	3235172	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g215414	i0	99.18	1	244	2	100	0	1	244	3500344	3500587	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	244	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26198778	26198778	PRJEB20058_P_NODE_228742_length_233_cov_6.633721_g225917_i0	PRJEB20058	228742	233	6.633721	15.45656993	Treponema putidum	221027	Bacteria	Bacteria	339	1.43e-88	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g225917	i0	95.305	116.695278969957	213	10	91	0	1	213	1558420	1558632	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	27190	339	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
26293197	26293197	PRJEB20058_P_NODE_167398_length_290_cov_39.362445_g164575_i0	PRJEB20058	167398	290	39.362445	114.1510905	Borreliella	64895	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2385115593\|gb\|CP075435.1\|	29519	g164575	i0	100	0.8	29	0	10	0	157	185	349390	349362	Borreliella garinii strain PFr chromosome, complete genome	blastn	232	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26329534	26329534	PRJEB20058_P_NODE_111031_length_382_cov_42.062305_g108219_i0	PRJEB20058	111031	382	42.062305	160.6780051	Leptospira mgodei	3235172	Bacteria	Bacteria	525	1.7899999999999994e-144	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g108219	i0	94.69	1.56020942408377	339	17	89	1	21	359	2918162	2917825	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	596	525	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26337762	26337762	PRJEB20058_P_NODE_69903_length_498_cov_26.192220_g67132_i0	PRJEB20058	69903	498	26.19222	130.4372556	Thermospira aquatica	2828656	Bacteria	Bacteria	374	9.139999999999999e-99	NTclustered	gi\|2242711866\|gb\|CP073355.1\|	2828656	g67132	i0	81.498	0.911646586345382	454	84	91	0	1	454	1421224	1420771	Thermospira aquatica strain F1F22 chromosome, complete genome	blastn	454	374	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Thermospiraceae	Thermospira	Thermospira aquatica
26429427	26429427	PRJEB20058_P_NODE_18791_length_956_cov_4.181006_g16765_i0	PRJEB20058	18791	956	4.181006	39.97041736	Treponema	157	Bacteria	Bacteria	1687	0	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g16765	i0	99.044	27.2698744769874	941	8	98	1	17	956	1376996	1376056	Treponema denticola strain OKA3 chromosome, complete genome	blastn	26070	1692	0.997044917257683	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
26473018	26473018	PRJEB20058_P_NODE_51176_length_587_cov_86.653992_g48444_i0	PRJEB20058	51176	587	86.653992	508.65893304	Treponema sp. OMZ 788	2563664	Bacteria	Bacteria	209	3.25e-49	NTclustered	gi\|2265141765\|gb\|CP051199.1\|	2563664	g48444	i0	90.062	0.785349233390119	161	16	27	0	409	569	764934	765094	Treponema sp. OMZ 788 chromosome, complete genome	blastn	461	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 788
26474913	26474913	PRJEB20058_P_NODE_87752_length_439_cov_9.923280_g84960_i0	PRJEB20058	87752	439	9.92328	43.5631992	Breznakiella homolactica	2798577	Bacteria	Bacteria	392	2.1999999999999998e-104	NTclustered	gi\|2093987262\|gb\|CP067089.2\|	2798577	g84960	i0	84.45	168.239179954442	418	43	95	12	6	421	9084	8687	Breznakiella homolactica strain RmG30 chromosome, complete genome	blastn	73857	392	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Breznakiella	Breznakiella homolactica
26566691	26566691	PRJEB20058_P_NODE_41216_length_655_cov_5.424242_g38566_i0	PRJEB20058	41216	655	5.424242	35.5287851	Treponema	157	Bacteria	Bacteria	778	0	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g38566	i0	90.134	9.0763358778626	598	59	91	0	24	621	918017	917420	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	5945	778	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii

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