metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_kingdom = "Methanobacteriati"

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
26693727	26693727	PRJNA1249042_S_NODE_93281_length_166_cov_3.040650_g93067_i0	PRJNA1249042	93281	166	3.04065	5.047479	Methanobacterium subterraneum	59277	Archaea	Archaea	41.2	0.044	NR	WP_100905497.1	59277	g93067	i0	43.6	0.704819277108434	39	22	70.5	0	6	122	88	126	WP_100905497.1 Fpg/Nei family DNA glycosylase [Methanobacterium subterraneum]	diamond	117	41.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
26852375	26852375	PRJNA1249042_S_NODE_110341_length_154_cov_1.729730_g110127_i0	PRJNA1249042	110341	154	1.72973	2.6637842	Methanobrevibacter sp.	66852	Archaea	Archaea	106	1.67e-27	NR	MDO5827389.1	66852	g110127	i0	100	0.993506493506494	51	0	99.4	0	1	153	10	60	MDO5827389.1 TIGR00295 family protein [Methanobrevibacter sp.]	diamond	153	106	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29347423	29347423	PRJNA1249042_S_NODE_99849_length_161_cov_2.847458_g99635_i0	PRJNA1249042	99849	161	2.847458	4.58440738	Methanomicrobiales archaeon	2184052	Archaea	Archaea	40.8	0.0213	NR	MCX6694254.1	2184052	g99635	i0	46.2	0.726708074534162	39	18	67.1	1	37	144	65	103	MCX6694254.1 ribonuclease P [Methanomicrobiales archaeon]	diamond	117	40.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
31875158	31875158	PRJNA1249042_S_NODE_19477_length_266_cov_1.663677_g19263_i0	PRJNA1249042	19477	266	1.663677	4.42538082	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.1	0.0352	NR	MDQ1372472.1	2806419	g19263	i0	43.6	0.620300751879699	55	24	56.4	2	237	88	286	338	MDQ1372472.1 transporter ATP-binding protein [Thermoplasmatota archaeon]	diamond	165	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
32033559	32033559	PRJNA1249042_S_NODE_9818_length_310_cov_3.142322_g9604_i0	PRJNA1249042	9818	310	3.142322	9.7411982	Halobacteria archaeon AArc-dxtr1	2979987	Archaea	Archaea	42.4	0.0161	NR	MCU4926469.1	2979987	g9604	i0	46.5	0.416129032258065	43	22	41.6	1	132	260	26	67	MCU4926469.1 MarR family transcriptional regulator [Halobacteria archaeon AArc-dxtr1]	diamond	129	42.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria				Halobacteria archaeon AArc-dxtr1

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