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

4 rows where analysis = "diamond", bioproject = "PRJNA841653" 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
28349553	28349553	PRJNA841653_P_NODE_49246_length_248_cov_0.880000_g48572_i0	PRJNA841653	49246	248	0.88	2.1824	Natronococcus sp.	35747	Archaea	Archaea	42.7	0.0193	NR	WP_416283822.1	35747	g48572	i0	53.5	0.520161290322581	43	19	50.8	1	248	123	96	138	WP_416283822.1 helix-turn-helix domain-containing protein [Natronococcus sp.]	diamond	129	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus sp.
31223563	31223563	PRJNA841653_P_NODE_56415_length_244_cov_0.900585_g55741_i0	PRJNA841653	56415	244	0.900585	2.1974274	Candidatus Poseidonia alphae	1915863	Archaea	Archaea	126	4.9099999999999996e-32	NR	MDA7464148.1	1915863	g55741	i0	75.9	0.971311475409836	79	19	97.1	0	2	238	132	210	MDA7464148.1 hypothetical protein [Candidatus Poseidonia alphae]	diamond	237	126	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae	Candidatus Poseidonia	Candidatus Poseidonia alphae
32204406	32204406	PRJNA841653_P_NODE_14558_length_431_cov_1.899441_g13887_i0	PRJNA841653	14558	431	1.899441	8.18659071	Halobacteriota archaeon	3100168	Archaea	Archaea	55.8	7.81e-6	NR	MDY6957599.1	3100168	g13887	i0	37.9	0.605568445475638	87	42	59.2	2	171	425	1046	1122	MDY6957599.1 hypothetical protein [Halobacteriota archaeon]	diamond	261	55.8	1	Archaea		Methanobacteriati	Halobacteriota					Halobacteriota archaeon
32299679	32299679	PRJNA841653_P_NODE_55419_length_244_cov_1.701754_g54745_i0	PRJNA841653	55419	244	1.701754	4.15227976	Methanocaldococcus villosus	667126	Archaea	Archaea	55.5	2.89e-7	NR	WP_004592618.1	667126	g54745	i0	42.5	3.9344262295082	80	28	98.4	2	2	241	69	130	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	960	55.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus

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