metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA688352" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA688352" 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
666900	666900	PRJNA688352_P_NODE_7181_length_251_cov_0.865169_g7078_i0	PRJNA688352	7181	251	0.865169	2.17157419	Sphaerochaeta associata	1129264	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g7078	i0	99.203	1	251	2	100	0	1	251	1299851	1300101	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	251	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
1942915	1942915	PRJNA688352_P_NODE_9102_length_247_cov_0.885057_g8999_i0	PRJNA688352	9102	247	0.885057	2.18609079	Sphaerochaeta associata	1129264	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g8999	i0	97.541	0.987854251012146	244	6	99	0	4	247	1997159	1996916	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	244	418	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
1942926	1942926	PRJNA688352_P_NODE_9802_length_246_cov_0.890173_g9699_i0	PRJNA688352	9802	246	0.890173	2.18982558	Sphaerochaeta associata	1129264	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g9699	i0	99.593	1.9349593495935	246	1	100	0	1	246	1806556	1806311	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	476	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
3217748	3217748	PRJNA688352_P_NODE_12163_length_241_cov_0.916667_g12060_i0	PRJNA688352	12163	241	0.916667	2.20916747	Sphaerochaeta associata	1129264	Bacteria	Bacteria	298	2.52e-76	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g12060	i0	89.121	0.991701244813278	239	26	99	0	1	239	1960466	1960228	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	239	298	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
3217759	3217759	PRJNA688352_P_NODE_2623_length_374_cov_1.534884_g2520_i0	PRJNA688352	2623	374	1.534884	5.74046616	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	396	1.43e-105	NTclustered	gi\|2621785415\|emb\|OY781873.1\|	886478	g2520	i0	87.356	0.93048128342246	348	40	93	3	1	346	3258266	3257921	MAG: uncultured Sphaerochaeta sp. isolate d3c3752c-658c-4035-93a5-350d78b9f8a8 genome assembly, chromosome: 1	blastn	348	396	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
3217795	3217795	PRJNA688352_P_NODE_6883_length_253_cov_1.711111_g6780_i0	PRJNA688352	6883	253	1.711111	4.32911083	Sphaerochaeta associata	1129264	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g6780	i0	99.605	1	253	1	100	0	1	253	2620396	2620648	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	253	462	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
5770507	5770507	PRJNA688352_P_NODE_3825_length_322_cov_1.172691_g3722_i0	PRJNA688352	3825	322	1.172691	3.77606502	Sphaerochaeta associata	1129264	Bacteria	Bacteria	579	1.1199999999999997e-160	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g3722	i0	99.068	1	322	3	100	0	1	322	1815695	1815374	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	322	579	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
7045492	7045492	PRJNA688352_P_NODE_11346_length_243_cov_0.905882_g11243_i0	PRJNA688352	11346	243	0.905882	2.20129326	Sphaerochaeta associata	1129264	Bacteria	Bacteria	416	6.739999999999998e-112	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11243	i0	97.531	2.83950617283951	243	6	100	0	1	243	1559945	1560187	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	690	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
7045550	7045550	PRJNA688352_P_NODE_8146_length_249_cov_0.875000_g8043_i0	PRJNA688352	8146	249	0.875	2.17875	Sphaerochaeta associata	1129264	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g8043	i0	98.394	2.98795180722892	249	4	100	0	1	249	2164749	2164997	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	744	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
7045562	7045562	PRJNA688352_P_NODE_9306_length_247_cov_0.885057_g9203_i0	PRJNA688352	9306	247	0.885057	2.18609079	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	235	2.07e-57	NTclustered	gi\|2621785415\|emb\|OY781873.1\|	886478	g9203	i0	86.697	125.546558704453	218	21	87	8	4	218	1914059	1914271	MAG: uncultured Sphaerochaeta sp. isolate d3c3752c-658c-4035-93a5-350d78b9f8a8 genome assembly, chromosome: 1	blastn	31010	235	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
12146239	12146239	PRJNA688352_P_NODE_11830_length_242_cov_0.911243_g11727_i0	PRJNA688352	11830	242	0.911243	2.20520806	Treponemataceae bacterium	2854022	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|2814788384\|emb\|OY762953.2\|	2854022	g11727	i0	82.143	0.925619834710744	224	40	93	0	19	242	1790093	1789870	MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1	blastn	224	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
12146241	12146241	PRJNA688352_P_NODE_11950_length_242_cov_0.911243_g11847_i0	PRJNA688352	11950	242	0.911243	2.20520806	Sphaerochaeta associata	1129264	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11847	i0	99.587	6.32231404958678	242	1	100	0	1	242	2285841	2286082	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	1530	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
12146242	12146242	PRJNA688352_P_NODE_11970_length_242_cov_0.911243_g11867_i0	PRJNA688352	11970	242	0.911243	2.20520806	Parasphaerochaeta coccoides	273376	Bacteria	Bacteria	346	8.930000000000001e-91	NTclustered	gi\|329747886\|gb\|CP002659.1\|	760011	g11867	i0	92.562	187.669421487603	242	17	100	1	1	242	771153	771393	Sphaerochaeta coccoides DSM 17374, complete genome	blastn	45416	346	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Parasphaerochaeta	Parasphaerochaeta coccoides
12146297	12146297	PRJNA688352_P_NODE_8350_length_249_cov_0.875000_g8247_i0	PRJNA688352	8350	249	0.875	2.17875	Sphaerochaeta associata	1129264	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g8247	i0	98.79	2.98393574297189	248	3	99	0	2	249	2598685	2598932	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	743	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
13420850	13420850	PRJNA688352_P_NODE_5111_length_288_cov_1.074419_g5008_i0	PRJNA688352	5111	288	1.074419	3.09432672	Sphaerochaeta globosa	1131703	Bacteria	Bacteria	268	2.43e-67	NTclustered	gi\|324025087\|gb\|CP002541.1\|	158189	g5008	i0	83.566	0.993055555555556	286	47	99	0	3	288	115909	116194	Sphaerochaeta globosa str. Buddy, complete genome	blastn	286	268	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta globosa
15969581	15969581	PRJNA688352_P_NODE_3893_length_320_cov_1.384615_g3790_i0	PRJNA688352	3893	320	1.384615	4.430768	Sphaerochaeta associata	1129264	Bacteria	Bacteria	569	6.699999999999998e-158	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g3790	i0	98.75	1.896875	320	4	100	0	1	320	1150599	1150918	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	607	569	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
18518915	18518915	PRJNA688352_P_NODE_10355_length_245_cov_0.895349_g10252_i0	PRJNA688352	10355	245	0.895349	2.19360505	Sphaerochaeta associata	1129264	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g10252	i0	98.367	1	245	4	100	0	1	245	2152300	2152544	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	245	431	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
19793763	19793763	PRJNA688352_P_NODE_10716_length_244_cov_0.900585_g10613_i0	PRJNA688352	10716	244	0.900585	2.1974274	Sphaerochaeta associata	1129264	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g10613	i0	100	1.99590163934426	244	0	100	0	1	244	576284	576041	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	487	451	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
21069273	21069273	PRJNA688352_P_NODE_11137_length_243_cov_0.905882_g11034_i0	PRJNA688352	11137	243	0.905882	2.20129326	Sphaerochaeta associata	1129264	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g11034	i0	99.177	1	243	2	100	0	1	243	2530655	2530897	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	243	438	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
21069302	21069302	PRJNA688352_P_NODE_3377_length_338_cov_1.090566_g3274_i0	PRJNA688352	3377	338	1.090566	3.68611308	Sphaerochaeta associata	1129264	Bacteria	Bacteria	481	3.43e-131	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g3274	i0	92.308	1	338	26	100	0	1	338	2206735	2207072	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	338	481	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
21579025	21579025	PRJNA688352_P_NODE_8537_length_248_cov_0.880000_g8434_i0	PRJNA688352	8537	248	0.88	2.1824	Sphaerochaeta	399320	Bacteria	Bacteria	250	7.41e-62	NTclustered	gi\|359350094\|gb\|CP003155.1\|	158190	g8434	i0	84.959	1.98387096774194	246	37	99	0	3	248	3088750	3088995	Sphaerochaeta pleomorpha str. Grapes, complete genome	blastn	492	250	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta pleomorpha

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