metadata: contig_metadata: 8 rows where bioproject = "PRJNA551951", tax_phylum = "Spirochaetota" and tax

8 rows where bioproject = "PRJNA551951", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
4951019	4951019	PRJNA551951_S_NODE_17204_length_154_cov_1.630252_g17086_i0	PRJNA551951	17204	154	1.630252	2.5105880800000002	Treponema	157	Bacteria	Bacteria	270	3.2099999999999992e-68	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g17086	i0	98.693	190.675324675325	153	1	99	1	1	152	1015609	1015457	Treponema medium strain T19 chromosome, complete genome	blastn	29364	270	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
10051198	10051198	PRJNA551951_S_NODE_10068_length_235_cov_2.780000_g9950_i0	PRJNA551951	10068	235	2.78	6.533	Treponema	157	Bacteria	Bacteria	401	1.8199999999999993e-107	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g9950	i0	97.854	72.4255319148936	233	4	99	1	1	233	2486843	2487074	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	17020	405	0.990123456790123	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
10051467	10051467	PRJNA551951_S_NODE_7368_length_300_cov_12.860377_g7250_i0	PRJNA551951	7368	300	12.860377	38.581131	Treponema	157	Bacteria	Bacteria	388	1.87e-103	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g7250	i0	91.289	186.106666666667	287	22	95	3	16	300	1285706	1285991	Treponema sp. OMZ 838, complete genome	blastn	55832	388	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
15151030	15151030	PRJNA551951_S_NODE_3472_length_496_cov_7.028200_g3360_i0	PRJNA551951	3472	496	7.0282	34.859872	Treponema	157	Bacteria	Bacteria	760	0	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g3360	i0	95.957	182.665322580645	470	15	95	4	21	489	325222	325688	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	90602	760	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18372214	18372214	PRJNA551951_S_NODE_10355_length_230_cov_2.594872_g10237_i0	PRJNA551951	10355	230	2.594872	5.9682056	Treponema denticola	158	Bacteria	Bacteria	359	1.0799999999999999e-94	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g10237	i0	98.058	18.9826086956522	206	4	90	0	1	206	1888615	1888820	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	4366	359	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18372227	18372227	PRJNA551951_S_NODE_11035_length_218_cov_1.442623_g10917_i0	PRJNA551951	11035	218	1.442623	3.14491814	Treponema vincentii	69710	Bacteria	Bacteria	110	1.13e-19	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g10917	i0	81.159	0.63302752293578	138	24	63	2	80	216	193544	193680	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	138	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22197574	22197574	PRJNA551951_S_NODE_9338_length_251_cov_2.300926_g9220_i0	PRJNA551951	9338	251	2.300926	5.77532426	Treponema socranskii	53419	Bacteria	Bacteria	449	6.899999999999999e-122	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g9220	i0	98.814	148.585657370518	253	1	100	2	1	251	906831	907083	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	37295	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
25349147	25349147	PRJNA551951_S_NODE_11420_length_212_cov_2.813559_g11302_i0	PRJNA551951	11420	212	2.813559	5.96474508	Treponema	157	Bacteria	Bacteria	355	1.27e-93	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g11302	i0	96.729	195.245283018868	214	5	100	1	1	212	1013890	1014103	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	41392	355	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium

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