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

5 rows where analysis = "diamond", bioproject = "PRJNA407087" 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
26680527	26680527	PRJNA407087_S_NODE_8841_length_161_cov_2.060606_g8378_i0	PRJNA407087	8841	161	2.060606	3.31757566	Thermococcus	2263	Archaea	Archaea	47	3.87e-4	NR	WP_297063831.1	35749	g8378	i0	43.1	2.16149068322981	58	28	98.8	1	1	159	157	214	WP_297063831.1 NAD(P)/FAD-dependent oxidoreductase, partial [Thermococcus sp.]	diamond	348	47	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp.
27612684	27612684	PRJNA407087_S_NODE_8844_length_161_cov_2.022727_g8381_i0	PRJNA407087	8844	161	2.022727	3.25659047	Methanoregulaceae archaeon	2485498	Archaea	Archaea	53.9	1.38e-6	NR	HNJ81026.1	2485498	g8381	i0	62.2	0.68944099378882	37	14	68.9	0	17	127	603	639	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	111	53.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
28323734	28323734	PRJNA407087_S_NODE_7526_length_177_cov_4.175676_g7063_i0	PRJNA407087	7526	177	4.175676	7.39094652	root	1	Root_unresolved	Root_unresolved	47	4.03e-4	NR	MDO5845470.1	2058474	g7063	i0	41.5	4.06779661016949	53	31	89.8	0	6	164	148	200	MDO5845470.1 MIP family channel protein [Methanocorpusculum sp.]	diamond	720	47	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
31845355	31845355	PRJNA407087_S_NODE_2697_length_381_cov_49.315341_g2235_i0	PRJNA407087	2697	381	49.315341	187.89144921	Methanocaldococcus villosus	667126	Archaea	Archaea	96.3	1.95e-22	NR	WP_004592618.1	667126	g2235	i0	45	0.874015748031496	111	43	87.4	2	379	47	48	140	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	333	96.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus
32510202	32510202	PRJNA407087_S_NODE_2599_length_391_cov_54.980663_g2138_i0	PRJNA407087	2599	391	54.980663	214.97439233	Methanocaldococcus villosus	667126	Archaea	Archaea	93.6	2.4600000000000003e-21	NR	WP_004592618.1	667126	g2138	i0	43.2	0.851662404092072	111	45	85.2	2	389	57	48	140	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	333	93.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus

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