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

5 rows where analysis = "diamond", bioproject = "PRJNA1105232" 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
1487299	1487299	PRJNA1105232_S_NODE_9342_length_207_cov_4.803797_g9126_i0	PRJNA1105232	9342	207	4.803797	9.94385979	Methanobacteriota archaeon	2026739	Archaea	Archaea	97.1	2.18e-22	NR	RZD41571.1	2026739	g9126	i0	66.7	2.88405797101449	66	22	95.7	0	199	2	208	273	RZD41571.1 MAG: transposase [Methanobacteriota archaeon]	diamond	597	97.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
6123441	6123441	PRJNA1105232_S_NODE_13825_length_176_cov_1.228346_g13609_i0	PRJNA1105232	13825	176	1.228346	2.16188896	root	1	Root_unresolved	Root_unresolved	84.3	3.18e-17	NR	WP_400197044.1	2173	g13609	i0	74.1	11.8636363636364	58	12	98.9	1	174	1	432	486	WP_400197044.1 IGHMBP2 family helicase, partial [Methanobrevibacter smithii]	diamond	2088	84.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
30321004	30321004	PRJNA1105232_S_NODE_15072_length_169_cov_3.750000_g14856_i0	PRJNA1105232	15072	169	3.75	6.3375	Thermoplasmatota archaeon	2806419	Archaea	Archaea	49.3	6.14e-6	NR	MEK6984926.1	2806419	g14856	i0	50.9	0.976331360946746	55	22	95.9	3	2	163	5	55	MEK6984926.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	165	49.3	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30636211	30636211	PRJNA1105232_S_NODE_8173_length_218_cov_2.378698_g7957_i0	PRJNA1105232	8173	218	2.378698	5.18556164	Natronolimnobius baerhuensis	253108	Archaea	Archaea	51.2	2.72e-5	NR	WP_087714810.1	253108	g7957	i0	46.2	2.29816513761468	52	28	71.6	0	217	62	476	527	WP_087714810.1 hydroxysqualene dehydroxylase [Natronolimnobius baerhuensis]	diamond	501	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronolimnobius	Natronolimnobius baerhuensis
30699496	30699496	PRJNA1105232_S_NODE_13774_length_176_cov_1.716535_g13558_i0	PRJNA1105232	13774	176	1.716535	3.0211016	Thermoplasmatales archaeon SM1-5	2268204	Archaea	Archaea	42.4	0.0211	NR	KYK25007.1	1803815	g13558	i0	47.6	0.715909090909091	42	22	71.6	0	26	151	655	696	KYK25007.1 MAG: hypothetical protein AYK25_05600 [Thermoplasmatales archaeon SM1-50]	diamond	126	42.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon SM1-50

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