metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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
5426790	5426790	PRJNA1196438_P_NODE_77005_length_240_cov_3.502994_g76578_i0	PRJNA1196438	77005	240	3.502994	8.4071856	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g76578	i0	97.5	10	240	6	100	0	1	240	1710629	1710868	Treponema sp. OMZ 305 chromosome, complete genome	blastn	2400	411	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
10527300	10527300	PRJNA1196438_P_NODE_73389_length_244_cov_2.280702_g72962_i0	PRJNA1196438	73389	244	2.280702	5.56491288	Treponema brennaborense	81028	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g72962	i0	81.328	2.11885245901639	241	41	98	4	2	240	2085282	2085520	Treponema brennaborense DSM 12168, complete genome	blastn	517	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
13076729	13076729	PRJNA1196438_P_NODE_44091_length_282_cov_2.909091_g43664_i0	PRJNA1196438	44091	282	2.909091	8.20363662	Treponema denticola	158	Bacteria	Bacteria	486	6.019999999999998e-133	NTclustered	gi\|2265178430\|gb\|CP051633.1\|	158	g43664	i0	97.865	22.1560283687943	281	6	99	0	1	281	675578	675858	Treponema denticola strain OMZ 898 chromosome, complete genome	blastn	6248	486	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
14352010	14352010	PRJNA1196438_P_NODE_29712_length_301_cov_3.057018_g29286_i0	PRJNA1196438	29712	301	3.057018	9.20162418	Treponema denticola	158	Bacteria	Bacteria	285	2.54e-72	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g29286	i0	97.59	27.4584717607973	166	4	100	0	136	301	682592	682757	Treponema denticola strain OKA3 chromosome, complete genome	blastn	8265	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18174878	18174878	PRJNA1196438_P_NODE_54055_length_267_cov_1.608247_g53628_i0	PRJNA1196438	54055	267	1.608247	4.29401949	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	366	7.68e-97	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g53628	i0	94.872	10.2734082397004	234	12	88	0	1	234	1350908	1351141	Treponema sp. OMZ 838, complete genome	blastn	2743	366	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
23275193	23275193	PRJNA1196438_P_NODE_28519_length_301_cov_3.539474_g28093_i0	PRJNA1196438	28519	301	3.539474	10.65381674	Spirochaetia bacterium	2053615	Bacteria	Bacteria	132	3.5e-26	NTclustered	gi\|2621706436\|emb\|OY764216.1\|	2053615	g28093	i0	86.777	5.12292358803987	121	12	40	3	35	153	5054388	5054270	MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1	blastn	1542	132	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
23275216	23275216	PRJNA1196438_P_NODE_31939_length_300_cov_3.563877_g31513_i0	PRJNA1196438	31939	300	3.563877	10.691631	Treponema socranskii	53419	Bacteria	Bacteria	279	1.18e-70	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g31513	i0	100	3.36333333333333	151	0	89	0	1	151	2575574	2575424	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	1009	279	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii

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