metadata: contig_metadata: 5 rows where bioproject = "PRJNA438111", tax_phylum = "Candidatus Woesearchaeota" and tax

5 rows where bioproject = "PRJNA438111", tax_phylum = "Candidatus Woesearchaeota" 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
2984550	2984550	PRJNA438111_P_NODE_23543_length_223_cov_2.927835_g22918_i0	PRJNA438111	23543	223	2.927835	6.52907205	Archaea	2157	Archaea	Archaea	121	2.75e-31	NR	MBW3020274.1	2026803	g22918	i0	81.1	2.98654708520179	74	14	99.6	0	223	2	114	187	MBW3020274.1 tyrosine--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	666	122	0.991803278688525	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
27297242	27297242	PRJNA438111_P_NODE_89523_length_151_cov_2.262295_g88898_i0	PRJNA438111	89523	151	2.262295	3.41606545	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	43.5	0.00468	NR	MEM4710823.1	2026803	g88898	i0	51.1	1.88741721854305	47	18	85.4	2	6	134	75	120	MEM4710823.1 class I SAM-dependent methyltransferase [Candidatus Woesearchaeota archaeon]	diamond	285	43.5	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
30629239	30629239	PRJNA438111_P_NODE_88413_length_151_cov_6.811475_g87788_i0	PRJNA438111	88413	151	6.811475	10.28532725	root	1	Root_unresolved	Root_unresolved	78.2	1.86e-15	NR	MBT4539725.1	2026803	g87788	i0	69.4	6.79470198675497	49	15	97.4	0	3	149	44	92	MBT4539725.1 D-glycerate dehydrogenase [Candidatus Woesearchaeota archaeon]	diamond	1026	78.2	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31561464	31561464	PRJNA438111_P_NODE_15076_length_270_cov_3.647303_g14451_i0	PRJNA438111	15076	270	3.647303	9.8477181	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	110	1.3600000000000002e-26	NR	MBD3204677.1	2026803	g14451	i0	58.9	1	90	36	100	1	270	1	138	226	MBD3204677.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Woesearchaeota archaeon]	diamond	270	110	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32668026	32668026	PRJNA438111_P_NODE_3440_length_528_cov_3.224449_g2933_i0	PRJNA438111	3440	528	3.224449	17.02509072	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	221	4.8199999999999985e-68	NR	MBI1970550.1	2026803	g2933	i0	62.9	0.994318181818182	175	65	99.4	0	527	3	175	349	MBI1970550.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Candidatus Woesearchaeota archaeon]	diamond	525	221	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota 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);;