metadata: contig_metadata: 5 rows where bioproject = "PRJNA1120060" and tax

5 rows where bioproject = "PRJNA1120060" and tax_phylum = "Candidatus Altarchaeota"

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_class	tax_order	tax_species
27195650	27195650	PRJNA1120060_P_NODE_2897222_length_244_cov_0.877193_g2879133_i0	PRJNA1120060	2897222	244	0.877193	2.14035092	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	43.1	0.0264	NR	MFH1788460.1	2599821	g2879133	i0	38.5	0.639344262295082	52	27	63.9	2	211	56	208	254	MFH1788460.1 hypothetical protein [Candidatus Altiarchaeota archaeon]	diamond	156	43.1	1	Archaea	Nanobdellati	Candidatus Altarchaeota			Candidatus Altiarchaeota archaeon
29184561	29184561	PRJNA1120060_P_NODE_1793549_length_281_cov_1.846154_g1775537_i0	PRJNA1120060	1793549	281	1.846154	5.18769274	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	55.8	2.22e-7	NR	MBR9689575.1	2599821	g1775537	i0	32.1	2.77580071174377	84	57	89.7	0	15	266	22	105	MBR9689575.1 ribonuclease HI family protein [Candidatus Altiarchaeota archaeon]	diamond	780	55.8	1	Archaea	Nanobdellati	Candidatus Altarchaeota			Candidatus Altiarchaeota archaeon
29585174	29585174	PRJNA1120060_P_NODE_2909450_length_243_cov_2.870588_g2891357_i0	PRJNA1120060	2909450	243	2.870588	6.97552884	root	1	Root_unresolved	Root_unresolved	62	5.66e-10	NR	MBR9689575.1	2599821	g2891357	i0	40.5	2.93827160493827	79	46	97.5	1	242	6	39	116	MBR9689575.1 ribonuclease HI family protein [Candidatus Altiarchaeota archaeon]	diamond	714	62.4	0.993589743589744	Archaea	Nanobdellati	Candidatus Altarchaeota			Candidatus Altiarchaeota archaeon
31617011	31617011	PRJNA1120060_P_NODE_157796_length_500_cov_2.384075_g141842_i0	PRJNA1120060	157796	500	2.384075	11.920375	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	73.9	2.09e-13	NR	MBR9689575.1	2599821	g141842	i0	35.4	0.576	96	61	57.6	1	9	296	39	133	MBR9689575.1 ribonuclease HI family protein [Candidatus Altiarchaeota archaeon]	diamond	288	73.9	1	Archaea	Nanobdellati	Candidatus Altarchaeota			Candidatus Altiarchaeota archaeon
31618089	31618089	PRJNA1120060_P_NODE_3138576_length_234_cov_3.173913_g3120472_i0	PRJNA1120060	3138576	234	3.173913	7.42695642	Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3	2013675	Archaea	Archaea	40	0.0415	NR	PKP54376.1	2013675	g3120472	i0	48.5	0.423076923076923	33	17	42.3	0	197	99	7	39	PKP54376.1 MAG: hypothetical protein CVT90_01590 [Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3]	diamond	99	40	1	Archaea	Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales	Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3

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);;