metadata: contig_metadata: 4 rows where bioproject = "PRJNA682774" and tax

4 rows where bioproject = "PRJNA682774" 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
28218883	28218883	PRJNA682774_P_NODE_2466_length_291_cov_1.431193_g2437_i0	PRJNA682774	2466	291	1.431193	4.16477163	Methanosarcinales archaeon	2250255	Archaea	Archaea	110	7.62e-26	NR	RYE85525.1	2250255	g2437	i0	55.1	0.917525773195876	89	39	90.7	1	2	265	600	688	RYE85525.1 MAG: hypothetical protein EOO65_00170 [Methanosarcinales archaeon]	diamond	267	110	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
30903691	30903691	PRJNA682774_P_NODE_4474_length_247_cov_0.896552_g4445_i0	PRJNA682774	4474	247	0.896552	2.21448344	Thermoplasmatales archaeon SG8-52-4	1803819	Archaea	Archaea	91.7	1.02e-19	NR	KYK20734.1	1803819	g4445	i0	60.3	9.91093117408907	68	27	82.6	0	18	221	2	69	KYK20734.1 MAG: molecular chaperone DnaJ [Thermoplasmatales archaeon SG8-52-4]	diamond	2448	91.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon SG8-52-4
31536090	31536090	PRJNA682774_P_NODE_3476_length_253_cov_0.866667_g3447_i0	PRJNA682774	3476	253	0.866667	2.19266751	Methanocorpusculum sp.	2058474	Archaea	Archaea	48.9	2.72e-4	NR	HJJ47081.1	2058474	g3447	i0	45.3	1.54150197628458	64	35	75.9	0	249	58	227	290	HJJ47081.1 Hsp70 family protein [Methanocorpusculum sp.]	diamond	390	48.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
32168799	32168799	PRJNA682774_P_NODE_2838_length_275_cov_1.910891_g2809_i0	PRJNA682774	2838	275	1.910891	5.25495025	Methanobacteriota archaeon	2026739	Archaea	Archaea	64.3	6.15e-10	NR	RYE97637.1	2026739	g2809	i0	64.4	1.35272727272727	45	16	49.1	0	141	275	18	62	RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon]	diamond	372	64.3	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon

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