metadata: contig_metadata: 5 rows where bioproject = "PRJNA533623", tax_clade = "Methanomada group" and tax

5 rows where bioproject = "PRJNA533623", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"

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
23458534	23458534	PRJNA533623_P_NODE_32619_length_393_cov_6.228916_g30848_i0	PRJNA533623	32619	393	6.228916	24.47963988	Methanobacterium sp. ACI-7	3240853	Archaea	Archaea	66.2	1.28e-11	NR	WP_414469398.1	3240853	g30848	i0	51.7	0.458015267175573	60	28	45.8	1	114	293	4	62	WP_414469398.1 YwbE family protein [Methanobacterium sp. ACI-7]	diamond	180	66.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. ACI-7
28846063	28846063	PRJNA533623_P_NODE_39268_length_349_cov_4.375000_g37494_i0	PRJNA533623	39268	349	4.375	15.26875	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	166	4.69e-45	NR	NYB27335.1	2099680	g37494	i0	97.6	0.722063037249284	84	2	72.2	0	2	253	970	1053	NYB27335.1 isoleucine--tRNA ligase [Methanobacteriaceae archaeon]	diamond	252	166	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
28846075	28846075	PRJNA533623_P_NODE_64228_length_239_cov_1.460674_g62447_i0	PRJNA533623	64228	239	1.460674	3.49101086	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	155	4.0599999999999986e-43	NR	NYB27229.1	2099680	g62447	i0	96.2	0.99163179916318	79	3	99.2	0	239	3	308	386	NYB27229.1 2-isopropylmalate synthase [Methanobacteriaceae archaeon]	diamond	237	155	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
29162214	29162214	PRJNA533623_P_NODE_54769_length_274_cov_3.305164_g52990_i0	PRJNA533623	54769	274	3.305164	9.05614936	Methanobacterium sp. PtaU1.Bin	2164	Archaea	Archaea	181	1.3e-55	NR	OPY19747.1	1811675	g52990	i0	100	0.91970802919708	84	0	92	0	273	22	56	139	OPY19747.1 MAG: Sortase family protein [Methanobacterium sp. PtaU1.Bin097]	diamond	252	181	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. PtaU1.Bin097
32116002	32116002	PRJNA533623_P_NODE_66258_length_232_cov_1.900585_g64477_i0	PRJNA533623	66258	232	1.900585	4.4093572	root	1	Root_unresolved	Root_unresolved	155	8.15e-45	NR	MEN4029920.1	2164	g64477	i0	96.1	1.99137931034483	77	3	99.6	0	232	2	90	166	MEN4029920.1 AMP-binding protein [Methanobacterium sp.]	diamond	462	155	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.

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