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

4 rows where analysis = "diamond", bioproject = "PRJNA493827" 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
27992849	27992849	PRJNA493827_P_NODE_119765_length_312_cov_1.514644_g117567_i0	PRJNA493827	119765	312	1.514644	4.72568928	Methanocaldococcus villosus	667126	Archaea	Archaea	70.5	9.98e-13	NR	WP_004592618.1	667126	g117567	i0	42.4	0.884615384615385	92	35	88.5	2	299	24	67	140	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	276	70.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus
29697389	29697389	PRJNA493827_P_NODE_39510_length_581_cov_2.411417_g37332_i0	PRJNA493827	39510	581	2.411417	14.01033277	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	212	1.4e-62	NR	MBX7076496.1	2099680	g37332	i0	54.7	0.991394148020654	192	86	99.1	1	579	4	69	259	MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon]	diamond	576	212	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
29855643	29855643	PRJNA493827_P_NODE_104751_length_334_cov_2.065134_g102553_i0	PRJNA493827	104751	334	2.065134	6.89754756	Methanobacterium sp. PtaB.Bin	2164	Archaea	Archaea	89	3.4e-20	NR	OPX57383.1	1811674	g102553	i0	51.8	2.27245508982036	85	39	74.6	1	274	26	25	109	OPX57383.1 MAG: molybdopterin biosynthesis-like protein MoeZ [Methanobacterium sp. PtaB.Bin024]	diamond	759	89	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. PtaB.Bin024
31435649	31435649	PRJNA493827_P_NODE_77076_length_393_cov_2.987500_g74878_i0	PRJNA493827	77076	393	2.9875	11.740875	Methanobrevibacter cuticularis	47311	Archaea	Archaea	59.3	2.02e-8	NR	WP_067259673.1	47311	g74878	i0	52.1	0.541984732824427	71	29	53.4	3	289	80	6	72	WP_067259673.1 thermonuclease family protein [Methanobrevibacter cuticularis]	diamond	213	59.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter cuticularis

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