metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA879067" 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
855722	855722	PRJNA879067_P_NODE_62741_length_431_cov_2.966480_g59256_i0	PRJNA879067	62741	431	2.96648	12.7855288	Leptospira cinconiae	3235173	Bacteria	Bacteria	732	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g59256	i0	99.502	178.983758700696	402	2	93	0	30	431	753237	753638	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	77142	732	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
2131723	2131723	PRJNA879067_P_NODE_90402_length_297_cov_1.375000_g86916_i0	PRJNA879067	90402	297	1.375	4.08375	Brachyspira murdochii	84378	Bacteria	Bacteria	499	8.2e-137	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g86916	i0	99.634	1.01683501683502	273	1	92	0	25	297	514628	514900	Brachyspira murdochii DSM 12563, complete genome	blastn	302	499	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
3404664	3404664	PRJNA879067_P_NODE_108583_length_244_cov_0.900585_g105097_i0	PRJNA879067	108583	244	0.900585	2.1974274	Brachyspira murdochii	84378	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g105097	i0	94.737	0.418032786885246	38	2	16	0	201	238	3184156	3184119	Brachyspira murdochii DSM 12563, complete genome	blastn	102	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
3790788	3790788	PRJNA879067_P_NODE_21723_length_955_cov_21.062358_g18715_i0	PRJNA879067	21723	955	21.062358	201.1455189	root	1	Root_unresolved	Root_unresolved	54.7	0.027	NTclustered	gi\|2537508579\|gb\|CP124112.1\|	64897	g18715	i0	100	0.0910994764397906	29	0	3	0	829	857	99	127	Borreliella bissettiae strain Pgeb plasmid lp54, complete sequence	blastn	87	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella bissettiae
4684270	4684270	PRJNA879067_P_NODE_71604_length_379_cov_7.196078_g68119_i0	PRJNA879067	71604	379	7.196078	27.27313562	Treponema peruense	2787628	Bacteria	Bacteria	640	6.059999999999999e-179	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g68119	i0	99.157	142.390501319261	356	1	94	2	1	355	1009822	1009468	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	53966	640	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
5958791	5958791	PRJNA879067_P_NODE_58845_length_457_cov_4.216146_g55360_i0	PRJNA879067	58845	457	4.216146	19.26778722	Leptospira cinconiae	3235173	Bacteria	Bacteria	486	1.0299999999999999e-132	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g55360	i0	87.215	0.958424507658643	438	43	93	6	31	457	3490218	3489783	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	438	486	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8509372	8509372	PRJNA879067_P_NODE_93887_length_284_cov_1.497630_g90401_i0	PRJNA879067	93887	284	1.49763	4.2532692	Leptospira cinconiae	3235173	Bacteria	Bacteria	342	1.3899999999999999e-89	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g90401	i0	90.945	0.894366197183099	254	23	89	0	3	256	39076	38823	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	254	342	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8509434	8509434	PRJNA879067_P_NODE_95927_length_277_cov_1.465686_g92441_i0	PRJNA879067	95927	277	1.465686	4.05995022	Leptospira cinconiae	3235173	Bacteria	Bacteria	291	4.96e-74	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g92441	i0	85.56	1	277	40	100	0	1	277	3365652	3365376	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	277	291	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8892179	8892179	PRJNA879067_P_NODE_80607_length_336_cov_2.973384_g77121_i0	PRJNA879067	80607	336	2.973384	9.99057024	Treponema	157	Bacteria	Bacteria	337	7.81e-88	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g77121	i0	87.586	96.5119047619048	290	36	86	0	14	303	290	1	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	32428	340	0.991176470588235	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
11059302	11059302	PRJNA879067_P_NODE_6229_length_2016_cov_29.138446_g4624_i0	PRJNA879067	6229	2016	29.138446	587.43107136	Treponema denticola	158	Bacteria	Bacteria	3607	0	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g4624	i0	99.008	28.6666666666667	2016	15	100	4	1	2016	2050029	2052039	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	57792	3607	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
12333386	12333386	PRJNA879067_P_NODE_20590_length_990_cov_45.406761_g17638_i0	PRJNA879067	20590	990	45.406761	449.5269339	Leptospira cinconiae	3235173	Bacteria	Bacteria	963	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g17638	i0	84.861	0.980808080808081	971	129	97	17	26	987	3255592	3256553	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	971	963	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
12334334	12334334	PRJNA879067_P_NODE_48150_length_540_cov_33.520343_g44672_i0	PRJNA879067	48150	540	33.520343	181.0098522	Borreliella garinii	29519	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2646141648\|gb\|CP117840.1\|	29519	g44672	i0	100	0.0555555555555556	30	0	6	0	319	348	3935	3964	Borreliella garinii strain 17-63N1 plasmid p_cp26, complete sequence	blastn	30	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
12718812	12718812	PRJNA879067_P_NODE_76110_length_356_cov_4.162544_g72624_i0	PRJNA879067	76110	356	4.162544	14.81865664	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	2.01e-4	NTclustered	gi\|2612877174\|gb\|CP136243.1\|	173	g72624	i0	100	40.4494382022472	32	0	9	0	325	356	2183964	2183995	Leptospira interrogans strain CUDO5 chromosome I, complete sequence	blastn	14400	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
12718918	12718918	PRJNA879067_P_NODE_90110_length_298_cov_1.711111_g86624_i0	PRJNA879067	90110	298	1.711111	5.09911078	root	1	Root_unresolved	Root_unresolved	52.8	0.028	NTclustered	gi\|225213769\|gb\|CP001357.1\|	565034	g86624	i0	100	0.187919463087248	28	0	9	0	198	225	2151293	2151320	Brachyspira hyodysenteriae WA1, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
19982627	19982627	PRJNA879067_P_NODE_73596_length_369_cov_2.050676_g70111_i0	PRJNA879067	73596	369	2.050676	7.56699444	Treponema peruense	2787628	Bacteria	Bacteria	244	5.389999999999999e-60	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g70111	i0	80.757	1.21138211382114	317	57	85	4	28	342	1354837	1355151	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	447	244	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
22531432	22531432	PRJNA879067_P_NODE_31058_length_746_cov_6.332838_g27727_i0	PRJNA879067	31058	746	6.332838	47.24297148	Leptospira cinconiae	3235173	Bacteria	Bacteria	1168	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g27727	i0	95.027	72.3793565683646	744	36	99	1	1	744	2680210	2680952	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	53995	1168	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
22916864	22916864	PRJNA879067_P_NODE_71598_length_379_cov_9.258170_g68113_i0	PRJNA879067	71598	379	9.25817	35.0884643	Treponema	157	Bacteria	Bacteria	643	4.679999999999999e-180	NTclustered	gi\|2189493055\|gb\|CP091738.1\|	167	g68113	i0	100	58.3324538258575	348	0	92	0	1	348	286643	286296	MAG: Treponema succinifaciens isolate nC27_bin.114.fa chromosome	blastn	22108	643	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
22916883	22916883	PRJNA879067_P_NODE_74018_length_367_cov_1.571429_g70533_i0	PRJNA879067	74018	367	1.571429	5.76714443	Sphaerochaeta	399320	Bacteria	Bacteria	326	1.86e-84	NTclustered	gi\|324025087\|gb\|CP002541.1\|	158189	g70533	i0	85.761	106.359673024523	309	42	84	2	37	344	1241515	1241822	Sphaerochaeta globosa str. Buddy, complete genome	blastn	39034	326	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta globosa
25082286	25082286	PRJNA879067_P_NODE_84680_length_319_cov_2.890244_g81194_i0	PRJNA879067	84680	319	2.890244	9.21987836	Treponema succinifaciens	167	Bacteria	Bacteria	545	1.13e-150	NTclustered	gi\|328447254\|gb\|CP002631.1\|	869209	g81194	i0	100	1.85266457680251	295	0	92	0	1	295	1050075	1049781	Treponema succinifaciens DSM 2489, complete genome	blastn	591	545	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens

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