metadata: contig_metadata: 31 rows where bioproject = "PRJNA667863" and tax

31 rows where bioproject = "PRJNA667863" 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
3184797	3184797	PRJNA667863_P_NODE_10463_length_255_cov_1.637363_g10429_i0	PRJNA667863	10463	255	1.637363	4.17527565	archaeon	1906665	Archaea	Archaea	156	6.98e-47	NR	RYH03712.1	1906665	g10429	i0	91.7	0.988235294117647	84	7	98.8	0	2	253	16	99	RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon]	diamond	252	156	1	Archaea								archaeon
8287330	8287330	PRJNA667863_P_NODE_7087_length_277_cov_2.941176_g7053_i0	PRJNA667863	7087	277	2.941176	8.14705752	Methanobacteriota archaeon	2026739	Archaea	Archaea	85.9	4.31e-18	NR	RYE97637.1	2026739	g7053	i0	73.6	0.574007220216607	53	14	57.4	0	159	1	19	71	RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon]	diamond	159	85.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
12113354	12113354	PRJNA667863_P_NODE_7290_length_276_cov_1.275862_g7256_i0	PRJNA667863	7290	276	1.275862	3.52137912	archaeon	1906665	Archaea	Archaea	148	4.35e-42	NR	RYG67557.1	1906665	g7256	i0	78	0.989130434782609	91	19	97.8	1	271	2	47	137	RYG67557.1 MAG: hypothetical protein EON64_07185 [archaeon]	diamond	273	148	1	Archaea								archaeon
17211976	17211976	PRJNA667863_P_NODE_14814_length_245_cov_0.895349_g14780_i0	PRJNA667863	14814	245	0.895349	2.19360505	archaeon	1906665	Archaea	Archaea	125	8.869999999999999e-34	NR	RYG62826.1	1906665	g14780	i0	75	0.979591836734694	80	20	98	0	241	2	47	126	RYG62826.1 MAG: dihydrolipoyl dehydrogenase, partial [archaeon]	diamond	240	125	1	Archaea								archaeon
18486338	18486338	PRJNA667863_P_NODE_15335_length_244_cov_0.900585_g15301_i0	PRJNA667863	15335	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	80.1	3.13e-16	NR	MDP2438286.1	1906665	g15301	i0	57.7	7.77049180327869	78	31	95.9	1	238	5	57	132	MDP2438286.1 hypothetical protein [archaeon]	diamond	1896	80.5	0.995031055900621	Archaea								archaeon
24860201	24860201	PRJNA667863_P_NODE_19560_length_199_cov_4.484127_g19526_i0	PRJNA667863	19560	199	4.484127	8.92341273	Methanosarcinales archaeon	2250255	Archaea	Archaea	139	1.5399999999999998e-37	NR	RYE83110.1	2250255	g19526	i0	95.5	0.994974874371859	66	3	99.5	0	198	1	278	343	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	198	139	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
27460962	27460962	PRJNA667863_P_NODE_15663_length_243_cov_0.905882_g15629_i0	PRJNA667863	15663	243	0.905882	2.20129326	archaeon	1906665	Archaea	Archaea	60.1	2.88e-8	NR	MDP2436434.1	1906665	g15629	i0	43.5	0.851851851851852	69	36	81.5	2	242	45	909	977	MDP2436434.1 ubiquitin-conjugating enzyme E2 [archaeon]	diamond	207	60.1	1	Archaea								archaeon
27871196	27871196	PRJNA667863_P_NODE_17725_length_235_cov_2.462963_g17691_i0	PRJNA667863	17725	235	2.462963	5.78796305	archaeon	1906665	Archaea	Archaea	46.2	5.68e-4	NR	RYY32091.1	1906665	g17691	i0	73.3	0.382978723404255	30	8	38.3	0	233	144	88	117	RYY32091.1 MAG: hypothetical protein EON62_05800 [archaeon]	diamond	90	46.2	1	Archaea								archaeon
28092259	28092259	PRJNA667863_P_NODE_18265_length_230_cov_2.006369_g18231_i0	PRJNA667863	18265	230	2.006369	4.6146487	Halococcus saccharolyticus	62319	Archaea	Archaea	43.9	0.0047	NR	WP_006078117.1	62319	g18231	i0	40	0.782608695652174	60	36	78.3	0	46	225	37	96	WP_006078117.1 hypothetical protein [Halococcus saccharolyticus]	diamond	180	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus saccharolyticus
28250018	28250018	PRJNA667863_P_NODE_13006_length_248_cov_0.880000_g12972_i0	PRJNA667863	13006	248	0.88	2.1824	archaeon	1906665	Archaea	Archaea	84.3	5.77e-18	NR	RYH32054.1	1906665	g12972	i0	64.6	0.786290322580645	65	23	78.6	0	50	244	125	189	RYH32054.1 MAG: hypothetical protein EON65_01180 [archaeon]	diamond	195	84.3	1	Archaea								archaeon
28408089	28408089	PRJNA667863_P_NODE_8966_length_264_cov_1.340314_g8932_i0	PRJNA667863	8966	264	1.340314	3.53842896	Methanobacteriota archaeon	2026739	Archaea	Archaea	43.5	0.024	NR	MAO69906.1	2026739	g8932	i0	38.3	0.681818181818182	60	36	67	1	206	30	23	82	MAO69906.1 low specificity L-threonine aldolase [Methanobacteriota archaeon]	diamond	180	43.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28597599	28597599	PRJNA667863_P_NODE_3367_length_338_cov_3.660377_g3333_i0	PRJNA667863	3367	338	3.660377	12.37207426	Nanobdellota archaeon	2026764	Archaea	Archaea	137	4.74e-35	NR	MCA9485224.1	2026764	g3333	i0	57.8	1.92603550295858	109	45	95.9	1	10	333	228	336	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	651	137	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
28818167	28818167	PRJNA667863_P_NODE_14528_length_245_cov_0.895349_g14494_i0	PRJNA667863	14528	245	0.895349	2.19360505	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	43.5	0.0188	NR	MAG24741.1	2026773	g14494	i0	37.5	0.881632653061225	72	43	85.7	2	36	245	198	269	MAG24741.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	216	43.5	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
28945053	28945053	PRJNA667863_P_NODE_13008_length_248_cov_0.880000_g12974_i0	PRJNA667863	13008	248	0.88	2.1824	archaeon	1906665	Archaea	Archaea	85.5	2.3e-17	NR	MCQ2820442.1	1906665	g12974	i0	42.1	1.29435483870968	107	34	95.6	2	238	2	228	334	MCQ2820442.1 hypothetical protein [archaeon]	diamond	321	85.5	1	Archaea								archaeon
28976502	28976502	PRJNA667863_P_NODE_4608_length_310_cov_1.856540_g4574_i0	PRJNA667863	4608	310	1.85654	5.755274	archaeon	1906665	Archaea	Archaea	106	2.44e-26	NR	MDP2439049.1	1906665	g4574	i0	57.5	0.841935483870968	87	37	84.2	0	38	298	4	90	MDP2439049.1 Rab family GTPase [archaeon]	diamond	261	106	1	Archaea								archaeon
29008274	29008274	PRJNA667863_P_NODE_9948_length_258_cov_1.600000_g9914_i0	PRJNA667863	9948	258	1.6	4.128	archaeon	1906665	Archaea	Archaea	57.8	5.59e-8	NR	RYG63325.1	1906665	g9914	i0	94.1	0.395348837209302	34	2	39.5	0	142	243	2	35	RYG63325.1 MAG: hypothetical protein EON64_16150 [archaeon]	diamond	102	57.8	1	Archaea								archaeon
29039766	29039766	PRJNA667863_P_NODE_18148_length_231_cov_2.208861_g18114_i0	PRJNA667863	18148	231	2.208861	5.10246891	archaeon	1906665	Archaea	Archaea	84.7	5.17e-17	NR	RYG70422.1	1906665	g18114	i0	56.6	0.987012987012987	76	33	98.7	0	2	229	289	364	RYG70422.1 MAG: hypothetical protein EON64_00215 [archaeon]	diamond	228	84.7	1	Archaea								archaeon
29765545	29765545	PRJNA667863_P_NODE_14151_length_246_cov_0.890173_g14117_i0	PRJNA667863	14151	246	0.890173	2.18982558	archaeon	1906665	Archaea	Archaea	91.7	4e-21	NR	RYG66790.1	1906665	g14117	i0	64.2	0.817073170731707	67	24	81.7	0	22	222	1	67	RYG66790.1 MAG: annexin [archaeon]	diamond	201	91.7	1	Archaea								archaeon
30176263	30176263	PRJNA667863_P_NODE_13772_length_246_cov_3.156069_g13738_i0	PRJNA667863	13772	246	3.156069	7.76392974	archaeon	1906665	Archaea	Archaea	118	2.9299999999999996e-31	NR	NCQ52285.1	1906665	g13738	i0	72.2	0.878048780487805	72	20	87.8	0	216	1	6	77	NCQ52285.1 hypothetical protein [archaeon]	diamond	216	118	1	Archaea								archaeon
30176270	30176270	PRJNA667863_P_NODE_19192_length_208_cov_5.007407_g19158_i0	PRJNA667863	19192	208	5.007407	10.41540656	archaeon	1906665	Archaea	Archaea	131	2.9e-37	NR	RYG68742.1	1906665	g19158	i0	91.2	0.980769230769231	68	6	98.1	0	3	206	38	105	RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon]	diamond	204	131	1	Archaea								archaeon
30745109	30745109	PRJNA667863_P_NODE_15234_length_244_cov_0.900585_g15200_i0	PRJNA667863	15234	244	0.900585	2.1974274	archaeon	1906665	Archaea	Archaea	69.7	1.21e-11	NR	RYH16101.1	1906665	g15200	i0	42.3	0.872950819672131	71	41	87.3	0	241	29	359	429	RYH16101.1 MAG: hypothetical protein EON65_30630 [archaeon]	diamond	213	69.7	1	Archaea								archaeon
31155495	31155495	PRJNA667863_P_NODE_8975_length_264_cov_1.256545_g8941_i0	PRJNA667863	8975	264	1.256545	3.3172788	archaeon	1906665	Archaea	Archaea	154	3.01e-41	NR	RYH30111.1	1906665	g8941	i0	86.2	0.988636363636364	87	12	98.9	0	262	2	1668	1754	RYH30111.1 MAG: DUF4704 domain-containing protein [archaeon]	diamond	261	154	1	Archaea								archaeon
31250620	31250620	PRJNA667863_P_NODE_17335_length_239_cov_3.674699_g17301_i0	PRJNA667863	17335	239	3.674699	8.78253061	archaeon	1906665	Archaea	Archaea	124	1.91e-32	NR	RYH04926.1	1906665	g17301	i0	79.7	1.98326359832636	79	16	99.2	0	2	238	160	238	RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon]	diamond	474	124	1	Archaea								archaeon
31440357	31440357	PRJNA667863_P_NODE_7756_length_272_cov_1.899497_g7722_i0	PRJNA667863	7756	272	1.899497	5.16663184	archaeon	1906665	Archaea	Archaea	130	5.67e-33	NR	RYG69984.1	1906665	g7722	i0	68.9	0.992647058823529	90	28	99.3	0	2	271	711	800	RYG69984.1 MAG: hypothetical protein EON64_01375, partial [archaeon]	diamond	270	130	1	Archaea								archaeon
31831843	31831843	PRJNA667863_P_NODE_2657_length_363_cov_1.872414_g2623_i0	PRJNA667863	2657	363	1.872414	6.79686282	root	1	Root_unresolved	Root_unresolved	207	1.7199999999999998e-66	NR	MDP2438463.1	1906665	g2623	i0	80	5.9504132231405	120	24	99.2	0	3	362	21	140	MDP2438463.1 MC/SLC25 family protein [archaeon]	diamond	2160	207	1	Archaea								archaeon
32073129	32073129	PRJNA667863_P_NODE_10818_length_253_cov_1.622222_g10784_i0	PRJNA667863	10818	253	1.622222	4.10422166	archaeon	1906665	Archaea	Archaea	98.2	1.99e-22	NR	RYG65852.1	1906665	g10784	i0	58.2	0.936758893280632	79	33	93.7	0	1	237	179	257	RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon]	diamond	237	98.2	1	Archaea								archaeon
32199756	32199756	PRJNA667863_P_NODE_17018_length_241_cov_0.916667_g16984_i0	PRJNA667863	17018	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	121	4.63e-33	NR	MDP2435761.1	1906665	g16984	i0	77	0.921161825726141	74	17	92.1	0	222	1	3	76	MDP2435761.1 ribosomal eL24 family protein [archaeon]	diamond	222	121	1	Archaea								archaeon
32358163	32358163	PRJNA667863_P_NODE_3539_length_334_cov_1.076628_g3505_i0	PRJNA667863	3539	334	1.076628	3.59593752	archaeon	1906665	Archaea	Archaea	153	4.58e-44	NR	RYH18875.1	1906665	g3505	i0	87.6	0.79940119760479	89	11	79.9	0	324	58	136	224	RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon]	diamond	267	153	1	Archaea								archaeon
32484575	32484575	PRJNA667863_P_NODE_11339_length_251_cov_0.865169_g11305_i0	PRJNA667863	11339	251	0.865169	2.17157419	Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1	3126527	Archaea	Archaea	45.1	0.00622	NR	WXG44847.1	3126527	g11305	i0	44.8	0.693227091633466	58	27	69.3	2	220	47	175	227	WXG44847.1 MAG: FAD-dependent oxidoreductase [Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1]	diamond	174	45.1	1	Archaea		Promethearchaeati						Promethearchaeati archaeon SRVP18_Atabeyarchaeia-1
32516334	32516334	PRJNA667863_P_NODE_17139_length_241_cov_0.916667_g17105_i0	PRJNA667863	17139	241	0.916667	2.20916747	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	42.7	0.0358	NR	NLF88514.1	2026714	g17105	i0	32	0.933609958506224	75	42	82.2	2	234	37	215	289	NLF88514.1 phosphopyruvate hydratase [Candidatus Bathyarchaeota archaeon]	diamond	225	42.7	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
32780082	32780082	PRJNA667863_P_NODE_8780_length_265_cov_1.604167_g8746_i0	PRJNA667863	8780	265	1.604167	4.25104255	root	1	Root_unresolved	Root_unresolved	52	2.61e-5	NR	MBT4434023.1	2026803	g8746	i0	51.1	1.53962264150943	47	22	53.2	1	231	91	170	215	MBT4434023.1 DUF4215 domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	408	52	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota 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);;