metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA879314" 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
7236058	7236058	PRJNA879314_P_NODE_8206_length_247_cov_0.896552_g8156_i0	PRJNA879314	8206	247	0.896552	2.21448344	Treponema ruminis	744515	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|1996301026\|gb\|CP031518.1\|	744515	g8156	i0	79.221	0.935222672064777	231	42	92	4	19	246	224985	225212	Treponema ruminis strain RU1 chromosome, complete genome	blastn	231	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema ruminis
9785768	9785768	PRJNA879314_P_NODE_8728_length_246_cov_0.901734_g8678_i0	PRJNA879314	8728	246	0.901734	2.21826564	Treponema parvum	138851	Bacteria	Bacteria	209	1.25e-49	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g8678	i0	84.434	0.861788617886179	212	33	86	0	2	213	1579709	1579920	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	212	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
11444169	11444169	PRJNA879314_P_NODE_2849_length_291_cov_1.206422_g2799_i0	PRJNA879314	2849	291	1.206422	3.51068802	Bacteria	2	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1464584672\|gb\|CP030147.1\|	1137606	g2799	i0	100	1.01030927835052	30	0	10	0	2	31	874248	874219	Leptospira mayottensis strain MDI272 chromosome I, complete sequence	blastn	294	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mayottensis
13611536	13611536	PRJNA879314_P_NODE_7551_length_248_cov_0.891429_g7501_i0	PRJNA879314	7551	248	0.891429	2.21074392	Treponema peruense	2787628	Bacteria	Bacteria	187	5.8899999999999985e-43	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g7501	i0	81.466	8.69354838709677	232	39	93	3	13	242	1459910	1460139	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	2156	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
17436054	17436054	PRJNA879314_P_NODE_5834_length_251_cov_0.876404_g5784_i0	PRJNA879314	5834	251	0.876404	2.19977404	Treponema bryantii	163	Bacteria	Bacteria	244	3.5000000000000003e-60	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g5784	i0	85.294	1.1792828685259	238	33	94	2	15	251	386958	387194	Treponema bryantii JCM 32280 DNA, complete genome	blastn	296	244	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
18709294	18709294	PRJNA879314_P_NODE_8075_length_247_cov_0.896552_g8025_i0	PRJNA879314	8075	247	0.896552	2.21448344	Treponema bryantii	163	Bacteria	Bacteria	268	2.04e-67	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g8025	i0	86.235	1	247	34	100	0	1	247	190511	190757	Treponema bryantii JCM 32280 DNA, complete genome	blastn	247	268	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii

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