metadata: contig_metadata: 5 rows where bioproject = "PRJNA704949", tax_kingdom = "Promethearchaeati" and tax

5 rows where bioproject = "PRJNA704949", tax_kingdom = "Promethearchaeati" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_species
15214199	15214199	PRJNA704949_P_NODE_1139712_length_240_cov_1.272251_g1124376_i0	PRJNA704949	1139712	240	1.272251	3.0534024	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	95.5	9.47e-22	NR	TFF68403.1	2053491	g1124376	i0	57.7	1.9375	78	33	97.5	0	236	3	24	101	TFF68403.1 MAG: A/G-specific adenine glycosylase [Candidatus Thorarchaeota archaeon]	diamond	465	95.5	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota	Candidatus Thorarchaeota archaeon
27368241	27368241	PRJNA704949_P_NODE_84643_length_843_cov_3.818640_g72661_i0	PRJNA704949	84643	843	3.81864	32.1911352	Candidatus Helarchaeota archaeon	2719382	Archaea	Archaea	67.8	6.8e-9	NR	NVM52372.1	2719382	g72661	i0	30.8	0.427046263345196	120	80	42.7	3	394	35	8	124	NVM52372.1 CapA family protein [Candidatus Helarchaeota archaeon]	diamond	360	67.8	1	Archaea	Promethearchaeati	Candidatus Helarchaeota	Candidatus Helarchaeota archaeon
27410347	27410347	PRJNA704949_P_NODE_1999223_length_167_cov_0.881356_g1983884_i0	PRJNA704949	1999223	167	0.881356	1.47186452	Archaea	2157	Archaea	Archaea	50.4	1.08e-5	NR	MCG3219992.1	2026747	g1983884	i0	43.6	4.0059880239521	55	30	98.8	1	3	167	53	106	MCG3219992.1 DUF5110 domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	669	50.4	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
28188199	28188199	PRJNA704949_P_NODE_151926_length_658_cov_1.725780_g138446_i0	PRJNA704949	151926	658	1.72578	11.3556324	Candidatus Gerdarchaeota archaeon	2795491	Archaea	Archaea	126	4.94e-31	NR	RLI71840.1	2795491	g138446	i0	43	0.583586626139818	128	72	57.9	1	641	261	209	336	RLI71840.1 MAG: hypothetical protein DRP02_03530 [Candidatus Gerdarchaeota archaeon]	diamond	384	126	1	Archaea	Promethearchaeati	Candidatus Gerdarchaeota	Candidatus Gerdarchaeota archaeon
31885029	31885029	PRJNA704949_P_NODE_948877_length_269_cov_1.181818_g933542_i0	PRJNA704949	948877	269	1.181818	3.17909042	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	42.4	0.0397	NR	RLI53085.1	2053491	g933542	i0	41.2	0.568773234200744	51	30	56.9	0	109	261	11	61	RLI53085.1 MAG: hypothetical protein DRP09_16535, partial [Candidatus Thorarchaeota archaeon]	diamond	153	42.4	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota	Candidatus Thorarchaeota 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);;