metadata: contig_metadata: 5 rows where bioproject = "PRJEB10320" and tax

5 rows where bioproject = "PRJEB10320" 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
2257692	2257692	PRJEB10320_P_NODE_8162_length_353_cov_2.474843_g7904_i0	PRJEB10320	8162	353	2.474843	8.73619579	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	184	2.0399999999999994e-54	NR	MBX7076500.1	2099680	g7904	i0	78.6	1.91218130311615	112	24	95.2	0	18	353	5	116	MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon]	diamond	675	184	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
12461574	12461574	PRJEB10320_P_NODE_8590_length_342_cov_1.824104_g8332_i0	PRJEB10320	8590	342	1.824104	6.23843568	root	1	Root_unresolved	Root_unresolved	145	1.49e-38	NR	MBX7076496.1	2099680	g8332	i0	67.3	1.7719298245614	101	33	88.6	0	307	5	192	292	MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon]	diamond	606	145	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
29022653	29022653	PRJEB10320_P_NODE_14028_length_247_cov_2.033019_g13770_i0	PRJEB10320	14028	247	2.033019	5.02155693	Haloferax sp. Atlit-12N	2077203	Archaea	Archaea	62.4	3.84e-9	NR	WP_115883272.1	2077203	g13770	i0	38.8	1.03238866396761	85	46	98.4	3	246	4	228	310	WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N]	diamond	255	62.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-12N
32403981	32403981	PRJEB10320_P_NODE_16279_length_222_cov_2.139037_g16021_i0	PRJEB10320	16279	222	2.139037	4.74866214	Methanobacteriota archaeon	2026739	Archaea	Archaea	42.7	0.0215	NR	MBI4415984.1	2026739	g16021	i0	58.1	0.837837837837838	31	12	41.9	1	113	21	118	147	MBI4415984.1 hypothetical protein [Methanobacteriota archaeon]	diamond	186	42.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32499038	32499038	PRJEB10320_P_NODE_23339_length_172_cov_1.459854_g23081_i0	PRJEB10320	23339	172	1.459854	2.51094888	Thermoplasmata archaeon	1906666	Archaea	Archaea	54.7	8.34e-7	NR	MCK5291882.1	1906666	g23081	i0	40.7	3.76744186046512	54	32	94.2	0	171	10	177	230	MCK5291882.1 transcription initiation factor IIB [Thermoplasmata archaeon]	diamond	648	54.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata 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);;