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

4 rows where analysis = "diamond", bioproject = "PRJNA929922" and tax_clade = "Methanomada 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
27498984	27498984	PRJNA929922_P_NODE_115583_length_250_cov_0.870056_g115043_i0	PRJNA929922	115583	250	0.870056	2.17514	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	85.9	2.65e-17	NR	WP_296889016.1	253161	g115043	i0	49.4	0.972	81	40	97.2	1	245	3	1577	1656	WP_296889016.1 carboxypeptidase-like regulatory domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	243	85.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29614039	29614039	PRJNA929922_S_NODE_60890_length_251_cov_1.685393_g60666_i0	PRJNA929922	60890	251	1.685393	4.23033643	Methanobrevibacter sp.	66852	Archaea	Archaea	119	2.38e-29	NR	MDO5826752.1	66852	g60666	i0	95.6	0.812749003984064	68	3	81.3	0	2	205	412	479	MDO5826752.1 flippase [Methanobrevibacter sp.]	diamond	204	119	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31707078	31707078	PRJNA929922_P_NODE_163237_length_241_cov_0.916667_g162697_i0	PRJNA929922	163237	241	0.916667	2.20916747	Methanobrevibacter	2172	Archaea	Archaea	112	3.73e-30	NR	WP_409198532.1	2172	g162697	i0	92.3	6.47302904564315	52	4	64.7	0	2	157	53	104	WP_409198532.1 MULTISPECIES: translation initiation factor eIF-1A [Methanobrevibacter]	diamond	1560	112	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter
31984658	31984658	PRJNA929922_P_NODE_19018_length_429_cov_0.856742_g18483_i0	PRJNA929922	19018	429	0.856742	3.67542318	Methanobrevibacter arboriphilus	39441	Archaea	Archaea	45.4	0.0279	NR	WP_221061479.1	39441	g18483	i0	37	0.566433566433566	81	47	55.2	2	169	405	202	280	WP_221061479.1 DUF460 domain-containing protein [Methanobrevibacter arboriphilus]	diamond	243	45.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter arboriphilus

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