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

31 rows where bioproject = "PRJNA694770" 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
5777807	5777807	PRJNA694770_P_NODE_36445_length_338_cov_1.452830_g36151_i0	PRJNA694770	36445	338	1.45283	4.9105654	Natrinema sp. J7-2	406552	Archaea	Archaea	562	1.19e-155	NTclustered	gi\|397680883\|gb\|CP003412.1\|	406552	g36151	i0	99.674	57.7011834319527	307	1	91	0	2	308	1830750	1831056	Natrinema sp. J7-2, complete genome	blastn	19503	562	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. J7-2
7558969	7558969	PRJNA694770_P_NODE_73866_length_257_cov_2.092391_g73572_i0	PRJNA694770	73866	257	2.092391	5.37744487	root	1	Root_unresolved	Root_unresolved	464	2.5299999999999998e-126	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g73572	i0	99.222	6.715953307393	257	2	100	0	1	257	2084	1828	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	1726	464	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
8327154	8327154	PRJNA694770_P_NODE_25947_length_383_cov_1.241935_g25653_i0	PRJNA694770	25947	383	1.241935	4.75661105	uncultured Methanoregula sp.	1005933	Archaea	Archaea	549	1.0599999999999999e-151	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g25653	i0	93.496	97.4543080939948	369	24	96	0	1	369	3092089	3091721	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	37325	549	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
8327751	8327751	PRJNA694770_P_NODE_48627_length_301_cov_1.013158_g48333_i0	PRJNA694770	48627	301	1.013158	3.04960558	Halorutilales archaeon Cl-col2-1	3242703	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2801083086\|gb\|CP169074.1\|	3242703	g48333	i0	96.97	0.109634551495017	33	1	11	0	206	238	1816624	1816592	Halorutilales archaeon Cl-col2-1 chromosome, complete genome	blastn	33	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halorutilales			Halorutilales archaeon Cl-col2-1
8833904	8833904	PRJNA694770_P_NODE_6627_length_746_cov_2.731055_g6347_i0	PRJNA694770	6627	746	2.731055	20.3736703	root	1	Root_unresolved	Root_unresolved	1373	0	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g6347	i0	99.866	7.9142091152815	746	1	100	0	1	746	1009	1754	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	5904	1373	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
11384824	11384824	PRJNA694770_P_NODE_85889_length_248_cov_0.880000_g85595_i0	PRJNA694770	85889	248	0.88	2.1824	Methanoculleus	45989	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2323247744\|gb\|CP109831.1\|	204050	g85595	i0	88	0.403225806451613	50	1	20	5	29	77	1398535	1398490	Methanoculleus submarinus strain DSM 15122 chromosome, complete genome	blastn	100	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus submarinus
18527262	18527262	PRJNA694770_P_NODE_73755_length_258_cov_1.118919_g73461_i0	PRJNA694770	73755	258	1.118919	2.88681102	Natrinema sp. J7-2	406552	Archaea	Archaea	379	9.479999999999998e-101	NTclustered	gi\|397680883\|gb\|CP003412.1\|	406552	g73461	i0	100	13.8875968992248	205	0	96	0	54	258	1830253	1830457	Natrinema sp. J7-2, complete genome	blastn	3583	379	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. J7-2
18527369	18527369	PRJNA694770_P_NODE_78215_length_251_cov_0.865169_g77921_i0	PRJNA694770	78215	251	0.865169	2.17157419	Thermococcus siculi	72803	Archaea	Archaea	172	8.44e-48	NR	WP_088855743.1	72803	g77921	i0	98.8	4.9601593625498	83	1	99.2	0	249	1	399	481	WP_088855743.1 DNA polymerase domain-containing protein [Thermococcus siculi]	diamond	1245	172	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus siculi
19802552	19802552	PRJNA694770_P_NODE_87356_length_247_cov_0.885057_g87062_i0	PRJNA694770	87356	247	0.885057	2.18609079	Methanosarcina sp.	2213	Archaea	Archaea	120	8.05e-33	NR	HET8686521.1	2213	g87062	i0	76.8	0.838056680161943	69	16	83.8	0	4	210	87	155	HET8686521.1 HNH endonuclease [Methanosarcina sp.]	diamond	207	120	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
21583612	21583612	PRJNA694770_P_NODE_90957_length_245_cov_0.895349_g90663_i0	PRJNA694770	90957	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|436492\|gb\|U00707.1\|PSU00707	33866	g90663	i0	100	11.9102040816327	245	0	100	0	1	245	838	1082	Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds	blastn	2918	453	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus sp.
24131689	24131689	PRJNA694770_P_NODE_100859_length_237_cov_2.347561_g100565_i0	PRJNA694770	100859	237	2.347561	5.56371957	root	1	Root_unresolved	Root_unresolved	438	1.4e-118	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g100565	i0	100	6	237	0	100	0	1	237	587	351	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	1422	438	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
24901553	24901553	PRJNA694770_P_NODE_71020_length_262_cov_1.629630_g70726_i0	PRJNA694770	71020	262	1.62963	4.2696306	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	313	9.93e-81	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g70726	i0	88.213	6.98091603053435	263	29	100	2	1	262	861383	861122	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	1829	313	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
26892989	26892989	PRJNA694770_P_NODE_53941_length_288_cov_1.432558_g53647_i0	PRJNA694770	53941	288	1.432558	4.12576704	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	60.5	1.39e-9	NR	MCJ7506345.1	2026714	g53647	i0	50.8	0.65625	63	30	65.6	1	1	189	26	87	MCJ7506345.1 hypothetical protein [Candidatus Bathyarchaeota archaeon]	diamond	189	60.5	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
27588258	27588258	PRJNA694770_P_NODE_85544_length_248_cov_0.880000_g85250_i0	PRJNA694770	85544	248	0.88	2.1824	Methanosarcina sp.	2213	Archaea	Archaea	158	1.0199999999999999e-43	NR	HET8686717.1	2213	g85250	i0	90.2	0.991935483870968	82	8	99.2	0	3	248	143	224	HET8686717.1 phage terminase large subunit family protein [Methanosarcina sp.]	diamond	246	158	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28503766	28503766	PRJNA694770_P_NODE_68007_length_267_cov_1.587629_g67713_i0	PRJNA694770	68007	267	1.587629	4.23896943	Halocatena marina	2934937	Archaea	Archaea	156	2.2299999999999993e-42	NR	WP_390207450.1	2934937	g67713	i0	83.1	2	89	15	100	0	267	1	285	373	WP_390207450.1 OB-fold nucleic acid binding domain-containing protein [Halocatena marina]	diamond	534	156	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halocatena	Halocatena marina
28819199	28819199	PRJNA694770_P_NODE_70788_length_263_cov_1.163158_g70494_i0	PRJNA694770	70788	263	1.163158	3.05910554	Methanosarcina sp.	2213	Archaea	Archaea	63.5	3.98e-10	NR	HET8685142.1	2213	g70494	i0	48.2	0.96958174904943	85	35	97	2	263	9	20	95	HET8685142.1 hypothetical protein [Methanosarcina sp.]	diamond	255	63.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28850835	28850835	PRJNA694770_P_NODE_13108_length_516_cov_1.625282_g12815_i0	PRJNA694770	13108	516	1.625282	8.38645512	Candidatus Parvarchaeota archaeon	2077140	Archaea	Archaea	46.2	0.0265	NR	MCL5009657.1	2077140	g12815	i0	27.6	0.505813953488372	87	63	50.6	0	159	419	84	170	MCL5009657.1 VIT1/CCC1 transporter family protein [Candidatus Parvarchaeota archaeon]	diamond	261	46.2	1	Archaea		Nanobdellati	Candidatus Parvarchaeota					Candidatus Parvarchaeota archaeon
28946057	28946057	PRJNA694770_P_NODE_50548_length_295_cov_2.045045_g50254_i0	PRJNA694770	50548	295	2.045045	6.03288275	Salinigranum rubrum	755307	Archaea	Archaea	56.2	1.21e-6	NR	WP_162562567.1	755307	g50254	i0	43.7	1.76949152542373	87	43	82.4	1	294	52	23	109	WP_162562567.1 patatin-like phospholipase family protein [Salinigranum rubrum]	diamond	522	56.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Salinigranum	Salinigranum rubrum
29324588	29324588	PRJNA694770_P_NODE_16109_length_467_cov_1.850254_g15815_i0	PRJNA694770	16109	467	1.850254	8.64068618	Halobellus sp. Atlit-31R	2282130	Archaea	Archaea	174	1.61e-53	NR	RLM51893.1	2282130	g15815	i0	86.6	0.623126338329764	97	13	62.3	0	16	306	1	97	RLM51893.1 hypothetical protein DVK02_16685, partial [Halobellus sp. Atlit-31R]	diamond	291	174	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus sp. Atlit-31R
30019569	30019569	PRJNA694770_P_NODE_45471_length_310_cov_1.177215_g45177_i0	PRJNA694770	45471	310	1.177215	3.6493665	Halobellus sp. Atlit-31R	2282130	Archaea	Archaea	111	9.729999999999999e-30	NR	RLM49163.1	2282130	g45177	i0	85.2	0.590322580645161	61	9	59	0	308	126	10	70	RLM49163.1 hypothetical protein DVK02_17945 [Halobellus sp. Atlit-31R]	diamond	183	111	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus sp. Atlit-31R
30114150	30114150	PRJNA694770_P_NODE_78312_length_251_cov_0.865169_g78018_i0	PRJNA694770	78312	251	0.865169	2.17157419	Methanobrevibacter sp.	66852	Archaea	Archaea	54.7	1.81e-6	NR	WP_330025701.1	66852	g78018	i0	50	0.50199203187251	42	21	50.2	0	90	215	1	42	WP_330025701.1 hypothetical protein [Methanobrevibacter sp.]	diamond	126	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30177305	30177305	PRJNA694770_P_NODE_45532_length_310_cov_0.974684_g45238_i0	PRJNA694770	45532	310	0.974684	3.0215204	Methanosarcina sp.	2213	Archaea	Archaea	146	2.809999999999999e-38	NR	HET8686737.1	2213	g45238	i0	78.8	0.82258064516129	85	18	82.3	0	308	54	653	737	HET8686737.1 hypothetical protein [Methanosarcina sp.]	diamond	255	146	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
30304251	30304251	PRJNA694770_P_NODE_22192_length_407_cov_1.260479_g21898_i0	PRJNA694770	22192	407	1.260479	5.13014953	Methanosarcina sp.	2213	Archaea	Archaea	92.8	6.89e-19	NR	HET8689126.1	2213	g21898	i0	62.4	0.626535626535627	85	32	62.7	0	406	152	510	594	HET8689126.1 hypothetical protein [Methanosarcina sp.]	diamond	255	92.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
30335783	30335783	PRJNA694770_P_NODE_88752_length_246_cov_0.890173_g88458_i0	PRJNA694770	88752	246	0.890173	2.18982558	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	88.2	3.2e-19	NR	MEM5878278.1	3121606	g88458	i0	68.9	0.74390243902439	61	18	74.4	1	2	184	174	233	MEM5878278.1 ribonucleoside-diphosphate reductase subunit alpha [Candidatus Aenigmatarchaeota archaeon]	diamond	183	88.2	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
30335791	30335791	PRJNA694770_P_NODE_99172_length_241_cov_0.916667_g98878_i0	PRJNA694770	99172	241	0.916667	2.20916747	Methanosarcina sp.	2213	Archaea	Archaea	150	3.62e-40	NR	HET8689129.1	2213	g98878	i0	87.5	0.995850622406639	80	10	99.6	0	1	240	1040	1119	HET8689129.1 hypothetical protein [Methanosarcina sp.]	diamond	240	150	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
30493426	30493426	PRJNA694770_P_NODE_79413_length_251_cov_0.865169_g79119_i0	PRJNA694770	79413	251	0.865169	2.17157419	Methanohalobium sp.	2837493	Archaea	Archaea	46.2	0.00147	NR	WP_292487096.1	2837493	g79119	i0	37.7	0.633466135458167	53	32	62.2	1	250	95	131	183	WP_292487096.1 hypothetical protein, partial [Methanohalobium sp.]	diamond	159	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanohalobium	Methanohalobium sp.
30746131	30746131	PRJNA694770_P_NODE_78734_length_251_cov_0.865169_g78440_i0	PRJNA694770	78734	251	0.865169	2.17157419	Methanosarcina sp.	2213	Archaea	Archaea	112	5.5700000000000006e-27	NR	HET8686511.1	2213	g78440	i0	60.3	0.932270916334661	78	31	93.2	0	236	3	1	78	HET8686511.1 class I SAM-dependent methyltransferase [Methanosarcina sp.]	diamond	234	112	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
31346674	31346674	PRJNA694770_P_NODE_48196_length_302_cov_1.327511_g47902_i0	PRJNA694770	48196	302	1.327511	4.00908322	Methanosarcina sp.	2213	Archaea	Archaea	83.2	7.39e-17	NR	HET8689744.1	2213	g47902	i0	69	0.576158940397351	58	18	57.6	0	176	3	10	67	HET8689744.1 hypothetical protein [Methanosarcina sp.]	diamond	174	83.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
31536572	31536572	PRJNA694770_P_NODE_93836_length_244_cov_0.900585_g93542_i0	PRJNA694770	93836	244	0.900585	2.1974274	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	152	5.309999999999999e-42	NR	WP_298536863.1	253161	g93542	i0	96.3	2.98770491803279	81	3	99.6	0	243	1	20	100	WP_298536863.1 TrkH family potassium uptake protein [uncultured Methanobrevibacter sp.]	diamond	729	152	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
31694422	31694422	PRJNA694770_P_NODE_19957_length_425_cov_2.090909_g19663_i0	PRJNA694770	19957	425	2.090909	8.88636325	Methanosarcina sp.	2213	Archaea	Archaea	70.9	3.89e-11	NR	HET8688197.1	2213	g19663	i0	39.3	0.755294117647059	107	62	73.4	2	314	3	329	435	HET8688197.1 SGNH/GDSL hydrolase family protein [Methanosarcina sp.]	diamond	321	70.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
31895578	31895578	PRJNA694770_P_NODE_98017_length_242_cov_0.911243_g97723_i0	PRJNA694770	98017	242	0.911243	2.20520806	Nitrosopumilus	338191	Archaea	Archaea	130	9.349999999999999e-35	NR	AIF00990.1	1456008	g97723	i0	83.8	5.9504132231405	80	13	99.2	0	242	3	87	166	AIF00990.1 iron-containing alcohol dehydrogenase [uncultured marine thaumarchaeote KM3_13_H10]	diamond	1440	130	1	Archaea		Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_13_H10

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