metadata: contig_metadata: 5 rows where bioproject = "PRJNA594101", tax_clade = "Candidatus Pacearchaeota" and tax

5 rows where bioproject = "PRJNA594101", tax_clade = "Candidatus Pacearchaeota" 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_clade	tax_kingdom	tax_species
29321778	29321778	PRJNA594101_S_NODE_39009_length_278_cov_1.663415_g38707_i0	PRJNA594101	39009	278	1.663415	4.6242937	Candidatus Pacearchaeota archaeon CG1_	2026773	Archaea	Archaea	44.3	0.0152	NR	OIO42480.1	1805298	g38707	i0	32.1	0.906474820143885	84	54	87.4	1	265	23	175	258	OIO42480.1 MAG: hypothetical protein AUJ64_04130 [Candidatus Pacearchaeota archaeon CG1_02_39_14]	diamond	252	44.3	1	Archaea	Candidatus Pacearchaeota	Nanobdellati	Candidatus Pacearchaeota archaeon CG1_02_39_14
29985017	29985017	PRJNA594101_S_NODE_30491_length_310_cov_1.708861_g30189_i0	PRJNA594101	30491	310	1.708861	5.2974691	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	68.9	7.47e-13	NR	MBS3088642.1	2026773	g30189	i0	57.4	0.52258064516129	54	22	51.3	1	167	9	2	55	MBS3088642.1 RNA-binding protein [Candidatus Pacearchaeota archaeon]	diamond	162	68.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati	Candidatus Pacearchaeota archaeon
30409479	30409479	PRJNA594101_S_NODE_37233_length_284_cov_1.772512_g36931_i0	PRJNA594101	37233	284	1.772512	5.03393408	root	1	Root_unresolved	Root_unresolved	59.3	8.63e-8	NR	MAG01845.1	2026773	g36931	i0	47.7	5.18661971830986	65	31	65.5	1	232	47	359	423	MAG01845.1 beta-ketoacyl-[acyl-carrier-protein] synthase II [Candidatus Pacearchaeota archaeon]	diamond	1473	59.3	1	Archaea	Candidatus Pacearchaeota	Nanobdellati	Candidatus Pacearchaeota archaeon
30522059	30522059	PRJNA594101_S_NODE_25893_length_333_cov_1.426923_g25591_i0	PRJNA594101	25893	333	1.426923	4.75165359	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	95.1	1.02e-20	NR	MBI4116843.1	2026773	g25591	i0	55.7	0.711711711711712	79	31	67.6	2	299	75	64	142	MBI4116843.1 deoxyhypusine synthase [Candidatus Pacearchaeota archaeon]	diamond	237	95.1	1	Archaea	Candidatus Pacearchaeota	Nanobdellati	Candidatus Pacearchaeota archaeon
30585142	30585142	PRJNA594101_S_NODE_52913_length_246_cov_0.976879_g52611_i0	PRJNA594101	52913	246	0.976879	2.40312234	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	84	1.17e-16	NR	MEM1535065.1	2026773	g52611	i0	55.6	1.82926829268293	72	32	87.8	0	226	11	341	412	MEM1535065.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Pacearchaeota archaeon]	diamond	450	84	1	Archaea	Candidatus Pacearchaeota	Nanobdellati	Candidatus Pacearchaeota 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);;