metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
6285261	6285261	PRJNA694770_P_NODE_85085_length_248_cov_0.880000_g84791_i0	PRJNA694770	85085	248	0.88	2.1824	Treponema	157	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g84791	i0	99.194	18.0282258064516	248	2	100	0	1	248	2679387	2679634	Treponema denticola strain CD-1 chromosome, complete genome	blastn	4471	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
7054066	7054066	PRJNA694770_P_NODE_77306_length_252_cov_1.139665_g77012_i0	PRJNA694770	77306	252	1.139665	2.8719558	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	453	5.36e-123	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g77012	i0	99.206	12.9206349206349	252	0	100	2	1	252	2361026	2361275	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	3256	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
8326676	8326676	PRJNA694770_P_NODE_100627_length_240_cov_2.305389_g100333_i0	PRJNA694770	100627	240	2.305389	5.5329336	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	161	3.4399999999999996e-35	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g100333	i0	81.818	1.59583333333333	198	30	81	6	19	213	217649	217455	Leptospira sp. severe_002 chromosome 1	blastn	383	161	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
8834322	8834322	PRJNA694770_P_NODE_92727_length_244_cov_1.356725_g92433_i0	PRJNA694770	92727	244	1.356725	3.310409	Treponema	157	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g92433	i0	93.776	9.93852459016393	241	15	99	0	1	241	1530932	1531172	Treponema sp. OMZ 838, complete genome	blastn	2425	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
9603249	9603249	PRJNA694770_P_NODE_54468_length_287_cov_2.990654_g54174_i0	PRJNA694770	54468	287	2.990654	8.58317698	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	296	1.11e-75	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g54174	i0	85.315	0.996515679442509	286	42	99	0	2	287	1497369	1497654	Treponema sp. OMZ 305 chromosome, complete genome	blastn	286	296	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
13429647	13429647	PRJNA694770_P_NODE_93991_length_244_cov_0.900585_g93697_i0	PRJNA694770	93991	244	0.900585	2.1974274	Treponema socranskii	53419	Bacteria	Bacteria	311	3.29e-80	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g93697	i0	89.712	1.99180327868852	243	25	99	0	1	243	1622896	1622654	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	486	311	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
17758913	17758913	PRJNA694770_P_NODE_73574_length_258_cov_1.416216_g73280_i0	PRJNA694770	73574	258	1.416216	3.65383728	Treponema	157	Bacteria	Bacteria	411	3.36e-110	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g73280	i0	95.686	6.95348837209302	255	11	99	0	1	255	173275	173529	Treponema sp. OMZ 838, complete genome	blastn	1794	414	0.992753623188406	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
24132895	24132895	PRJNA694770_P_NODE_70879_length_262_cov_2.317460_g70585_i0	PRJNA694770	70879	262	2.31746	6.0717452	Treponema	157	Bacteria	Bacteria	368	2.09e-97	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g70585	i0	91.985	2	262	21	100	0	1	262	1012803	1012542	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	524	368	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii

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