metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA688655" 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
667097	667097	PRJNA688655_P_NODE_12001_length_246_cov_0.890173_g11936_i0	PRJNA688655	12001	246	0.890173	2.18982558	Sphaerochaeta associata	1129264	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11936	i0	99.593	1	246	1	100	0	1	246	701927	701682	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	246	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
667137	667137	PRJNA688655_P_NODE_15221_length_242_cov_0.911243_g15156_i0	PRJNA688655	15221	242	0.911243	2.20520806	Sphaerochaeta associata	1129264	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g15156	i0	99.587	1	242	1	100	0	1	242	60855	60614	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	242	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
667190	667190	PRJNA688655_P_NODE_4621_length_303_cov_1.339130_g4556_i0	PRJNA688655	4621	303	1.33913	4.0575639	Sphaerochaeta associata	1129264	Bacteria	Bacteria	560	3.79e-155	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g4556	i0	100	1	303	0	100	0	1	303	1823388	1823086	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	303	560	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
1943192	1943192	PRJNA688655_P_NODE_5262_length_290_cov_1.419355_g5197_i0	PRJNA688655	5262	290	1.419355	4.1161295	Sphaerochaeta associata	1129264	Bacteria	Bacteria	525	1.32e-144	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g5197	i0	99.31	1	290	2	100	0	1	290	2023658	2023947	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	290	525	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
3217981	3217981	PRJNA688655_P_NODE_11443_length_247_cov_0.885057_g11378_i0	PRJNA688655	11443	247	0.885057	2.18609079	Sphaerochaeta associata	1129264	Bacteria	Bacteria	438	1.4699999999999995e-118	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11378	i0	98.78	0.995951417004049	246	3	99	0	1	246	1441017	1441262	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	246	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
4495202	4495202	PRJNA688655_P_NODE_7504_length_253_cov_1.322222_g7439_i0	PRJNA688655	7504	253	1.322222	3.34522166	Sphaerochaeta associata	1129264	Bacteria	Bacteria	429	9.079999999999999e-116	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g7439	i0	97.233	1	253	7	100	0	1	253	1665924	1665672	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	253	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
5770879	5770879	PRJNA688655_P_NODE_9565_length_249_cov_0.875000_g9500_i0	PRJNA688655	9565	249	0.875	2.17875	Sphaerochaeta associata	1129264	Bacteria	Bacteria	335	2e-87	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g9500	i0	91.165	1	249	19	100	1	1	249	3042334	3042089	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	249	335	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
7045682	7045682	PRJNA688655_P_NODE_10126_length_248_cov_0.880000_g10061_i0	PRJNA688655	10126	248	0.88	2.1824	Sphaerochaeta associata	1129264	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g10061	i0	99.194	40.3266129032258	248	2	100	0	1	248	39846	40093	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	10001	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
10871199	10871199	PRJNA688655_P_NODE_16689_length_241_cov_0.916667_g16624_i0	PRJNA688655	16689	241	0.916667	2.20916747	Sphaerochaeta associata	1129264	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g16624	i0	98.755	1	241	3	100	0	1	241	48062	47822	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	241	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
12146549	12146549	PRJNA688655_P_NODE_3370_length_334_cov_1.111111_g3305_i0	PRJNA688655	3370	334	1.111111	3.71111074	Sphaerochaeta associata	1129264	Bacteria	Bacteria	592	1.4999999999999997e-164	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g3305	i0	99.69	6.7814371257485	323	1	98	0	1	323	331517	331839	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	2265	592	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
12146622	12146622	PRJNA688655_P_NODE_9710_length_249_cov_0.875000_g9645_i0	PRJNA688655	9710	249	0.875	2.17875	Sphaerochaeta associata	1129264	Bacteria	Bacteria	411	3.2299999999999996e-110	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g9645	i0	96.386	2.10843373493976	249	9	100	0	1	249	1359225	1359473	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	525	411	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
13421003	13421003	PRJNA688655_P_NODE_10211_length_248_cov_0.880000_g10146_i0	PRJNA688655	10211	248	0.88	2.1824	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	198	2.7199999999999993e-46	NTclustered	gi\|2621785415\|emb\|OY781873.1\|	886478	g10146	i0	84.058	1.58870967741935	207	31	83	2	11	216	415523	415318	MAG: uncultured Sphaerochaeta sp. isolate d3c3752c-658c-4035-93a5-350d78b9f8a8 genome assembly, chromosome: 1	blastn	394	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
13421010	13421010	PRJNA688655_P_NODE_10551_length_248_cov_0.880000_g10486_i0	PRJNA688655	10551	248	0.88	2.1824	Sphaerochaeta associata	1129264	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g10486	i0	95.968	1	248	10	100	0	1	248	2571453	2571206	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	248	403	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
15969918	15969918	PRJNA688655_P_NODE_5713_length_282_cov_1.224880_g5648_i0	PRJNA688655	5713	282	1.22488	3.4541616	Sphaerochaeta associata	1129264	Bacteria	Bacteria	359	1.37e-94	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g5648	i0	89.68	0.99645390070922	281	29	99	0	1	281	442757	443037	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	281	359	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
17245123	17245123	PRJNA688655_P_NODE_3334_length_335_cov_1.175573_g3269_i0	PRJNA688655	3334	335	1.175573	3.93816955	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	531	3.33e-146	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g3269	i0	95.224	12.0388059701493	335	16	100	0	1	335	166284	165950	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	4033	531	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
17245182	17245182	PRJNA688655_P_NODE_8394_length_250_cov_1.740113_g8329_i0	PRJNA688655	8394	250	1.740113	4.3502825	Sphaerochaeta associata	1129264	Bacteria	Bacteria	215	2.73e-51	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g8329	i0	82.988	1.372	241	38	96	3	9	248	3279383	3279145	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	343	215	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
18519161	18519161	PRJNA688655_P_NODE_11475_length_247_cov_0.885057_g11410_i0	PRJNA688655	11475	247	0.885057	2.18609079	Sphaerochaeta associata	1129264	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11410	i0	100	3.72064777327935	247	0	100	0	1	247	3356505	3356751	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	919	457	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
18519173	18519173	PRJNA688655_P_NODE_12855_length_245_cov_0.895349_g12790_i0	PRJNA688655	12855	245	0.895349	2.19360505	Sphaerochaeta associata	1129264	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g12790	i0	99.592	1	245	1	100	0	1	245	2026488	2026732	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	245	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
18519271	18519271	PRJNA688655_P_NODE_5135_length_293_cov_0.945455_g5070_i0	PRJNA688655	5135	293	0.945455	2.77018315	Sphaerochaeta associata	1129264	Bacteria	Bacteria	503	6.24e-138	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g5070	i0	97.611	1	293	7	100	0	1	293	3180301	3180009	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	293	503	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
19794033	19794033	PRJNA688655_P_NODE_12596_length_245_cov_0.895349_g12531_i0	PRJNA688655	12596	245	0.895349	2.19360505	Sphaerochaeta associata	1129264	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g12531	i0	99.184	2.97142857142857	245	2	100	0	1	245	3370203	3369959	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	728	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
19794117	19794117	PRJNA688655_P_NODE_4016_length_317_cov_1.172131_g3951_i0	PRJNA688655	4016	317	1.172131	3.71565527	Sphaerochaeta associata	1129264	Bacteria	Bacteria	569	6.629999999999998e-158	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g3951	i0	99.054	1	317	3	100	0	1	317	219368	219684	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	317	569	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
22344445	22344445	PRJNA688655_P_NODE_13638_length_244_cov_0.900585_g13573_i0	PRJNA688655	13638	244	0.900585	2.1974274	Sphaerochaeta associata	1129264	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g13573	i0	99.59	1	244	1	100	0	1	244	1832200	1832443	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	244	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
22344475	22344475	PRJNA688655_P_NODE_15598_length_242_cov_0.911243_g15533_i0	PRJNA688655	15598	242	0.911243	2.20520806	Spirochaetia bacterium	2053615	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|2621717749\|emb\|OY776146.1\|	2053615	g15533	i0	87.5	40.995867768595	160	16	66	4	81	240	2783607	2783452	MAG: Spirochaetia bacterium isolate efeffb62-48c8-43b6-be4a-4368b18f5a81 genome assembly, chromosome: 1	blastn	9921	182	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
23620035	23620035	PRJNA688655_P_NODE_4319_length_310_cov_0.974684_g4254_i0	PRJNA688655	4319	310	0.974684	3.0215204	Sphaerochaeta associata	1129264	Bacteria	Bacteria	462	1.13e-125	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g4254	i0	93.548	1.97741935483871	310	20	100	0	1	310	2063872	2063563	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	613	462	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
24893202	24893202	PRJNA688655_P_NODE_10460_length_248_cov_0.880000_g10395_i0	PRJNA688655	10460	248	0.88	2.1824	Parasphaerochaeta coccoides	273376	Bacteria	Bacteria	182	2.74e-41	NTclustered	gi\|329747886\|gb\|CP002659.1\|	760011	g10395	i0	80.081	33.3951612903226	246	48	99	1	2	246	300660	300415	Sphaerochaeta coccoides DSM 17374, complete genome	blastn	8282	182	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Parasphaerochaeta	Parasphaerochaeta coccoides
24893207	24893207	PRJNA688655_P_NODE_10660_length_248_cov_0.880000_g10595_i0	PRJNA688655	10660	248	0.88	2.1824	Sphaerochaeta associata	1129264	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g10595	i0	100	1	248	0	100	0	1	248	2808051	2808298	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	248	459	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
24893290	24893290	PRJNA688655_P_NODE_15540_length_242_cov_0.911243_g15475_i0	PRJNA688655	15540	242	0.911243	2.20520806	Sphaerochaeta associata	1129264	Bacteria	Bacteria	217	7.3e-52	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g15475	i0	82.917	0.991735537190083	240	41	99	0	1	240	909720	909959	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	240	217	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
24893413	24893413	PRJNA688655_P_NODE_9900_length_249_cov_0.875000_g9835_i0	PRJNA688655	9900	249	0.875	2.17875	Sphaerochaeta associata	1129264	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g9835	i0	100	1	249	0	100	0	1	249	832015	831767	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	249	460	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
25403390	25403390	PRJNA688655_P_NODE_12960_length_245_cov_0.895349_g12895_i0	PRJNA688655	12960	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	448	2.41e-121	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g12895	i0	99.592	128.375510204082	245	1	100	0	1	245	2037212	2036968	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	31452	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae

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