metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA379145" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA379145" 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_species
13154379	13154379	PRJNA379145_P_NODE_20831_length_577_cov_2.340074_g18939_i0	PRJNA379145	20831	577	2.340074	13.50222698	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	162	4.59e-45	NR	RLI96203.1	3121606	g18939	i0	69.2	6.83188908145581	117	35	60.8	1	575	225	156	271	RLI96203.1 MAG: pyruvate, phosphate dikinase, partial [Candidatus Aenigmatarchaeota archaeon]	diamond	3942	162	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota archaeon
27106368	27106368	PRJNA379145_P_NODE_22222_length_547_cov_3.110895_g20271_i0	PRJNA379145	22222	547	3.110895	17.01659565	Nanobdellota archaeon	2026764	Archaea	Archaea	68.9	3.29e-11	NR	MBU2562356.1	2026764	g20271	i0	34.5	1.31627056672761	116	70	63.6	3	17	364	2	111	MBU2562356.1 SET domain-containing protein [Nanoarchaeota archaeon]	diamond	720	68.9	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27201169	27201169	PRJNA379145_P_NODE_37682_length_324_cov_2.281787_g35531_i0	PRJNA379145	37682	324	2.281787	7.39298988	Nanobdellota archaeon	2026764	Archaea	Archaea	129	5.13e-32	NR	MCA9485224.1	2026764	g35531	i0	52.3	0.990740740740741	107	51	99.1	0	322	2	187	293	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	321	129	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27801669	27801669	PRJNA379145_P_NODE_68564_length_163_cov_1.523077_g66410_i0	PRJNA379145	68564	163	1.523077	2.48261551	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	82	1.42e-16	NR	MBD3210255.1	2250274	g66410	i0	69.8	1.95092024539877	53	16	97.5	0	3	161	359	411	MBD3210255.1 ATPase [Candidatus Micrarchaeota archaeon]	diamond	318	82	1	Archaea		Nanobdellati	Candidatus Micrarchaeota		Candidatus Micrarchaeota archaeon
27832943	27832943	PRJNA379145_P_NODE_15504_length_718_cov_5.214599_g13862_i0	PRJNA379145	15504	718	5.214599	37.44082082	Nanobdellota archaeon	2026764	Archaea	Archaea	187	1.2e-55	NR	MBU0470866.1	2026764	g13862	i0	45.2	0.877437325905292	210	104	84	3	655	53	2	209	MBU0470866.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	630	187	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
28180168	28180168	PRJNA379145_P_NODE_4226_length_1435_cov_61.714693_g3694_i0	PRJNA379145	4226	1435	61.714693	885.60584455	Nanobdellota archaeon	2026764	Archaea	Archaea	62.4	2.46e-6	NR	MCA9495696.1	2026764	g3694	i0	27	0.712891986062718	341	197	61.7	16	1318	434	26	360	MCA9495696.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	1023	62.4	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
28874994	28874994	PRJNA379145_P_NODE_4348_length_1419_cov_2.683261_g3803_i0	PRJNA379145	4348	1419	2.683261	38.07547359	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	332	5.569999999999998e-106	NR	MBI5226828.1	2250274	g3803	i0	59	1.22198731501057	293	117	61.7	2	529	1404	131	421	MBI5226828.1 hydroxymethylglutaryl-CoA reductase, degradative [Candidatus Micrarchaeota archaeon]	diamond	1734	332	1	Archaea		Nanobdellati	Candidatus Micrarchaeota		Candidatus Micrarchaeota archaeon
30548835	30548835	PRJNA379145_P_NODE_41033_length_294_cov_6.337165_g38882_i0	PRJNA379145	41033	294	6.337165	18.6312651	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	50.1	1.81e-4	NR	MBS3086875.1	2026773	g38882	i0	62.5	0.408163265306122	40	13	40.8	1	1	120	430	467	MBS3086875.1 DUF4215 domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	120	50.1	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota archaeon
30928156	30928156	PRJNA379145_P_NODE_41954_length_287_cov_1.838583_g39802_i0	PRJNA379145	41954	287	1.838583	5.27673321	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	67.8	7.83e-11	NR	HLD98439.1	2910166	g39802	i0	43.8	0.763066202090592	73	41	76.3	0	263	45	244	316	HLD98439.1 FAD-dependent oxidoreductase [Candidatus Nanoarchaeia archaeon]	diamond	219	67.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
32098002	32098002	PRJNA379145_P_NODE_18178_length_640_cov_2.097199_g16398_i0	PRJNA379145	18178	640	2.097199	13.4220736	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	117	4.3500000000000006e-27	NR	MCK4555072.1	3121606	g16398	i0	66.7	0.39375	84	27	38.9	1	482	234	218	301	MCK4555072.1 NADP-dependent malic enzyme [Candidatus Aenigmatarchaeota archaeon]	diamond	252	117	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota 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);;