metadata: contig_metadata: 36 rows where bioproject = "PRJNA1164198" and tax

36 rows where bioproject = "PRJNA1164198" 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
311990	311990	PRJNA1164198_P_NODE_23241_length_257_cov_2.565217_g22972_i0	PRJNA1164198	23241	257	2.565217	6.59260769	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	459	1.18e-124	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g22972	i0	98.833	100.610894941634	257	3	100	0	1	257	1504256	1504512	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	25857	459	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
2862772	2862772	PRJNA1164198_P_NODE_11763_length_362_cov_2.207612_g11495_i0	PRJNA1164198	11763	362	2.207612	7.99155544	archaeon	1906665	Archaea	Archaea	184	1.42e-56	NR	RYG65124.1	1906665	g11495	i0	87.4	0.853591160220994	103	13	85.4	0	361	53	110	212	RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon]	diamond	309	184	1	Archaea								archaeon
2862791	2862791	PRJNA1164198_P_NODE_19023_length_284_cov_1.478673_g18754_i0	PRJNA1164198	19023	284	1.478673	4.19943132	root	1	Root_unresolved	Root_unresolved	138	1.0199999999999998e-37	NR	MEM4658407.1	2495426	g18754	i0	63.8	4.96478873239437	94	34	99.3	0	282	1	14	107	MEM4658407.1 adenylyl-sulfate kinase [Candidatus Methanosuratincola sp.]	diamond	1410	138	1	Archaea		Thermoproteati	Thermoproteota	Methanosuratincolia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae	Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016)	Candidatus Methanosuratincola sp.
3589995	3589995	PRJNA1164198_P_NODE_30923_length_242_cov_0.923077_g30654_i0	PRJNA1164198	30923	242	0.923077	2.23384634	archaeon	1906665	Archaea	Archaea	132	3.75e-38	NR	RYG67591.1	1906665	g30654	i0	81.3	0.991735537190083	80	15	99.2	0	240	1	8	87	RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon]	diamond	240	132	1	Archaea								archaeon
5415026	5415026	PRJNA1164198_P_NODE_15385_length_315_cov_2.590909_g15116_i0	PRJNA1164198	15385	315	2.590909	8.16136335	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	549	8.579999999999997e-152	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g15116	i0	98.095	97.584126984127	315	6	100	0	1	315	1538062	1537748	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	30739	549	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
5415048	5415048	PRJNA1164198_P_NODE_21625_length_267_cov_1.649485_g21356_i0	PRJNA1164198	21625	267	1.649485	4.40412495	archaeon	1906665	Archaea	Archaea	157	1e-43	NR	RYH13265.1	1906665	g21356	i0	86.4	1.96629213483146	88	12	98.9	0	3	266	365	452	RYH13265.1 MAG: F0F1 ATP synthase subunit alpha [archaeon]	diamond	525	157	1	Archaea								archaeon
7417386	7417386	PRJNA1164198_P_NODE_21746_length_266_cov_3.093264_g21477_i0	PRJNA1164198	21746	266	3.093264	8.22808224	Methanobacteriati	3366610	Archaea	Archaea	492	1.2099999999999999e-134	NTclustered	gi\|224979270\|gb\|FJ752570.1\|	198240	g21477	i0	100	96.9736842105263	266	0	100	0	1	266	54	319	Uncultured methanogenic archaeon clone E18_16S1_Mx-03 16S ribosomal RNA gene, partial sequence	blastn	25795	492	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured methanogenic archaeon
9239857	9239857	PRJNA1164198_P_NODE_16888_length_301_cov_0.921053_g16619_i0	PRJNA1164198	16888	301	0.921053	2.77236953	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	556	4.87e-154	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g16619	i0	100	45.3521594684385	301	0	100	0	1	301	1502910	1502610	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	13651	556	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
11790557	11790557	PRJNA1164198_P_NODE_20990_length_271_cov_1.429293_g20721_i0	PRJNA1164198	20990	271	1.429293	3.87338403	archaeon	1906665	Archaea	Archaea	96.7	8.1e-23	NR	RYH14173.1	1906665	g20721	i0	62.5	0.974169741697417	88	28	93	3	1	252	37	123	RYH14173.1 MAG: hypothetical protein EON65_34035 [archaeon]	diamond	264	96.7	1	Archaea								archaeon
14340884	14340884	PRJNA1164198_P_NODE_15552_length_314_cov_1.294606_g15283_i0	PRJNA1164198	15552	314	1.294606	4.06506284	archaeon	1906665	Archaea	Archaea	186	5.8599999999999985e-56	NR	MDP2438594.1	1906665	g15283	i0	82.5	0.984076433121019	103	18	98.4	0	309	1	189	291	MDP2438594.1 WD40 repeat domain-containing protein [archaeon]	diamond	309	186	1	Archaea								archaeon
14340899	14340899	PRJNA1164198_P_NODE_21072_length_270_cov_3.035533_g20803_i0	PRJNA1164198	21072	270	3.035533	8.1959391	uncultured archaeon	115547	Archaea	Archaea	333	7.8899999999999995e-87	NTclustered	gi\|1032564008\|gb\|KX029804.1\|	115547	g20803	i0	94.907	41.5888888888889	216	5	80	5	55	270	250	41	Uncultured archaeon clone A_OTU_328 16S ribosomal RNA gene, partial sequence	blastn	11229	333	1	Archaea								uncultured archaeon
14340958	14340958	PRJNA1164198_P_NODE_4632_length_584_cov_1.933464_g4384_i0	PRJNA1164198	4632	584	1.933464	11.29142976	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	1079	0	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g4384	i0	100	109.635273972603	584	0	100	0	1	584	1503535	1502952	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	64027	1079	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
18163627	18163627	PRJNA1164198_P_NODE_31515_length_232_cov_2.767296_g31246_i0	PRJNA1164198	31515	232	2.767296	6.42012672	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	427	2.95e-115	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g31246	i0	100	166.521551724138	231	0	99	0	2	232	1502377	1502607	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	38633	427	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
21988731	21988731	PRJNA1164198_P_NODE_27718_length_247_cov_0.896552_g27449_i0	PRJNA1164198	27718	247	0.896552	2.21448344	Salinirubellus litoreus	3131999	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2700494409\|gb\|CP147841.1\|	3131999	g27449	i0	100	0.57085020242915	29	0	12	0	52	80	2610986	2610958	Salinirubellus litoreus strain SYNS196 chromosome, complete genome	blastn	141	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Salinirubellus	Salinirubellus litoreus
21988763	21988763	PRJNA1164198_P_NODE_9098_length_413_cov_1.482353_g8833_i0	PRJNA1164198	9098	413	1.482353	6.12211789	archaeon	1906665	Archaea	Archaea	217	6.280000000000001e-70	NR	RYH06910.1	1906665	g8833	i0	88.7	0.835351089588378	115	13	83.5	0	412	68	48	162	RYH06910.1 MAG: hypothetical protein EON65_42320 [archaeon]	diamond	345	217	1	Archaea								archaeon
23991709	23991709	PRJNA1164198_P_NODE_7139_length_470_cov_1.732997_g6878_i0	PRJNA1164198	7139	470	1.732997	8.1450859	Methanobacteriati	3366610	Archaea	Archaea	869	0	NTclustered	gi\|91807144\|gb\|DQ445723.1\|	379361	g6878	i0	100	99.9510638297872	470	0	100	0	1	470	341	810	Methanogenic archaeon CH1270 16S ribosomal RNA gene, partial sequence	blastn	46977	869	1	Archaea		Methanobacteriati	Methanobacteriota					methanogenic archaeon CH1270
24537933	24537933	PRJNA1164198_P_NODE_29840_length_243_cov_2.664706_g29571_i0	PRJNA1164198	29840	243	2.664706	6.47523558	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	442	1.1099999999999995e-119	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g29571	i0	99.587	10.8353909465021	242	1	99	0	2	243	1503976	1504217	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	2633	442	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
26787368	26787368	PRJNA1164198_P_NODE_26501_length_249_cov_0.886364_g26232_i0	PRJNA1164198	26501	249	0.886364	2.20704636	archaeon	1906665	Archaea	Archaea	141	9.79e-41	NR	RYH28497.1	1906665	g26232	i0	78.3	1	83	15	100	1	249	1	55	134	RYH28497.1 MAG: hypothetical protein EON65_11945 [archaeon]	diamond	249	141	1	Archaea								archaeon
26945391	26945391	PRJNA1164198_P_NODE_29222_length_245_cov_0.883721_g28953_i0	PRJNA1164198	29222	245	0.883721	2.16511645	archaeon	1906665	Archaea	Archaea	60.5	2.16e-8	NR	MDP2439311.1	1906665	g28953	i0	60.5	0.52653061224489806	43	17	52.7	0	117	245	666	708	MDP2439311.1 RasGEF domain-containing protein [archaeon]	diamond	129	60.5	1	Archaea								archaeon
27008629	27008629	PRJNA1164198_P_NODE_18762_length_286_cov_1.464789_g18493_i0	PRJNA1164198	18762	286	1.464789	4.18929654	archaeon	1906665	Archaea	Archaea	127	1.42e-33	NR	MDP2435546.1	1906665	g18493	i0	69.5	0.86013986013986	82	25	86	0	37	282	8	89	MDP2435546.1 30S ribosomal protein S2 [archaeon]	diamond	246	127	1	Archaea								archaeon
27735760	27735760	PRJNA1164198_P_NODE_21844_length_266_cov_1.378238_g21575_i0	PRJNA1164198	21844	266	1.378238	3.66611308	archaeon	1906665	Archaea	Archaea	156	6.04e-44	NR	RYG69615.1	1906665	g21575	i0	81.4	0.969924812030075	86	16	97	0	260	3	274	359	RYG69615.1 MAG: hypothetical protein EON64_02265 [archaeon]	diamond	258	156	1	Archaea								archaeon
27988085	27988085	PRJNA1164198_P_NODE_21645_length_267_cov_1.603093_g21376_i0	PRJNA1164198	21645	267	1.603093	4.28025831	archaeon	1906665	Archaea	Archaea	89.7	2.17e-19	NR	RYG67343.1	1906665	g21376	i0	60.2	0.98876404494382	88	33	98.9	2	3	266	28	113	RYG67343.1 MAG: hypothetical protein EON64_07675 [archaeon]	diamond	264	89.7	1	Archaea								archaeon
29692700	29692700	PRJNA1164198_P_NODE_29310_length_244_cov_1.742690_g29041_i0	PRJNA1164198	29310	244	1.74269	4.2521636	archaeon	1906665	Archaea	Archaea	52.4	8.63e-7	NR	RYG97170.1	1906665	g29041	i0	50.9	0.651639344262295	53	23	61.5	1	244	95	16	68	RYG97170.1 MAG: hypothetical protein EON65_53280, partial [archaeon]	diamond	159	52.4	1	Archaea								archaeon
29819118	29819118	PRJNA1164198_P_NODE_19471_length_281_cov_1.269231_g19202_i0	PRJNA1164198	19471	281	1.269231	3.56653911	archaeon	1906665	Archaea	Archaea	54.3	5.24e-6	NR	MDP2435053.1	1906665	g19202	i0	45.7	0.864768683274021	81	36	81.1	5	22	249	1226	1303	MDP2435053.1 hypothetical protein [archaeon]	diamond	243	54.3	1	Archaea								archaeon
30009056	30009056	PRJNA1164198_P_NODE_24431_length_253_cov_0.866667_g24162_i0	PRJNA1164198	24431	253	0.866667	2.19266751	archaeon	1906665	Archaea	Archaea	43.5	0.0223	NR	RYH24738.1	1906665	g24162	i0	60.7	0.33201581027668	28	11	33.2	0	245	162	846	873	RYH24738.1 MAG: protein serine/threonine phosphatase 2C family protein [archaeon]	diamond	84	43.5	1	Archaea								archaeon
30134909	30134909	PRJNA1164198_P_NODE_26412_length_249_cov_0.886364_g26143_i0	PRJNA1164198	26412	249	0.886364	2.20704636	Nitrosarchaeum sp.	2026886	Archaea	Archaea	110	5.49e-26	NR	MFB5612793.1	2026886	g26143	i0	68.3	0.987951807228916	82	26	98.8	0	247	2	515	596	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	246	110	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
30735510	30735510	PRJNA1164198_P_NODE_7234_length_467_cov_1.505076_g6973_i0	PRJNA1164198	7234	467	1.505076	7.02870492	Nanobdellota archaeon	2026764	Archaea	Archaea	212	2.89e-61	NR	MCA9485224.1	2026764	g6973	i0	64.5	0.995717344753747	155	55	99.6	0	467	3	268	422	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	465	212	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
30830287	30830287	PRJNA1164198_P_NODE_14034_length_330_cov_2.319066_g13765_i0	PRJNA1164198	14034	330	2.319066	7.6529178	archaeon	1906665	Archaea	Archaea	72	3.04e-13	NR	MDP2436403.1	1906665	g13765	i0	36.7	0.818181818181818	90	52	77.3	1	269	15	2	91	MDP2436403.1 hypothetical protein [archaeon]	diamond	270	72	1	Archaea								archaeon
30893694	30893694	PRJNA1164198_P_NODE_20294_length_275_cov_1.544554_g20025_i0	PRJNA1164198	20294	275	1.544554	4.2475235	archaeon	1906665	Archaea	Archaea	107	5.12e-25	NR	RYG67429.1	1906665	g20025	i0	53.8	0.992727272727273	91	41	98.2	1	4	273	297	387	RYG67429.1 MAG: hypothetical protein EON64_07455 [archaeon]	diamond	273	107	1	Archaea								archaeon
31083125	31083125	PRJNA1164198_P_NODE_1615_length_961_cov_1.763514_g1447_i0	PRJNA1164198	1615	961	1.763514	16.94736954	Nitrososphaerota archaeon	2026795	Archaea	Archaea	60.5	5.96e-6	NR	MDG6921989.1	2026795	g1447	i0	25.9	0.602497398543184	193	127	59.6	6	933	361	632	810	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	579	60.5	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31355368	31355368	PRJNA1164198_P_NODE_31996_length_208_cov_2.259259_g31727_i0	PRJNA1164198	31996	208	2.259259	4.6992587199999996	Candidatus Fermentimicrarchaeum	2795013	Archaea	Archaea	43.9	0.00823	NR	MBU2100876.1	2250274	g31727	i0	77.3	0.692307692307692	22	5	31.7	0	9	74	9	30	MBU2100876.1 carboxypeptidase-like regulatory domain-containing protein [Candidatus Micrarchaeota archaeon]	diamond	144	44.3	0.99097065462754	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
31399434	31399434	PRJNA1164198_P_NODE_9436_length_405_cov_1.903614_g9171_i0	PRJNA1164198	9436	405	1.903614	7.7096367	Nitrososphaerota archaeon	2026795	Archaea	Archaea	61.6	6e-8	NR	MDG6921989.1	2026795	g9171	i0	28.9	0.896296296296296	121	79	84.4	2	46	387	500	620	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	363	61.6	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31430832	31430832	PRJNA1164198_P_NODE_26756_length_249_cov_0.886364_g26487_i0	PRJNA1164198	26756	249	0.886364	2.20704636	archaeon	1906665	Archaea	Archaea	99.4	2.85e-23	NR	MDP2438765.1	1906665	g26487	i0	68.2	0.795180722891566	66	21	79.5	0	52	249	68	133	MDP2438765.1 hypothetical protein [archaeon]	diamond	198	99.4	1	Archaea								archaeon
31778745	31778745	PRJNA1164198_P_NODE_31737_length_228_cov_2.012903_g31468_i0	PRJNA1164198	31737	228	2.012903	4.5894188400000004	archaeon	1906665	Archaea	Archaea	100	3.1599999999999996e-23	NR	MDP2439249.1	1906665	g31468	i0	72.6	0.815789473684211	62	17	81.6	0	34	219	15	76	MDP2439249.1 MC/SLC25 family protein [archaeon]	diamond	186	100	1	Archaea								archaeon
32000279	32000279	PRJNA1164198_P_NODE_24318_length_253_cov_0.866667_g24049_i0	PRJNA1164198	24318	253	0.866667	2.19266751	archaeon	1906665	Archaea	Archaea	120	5.34e-33	NR	MDP2434993.1	1906665	g24049	i0	72.6	0.99604743083004	84	23	99.6	0	1	252	10	93	MDP2434993.1 hypothetical protein [archaeon]	diamond	252	120	1	Archaea								archaeon
32127033	32127033	PRJNA1164198_P_NODE_17178_length_298_cov_1.484444_g16909_i0	PRJNA1164198	17178	298	1.484444	4.42364312	archaeon	1906665	Archaea	Archaea	159	9.549999999999999e-48	NR	RYG68310.1	1906665	g16909	i0	81.8	0.996644295302013	99	18	99.7	0	297	1	3	101	RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon]	diamond	297	159	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);;