metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_kingdom = "Nanobdellati"

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
26630363	26630363	PRJNA1240804_P_NODE_31221_length_262_cov_1.286385_g30855_i0	PRJNA1240804	31221	262	1.286385	3.3703287	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	161	4.27e-47	NR	HUC42166.1	2953041	g30855	i0	91.9	0.984732824427481	86	7	98.5	0	258	1	24	109	HUC42166.1 alpha/beta fold hydrolase [Candidatus Micrarchaeaceae archaeon]	diamond	258	161	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
26630404	26630404	PRJNA1240804_P_NODE_77681_length_188_cov_1.381295_g77315_i0	PRJNA1240804	77681	188	1.381295	2.5968346	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	92.4	3.74e-20	NR	MBN2101378.1	3121606	g77315	i0	75	6.31914893617021	56	14	89.4	0	173	6	221	276	MBN2101378.1 translation elongation factor EF-1 subunit alpha [Candidatus Aenigmatarchaeota archaeon]	diamond	1188	92.4	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
26996594	26996594	PRJNA1240804_P_NODE_151182_length_162_cov_0.920354_g150816_i0	PRJNA1240804	151182	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	51.6	7.66e-6	NR	MCK9571010.1	2026773	g150816	i0	90.5	2.96296296296296	21	2	38.9	0	15	77	33	53	MCK9571010.1 DNA cytosine methyltransferase [Candidatus Pacearchaeota archaeon]	diamond	480	51.6	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
28052538	28052538	PRJNA1240804_P_NODE_133805_length_165_cov_0.896552_g133439_i0	PRJNA1240804	133805	165	0.896552	1.4793108	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	48.9	8.52e-5	NR	MEM4268277.1	2026803	g133439	i0	47.1	0.927272727272727	51	27	92.7	0	5	157	663	713	MEM4268277.1 ATP-dependent helicase [Candidatus Woesearchaeota archaeon]	diamond	153	48.9	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29441663	29441663	PRJNA1240804_P_NODE_88650_length_181_cov_0.977273_g88284_i0	PRJNA1240804	88650	181	0.977273	1.76886413	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	52.8	4.72e-6	NR	MCX6801837.1	2026736	g88284	i0	42.9	4.67403314917127	56	32	92.8	0	181	14	145	200	MCX6801837.1 CBS domain-containing protein [Candidatus Iainarchaeum archaeon]	diamond	846	52.8	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
29630950	29630950	PRJNA1240804_P_NODE_107410_length_169_cov_0.866667_g107044_i0	PRJNA1240804	107410	169	0.866667	1.46466723	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	43.5	0.00759	NR	MBS3148878.1	2026803	g107044	i0	73.1	0.461538461538462	26	7	46.2	0	4	81	1488	1513	MBS3148878.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	78	43.5	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
30326786	30326786	PRJNA1240804_P_NODE_140112_length_164_cov_0.747826_g139746_i0	PRJNA1240804	140112	164	0.747826	1.22643464	Candidatus Bilamarchaeaceae archaeon	2886391	Archaea	Archaea	52.4	4.88e-6	NR	MEM4360379.1	2886391	g139746	i0	53.1	0.896341463414634	49	23	89.6	0	17	163	143	191	MEM4360379.1 aldo/keto reductase [Candidatus Bilamarchaeaceae archaeon]	diamond	147	52.4	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Anstonellales	Candidatus Bilamarchaeaceae		Candidatus Bilamarchaeaceae archaeon
30642111	30642111	PRJNA1240804_P_NODE_88533_length_181_cov_1.075758_g88167_i0	PRJNA1240804	88533	181	1.075758	1.94712198	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	76.3	2.77e-15	NR	HUC42167.1	2953041	g88167	i0	74.5	0.845303867403315	51	10	79.6	1	2	145	102	152	HUC42167.1 TetR/AcrR family transcriptional regulator [Candidatus Micrarchaeaceae archaeon]	diamond	153	76.3	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
31559084	31559084	PRJNA1240804_P_NODE_52496_length_215_cov_1.475904_g52130_i0	PRJNA1240804	52496	215	1.475904	3.1731936	Nanobdellota archaeon	2026764	Archaea	Archaea	70.1	1.77e-12	NR	MFC1728251.1	2026764	g52130	i0	61	1.64651162790698	59	23	82.3	0	192	16	74	132	MFC1728251.1 HAD family hydrolase [Nanoarchaeota archaeon]	diamond	354	70.1	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota 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);;