metadata: contig_metadata: 10 rows where bioproject = "PRJNA724011" and tax

10 rows where bioproject = "PRJNA724011" and tax_phylum = "Candidatus Heimdallarchaeota"

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
16013047	16013047	PRJNA724011_P_NODE_28413_length_523_cov_1.708889_g27396_i0	PRJNA724011	28413	523	1.708889	8.93748947	Candidatus Heimdallarchaeota archaeon LC_2	1841597	Archaea	Archaea	147	2.11e-37	NR	OLS20386.1	1841597	g27396	i0	48.1	0.762906309751434	133	67	76.3	1	3	401	348	478	OLS20386.1 MAG: Copper-exporting P-type ATPase A [Candidatus Heimdallarchaeota archaeon LC_2]	diamond	399	147	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon LC_2
26862586	26862586	PRJNA724011_P_NODE_12221_length_888_cov_1.647853_g11336_i0	PRJNA724011	12221	888	1.647853	14.63293464	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	53.5	5.67e-4	NR	MCE7735885.1	2026747	g11336	i0	31.9	0.391891891891892	116	64	38.9	4	721	377	319	420	MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon]	diamond	348	53.5	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
26925579	26925579	PRJNA724011_P_NODE_45902_length_386_cov_1.597444_g44879_i0	PRJNA724011	45902	386	1.597444	6.16613384	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	150	2.47e-39	NR	RLI67974.1	2026747	g44879	i0	57.9	0.979274611398964	126	53	97.9	0	3	380	438	563	RLI67974.1 MAG: beta-ketoacyl synthase, partial [Candidatus Heimdallarchaeota archaeon]	diamond	378	150	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
27368602	27368602	PRJNA724011_P_NODE_67083_length_308_cov_1.965957_g66060_i0	PRJNA724011	67083	308	1.965957	6.05514756	Candidatus Heimdallarchaeota archaeon LC_3	1841598	Archaea	Archaea	99.8	7.87e-22	NR	OLS20457.1	1841598	g66060	i0	63.6	3.80844155844156	77	28	75	0	306	76	777	853	OLS20457.1 MAG: Copper-exporting P-type ATPase A [Candidatus Heimdallarchaeota archaeon LC_3]	diamond	1173	99.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon LC_3
28157805	28157805	PRJNA724011_P_NODE_16505_length_740_cov_9.212894_g15531_i0	PRJNA724011	16505	740	9.212894	68.1754156	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	154	1.3099999999999999e-42	NR	MDH5401859.1	2026747	g15531	i0	36.6	0.863513513513513	213	133	85.9	2	30	665	10	221	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	639	154	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
28388952	28388952	PRJNA724011_P_NODE_49186_length_370_cov_1.939394_g48163_i0	PRJNA724011	49186	370	1.939394	7.1757578	root	1	Root_unresolved	Root_unresolved	52.8	4.7e-5	NR	OLS22455.1	1841598	g48163	i0	40	1.41081081081081	90	45	68.9	4	5	259	487	572	OLS22455.1 MAG: hypothetical protein HeimC3_30880 [Candidatus Heimdallarchaeota archaeon LC_3]	diamond	522	52.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon LC_3
29041874	29041874	PRJNA724011_P_NODE_6068_length_1277_cov_4.298173_g5475_i0	PRJNA724011	6068	1277	4.298173	54.88766921	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	283	4.96e-86	NR	MCH8908781.1	2026747	g5475	i0	51.4	1.37196554424432	292	132	67.2	3	3	860	292	579	MCH8908781.1 copper-translocating P-type ATPase [Candidatus Heimdallarchaeota archaeon]	diamond	1752	283	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
29767771	29767771	PRJNA724011_P_NODE_66811_length_309_cov_1.627119_g65788_i0	PRJNA724011	66811	309	1.627119	5.02779771	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	68.6	6.69e-11	NR	MCG3218823.1	2026747	g65788	i0	41.4	0.961165048543689	99	50	96.1	3	11	307	52	142	MCG3218823.1 beta-ketoacyl synthase [Candidatus Heimdallarchaeota archaeon]	diamond	297	68.6	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
31189175	31189175	PRJNA724011_P_NODE_13335_length_843_cov_14.557143_g12422_i0	PRJNA724011	13335	843	14.557143	122.71671549	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	155	2.7199999999999994e-42	NR	MDH5401859.1	2026747	g12422	i0	37.7	0.793594306049822	223	137	79.4	1	25	693	8	228	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	669	155	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
32528860	32528860	PRJNA724011_P_NODE_18019_length_702_cov_1.251192_g17021_i0	PRJNA724011	18019	702	1.251192	8.78336784	root	1	Root_unresolved	Root_unresolved	251	1.02e-76	NR	MBY8999837.1	2026747	g17021	i0	54.7	4.95299145299145	234	88	100	2	702	1	274	489	MBY8999837.1 gamma-glutamyltransferase [Candidatus Heimdallarchaeota archaeon]	diamond	3477	251	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota 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);;