metadata: contig_metadata: 26 rows where bioproject = "PRJNA438687" and tax

26 rows where bioproject = "PRJNA438687" 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
435356	435356	PRJNA438687_S_NODE_5641_length_186_cov_1.887417_g5551_i0	PRJNA438687	5641	186	1.887417	3.51059562	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	311	2.38e-80	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g5551	i0	96.774	163.913978494624	186	6	100	0	1	186	1963037	1962852	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	30488	311	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
1091134	1091134	PRJNA438687_S_NODE_181_length_610_cov_3.090435_g121_i0	PRJNA438687	181	610	3.090435	18.8516535	Treponema	157	Bacteria	Bacteria	658	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g121	i0	86.504	194.088524590164	615	64	99	18	5	610	2078791	2078187	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	118394	664	0.990963855421687	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
1710169	1710169	PRJNA438687_S_NODE_3802_length_228_cov_5.875648_g3712_i0	PRJNA438687	3802	228	5.875648	13.39647744	Treponema phagedenis	162	Bacteria	Bacteria	381	2.2799999999999994e-101	NTclustered	gi\|1732601887\|gb\|CP042818.1\|	162	g3712	i0	98.165	178.087719298246	218	4	96	0	11	228	2503212	2502995	Treponema phagedenis strain B43.1 chromosome, complete genome	blastn	40604	381	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
2985936	2985936	PRJNA438687_S_NODE_163_length_622_cov_9.005111_g109_i0	PRJNA438687	163	622	9.005111	56.01179042	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	924	0	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g109	i0	93.579	189.811897106109	623	35	99	5	2	621	208754	209374	Treponema sp. OMZ 857 chromosome, complete genome	blastn	118063	924	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
3642185	3642185	PRJNA438687_S_NODE_563_length_440_cov_94.466667_g478_i0	PRJNA438687	563	440	94.466667	415.6533348	Treponema	157	Bacteria	Bacteria	484	3.5399999999999996e-132	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g478	i0	98.893	168.788636363636	271	3	62	0	1	271	217086	216816	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	74267	484	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
5539000	5539000	PRJNA438687_S_NODE_3825_length_227_cov_23.125000_g3735_i0	PRJNA438687	3825	227	23.125	52.49375	Treponema sp. OMZ 857	1643513	Bacteria	Bacteria	285	1.83e-72	NTclustered	gi\|2265110357\|gb\|CP051147.1\|	1643513	g3735	i0	89.427	194.409691629956	227	22	99	2	2	227	208286	208511	Treponema sp. OMZ 857 chromosome, complete genome	blastn	44131	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 857
5539026	5539026	PRJNA438687_S_NODE_505_length_453_cov_13.691388_g422_i0	PRJNA438687	505	453	13.691388	62.02198764	Spirochaeta aurantia	147	Bacteria	Bacteria	651	0	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g422	i0	92.747	75.1258278145695	455	25	99	8	1	451	3393	3843	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	34032	651	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
6194193	6194193	PRJNA438687_S_NODE_2245_length_294_cov_5.200772_g2155_i0	PRJNA438687	2245	294	5.200772	15.29026968	Treponema	157	Bacteria	Bacteria	309	1.4700000000000002e-79	NTclustered	gi\|3132611\|gb\|AF061347.1\|AF061347	76133	g2155	i0	86.316	80.6190476190476	285	37	97	2	11	294	217	500	Treponema sp. I:Q:AT20 16S ribosomal RNA gene, complete sequence	blastn	23702	309	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:Q:AT20
6813046	6813046	PRJNA438687_S_NODE_266_length_557_cov_14.986590_g194_i0	PRJNA438687	266	557	14.98659	83.4753063	Spirochaeta aurantia	147	Bacteria	Bacteria	850	0	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g194	i0	94.414	58.1202872531418	555	28	99	3	5	557	2481	1928	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	32373	850	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
8088491	8088491	PRJNA438687_S_NODE_2867_length_264_cov_2.362445_g2777_i0	PRJNA438687	2867	264	2.362445	6.2368548	Treponema putidum	221027	Bacteria	Bacteria	270	6.119999999999999e-68	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g2777	i0	85.502	26.5416666666667	269	28	100	9	1	264	1557534	1557272	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	7007	270	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
9363276	9363276	PRJNA438687_S_NODE_228_length_581_cov_6.168498_g163_i0	PRJNA438687	228	581	6.168498	35.83897338	Treponema medium	58231	Bacteria	Bacteria	433	1.75e-116	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g163	i0	94.662	110.344234079174	281	12	48	3	303	580	1014339	1014619	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	64110	433	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
9363362	9363362	PRJNA438687_S_NODE_5648_length_186_cov_1.344371_g5558_i0	PRJNA438687	5648	186	1.344371	2.50053006	Treponema parvum	138851	Bacteria	Bacteria	211	2.48e-50	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g5558	i0	87.234	116.774193548387	188	20	100	4	1	186	1516819	1516634	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	21720	211	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
10019407	10019407	PRJNA438687_S_NODE_7788_length_155_cov_1.483333_g7698_i0	PRJNA438687	7788	155	1.483333	2.29916615	Treponema	157	Bacteria	Bacteria	237	3.2800000000000004e-58	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g7698	i0	94.194	25.7483870967742	155	9	100	0	1	155	907441	907287	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	3991	237	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
10639138	10639138	PRJNA438687_S_NODE_1809_length_316_cov_16.245552_g1719_i0	PRJNA438687	1809	316	16.245552	51.33594432	Spirochaeta aurantia	147	Bacteria	Bacteria	566	8.549999999999998e-157	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1719	i0	99.048	260.379746835443	315	3	99	0	2	316	2774	3088	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	82280	566	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
11294396	11294396	PRJNA438687_S_NODE_8029_length_152_cov_2.017094_g7939_i0	PRJNA438687	8029	152	2.017094	3.06598288	Treponema	157	Bacteria	Bacteria	156	9.21e-34	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g7939	i0	85.906	101.559210526316	149	17	98	3	1	149	1013868	1014012	Treponema medium strain T19 chromosome, complete genome	blastn	15437	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
11913987	11913987	PRJNA438687_S_NODE_1230_length_355_cov_9.009375_g1140_i0	PRJNA438687	1230	355	9.009375	31.98328125	Spirochaeta aurantia	147	Bacteria	Bacteria	444	4.74e-120	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1140	i0	95.668	95.9323943661972	277	10	78	2	80	355	2203	1928	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	34056	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
11914003	11914003	PRJNA438687_S_NODE_1750_length_319_cov_5.573944_g1660_i0	PRJNA438687	1750	319	5.573944	17.78088136	Entomospira nematocerorum	2719987	Bacteria	Bacteria	246	1.28e-60	NTclustered	gi\|2446641004\|gb\|CP118168.1\|	2719987	g1660	i0	85.83	298.915360501567	247	18	77	13	4	250	323439	323668	Entomospira nematocerorum strain BR208 chromosome	blastn	95354	246	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Entomospira	Entomospira nematocerorum
15118949	15118949	PRJNA438687_S_NODE_3072_length_255_cov_9.050000_g2982_i0	PRJNA438687	3072	255	9.05	23.0775	Treponema	157	Bacteria	Bacteria	372	1.57e-98	NTclustered	gi\|960884853\|gb\|KT192148.1\|	58231	g2982	i0	98.122	92.6980392156863	213	4	84	0	43	255	1	213	Treponema medium strain OMZ 805 16S ribosomal RNA gene, complete sequence	blastn	23638	372	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
15119030	15119030	PRJNA438687_S_NODE_6932_length_165_cov_18.792308_g6842_i0	PRJNA438687	6932	165	18.792308	31.0073082	Treponema	157	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|2419353348\|gb\|CP115139.1\|	160	g6842	i0	99.39	192.824242424242	164	1	99	0	1	164	235768	235931	Treponema pallidum strain ARG66248H1 chromosome	blastn	31816	300	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pallidum
16393786	16393786	PRJNA438687_S_NODE_5813_length_183_cov_2.310811_g5723_i0	PRJNA438687	5813	183	2.310811	4.22878413	Treponema	157	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|6049688\|gb\|AF182835.1\|AF182835	105289	g5723	i0	97.814	99.8852459016394	183	4	100	0	1	183	1388	1206	Treponema sp. 3:G:BB003 16S ribosomal RNA gene, partial sequence	blastn	18279	316	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. 3:G:BB003
17012659	17012659	PRJNA438687_S_NODE_5194_length_194_cov_16.622642_g5104_i0	PRJNA438687	5194	194	16.622642	32.24792548	Spirochaeta aurantia	147	Bacteria	Bacteria	259	9.19e-65	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g5104	i0	91.146	161.994845360825	192	15	98	2	1	191	3361	3551	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	31427	259	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
17668914	17668914	PRJNA438687_S_NODE_614_length_432_cov_7.088161_g526_i0	PRJNA438687	614	432	7.088161	30.62085552	Bacteria	2	Bacteria	Bacteria	470	9.71e-128	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g526	i0	86.512	211.814814814815	430	54	99	4	5	432	1016450	1016023	Treponema medium strain T19 chromosome, complete genome	blastn	91504	470	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
18942664	18942664	PRJNA438687_S_NODE_5775_length_183_cov_82.250000_g5685_i0	PRJNA438687	5775	183	82.25	150.5175	Bacteria	2	Bacteria	Bacteria	255	1.11e-63	NTclustered	gi\|1066933105\|gb\|CP015217.1\|	2564040	g5685	i0	91.803	190.994535519126	183	15	100	0	1	183	803259	803441	Leptospira tipperaryensis strain GWTS #1 chromosome 1, complete sequence	blastn	34952	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira tipperaryensis
23387459	23387459	PRJNA438687_S_NODE_1959_length_308_cov_11.490842_g1869_i0	PRJNA438687	1959	308	11.490842	35.39179336	Spirochaeta aurantia	147	Bacteria	Bacteria	514	3.05e-141	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1869	i0	96.753	404.928571428571	308	10	100	0	1	308	2502	2809	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	124718	514	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
23387460	23387460	PRJNA438687_S_NODE_1999_length_305_cov_12.170370_g1909_i0	PRJNA438687	1999	305	12.17037	37.1196285	Spirochaeta aurantia	147	Bacteria	Bacteria	525	1.39e-144	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1909	i0	97.705	611.039344262295	305	7	100	0	1	305	3091	3395	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	186367	525	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
24661539	24661539	PRJNA438687_S_NODE_3020_length_257_cov_24.112613_g2930_i0	PRJNA438687	3020	257	24.112613	61.96941541	Spirochaeta aurantia	147	Bacteria	Bacteria	448	2.5499999999999995e-121	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g2930	i0	98.062	118.801556420233	258	4	100	1	1	257	4486	4229	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	30532	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia

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