metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
3650993	3650993	PRJNA493244_P_NODE_1568223_length_227_cov_2.246988_g1545098_i0	PRJNA493244	1568223	227	2.246988	5.10066276	Treponema	157	Bacteria	Bacteria	228	3.129999999999999e-55	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g1545098	i0	86.73	59.9030837004405	211	21	91	7	1	207	430037	429830	Treponema brennaborense DSM 12168, complete genome	blastn	13598	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
5558651	5558651	PRJNA493244_P_NODE_1190505_length_332_cov_2.184502_g1167381_i0	PRJNA493244	1190505	332	2.184502	7.25254664	Treponema denticola	158	Bacteria	Bacteria	573	5.399999999999999e-159	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g1167381	i0	99.681	5.6566265060241	313	1	94	0	20	332	1927590	1927902	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	1878	573	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
7477602	7477602	PRJNA493244_P_NODE_1087466_length_370_cov_2.744337_g1064345_i0	PRJNA493244	1087466	370	2.744337	10.1540469	Treponema	157	Bacteria	Bacteria	566	1.0199999999999999e-156	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g1064345	i0	96	187.448648648649	350	11	95	2	21	370	1285404	1285750	Treponema sp. OMZ 838, complete genome	blastn	69356	566	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
8108922	8108922	PRJNA493244_P_NODE_1492687_length_244_cov_17.120219_g1469562_i0	PRJNA493244	1492687	244	17.120219	41.77333436	Treponema medium	58231	Bacteria	Bacteria	398	2.4499999999999996e-106	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g1469562	i0	99.095	186.627049180328	221	2	91	0	24	244	1012704	1012924	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	45537	398	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
12578683	12578683	PRJNA493244_P_NODE_1408510_length_266_cov_1.560976_g1385385_i0	PRJNA493244	1408510	266	1.560976	4.15219616	Treponema	157	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g1385385	i0	99.624	13	266	0	100	1	1	266	1877149	1876885	Treponema denticola strain OKA3 chromosome, complete genome	blastn	3458	484	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17677470	17677470	PRJNA493244_P_NODE_1448194_length_255_cov_7.572165_g1425069_i0	PRJNA493244	1448194	255	7.572165	19.30902075	Treponema	157	Bacteria	Bacteria	416	7.129999999999998e-112	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g1425069	i0	98.312	181.011764705882	237	4	93	0	19	255	2079610	2079374	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	46158	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18307791	18307791	PRJNA493244_P_NODE_1640235_length_212_cov_1.562914_g1617110_i0	PRJNA493244	1640235	212	1.562914	3.31337768	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	195	2.9299999999999997e-45	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g1617110	i0	92.593	0.636792452830189	135	10	64	0	1	135	598607	598473	Treponema sp. Marseille-Q4132 chromosome	blastn	135	195	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
18951350	18951350	PRJNA493244_P_NODE_1485935_length_246_cov_1.956757_g1462810_i0	PRJNA493244	1485935	246	1.956757	4.81362222	Treponema	157	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g1462810	i0	100	22.2317073170732	228	0	93	0	1	228	221324	221097	Treponema denticola strain OKA3 chromosome, complete genome	blastn	5469	422	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18951364	18951364	PRJNA493244_P_NODE_1509955_length_240_cov_29.592179_g1486830_i0	PRJNA493244	1509955	240	29.592179	71.0212296	Treponema	157	Bacteria	Bacteria	246	9.23e-61	NTclustered	gi\|1928027651\|gb\|CP061839.1\|	409322	g1486830	i0	87.215	161.379166666667	219	25	90	3	1	217	388042	387825	Treponema pedis strain KS1 chromosome, complete genome	blastn	38731	246	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
18951616	18951616	PRJNA493244_P_NODE_489955_length_738_cov_9.429838_g469988_i0	PRJNA493244	489955	738	9.429838	69.59220444	Treponema	157	Bacteria	Bacteria	1317	0	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g469988	i0	98.916	195.539295392954	738	6	100	1	1	738	326063	325328	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	144308	1319	0.998483699772555	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
19581032	19581032	PRJNA493244_P_NODE_1217776_length_323_cov_1.423664_g1194652_i0	PRJNA493244	1217776	323	1.423664	4.59843472	Treponema parvum	138851	Bacteria	Bacteria	381	3.409999999999999e-101	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g1194652	i0	88.924	185.306501547988	316	26	96	8	13	323	1517963	1517652	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	59854	381	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
19582678	19582678	PRJNA493244_P_NODE_322456_length_944_cov_1.945640_g306331_i0	PRJNA493244	322456	944	1.94564	18.3668416	Oceanispirochaeta crateris	2518645	Bacteria	Bacteria	102	9.35e-17	NTclustered	gi\|1735511476\|gb\|CP036150.1\|	2518645	g306331	i0	92.857	2.86758474576271	70	5	7	0	862	931	2574412	2574481	Oceanispirochaeta crateris strain K2 chromosome, complete genome	blastn	2707	102	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Oceanispirochaeta	Oceanispirochaeta crateris
20856493	20856493	PRJNA493244_P_NODE_1064177_length_380_cov_1.103448_g1041060_i0	PRJNA493244	1064177	380	1.103448	4.1931024	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	409	1.87e-109	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g1041060	i0	86.162	3.02894736842105	383	47	100	3	1	380	598653	599032	Treponema sp. Marseille-Q4132 chromosome	blastn	1151	409	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
20858670	20858670	PRJNA493244_P_NODE_430137_length_802_cov_2.631579_g411301_i0	PRJNA493244	430137	802	2.631579	21.10526358	Borreliella spielmanii	88916	Bacteria	Bacteria	54.7	0.022	NTclustered	gi\|2537422926\|gb\|CP124042.1\|	88916	g411301	i0	96.875	0.0399002493765586	32	1	4	0	570	601	717139	717170	Borreliella spielmanii strain Pmew chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella spielmanii
22132167	22132167	PRJNA493244_P_NODE_1444718_length_256_cov_3.425641_g1421593_i0	PRJNA493244	1444718	256	3.425641	8.76964096	Treponemataceae bacterium	2854022	Bacteria	Bacteria	340	4.44e-89	NTclustered	gi\|2814788384\|emb\|OY762953.2\|	2854022	g1421593	i0	93.45	128.52734375	229	15	89	0	1	229	1490431	1490203	MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1	blastn	32903	340	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
25326145	25326145	PRJNA493244_P_NODE_1622940_length_215_cov_5.292208_g1599815_i0	PRJNA493244	1622940	215	5.292208	11.3782472	Treponema	157	Bacteria	Bacteria	257	3.74e-64	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g1599815	i0	89.706	157.172093023256	204	17	94	4	13	215	338	538	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	33792	257	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense

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