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

4 rows where analysis = "diamond", bioproject = "PRJNA630877" and tax_clade = "Stenosarchaea group"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28154902	28154902	PRJNA630877_S_NODE_119405_length_191_cov_1.460000_g100268_i0	PRJNA630877	119405	191	1.46	2.7886	Haloferax sp. DFSO52	3388505	Archaea	Archaea	42.4	0.00306	NR	WP_416838656.1	3388505	g100268	i0	41.9	0.675392670157068	43	23	64.4	1	135	13	15	57	WP_416838656.1 hypothetical protein [Haloferax sp. DFSO52]	diamond	129	42.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. DFSO52
28312673	28312673	PRJNA630877_S_NODE_106586_length_213_cov_1.279070_g87449_i0	PRJNA630877	106586	213	1.27907	2.7244191	Haloprofundus halobius	2876194	Archaea	Archaea	44.3	0.00757	NR	WP_224338209.1	2876194	g87449	i0	34.5	0.774647887323944	55	36	77.5	0	34	198	955	1009	WP_224338209.1 UvrD-helicase domain-containing protein [Haloprofundus halobius]	diamond	165	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus halobius
29386229	29386229	PRJNA630877_S_NODE_91429_length_251_cov_1.257143_g72292_i0	PRJNA630877	91429	251	1.257143	3.15542893	Natronoarchaeum rubrum	755311	Archaea	Archaea	44.3	0.00731	NR	WP_256391329.1	755311	g72292	i0	30.6	0.860557768924303	72	44	86.1	2	243	28	69	134	WP_256391329.1 hypothetical protein [Natronoarchaeum rubrum]	diamond	216	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natronoarchaeum	Natronoarchaeum rubrum
30965717	30965717	PRJNA630877_S_NODE_78634_length_301_cov_1.873077_g59497_i0	PRJNA630877	78634	301	1.873077	5.63796177	Halobacterium salinarum	2242	Archaea	Archaea	41.6	0.0284	NR	WP_285255298.1	2242	g59497	i0	35	0.598006644518272	60	39	59.8	0	5	184	2	61	WP_285255298.1 hypothetical protein [Halobacterium salinarum]	diamond	180	41.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium salinarum

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