metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA408129" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA408129" 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
29145146	29145146	PRJNA408129_S_NODE_16369_length_190_cov_3.006536_g16351_i0	PRJNA408129	16369	190	3.006536	5.7124184	Spirochaetales	136	Bacteria	Bacteria	119	1.81e-29	NR	WP_132780366.1	2094121	g16351	i0	96.7	2.84210526315789	60	2	94.7	0	180	1	48	107	WP_132780366.1 4Fe-4S binding protein [Treponema sp. J25]	diamond	540	120	0.991666666666667	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. J25
29886154	29886154	PRJNA408129_S_NODE_4251_length_279_cov_4.830579_g4233_i0	PRJNA408129	4251	279	4.830579	13.47731541	Sphaerochaeta associata	1129264	Bacteria	Bacteria	43.1	0.0353	NR	WP_323385125.1	1129264	g4233	i0	28.8	0.709677419354839	66	45	68.8	1	279	88	76	141	WP_323385125.1 GntR family transcriptional regulator [Sphaerochaeta associata]	diamond	198	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
30882009	30882009	PRJNA408129_S_NODE_14474_length_198_cov_1.409938_g14456_i0	PRJNA408129	14474	198	1.409938	2.79167724	Treponema	157	Bacteria	Bacteria	102	6.93e-24	NR	WP_303932638.1	158	g14456	i0	79	4.6969696969697	62	13	93.9	0	192	7	297	358	WP_303932638.1 UDP-N-acetylmuramyl-tripeptide synthetase, partial [Treponema denticola]	diamond	930	103	0.990291262135922	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
32747284	32747284	PRJNA408129_S_NODE_16840_length_188_cov_5.291391_g16822_i0	PRJNA408129	16840	188	5.291391	9.94781508	Pseudomonadati	3379134	Bacteria	Bacteria	101	1.04e-24	NR	MCE9500260.1	178	g16822	i0	84.5	1.85106382978723	58	9	92.6	0	175	2	61	118	MCE9500260.1 alpha/beta fold hydrolase [Leptospira sp.]	diamond	348	102	0.990196078431373	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.

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