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

26 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
835291	835291	PRJNA849172_P_NODE_143781_length_203_cov_5.923077_g143421_i0	PRJNA849172	143781	203	5.923077	12.02384631	Leptospira mgodei	3235172	Bacteria	Bacteria	176	1.01e-39	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g143421	i0	83.246	0.940886699507389	191	32	94	0	1	191	2942578	2942768	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	191	176	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
837141	837141	PRJNA849172_P_NODE_70401_length_269_cov_2.387755_g70041_i0	PRJNA849172	70401	269	2.387755	6.42306095	Treponema vincentii	69710	Bacteria	Bacteria	364	2.7899999999999998e-96	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g70041	i0	91.111	8.48327137546468	270	22	100	2	1	269	475863	476131	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	2282	364	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
2507429	2507429	PRJNA849172_P_NODE_118322_length_233_cov_3.875000_g117962_i0	PRJNA849172	118322	233	3.875	9.02875	Treponema	157	Bacteria	Bacteria	255	1.48e-63	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g117962	i0	86.58	5.86695278969957	231	31	99	0	1	231	1581569	1581339	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	1367	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
2508359	2508359	PRJNA849172_P_NODE_68082_length_271_cov_12.363636_g67722_i0	PRJNA849172	68082	271	12.363636	33.50545356	Treponema	157	Bacteria	Bacteria	490	4.44e-134	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g67722	i0	99.262	195.169741697417	271	2	100	0	1	271	216817	217087	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	52891	490	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
3385174	3385174	PRJNA849172_P_NODE_113963_length_237_cov_3.207317_g113603_i0	PRJNA849172	113963	237	3.207317	7.60134129	Treponema vincentii	69710	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g113603	i0	100	3	237	0	100	0	1	237	2572007	2571771	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	711	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
4665824	4665824	PRJNA849172_P_NODE_78164_length_261_cov_3.648936_g77804_i0	PRJNA849172	78164	261	3.648936	9.52372296	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	455	1.55e-123	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g77804	i0	98.084	9.3639846743295	261	5	100	0	1	261	23938	24198	Treponema sp. OMZ 857 chromosome, complete genome	blastn	2444	455	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
7213448	7213448	PRJNA849172_P_NODE_143886_length_203_cov_5.484615_g143526_i0	PRJNA849172	143886	203	5.484615	11.13376845	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2621705858\|emb\|OY763920.1\|	2791017	g143526	i0	86.275	0.251231527093596	51	5	25	2	117	167	1101617	1101569	MAG: Sphaerochaetaceae bacterium isolate d5506382-6fb0-4ee2-9b9e-b33663e62a62 genome assembly, chromosome: 1	blastn	51	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
7610133	7610133	PRJNA849172_P_NODE_135406_length_213_cov_6.307143_g135046_i0	PRJNA849172	135406	213	6.307143	13.43421459	Treponema	157	Bacteria	Bacteria	383	5.8499999999999996e-102	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g135046	i0	99.061	11.7276995305164	213	2	100	0	1	213	43882	43670	Treponema medium strain T19 chromosome, complete genome	blastn	2498	383	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
7610359	7610359	PRJNA849172_P_NODE_21906_length_440_cov_2.942779_g21547_i0	PRJNA849172	21906	440	2.942779	12.9482276	Treponema	157	Bacteria	Bacteria	732	0	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g21547	i0	97.436	22.4318181818182	429	11	98	0	1	429	686608	687036	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	9870	734	0.997275204359673	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
8490003	8490003	PRJNA849172_P_NODE_71087_length_268_cov_3.835897_g70727_i0	PRJNA849172	71087	268	3.835897	10.28020396	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	219	2.2899999999999998e-52	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g70727	i0	85.068	5.5410447761194	221	26	82	6	17	236	906596	906810	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	1485	219	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
9765058	9765058	PRJNA849172_P_NODE_64808_length_275_cov_3.084158_g64448_i0	PRJNA849172	64808	275	3.084158	8.4814345	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	481	2.72e-131	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g64448	i0	98.182	11.8836363636364	275	5	100	0	1	275	492143	491869	Treponema sp. OMZ 906 chromosome, complete genome	blastn	3268	481	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
11038576	11038576	PRJNA849172_P_NODE_128609_length_223_cov_8.666667_g128249_i0	PRJNA849172	128609	223	8.666667	19.32666741	Treponema brennaborense	81028	Bacteria	Bacteria	171	5.24e-38	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g128249	i0	80.804	196.533632286996	224	37	100	4	1	223	429830	430048	Treponema brennaborense DSM 12168, complete genome	blastn	43827	171	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
11040859	11040859	PRJNA849172_P_NODE_71469_length_268_cov_2.102564_g71109_i0	PRJNA849172	71469	268	2.102564	5.63487152	Treponema medium	58231	Bacteria	Bacteria	261	3.75e-65	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g71109	i0	89.372	2.35074626865672	207	22	77	0	10	216	2241678	2241472	Treponema medium strain T19 chromosome, complete genome	blastn	630	261	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
11436229	11436229	PRJNA849172_P_NODE_34389_length_350_cov_7.097473_g34030_i0	PRJNA849172	34389	350	7.097473	24.8411555	Treponema	157	Bacteria	Bacteria	457	6e-124	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g34030	i0	91.124	13.5971428571429	338	29	96	1	14	350	1417408	1417071	Treponema medium strain T19 chromosome, complete genome	blastn	4759	460	0.993478260869565	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
13591408	13591408	PRJNA849172_P_NODE_88971_length_252_cov_2.586592_g88611_i0	PRJNA849172	88971	252	2.586592	6.51821184	Treponema denticola	158	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|2265181513\|gb\|CP051634.1\|	158	g88611	i0	98.016	14.8849206349206	252	5	100	0	1	252	168817	169068	Treponema denticola strain OMZ 850 chromosome, complete genome	blastn	3751	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
14865879	14865879	PRJNA849172_P_NODE_96572_length_248_cov_1.514286_g96212_i0	PRJNA849172	96572	248	1.514286	3.75542928	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g96212	i0	98.79	1	248	3	100	0	1	248	281925	281678	Treponema sp. OMZ 906 chromosome, complete genome	blastn	248	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
15260214	15260214	PRJNA849172_P_NODE_146112_length_201_cov_4.398438_g145752_i0	PRJNA849172	146112	201	4.398438	8.84086038	Treponema	157	Bacteria	Bacteria	344	2.5799999999999998e-90	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g145752	i0	97.512	5	201	5	100	0	1	201	2578222	2578022	Treponema denticola strain CD-1 chromosome, complete genome	blastn	1005	344	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15261111	15261111	PRJNA849172_P_NODE_97192_length_248_cov_0.868571_g96832_i0	PRJNA849172	97192	248	0.868571	2.15405608	Treponema	157	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g96832	i0	97.581	3	248	6	100	0	1	248	1838356	1838603	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	744	425	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
16140161	16140161	PRJNA849172_P_NODE_78533_length_261_cov_2.085106_g78173_i0	PRJNA849172	78533	261	2.085106	5.44212666	Treponema vincentii	69710	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g78173	i0	100	8.96551724137931	261	0	100	0	1	261	2356738	2356478	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	2340	483	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
16535705	16535705	PRJNA849172_P_NODE_93653_length_249_cov_5.750000_g93293_i0	PRJNA849172	93653	249	5.75	14.3175	Leptospira	171	Bacteria	Bacteria	453	5.29e-123	NTclustered	gi\|2330606\|emb\|Z98588.1\|	172	g93293	i0	99.598	104	249	0	100	1	1	249	482	235	Leptospira biflexa 16S ribosomal RNA, mutant 3/1994	blastn	25896	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira biflexa
17412615	17412615	PRJNA849172_P_NODE_113034_length_238_cov_2.830303_g112674_i0	PRJNA849172	113034	238	2.830303	6.73612114	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	412	8.51e-111	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g112674	i0	97.899	8.98739495798319	238	5	100	0	1	238	1707797	1707560	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	2139	412	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
17412935	17412935	PRJNA849172_P_NODE_123614_length_229_cov_2.794872_g123254_i0	PRJNA849172	123614	229	2.794872	6.40025688	Treponema denticola	158	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|2265163189\|gb\|CP051302.1\|	158	g123254	i0	99.563	12.4934497816594	229	1	100	0	1	229	992232	992460	Treponema denticola strain OMZ 853 chromosome, complete genome	blastn	2861	418	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
19961047	19961047	PRJNA849172_P_NODE_119216_length_232_cov_5.257862_g118856_i0	PRJNA849172	119216	232	5.257862	12.19823984	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	372	1.3999999999999998e-98	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g118856	i0	95.671	4.00862068965517	231	10	99	0	2	232	1539991	1539761	Treponema sp. OMZ 857 chromosome, complete genome	blastn	930	372	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
21238708	21238708	PRJNA849172_P_NODE_53277_length_290_cov_1.783410_g52917_i0	PRJNA849172	53277	290	1.78341	5.171889	Treponema denticola	158	Bacteria	Bacteria	379	1.08e-100	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g52917	i0	96.121	18.9758620689655	232	9	80	0	59	290	775502	775733	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	5503	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
22511747	22511747	PRJNA849172_P_NODE_130998_length_220_cov_4.102041_g130638_i0	PRJNA849172	130998	220	4.102041	9.0244902	Treponema denticola	158	Bacteria	Bacteria	401	1.6799999999999993e-107	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g130638	i0	99.545	14.8	220	1	100	0	1	220	2521127	2520908	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	3256	401	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25061346	25061346	PRJNA849172_P_NODE_138140_length_210_cov_4.270073_g137780_i0	PRJNA849172	138140	210	4.270073	8.9671533	Treponema denticola	158	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|2265199313\|gb\|CP058624.1\|	158	g137780	i0	99.524	22.8904761904762	210	1	100	0	1	210	1524411	1524620	Treponema denticola strain OMZ 854 chromosome, complete genome	blastn	4807	383	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola

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