metadata: contig_metadata: 29 rows where bioproject = "PRJNA438572" and tax

29 rows where bioproject = "PRJNA438572" 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
435159	435159	PRJNA438572_P_NODE_6061_length_407_cov_0.934132_g5942_i0	PRJNA438572	6061	407	0.934132	3.80191724	archaeon	1906665	Archaea	Archaea	200	5.92e-63	NR	MDP2437245.1	1906665	g5942	i0	97.1	0.759213759213759	103	3	75.9	0	360	52	1	103	MDP2437245.1 Ras-related Rap1 family protein [archaeon]	diamond	309	200	1	Archaea								archaeon
2366478	2366478	PRJNA438572_P_NODE_21302_length_246_cov_1.780347_g21183_i0	PRJNA438572	21302	246	1.780347	4.37965362	root	1	Root_unresolved	Root_unresolved	73.2	7.49e-13	NR	MDA4120811.1	2026795	g21183	i0	44.7	2.70731707317073	76	41	91.5	1	10	234	507	582	MDA4120811.1 ATP-dependent DNA ligase [Nitrososphaerota archaeon]	diamond	666	73.6	0.994565217391304	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
26600850	26600850	PRJNA438572_P_NODE_17381_length_252_cov_1.636872_g17262_i0	PRJNA438572	17381	252	1.636872	4.12491744	archaeon	1906665	Archaea	Archaea	106	7.36e-25	NR	RYY82929.1	1906665	g17262	i0	73.8	0.773809523809524	65	17	77.4	0	55	249	3	67	RYY82929.1 MAG: hypothetical protein EON63_12300, partial [archaeon]	diamond	195	106	1	Archaea								archaeon
26981039	26981039	PRJNA438572_P_NODE_7822_length_363_cov_1.448276_g7703_i0	PRJNA438572	7822	363	1.448276	5.25724188	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	46.6	0.00463	NR	HKM78303.1	3045160	g7703	i0	36.7	0.743801652892562	90	51	69.4	1	339	88	11	100	HKM78303.1 lipoyl(octanoyl) transferase LipB [Candidatus Bathyarchaeia archaeon]	diamond	270	46.6	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
27138810	27138810	PRJNA438572_P_NODE_15302_length_266_cov_1.233161_g15183_i0	PRJNA438572	15302	266	1.233161	3.28020826	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	47.4	0.00115	NR	MBI5061504.1	3121606	g15183	i0	42.9	3.0112781954887202	70	37	75.6	2	226	26	330	399	MBI5061504.1 VWA domain-containing protein [Candidatus Aenigmatarchaeota archaeon]	diamond	801	47.4	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
27423890	27423890	PRJNA438572_P_NODE_17263_length_253_cov_0.866667_g17144_i0	PRJNA438572	17263	253	0.866667	2.19266751	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	94.4	2.87e-20	NR	MBN2053197.1	2026803	g17144	i0	53.2	0.91304347826087	77	36	91.3	0	18	248	1	77	MBN2053197.1 pyruvate, phosphate dikinase [Candidatus Woesearchaeota archaeon]	diamond	231	94.4	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
27739725	27739725	PRJNA438572_P_NODE_21124_length_247_cov_0.896552_g21005_i0	PRJNA438572	21124	247	0.896552	2.21448344	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	75.1	2.61e-14	NR	MCD6092916.1	3121606	g21005	i0	43.5	4.70040485829959	85	43	98.4	2	2	244	44	127	MCD6092916.1 adenylate kinase [Candidatus Aenigmatarchaeota archaeon]	diamond	1161	75.1	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
28434066	28434066	PRJNA438572_P_NODE_11346_length_305_cov_1.594828_g11227_i0	PRJNA438572	11346	305	1.594828	4.8642254	archaeon	1906665	Archaea	Archaea	49.3	3.85e-4	NR	MCQ2820519.1	1906665	g11227	i0	28.7	0.855737704918033	87	62	85.6	0	43	303	80	166	MCQ2820519.1 carbonic anhydrase family protein [archaeon]	diamond	261	49.3	1	Archaea								archaeon
28560426	28560426	PRJNA438572_P_NODE_17567_length_252_cov_0.871508_g17448_i0	PRJNA438572	17567	252	0.871508	2.19620016	archaeon	1906665	Archaea	Archaea	110	1.08e-29	NR	RYH24231.1	1906665	g17448	i0	73.2	0.976190476190476	82	21	96.4	1	244	2	4	85	RYH24231.1 MAG: hypothetical protein EON65_16950 [archaeon]	diamond	246	110	1	Archaea								archaeon
28623620	28623620	PRJNA438572_P_NODE_14227_length_276_cov_1.339901_g14108_i0	PRJNA438572	14227	276	1.339901	3.69812676	archaeon	1906665	Archaea	Archaea	45.4	0.00383	NR	MCQ2819164.1	1906665	g14108	i0	36.1	0.782608695652174	72	39	71.7	2	208	11	82	152	MCQ2819164.1 hypothetical protein [archaeon]	diamond	216	45.4	1	Archaea								archaeon
28812548	28812548	PRJNA438572_P_NODE_12508_length_291_cov_1.568807_g12389_i0	PRJNA438572	12508	291	1.568807	4.56522837	Methanoregula sp. UBA64	1915554	Archaea	Archaea	78.6	1.69e-14	NR	WP_292370680.1	1915554	g12389	i0	45.3	2.95876288659794	95	49	97.9	1	5	289	802	893	WP_292370680.1 magnesium-translocating P-type ATPase [Methanoregula sp. UBA64]	diamond	861	78.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. UBA64
29633411	29633411	PRJNA438572_P_NODE_24490_length_242_cov_0.923077_g24371_i0	PRJNA438572	24490	242	0.923077	2.23384634	Thermoplasmata archaeon	1906666	Archaea	Archaea	62.4	2.36e-9	NR	MFP4000404.1	1906666	g24371	i0	36.3	0.991735537190083	80	47	94.2	1	242	15	16	95	MFP4000404.1 enoyl-CoA hydratase/isomerase family protein [Thermoplasmata archaeon]	diamond	240	62.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29728273	29728273	PRJNA438572_P_NODE_14670_length_272_cov_1.040201_g14551_i0	PRJNA438572	14670	272	1.040201	2.82934672	archaeon	1906665	Archaea	Archaea	123	4.68e-33	NR	MDP2437002.1	1906665	g14551	i0	83.8	2.52573529411765	74	12	81.6	0	270	49	87	160	MDP2437002.1 Rab family GTPase [archaeon]	diamond	687	123	1	Archaea								archaeon
29918181	29918181	PRJNA438572_P_NODE_21671_length_246_cov_0.901734_g21552_i0	PRJNA438572	21671	246	0.901734	2.21826564	archaeon	1906665	Archaea	Archaea	45.1	0.00592	NR	MDP2434991.1	1906665	g21552	i0	41.2	0.621951219512195	51	30	62.2	0	244	92	657	707	MDP2434991.1 ankyrin repeat domain-containing protein [archaeon]	diamond	153	45.1	1	Archaea								archaeon
30329290	30329290	PRJNA438572_P_NODE_1952_length_694_cov_2.727858_g1842_i0	PRJNA438572	1952	694	2.727858	18.93133452	archaeon	1906665	Archaea	Archaea	213	3.13e-62	NR	MCQ2816174.1	1906665	g1842	i0	44.6	1.95821325648415	224	117	96.4	2	26	694	314	531	MCQ2816174.1 hypothetical protein [archaeon]	diamond	1359	213	1	Archaea								archaeon
30518336	30518336	PRJNA438572_P_NODE_23013_length_244_cov_0.912281_g22894_i0	PRJNA438572	23013	244	0.912281	2.22596564	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	128	4.979999999999998e-35	NR	RJS75544.1	2026714	g22894	i0	69.1	0.995901639344262	81	25	99.6	0	2	244	69	149	RJS75544.1 MAG: TIGR00289 family protein [Candidatus Bathyarchaeota archaeon]	diamond	243	128	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30644556	30644556	PRJNA438572_P_NODE_10673_length_314_cov_1.294606_g10554_i0	PRJNA438572	10673	314	1.294606	4.06506284	Methanomethylophilus sp.	2774294	Archaea	Archaea	45.1	0.0116	NR	MBO4502605.1	2774294	g10554	i0	36.4	1.46178343949045	55	35	52.5	0	114	278	12	66	MBO4502605.1 Mrp/NBP35 family ATP-binding protein [Methanomethylophilus sp.]	diamond	459	45.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus sp.
30739449	30739449	PRJNA438572_P_NODE_15314_length_266_cov_1.212435_g15195_i0	PRJNA438572	15314	266	1.212435	3.2250771	archaeon	1906665	Archaea	Archaea	62	8.14e-9	NR	MCQ2820475.1	1906665	g15195	i0	41.6	2.59398496240602	77	45	86.8	0	266	36	554	630	MCQ2820475.1 hypothetical protein [archaeon]	diamond	690	62	1	Archaea								archaeon
30819028	30819028	PRJNA438572_P_NODE_12874_length_288_cov_1.409302_g12755_i0	PRJNA438572	12874	288	1.409302	4.05878976	root	1	Root_unresolved	Root_unresolved	127	4.27e-33	NR	WP_089866118.1	553466	g12755	i0	58.5	21.5833333333333	94	39	97.9	0	5	286	54	147	WP_089866118.1 alcohol dehydrogenase [Halogranum rubrum]	diamond	6216	127	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halogranum	Halogranum rubrum
30819036	30819036	PRJNA438572_P_NODE_8774_length_344_cov_1.151292_g8655_i0	PRJNA438572	8774	344	1.151292	3.96044448	root	1	Root_unresolved	Root_unresolved	92.8	2.46e-19	NR	HEX7444945.1	90426	g8655	i0	43.6	4.68313953488372	110	56	94.2	2	18	341	32	137	HEX7444945.1 ATP citrate lyase citrate-binding domain-containing protein [Methanothrix sp.]	diamond	1611	93.6	0.991452991452991	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30865814	30865814	PRJNA438572_P_NODE_9834_length_326_cov_2.000000_g9715_i0	PRJNA438572	9834	326	2	6.52	archaeon	1906665	Archaea	Archaea	107	2.5e-27	NR	NDB28235.1	1906665	g9715	i0	67.5	0.763803680981595	83	26	75.5	1	322	77	59	141	NDB28235.1 dUTP diphosphatase [archaeon]	diamond	249	107	1	Archaea								archaeon
31371749	31371749	PRJNA438572_P_NODE_11916_length_298_cov_0.928889_g11797_i0	PRJNA438572	11916	298	0.928889	2.76808922	archaeon	1906665	Archaea	Archaea	50.8	5.87e-5	NR	MDP2435104.1	1906665	g11797	i0	40	0.704697986577181	70	40	68.5	2	215	12	39	108	MDP2435104.1 SH2 domain-containing protein [archaeon]	diamond	210	50.8	1	Archaea								archaeon
31656070	31656070	PRJNA438572_P_NODE_9837_length_326_cov_1.849802_g9718_i0	PRJNA438572	9837	326	1.849802	6.03035452	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	49.7	1.71e-4	NR	MEM4268237.1	2026803	g9718	i0	38	0.653374233128834	71	38	62.6	3	25	228	93	160	MEM4268237.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	213	49.7	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
31845916	31845916	PRJNA438572_P_NODE_17717_length_252_cov_0.871508_g17598_i0	PRJNA438572	17717	252	0.871508	2.19620016	archaeon	1906665	Archaea	Archaea	113	4.31e-30	NR	RYG62656.1	1906665	g17598	i0	66.3	0.988095238095238	83	28	98.8	0	2	250	7	89	RYG62656.1 MAG: hypothetical protein EON64_17460 [archaeon]	diamond	249	113	1	Archaea								archaeon
32035853	32035853	PRJNA438572_P_NODE_5378_length_430_cov_1.184874_g5259_i0	PRJNA438572	5378	430	1.184874	5.0949582	Thermoplasmata archaeon	1906666	Archaea	Archaea	44.7	0.0474	NR	MCK5292578.1	1906666	g5259	i0	31.8	0.613953488372093	88	57	59.3	1	6	260	211	298	MCK5292578.1 cell division protein FtsZ [Thermoplasmata archaeon]	diamond	264	44.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32130996	32130996	PRJNA438572_P_NODE_8878_length_342_cov_1.427509_g8759_i0	PRJNA438572	8878	342	1.427509	4.88208078	archaeon	1906665	Archaea	Archaea	154	1.7799999999999994e-42	NR	MDP2436715.1	1906665	g8759	i0	67.3	1.98245614035088	113	35	99.1	2	339	1	8	118	MDP2436715.1 hypothetical protein [archaeon]	diamond	678	154	1	Archaea								archaeon
32605234	32605234	PRJNA438572_P_NODE_13220_length_285_cov_1.174528_g13101_i0	PRJNA438572	13220	285	1.174528	3.3474048	archaeon	1906665	Archaea	Archaea	86.3	1.55e-18	NR	RYY33328.1	1906665	g13101	i0	47.6	0.863157894736842	82	38	83.2	2	47	283	8	87	RYY33328.1 MAG: hypothetical protein EON62_04335 [archaeon]	diamond	246	86.3	1	Archaea								archaeon
32621405	32621405	PRJNA438572_P_NODE_24360_length_242_cov_0.923077_g24241_i0	PRJNA438572	24360	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	74.7	1.97e-13	NR	MBM3910197.1	2026795	g24241	i0	44.9	4.68595041322314	78	41	95.5	2	234	4	29	105	MBM3910197.1 FAD-dependent oxidoreductase [Nitrososphaerota archaeon]	diamond	1134	74.7	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
32810361	32810361	PRJNA438572_P_NODE_3060_length_561_cov_1.684426_g2942_i0	PRJNA438572	3060	561	1.684426	9.44962986	Methanoregula	395331	Archaea	Archaea	50.4	0.00166	NR	WP_292368417.1	1915554	g2942	i0	38.2	0.796791443850267	76	42	40.6	1	334	561	292	362	WP_292368417.1 hypothetical protein [Methanoregula sp. UBA64]	diamond	447	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. UBA64

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