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

8 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
1704772	1704772	PRJNA432257_S_NODE_5962_length_492_cov_3.973626_g5683_i0	PRJNA432257	5962	492	3.973626	19.55023992	Treponema putidum	221027	Bacteria	Bacteria	654	0	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g5683	i0	93.096	3.88617886178862	449	28	91	3	1	447	1188583	1188136	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	1912	654	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
6807712	6807712	PRJNA432257_S_NODE_67626_length_206_cov_3.449704_g67245_i0	PRJNA432257	67626	206	3.449704	7.10639024	Treponema parvum	138851	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g67245	i0	100	0.135922330097087	28	0	14	0	149	176	1050613	1050586	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
13183253	13183253	PRJNA432257_S_NODE_3531_length_594_cov_3.265709_g3322_i0	PRJNA432257	3531	594	3.265709	19.39831146	Treponema denticola	158	Bacteria	Bacteria	959	0	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g3322	i0	95.791	7.0959595959596	594	25	100	0	1	594	1672368	1671775	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	4215	959	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
13842159	13842159	PRJNA432257_S_NODE_25451_length_296_cov_4.671815_g25070_i0	PRJNA432257	25451	296	4.671815	13.8285724	Treponema	157	Bacteria	Bacteria	520	6.2699999999999985e-143	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g25070	i0	98.639	4.99324324324324	294	3	99	1	1	293	1672355	1672648	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	1478	520	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15731702	15731702	PRJNA432257_S_NODE_112793_length_163_cov_2.865079_g112412_i0	PRJNA432257	112793	163	2.865079	4.67007877	Borreliella garinii	29519	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2371381440\|gb\|CP075234.1\|	29519	g112412	i0	94.286	0.429447852760736	35	0	20	2	29	61	773757	773791	Borreliella garinii strain JAASAAF1012 chromosome, complete genome	blastn	70	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
19555737	19555737	PRJNA432257_S_NODE_556_length_1583_cov_10.401682_g526_i0	PRJNA432257	556	1583	10.401682	164.65862606	Treponema denticola	158	Bacteria	Bacteria	2261	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g526	i0	93.115	9.76563487049905	1554	89	98	15	1	1547	1322436	1320894	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	15459	2261	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
21490718	21490718	PRJNA432257_S_NODE_92237_length_182_cov_11.137931_g91856_i0	PRJNA432257	92237	182	11.137931	20.27103442	Gracilinema	2951106	Bacteria	Bacteria	195	2.43e-45	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g91856	i0	89.241	164.835164835165	158	13	86	3	27	182	2311	2466	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	30000	195	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
24656040	24656040	PRJNA432257_S_NODE_45080_length_240_cov_3.266010_g44699_i0	PRJNA432257	45080	240	3.26601	7.838424	Treponema putidum	221027	Bacteria	Bacteria	383	6.74e-102	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g44699	i0	95.417	6	240	11	100	0	1	240	1188558	1188797	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	1440	383	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum

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