metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA169559" 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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1054855	1054855	PRJNA169559_P_NODE_28281_length_274_cov_2.220408_g26205_i0	PRJNA169559	28281	274	2.220408	6.08391792	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	75.9	1.18e-13	NR	MEM5836295.1	3121606	g26205	i0	57.9	1.22627737226277	57	24	62.4	0	99	269	540	596	MEM5836295.1 leucine--tRNA ligase [Candidatus Aenigmatarchaeota archaeon]	diamond	336	75.9	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
18216662	18216662	PRJNA169559_P_NODE_23575_length_320_cov_2.130584_g21502_i0	PRJNA169559	23575	320	2.130584	6.8178688	archaeon	1906665	Archaea	Archaea	101	1.2699999999999999e-23	NR	MDP2436823.1	1906665	g21502	i0	86	0.9375	50	7	46.9	0	2	151	173	222	MDP2436823.1 serine/threonine-protein phosphatase [archaeon]	diamond	300	101	1	Archaea								archaeon
23316921	23316921	PRJNA169559_P_NODE_11099_length_505_cov_15.936975_g9284_i0	PRJNA169559	11099	505	15.936975	80.48172375	archaeon	1906665	Archaea	Archaea	254	4.25e-84	NR	MCQ2818557.1	1906665	g9284	i0	79.9	3.4039603960396	144	29	85.5	0	503	72	5	148	MCQ2818557.1 ubiquitin-conjugating enzyme E2 [archaeon]	diamond	1719	254	1	Archaea								archaeon
28052983	28052983	PRJNA169559_P_NODE_6805_length_649_cov_33.167742_g5304_i0	PRJNA169559	6805	649	33.167742	215.25864558	archaeon	1906665	Archaea	Archaea	281	2.9e-93	NR	MCQ2821492.1	1906665	g5304	i0	70.9	7.50693374422188	203	59	93.8	0	3	611	2	204	MCQ2821492.1 50S ribosomal protein L15e [archaeon]	diamond	4872	281	1	Archaea								archaeon
28873928	28873928	PRJNA169559_P_NODE_568_length_2274_cov_3.105568_g245_i0	PRJNA169559	568	2274	3.105568	70.62061632	archaeon	1906665	Archaea	Archaea	157	2.01e-35	NR	MDP2435053.1	1906665	g245	i0	30.3	0.518469656992084	393	202	47	12	1069	2	301	658	MDP2435053.1 hypothetical protein [archaeon]	diamond	1179	157	1	Archaea								archaeon
28905292	28905292	PRJNA169559_P_NODE_2548_length_1037_cov_2.889881_g1637_i0	PRJNA169559	2548	1037	2.889881	29.96806597	Methanoregulaceae archaeon	2485498	Archaea	Archaea	65.5	1.48e-7	NR	HNJ81026.1	2485498	g1637	i0	45	0.17357762777242	60	31	17.4	1	732	553	603	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	180	65.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
29063542	29063542	PRJNA169559_P_NODE_31428_length_259_cov_1.152174_g29352_i0	PRJNA169559	31428	259	1.152174	2.98413066	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	56.2	5.83e-8	NR	MEM0150088.1	2953041	g29352	i0	37.2	0.996138996138996	86	42	99.6	1	258	1	20	93	MEM0150088.1 C1 family peptidase [Candidatus Micrarchaeaceae archaeon]	diamond	258	56.2	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
29884538	29884538	PRJNA169559_P_NODE_20971_length_359_cov_2.127273_g18914_i0	PRJNA169559	20971	359	2.127273	7.63691007	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	87	1.33e-17	NR	RLI10719.1	2026714	g18914	i0	44.7	3.14206128133705	94	52	78.6	0	357	76	12	105	RLI10719.1 MAG: L-threonine 3-dehydrogenase [Candidatus Bathyarchaeota archaeon]	diamond	1128	87	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30769109	30769109	PRJNA169559_P_NODE_31094_length_260_cov_1.718615_g29018_i0	PRJNA169559	31094	260	1.718615	4.468399	Pyrobaculum sp.	2004705	Archaea	Archaea	76.6	2.24e-14	NR	MCC6035629.1	2004705	g29018	i0	45.9	3.92307692307692	85	46	98.1	0	257	3	205	289	MCC6035629.1 deoxyhypusine synthase [Pyrobaculum sp.]	diamond	1020	76.6	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum sp.
32097044	32097044	PRJNA169559_P_NODE_318_length_4507_cov_3.357972_g109_i0	PRJNA169559	318	4507	3.357972	151.34379804	archaeon	1906665	Archaea	Archaea	108	3e-19	NR	MDP2435053.1	1906665	g109	i0	26.1	0.252939871311294	380	220	23	13	4500	3463	238	590	MDP2435053.1 hypothetical protein [archaeon]	diamond	1140	108	1	Archaea								archaeon
32634364	32634364	PRJNA169559_P_NODE_320_length_4464_cov_3.395265_g109_i1	PRJNA169559	320	4464	3.395265	151.5646296	archaeon	1906665	Archaea	Archaea	105	1.5e-18	NR	MDP2435053.1	1906665	g109	i1	26.3	0.24260752688172	361	211	22.1	12	4449	3463	253	590	MDP2435053.1 hypothetical protein [archaeon]	diamond	1083	105	1	Archaea								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);;