metadata: contig_metadata: 43 rows where bioproject = "PRJNA235310" and tax

43 rows where bioproject = "PRJNA235310" 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
367373	367373	PRJNA235310_P_NODE_4341_length_179_cov_2.000000_g4315_i0	PRJNA235310	4341	179	2	3.58	archaeon	1906665	Archaea	Archaea	123	1.08e-31	NR	RYG65165.1	1906665	g4315	i0	96.6	1.97765363128492	59	2	98.9	0	2	178	281	339	RYG65165.1 MAG: ABC-F family ATP-binding cassette domain-containing protein [archaeon]	diamond	354	123	1	Archaea								archaeon
13121152	13121152	PRJNA235310_P_NODE_2631_length_236_cov_1.385027_g2605_i0	PRJNA235310	2631	236	1.385027	3.26866372	Candidatus Caldarchaeum subterraneum	311458	Archaea	Archaea	56.5	0.002	NTclustered	gi\|315425078\|dbj\|AP011708.1\|	311458	g2605	i0	100	0.491525423728814	30	0	13	0	202	231	41486	41457	Candidatus Caldiarchaeum subterraneum DNA, fosmid clone: JFF022_F09	blastn	116	56.5	1	Archaea		Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum subterraneum
18219014	18219014	PRJNA235310_P_NODE_2335_length_253_cov_1.274510_g2309_i0	PRJNA235310	2335	253	1.27451	3.2245103	archaeon	1906665	Archaea	Archaea	138	2.529999999999999e-38	NR	RYG67557.1	1906665	g2309	i0	87.7	1.92094861660079	81	10	96	0	3	245	193	273	RYG67557.1 MAG: hypothetical protein EON64_07185 [archaeon]	diamond	486	138	1	Archaea								archaeon
19493337	19493337	PRJNA235310_P_NODE_4516_length_175_cov_1.650794_g4490_i0	PRJNA235310	4516	175	1.650794	2.8888895	uncultured Methanocorpusculum sp.	176309	Archaea	Archaea	54.7	0.004	NTclustered	gi\|2621784620\|emb\|OY781078.1\|	176309	g4490	i0	88.889	0.8	45	3	25	2	74	117	1118629	1118672	MAG: uncultured Methanocorpusculum sp. isolate da2e5db0-0b8c-42b4-9ad7-c040378b94a4 genome assembly, chromosome: 1	blastn	140	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	uncultured Methanocorpusculum sp.
20768877	20768877	PRJNA235310_P_NODE_2877_length_225_cov_1.045455_g2851_i0	PRJNA235310	2877	225	1.045455	2.35227375	Methanolobus psychrophilus	420950	Archaea	Archaea	73.1	1.54e-8	NTclustered	gi\|409168338\|gb\|CP003083.1\|	1094980	g2851	i0	97.674	2.90222222222222	43	0	20	1	53	95	2837736	2837777	Methanolobus psychrophilus R15 chromosome, complete genome	blastn	653	73.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus psychrophilus
20768895	20768895	PRJNA235310_P_NODE_3797_length_194_cov_1.075862_g3771_i0	PRJNA235310	3797	194	1.075862	2.08717228	uncultured Poseidoniia archaeon	1697135	Archaea	Archaea	56.5	0.001	NTclustered	gi\|730903838\|gb\|KP211909.1\|	1697135	g3771	i0	90.476	0.216494845360825	42	4	22	0	57	98	13332	13373	Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-OCT2007-C1337 genomic sequence	blastn	42	56.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia				uncultured Poseidoniia archaeon
23319430	23319430	PRJNA235310_P_NODE_459_length_548_cov_3.587174_g435_i0	PRJNA235310	459	548	3.587174	19.65771352	archaeon	1906665	Archaea	Archaea	58.9	2.8e-7	NR	MDP2436882.1	1906665	g435	i0	31.4	0.645985401459854	118	73	61.9	4	60	398	19	133	MDP2436882.1 hypothetical protein [archaeon]	diamond	354	58.9	1	Archaea								archaeon
26694073	26694073	PRJNA235310_P_NODE_3821_length_193_cov_2.395833_g3795_i0	PRJNA235310	3821	193	2.395833	4.62395769	archaeon	1906665	Archaea	Archaea	55.1	5.51e-8	NR	RYY78133.1	1906665	g3795	i0	60.4	0.746113989637306	48	19	74.6	0	47	190	11	58	RYY78133.1 MAG: hypothetical protein EON63_17980 [archaeon]	diamond	144	55.1	1	Archaea								archaeon
26789290	26789290	PRJNA235310_P_NODE_5001_length_168_cov_1.747899_g4975_i0	PRJNA235310	5001	168	1.747899	2.93647032	archaeon	1906665	Archaea	Archaea	48.9	8.8e-5	NR	MDP2436763.1	1906665	g4975	i0	45.3	0.946428571428571	53	28	92.9	1	167	12	344	396	MDP2436763.1 alpha/beta hydrolase fold domain-containing protein [archaeon]	diamond	159	48.9	1	Archaea								archaeon
27168599	27168599	PRJNA235310_P_NODE_5322_length_167_cov_0.881356_g5296_i0	PRJNA235310	5322	167	0.881356	1.47186452	archaeon	1906665	Archaea	Archaea	42	0.00487	NR	RYH18504.1	1906665	g5296	i0	57.1	0.62874251497006	35	11	55.7	1	6	98	44	78	RYH18504.1 MAG: hypothetical protein EON65_27160 [archaeon]	diamond	105	42	1	Archaea								archaeon
27326901	27326901	PRJNA235310_P_NODE_3363_length_207_cov_0.987342_g3337_i0	PRJNA235310	3363	207	0.987342	2.04379794	Methanocorpusculum sp.	2058474	Archaea	Archaea	55.1	9.97e-7	NR	MDO5845745.1	2058474	g3337	i0	52.5	0.579710144927536	40	19	58	0	33	152	348	387	MDO5845745.1 ABC transporter substrate-binding protein [Methanocorpusculum sp.]	diamond	120	55.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
27439685	27439685	PRJNA235310_P_NODE_6443_length_162_cov_0.920354_g6417_i0	PRJNA235310	6443	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	80.9	5.9e-18	NR	MCQ2816490.1	1906665	g6417	i0	71.7	1.96296296296296	53	15	98.1	0	3	161	57	109	MCQ2816490.1 Fe-S cluster assembly scaffold IscU [archaeon]	diamond	318	80.9	1	Archaea								archaeon
27769207	27769207	PRJNA235310_P_NODE_3624_length_198_cov_1.630872_g3598_i0	PRJNA235310	3624	198	1.630872	3.22912656	archaeon	1906665	Archaea	Archaea	59.3	2.79e-8	NR	MDP2434370.1	1906665	g3598	i0	49.2	0.924242424242424	61	28	90.9	2	197	18	271	329	MDP2434370.1 pepsin-like aspartic protease [archaeon]	diamond	183	59.3	1	Archaea								archaeon
27769210	27769210	PRJNA235310_P_NODE_5244_length_167_cov_1.322034_g5218_i0	PRJNA235310	5244	167	1.322034	2.20779678	archaeon	1906665	Archaea	Archaea	72.8	1.52e-13	NR	RYG67557.1	1906665	g5218	i0	71.7	1.86826347305389	53	14	93.4	1	12	167	48	100	RYG67557.1 MAG: hypothetical protein EON64_07185 [archaeon]	diamond	312	72.8	1	Archaea								archaeon
28432067	28432067	PRJNA235310_P_NODE_3266_length_210_cov_0.968944_g3240_i0	PRJNA235310	3266	210	0.968944	2.0347824	archaeon	1906665	Archaea	Archaea	110	8.48e-28	NR	RYH12497.1	1906665	g3240	i0	88.7	0.885714285714286	62	7	88.6	0	2	187	202	263	RYH12497.1 MAG: 3-hydroxyacyl-CoA dehydrogenase [archaeon]	diamond	186	110	1	Archaea								archaeon
28590034	28590034	PRJNA235310_P_NODE_2867_length_225_cov_1.181818_g2841_i0	PRJNA235310	2867	225	1.181818	2.6590905	archaeon	1906665	Archaea	Archaea	94.7	5.26e-21	NR	MDP2434610.1	1906665	g2841	i0	63	1.94666666666667	73	27	97.3	0	224	6	264	336	MDP2434610.1 AGC family serine/threonine-protein kinase [archaeon]	diamond	438	94.7	1	Archaea								archaeon
28937295	28937295	PRJNA235310_P_NODE_4848_length_169_cov_0.866667_g4822_i0	PRJNA235310	4848	169	0.866667	1.46466723	archaeon	1906665	Archaea	Archaea	90.9	2.17e-20	NR	RYG70257.1	1906665	g4822	i0	78.6	0.994082840236686	56	12	99.4	0	169	2	168	223	RYG70257.1 MAG: fatty acid oxidation complex subunit alpha FadJ, partial [archaeon]	diamond	168	90.9	1	Archaea								archaeon
29095194	29095194	PRJNA235310_P_NODE_768_length_451_cov_1.606965_g742_i0	PRJNA235310	768	451	1.606965	7.24741215	archaeon	1906665	Archaea	Archaea	85.9	2.72e-16	NR	MDP2436671.1	1906665	g742	i0	38.5	1.74279379157428	135	76	85.1	3	3	386	116	250	MDP2436671.1 S53 family peptidase [archaeon]	diamond	786	85.9	1	Archaea								archaeon
29126901	29126901	PRJNA235310_P_NODE_2269_length_257_cov_1.677885_g2243_i0	PRJNA235310	2269	257	1.677885	4.31216445	archaeon	1906665	Archaea	Archaea	87.8	2.45e-18	NR	MDP2437720.1	1906665	g2243	i0	47.6	0.980544747081712	84	44	98.1	0	252	1	75	158	MDP2437720.1 carboxylesterase family protein [archaeon]	diamond	252	87.8	1	Archaea								archaeon
29126904	29126904	PRJNA235310_P_NODE_3169_length_213_cov_1.573171_g3143_i0	PRJNA235310	3169	213	1.573171	3.35085423	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	89	1.55e-19	NR	MBT6402390.1	2026803	g3143	i0	63.5	0.887323943661972	63	22	88.7	1	193	5	43	104	MBT6402390.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	189	89	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29347730	29347730	PRJNA235310_P_NODE_4929_length_169_cov_0.866667_g4903_i0	PRJNA235310	4929	169	0.866667	1.46466723	archaeon	1906665	Archaea	Archaea	62.4	5.51e-11	NR	MCQ2816429.1	1906665	g4903	i0	49.1	0.976331360946746	55	28	97.6	0	167	3	1	55	MCQ2816429.1 acyl-CoA-binding protein [archaeon]	diamond	165	62.4	1	Archaea								archaeon
29663026	29663026	PRJNA235310_P_NODE_5910_length_164_cov_0.904348_g5884_i0	PRJNA235310	5910	164	0.904348	1.48313072	archaeon	1906665	Archaea	Archaea	43.9	0.00356	NR	MFH1174141.1	1906665	g5884	i0	38.9	0.98780487804878	54	32	98.8	1	164	3	97	149	MFH1174141.1 YbhB/YbcL family Raf kinase inhibitor-like protein [archaeon]	diamond	162	43.9	1	Archaea								archaeon
29979215	29979215	PRJNA235310_P_NODE_2811_length_228_cov_1.162011_g2785_i0	PRJNA235310	2811	228	1.162011	2.64938508	archaeon	1906665	Archaea	Archaea	93.6	6.550000000000001e-21	NR	MDP2436293.1	1906665	g2785	i0	56.6	1	76	32	98.7	1	3	227	167	242	MDP2436293.1 SDR family NAD(P)-dependent oxidoreductase [archaeon]	diamond	228	93.6	1	Archaea								archaeon
30327278	30327278	PRJNA235310_P_NODE_6032_length_164_cov_0.895652_g6006_i0	PRJNA235310	6032	164	0.895652	1.46886928	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	63.9	1.81e-10	NR	MBR9698932.1	2026803	g6006	i0	56.6	0.969512195121951	53	23	97	0	160	2	89	141	MBR9698932.1 SDR family oxidoreductase [Candidatus Woesearchaeota archaeon]	diamond	159	63.9	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
30358846	30358846	PRJNA235310_P_NODE_2672_length_234_cov_1.048649_g2646_i0	PRJNA235310	2672	234	1.048649	2.45383866	archaeon	1906665	Archaea	Archaea	110	2.84e-26	NR	MDP2436532.1	1906665	g2646	i0	64.1	1	78	27	98.7	1	4	234	70	147	MDP2436532.1 protein kinase [archaeon]	diamond	234	110	1	Archaea								archaeon
30390377	30390377	PRJNA235310_P_NODE_613_length_492_cov_1.279910_g588_i0	PRJNA235310	613	492	1.27991	6.2971572	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	221	2.03e-67	NR	MBU0527194.1	2250274	g588	i0	66.9	5.89024390243902	160	49	97.6	2	481	2	233	388	MBU0527194.1 ATPase [Candidatus Micrarchaeota archaeon]	diamond	2898	221	1	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
30547892	30547892	PRJNA235310_P_NODE_6193_length_163_cov_0.912281_g6167_i0	PRJNA235310	6193	163	0.912281	1.48701803	archaeon	1906665	Archaea	Archaea	100	2.47e-26	NR	RYY87779.1	1906665	g6167	i0	88.7	0.975460122699387	53	6	97.5	0	161	3	13	65	RYY87779.1 MAG: hypothetical protein EON63_03500 [archaeon]	diamond	159	100	1	Archaea								archaeon
30579275	30579275	PRJNA235310_P_NODE_5453_length_166_cov_1.324786_g5427_i0	PRJNA235310	5453	166	1.324786	2.19914476	archaeon	1906665	Archaea	Archaea	41.2	0.0458	NR	MDP2438259.1	1906665	g5427	i0	43.1	0.921686746987952	51	28	92.2	1	155	3	1119	1168	MDP2438259.1 ABC transporter permease [archaeon]	diamond	153	41.2	1	Archaea								archaeon
30990411	30990411	PRJNA235310_P_NODE_2534_length_242_cov_1.673575_g2508_i0	PRJNA235310	2534	242	1.673575	4.0500515	archaeon	1906665	Archaea	Archaea	103	5.7600000000000005e-27	NR	MDP2438881.1	1906665	g2508	i0	56.9	0.892561983471074	72	31	89.3	0	24	239	1	72	MDP2438881.1 hypothetical protein [archaeon]	diamond	216	103	1	Archaea								archaeon
31496290	31496290	PRJNA235310_P_NODE_1356_length_346_cov_2.350168_g1330_i0	PRJNA235310	1356	346	2.350168	8.13158128	archaeon	1906665	Archaea	Archaea	77.4	5.72e-16	NR	RYG67183.1	1906665	g1330	i0	56.2	2.1242774566474	73	30	61.6	1	323	111	3	75	RYG67183.1 MAG: hypothetical protein EON64_08020 [archaeon]	diamond	735	77.4	1	Archaea								archaeon
31496293	31496293	PRJNA235310_P_NODE_3356_length_207_cov_1.120253_g3330_i0	PRJNA235310	3356	207	1.120253	2.31892371	archaeon	1906665	Archaea	Archaea	58.2	7.95e-8	NR	MDP2437063.1	1906665	g3330	i0	39.7	0.985507246376812	68	40	98.6	1	3	206	258	324	MDP2437063.1 hypothetical protein [archaeon]	diamond	204	58.2	1	Archaea								archaeon
31749010	31749010	PRJNA235310_P_NODE_5597_length_166_cov_0.888889_g5571_i0	PRJNA235310	5597	166	0.888889	1.47555574	archaeon	1906665	Archaea	Archaea	109	2.98e-29	NR	RYG66797.1	1906665	g5571	i0	83.6	1.98795180722892	55	9	99.4	0	165	1	13	67	RYG66797.1 MAG: 50S ribosomal protein L3, partial [archaeon]	diamond	330	109	1	Archaea								archaeon
31798300	31798300	PRJNA235310_P_NODE_2017_length_277_cov_1.820175_g1991_i0	PRJNA235310	2017	277	1.820175	5.04188475	Archaea	2157	Archaea	Archaea	62.4	8.64e-11	NR	MBC7128437.1	2268204	g1991	i0	64.9	2.76173285198556	37	13	40.1	0	276	166	12	48	MBC7128437.1 30S ribosomal protein S27ae [Thermoplasmatales archaeon]	diamond	765	62.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
31843902	31843902	PRJNA235310_P_NODE_5437_length_166_cov_1.333333_g5411_i0	PRJNA235310	5437	166	1.333333	2.21333278	archaeon	1906665	Archaea	Archaea	94	5.72e-22	NR	RYG58925.1	1906665	g5411	i0	76.4	1.98795180722892	55	13	99.4	0	165	1	18	72	RYG58925.1 MAG: 30S ribosomal protein S2, partial [archaeon]	diamond	330	94	1	Archaea								archaeon
31875491	31875491	PRJNA235310_P_NODE_2337_length_253_cov_1.196078_g2311_i0	PRJNA235310	2337	253	1.196078	3.02607734	archaeon	1906665	Archaea	Archaea	103	3.68e-24	NR	MDP2437063.1	1906665	g2311	i0	58.9	0.865612648221344	73	30	86.6	0	3	221	175	247	MDP2437063.1 hypothetical protein [archaeon]	diamond	219	103	1	Archaea								archaeon
32223805	32223805	PRJNA235310_P_NODE_4498_length_176_cov_0.976378_g4472_i0	PRJNA235310	4498	176	0.976378	1.71842528	archaeon	1906665	Archaea	Archaea	56.6	1.91e-7	NR	MDP2434477.1	1906665	g4472	i0	61.5	0.664772727272727	39	15	66.5	0	29	145	241	279	MDP2434477.1 serine/threonine-protein kinase [archaeon]	diamond	117	56.6	1	Archaea								archaeon
32381976	32381976	PRJNA235310_P_NODE_4839_length_169_cov_0.866667_g4813_i0	PRJNA235310	4839	169	0.866667	1.46466723	archaeon	1906665	Archaea	Archaea	76.6	3.21e-15	NR	MCQ2818463.1	1906665	g4813	i0	63.5	1.91715976331361	52	17	88.8	1	151	2	11	62	MCQ2818463.1 GTP-binding protein [archaeon]	diamond	324	76.6	1	Archaea								archaeon
32477008	32477008	PRJNA235310_P_NODE_3979_length_189_cov_1.857143_g3953_i0	PRJNA235310	3979	189	1.857143	3.51000027	archaeon	1906665	Archaea	Archaea	92	3.8600000000000005e-21	NR	MDP2438357.1	1906665	g3953	i0	67.2	0.920634920634921	58	19	92.1	0	188	15	75	132	MDP2438357.1 emopamil-binding family protein [archaeon]	diamond	174	92	1	Archaea								archaeon
32603232	32603232	PRJNA235310_P_NODE_60_length_1023_cov_3.162218_g46_i0	PRJNA235310	60	1023	3.162218	32.34949014	archaeon	1906665	Archaea	Archaea	79.7	5.4e-14	NR	MDP2436403.1	1906665	g46	i0	42.7	0.26099706744868	89	46	24.6	1	480	229	2	90	MDP2436403.1 hypothetical protein [archaeon]	diamond	267	79.7	1	Archaea								archaeon
32666118	32666118	PRJNA235310_P_NODE_3400_length_205_cov_1.666667_g3374_i0	PRJNA235310	3400	205	1.666667	3.41666735	archaeon	1906665	Archaea	Archaea	137	4.94e-39	NR	RYH25290.1	1906665	g3374	i0	95.6	0.995121951219512	68	3	99.5	0	205	2	57	124	RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon]	diamond	204	137	1	Archaea								archaeon
32697548	32697548	PRJNA235310_P_NODE_5400_length_167_cov_0.881356_g5374_i0	PRJNA235310	5400	167	0.881356	1.47186452	archaeon	1906665	Archaea	Archaea	110	1.7000000000000003e-28	NR	RYH27822.1	1906665	g5374	i0	85.5	0.988023952095808	55	8	98.8	0	167	3	21	75	RYH27822.1 MAG: type 1 glutamine amidotransferase domain-containing protein [archaeon]	diamond	165	110	1	Archaea								archaeon
32791923	32791923	PRJNA235310_P_NODE_4800_length_169_cov_1.300000_g4774_i0	PRJNA235310	4800	169	1.3	2.197	archaeon	1906665	Archaea	Archaea	110	1.03e-27	NR	RYG64517.1	1906665	g4774	i0	91.1	0.994082840236686	56	5	99.4	0	2	169	82	137	RYG64517.1 MAG: SDR family NAD(P)-dependent oxidoreductase [archaeon]	diamond	168	110	1	Archaea								archaeon
32823645	32823645	PRJNA235310_P_NODE_4340_length_179_cov_2.000000_g4314_i0	PRJNA235310	4340	179	2	3.58	archaeon	1906665	Archaea	Archaea	105	4.6e-26	NR	RYG67557.1	1906665	g4314	i0	81.4	0.988826815642458	59	11	98.9	0	179	3	107	165	RYG67557.1 MAG: hypothetical protein EON64_07185 [archaeon]	diamond	177	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);;