metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_clade = "Stenosarchaea 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
22599976	22599976	PRJNA942359_P_NODE_16438_length_248_cov_0.891429_g16323_i0	PRJNA942359	16438	248	0.891429	2.21074392	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	134	8.34e-35	NR	HWR96842.1	2032688	g16323	i0	85.4	0.991935483870968	82	12	99.2	0	1	246	261	342	HWR96842.1 DHA2 family efflux MFS transporter permease subunit [Candidatus Methanoperedens sp.]	diamond	246	134	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
27948131	27948131	PRJNA942359_P_NODE_14325_length_251_cov_0.876404_g14210_i0	PRJNA942359	14325	251	0.876404	2.19977404	root	1	Root_unresolved	Root_unresolved	98.6	4.04e-22	NR	WP_048038854.1	2209	g14210	i0	56.6	5.85657370517928	83	36	99.2	0	249	1	274	356	WP_048038854.1 restriction endonuclease subunit S [Methanosarcina mazei]	diamond	1470	99	0.995959595959596	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
28320125	28320125	PRJNA942359_P_NODE_14446_length_251_cov_0.876404_g14331_i0	PRJNA942359	14446	251	0.876404	2.19977404	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	142	6.51e-39	NR	HWR98640.1	2032688	g14331	i0	81.7	0.9800796812749	82	15	98	0	1	246	120	201	HWR98640.1 DHH family phosphoesterase [Candidatus Methanoperedens sp.]	diamond	246	142	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
30973254	30973254	PRJNA942359_P_NODE_14314_length_251_cov_0.876404_g14199_i0	PRJNA942359	14314	251	0.876404	2.19977404	Haloferax	2251	Archaea	Archaea	52.8	1.23e-5	NR	WP_151114281.1	2251	g14199	i0	36.3	1.60159362549801	80	35	95.6	2	243	4	726	789	WP_151114281.1 MULTISPECIES: PD-(D/E)XK nuclease family protein [Haloferax]	diamond	402	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax
32774966	32774966	PRJNA942359_P_NODE_15660_length_249_cov_0.886364_g15545_i0	PRJNA942359	15660	249	0.886364	2.20704636	Methanothrix sp.	90426	Archaea	Archaea	143	1.59e-38	NR	MBP8623374.1	90426	g15545	i0	83.1	1	83	14	100	0	249	1	57	139	MBP8623374.1 anthranilate synthase component I [Methanothrix sp.]	diamond	249	143	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix 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);;