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

29 rows where bioproject = "PRJNA600413" and tax_phylum = "Methanobacteriota"

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
3124792	3124792	PRJNA600413_P_NODE_24823_length_285_cov_1.974576_g24122_i0	PRJNA600413	24823	285	1.974576	5.6275416	Natronomonas gomsonensis	1046043	Archaea	Archaea	76.8	1.56e-9	NTclustered	gi\|2273673090\|gb\|CP101323.1\|	1046043	g24122	i0	97.727	0.919298245614035	44	1	15	0	29	72	1095640	1095597	Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome	blastn	262	76.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas gomsonensis
5678786	5678786	PRJNA600413_P_NODE_79305_length_180_cov_1.557252_g78604_i0	PRJNA600413	79305	180	1.557252	2.8030536	Halobellus limi	699433	Archaea	Archaea	106	1.16e-18	NTclustered	gi\|1621075116\|gb\|CP031311.1\|	699433	g78604	i0	81.295	0.772222222222222	139	18	75	8	46	180	2818311	2818177	Halobellus limi strain CGMCC 1.10331 chromosome, complete genome	blastn	139	106	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus limi
9501970	9501970	PRJNA600413_P_NODE_156228_length_152_cov_4.320388_g155527_i0	PRJNA600413	156228	152	4.320388	6.56698976	Halococcus	2249	Archaea	Archaea	90.9	8.35e-20	NR	WP_256686215.1	224402	g155527	i0	78.8	2.05263157894737	52	9	98.7	1	151	2	349	400	WP_256686215.1 RNA-guided endonuclease InsQ/TnpB family protein [Halococcus qingdaonensis]	diamond	312	90.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus qingdaonensis
10777808	10777808	PRJNA600413_P_NODE_151029_length_161_cov_0.910714_g150328_i0	PRJNA600413	151029	161	0.910714	1.46624954	Natronorubrum aibiense	348826	Archaea	Archaea	130	6.01e-26	NTclustered	gi\|1770796843\|gb\|CP045490.1\|	348826	g150328	i0	85.95	1.79503105590062	121	17	75	0	3	123	152200	152080	Natronorubrum aibiense strain 7-3 plasmid unnamed2	blastn	289	130	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum aibiense
12054057	12054057	PRJNA600413_P_NODE_66770_length_188_cov_2.482014_g66069_i0	PRJNA600413	66770	188	2.482014	4.6661863200000004	Methanobacteriota archaeon	2026739	Archaea	Archaea	124	1.64e-31	NR	MCH7660452.1	2026739	g66069	i0	91.9	0.98936170212766	62	5	98.9	0	2	187	69	130	MCH7660452.1 ABC transporter substrate-binding protein [Methanobacteriota archaeon]	diamond	186	124	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
15170879	15170879	PRJNA600413_P_NODE_86832_length_175_cov_2.841270_g86131_i0	PRJNA600413	86832	175	2.84127	4.9722225	root	1	Root_unresolved	Root_unresolved	324	2.83e-84	NTclustered	gi\|146328296\|emb\|AM261790.1\|	114243	g86131	i0	100	100.971428571429	175	0	100	0	1	175	186	360	Uncultured euryarchaeota partial 16S rRNA gene, clone 6-1	blastn	17670	324	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured euryarchaeote
17150419	17150419	PRJNA600413_P_NODE_104634_length_167_cov_0.864407_g103933_i0	PRJNA600413	104634	167	0.864407	1.44355969	Halalkalicoccus	332246	Archaea	Archaea	102	2.4e-24	NR	WP_340603773.1	175632	g103933	i0	83.3	3.91616766467066	54	9	97	0	2	163	81	134	WP_340603773.1 tRNA-intron lyase [Halalkalicoccus tibetensis]	diamond	654	103	0.990291262135922	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus tibetensis
18993364	18993364	PRJNA600413_P_NODE_149895_length_161_cov_0.910714_g149194_i0	PRJNA600413	149895	161	0.910714	1.46624954	Natrialbaceae	1644061	Archaea	Archaea	183	4.55e-42	NTclustered	gi\|2006064443\|gb\|CP071462.1\|	2816475	g149194	i0	87.421	4.83229813664596	159	20	99	0	3	161	416436	416594	Haloterrigena alkaliphila strain KZCA68 chromosome, complete genome	blastn	778	183	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena alkaliphila
23525486	23525486	PRJNA600413_P_NODE_124299_length_164_cov_0.886957_g123598_i0	PRJNA600413	124299	164	0.886957	1.45460948	Halocatena salina	2934340	Archaea	Archaea	156	1.01e-33	NTclustered	gi\|2230625526\|gb\|CP096019.1\|	2934340	g123598	i0	85.333	0.914634146341463	150	22	91	0	1	150	851303	851452	Halocatena salina strain AD-1 chromosome, complete genome	blastn	150	156	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halocatena	Halocatena salina
23527243	23527243	PRJNA600413_P_NODE_67259_length_188_cov_1.467626_g66558_i0	PRJNA600413	67259	188	1.467626	2.75913688	Natrononativus amylolyticus	2963434	Archaea	Archaea	65.8	2.07e-6	NTclustered	gi\|2274417431\|gb\|CP101458.1\|	2963434	g66558	i0	100	1.51595744680851	35	0	19	0	121	155	1421098	1421132	Natrononativus amylolyticus strain CGA73 chromosome, complete genome	blastn	285	65.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrononativus	Natrononativus amylolyticus
27048351	27048351	PRJNA600413_P_NODE_137302_length_162_cov_1.805310_g136601_i0	PRJNA600413	137302	162	1.80531	2.9246022	Methanobacteriota archaeon	2026739	Archaea	Archaea	60.8	1.43e-9	NR	MCH7660815.1	2026739	g136601	i0	96.3	0.5	27	1	50	0	83	3	1	27	MCH7660815.1 DUF655 domain-containing protein [Methanobacteriota archaeon]	diamond	81	60.8	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27630470	27630470	PRJNA600413_P_NODE_131784_length_163_cov_0.894737_g131083_i0	PRJNA600413	131784	163	0.894737	1.45842131	Halobacteriales	2235	Archaea	Archaea	80.5	2.07e-17	NR	HET7324594.1	29286	g131083	i0	82.4	6.4601226993865	51	9	93.9	0	154	2	5	55	HET7324594.1 Tfx family DNA-binding protein [Halococcus sp.]	diamond	1053	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp.
28185087	28185087	PRJNA600413_P_NODE_143646_length_162_cov_0.858407_g142945_i0	PRJNA600413	143646	162	0.858407	1.39061934	Methanobacteriota archaeon	2026739	Archaea	Archaea	97.4	5.46e-24	NR	MCH7662173.1	2026739	g142945	i0	83.3	1	54	9	100	0	1	162	62	115	MCH7662173.1 metallophosphoesterase [Methanobacteriota archaeon]	diamond	162	97.4	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28311736	28311736	PRJNA600413_P_NODE_96526_length_170_cov_1.347107_g95825_i0	PRJNA600413	96526	170	1.347107	2.2900819	Methanobacteriota archaeon	2026739	Archaea	Archaea	95.1	2.0099999999999994e-23	NR	MCH7659369.1	2026739	g95825	i0	80	2.87647058823529	55	11	97.1	0	2	166	53	107	MCH7659369.1 M67 family metallopeptidase [Methanobacteriota archaeon]	diamond	489	95.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28753641	28753641	PRJNA600413_P_NODE_145867_length_161_cov_0.910714_g145166_i0	PRJNA600413	145867	161	0.910714	1.46624954	Natronorubrum bangense JCM 1	61858	Archaea	Archaea	99.8	5.75e-23	NR	ELY49078.1	1227500	g145166	i0	90.6	4.93788819875776	53	5	98.8	0	2	160	107	159	ELY49078.1 adenine-specific DNA methylase [Natronorubrum bangense JCM 10635]	diamond	795	99.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum bangense
28924676	28924676	PRJNA600413_P_NODE_102288_length_167_cov_1.338983_g101587_i0	PRJNA600413	102288	167	1.338983	2.23610161	Halococcus	2249	Archaea	Archaea	112	1.06e-28	NR	HET7323934.1	29286	g101587	i0	92.7	2.96407185628743	55	4	98.8	0	166	2	110	164	HET7323934.1 ribonucleotide-diphosphate reductase subunit beta [Halococcus sp.]	diamond	495	112	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp.
29385283	29385283	PRJNA600413_P_NODE_74769_length_183_cov_1.522388_g74068_i0	PRJNA600413	74769	183	1.522388	2.78597004	Methanobacteriota archaeon	2026739	Archaea	Archaea	68.6	1.33e-11	NR	MCH7660235.1	2026739	g74068	i0	84.4	0.737704918032787	45	6	73.8	1	135	1	1	44	MCH7660235.1 zinc ABC transporter substrate-binding protein [Methanobacteriota archaeon]	diamond	135	68.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29448038	29448038	PRJNA600413_P_NODE_108290_length_166_cov_1.743590_g107589_i0	PRJNA600413	108290	166	1.74359	2.8943594	Methanobacteriota archaeon	2026739	Archaea	Archaea	95.1	7.1700000000000005e-22	NR	MCH7661649.1	2026739	g107589	i0	78.2	0.993975903614458	55	12	99.4	0	165	1	98	152	MCH7661649.1 extracellular solute-binding protein [Methanobacteriota archaeon]	diamond	165	95.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29448051	29448051	PRJNA600413_P_NODE_145950_length_161_cov_0.910714_g145249_i0	PRJNA600413	145950	161	0.910714	1.46624954	Methanobacteriota archaeon	2026739	Archaea	Archaea	79	2.08e-15	NR	MCH7660606.1	2026739	g145249	i0	71.7	0.987577639751553	53	15	98.8	0	2	160	44	96	MCH7660606.1 Hvo_1808 family surface protein [Methanobacteriota archaeon]	diamond	159	79	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29700511	29700511	PRJNA600413_P_NODE_117310_length_165_cov_0.879310_g116609_i0	PRJNA600413	117310	165	0.87931	1.4508615	Halobacteriales archaeon SW_9_67_24	1919209	Archaea	Archaea	59.3	1.77e-8	NR	PSQ66431.1	1919209	g116609	i0	84.8	1.76363636363636	33	5	60	0	66	164	1	33	PSQ66431.1 MAG: ADP-forming succinate--CoA ligase subunit beta [Halobacteriales archaeon SW_9_67_24]	diamond	291	59.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon SW_9_67_24
29922094	29922094	PRJNA600413_P_NODE_155911_length_153_cov_2.644231_g155210_i0	PRJNA600413	155911	153	2.644231	4.04567343	Halalkalicoccus jeotgali	413810	Archaea	Archaea	90.1	2.17e-19	NR	WP_008414089.1	413810	g155210	i0	84	0.980392156862745	50	8	98	0	152	3	150	199	WP_008414089.1 type IV secretory system conjugative DNA transfer family protein [Halalkalicoccus jeotgali]	diamond	150	90.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
30124590	30124590	PRJNA600413_P_NODE_123632_length_164_cov_1.330435_g122931_i0	PRJNA600413	123632	164	1.330435	2.1819134	Halalkalicoccus	332246	Archaea	Archaea	100	3.88e-24	NR	WP_340603448.1	175632	g122931	i0	79.6	3.95121951219512	54	11	98.8	0	3	164	3	56	WP_340603448.1 diaminopimelate epimerase [Halalkalicoccus tibetensis]	diamond	648	101	0.99009900990099	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus tibetensis
30206039	30206039	PRJNA600413_P_NODE_126532_length_164_cov_0.886957_g125831_i0	PRJNA600413	126532	164	0.886957	1.45460948	Halorarum salinum	2743089	Archaea	Archaea	75.5	1.82e-14	NR	WP_179266943.1	2743089	g125831	i0	67.3	0.896341463414634	49	16	89.6	0	147	1	6	54	WP_179266943.1 energy-coupling factor ABC transporter ATP-binding protein [Halorarum salinum]	diamond	147	75.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorarum	Halorarum salinum
30237906	30237906	PRJNA600413_P_NODE_126232_length_164_cov_0.886957_g125531_i0	PRJNA600413	126232	164	0.886957	1.45460948	Halobacteriales archaeon QS_7_68_65	1919184	Archaea	Archaea	102	5.7299999999999996e-24	NR	PSQ14256.1	1919184	g125531	i0	87	0.98780487804878	54	7	98.8	0	164	3	67	120	PSQ14256.1 MAG: hypothetical protein BRC98_00580 [Halobacteriales archaeon QS_7_68_65]	diamond	162	102	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon QS_7_68_65
30964722	30964722	PRJNA600413_P_NODE_136014_length_163_cov_0.894737_g135313_i0	PRJNA600413	136014	163	0.894737	1.45842131	Halococcus thailandensis	335952	Archaea	Archaea	87.8	3.12e-19	NR	WP_007736513.1	335952	g135313	i0	83.3	0.993865030674847	54	9	99.4	0	1	162	3	56	WP_007736513.1 hypothetical protein [Halococcus thailandensis]	diamond	162	87.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus thailandensis
31944709	31944709	PRJNA600413_P_NODE_58097_length_197_cov_1.378378_g57396_i0	PRJNA600413	58097	197	1.378378	2.71540466	Methanobacteriota archaeon	2026739	Archaea	Archaea	92	8.42e-20	NR	MCH7659816.1	2026739	g57396	i0	92.5	1.61421319796954	53	4	80.7	0	160	2	1	53	MCH7659816.1 cation:proton antiporter [Methanobacteriota archaeon]	diamond	318	92	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32134831	32134831	PRJNA600413_P_NODE_119978_length_165_cov_0.879310_g119277_i0	PRJNA600413	119978	165	0.87931	1.4508615	Halalkalicoccus sp. NIPERK	1973143	Archaea	Archaea	68.9	1.11e-12	NR	WP_286044859.1	3053469	g119277	i0	86.8	0.690909090909091	38	5	69.1	0	3	116	145	182	WP_286044859.1 HAD family hydrolase [Halalkalicoccus sp. NIPERK01]	diamond	114	68.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus sp. NIPERK01
32198046	32198046	PRJNA600413_P_NODE_89538_length_174_cov_1.288000_g88837_i0	PRJNA600413	89538	174	1.288	2.24112	Natronococcus wangiae	3068275	Archaea	Archaea	84.7	1.7e-17	NR	WP_306055534.1	3068275	g88837	i0	70.2	0.982758620689655	57	17	98.3	0	2	172	276	332	WP_306055534.1 MFS transporter [Natronococcus wangiae]	diamond	171	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus wangiae
32546240	32546240	PRJNA600413_P_NODE_137059_length_162_cov_1.805310_g136358_i0	PRJNA600413	137059	162	1.80531	2.9246022	Halalkalicoccus subterraneus	2675002	Archaea	Archaea	51.2	7.17e-7	NR	WP_122087999.1	2675002	g136358	i0	95.7	0.851851851851852	23	1	42.6	0	70	2	1	23	WP_122087999.1 hypothetical protein [Halalkalicoccus subterraneus]	diamond	138	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus subterraneus

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