metadata: contig_metadata: 32 rows where bioproject = "PRJNA558770" and tax

32 rows where bioproject = "PRJNA558770" and tax_clade = "Methanomada group"

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
3092062	3092062	PRJNA558770_P_NODE_333583_length_233_cov_5.333333_g331578_i0	PRJNA558770	333583	233	5.333333	12.42666589	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	97.1	9.5e-16	NTclustered	gi\|2874253877\|emb\|OY969932.1\|	176233	g331578	i0	95.082	0.261802575107296	61	3	26	0	163	223	499293	499353	MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1	blastn	61	97.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
5643030	5643030	PRJNA558770_P_NODE_202285_length_234_cov_3.693467_g200280_i0	PRJNA558770	202285	234	3.693467	8.64271278	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	82.4	2.67e-11	NTclustered	gi\|2874253858\|emb\|OY969914.1\|	176233	g200280	i0	92.982	0.700854700854701	57	3	24	1	160	216	2333682	2333627	MAG: uncultured Methanobacteriaceae archaeon isolate MFD02416.bin.1.248 genome assembly, chromosome: 1	blastn	164	82.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
5644783	5644783	PRJNA558770_P_NODE_316145_length_233_cov_10.080808_g314140_i0	PRJNA558770	316145	233	10.080808	23.48828264	Methanobrevibacter acididurans	120963	Archaea	Archaea	124	4.36e-24	NTclustered	gi\|2871247231\|gb\|CP166991.1\|	120963	g314140	i0	97.26	3.47210300429185	73	2	31	0	161	233	339776	339704	Methanobrevibacter acididurans strain DSM 15163 chromosome, complete genome	blastn	809	124	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter acididurans
8781511	8781511	PRJNA558770_P_NODE_111547_length_234_cov_10.351759_g109542_i0	PRJNA558770	111547	234	10.351759	24.22311606	Methanobacterium	2160	Archaea	Archaea	82.4	2.67e-11	NTclustered	gi\|2874253795\|emb\|OY969779.1\|	176233	g109542	i0	94.34	1.05128205128205	53	3	23	0	163	215	818362	818414	MAG: uncultured Methanobacteriaceae archaeon isolate MFD04716.bin.c.1 genome assembly, chromosome: 1	blastn	246	82.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
10742812	10742812	PRJNA558770_P_NODE_172209_length_234_cov_5.045226_g170204_i0	PRJNA558770	172209	234	5.045226	11.80582884	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	76.8	1.24e-9	NTclustered	gi\|2874253858\|emb\|OY969914.1\|	176233	g170204	i0	92.453	0.452991452991453	53	4	23	0	1	53	2218500	2218552	MAG: uncultured Methanobacteriaceae archaeon isolate MFD02416.bin.1.248 genome assembly, chromosome: 1	blastn	106	76.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
22216663	22216663	PRJNA558770_P_NODE_219238_length_234_cov_3.115578_g217233_i0	PRJNA558770	219238	234	3.115578	7.29045252	Methanobacterium petrolearium	710190	Archaea	Archaea	111	3.41e-20	NTclustered	gi\|2465759960\|dbj\|AP027739.1\|	710190	g217233	i0	93.421	0.324786324786325	76	4	32	1	160	234	438122	438047	Methanobacterium petrolearium NBRC 105198 DNA, complete genome	blastn	76	111	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium petrolearium
24765077	24765077	PRJNA558770_P_NODE_182920_length_234_cov_4.507538_g180915_i0	PRJNA558770	182920	234	4.507538	10.54763892	Methanobacterium ferruginis	710191	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2465756734\|dbj\|AP027738.1\|	710191	g180915	i0	100	0.123931623931624	29	0	12	0	167	195	884095	884123	Methanobacterium ferruginis NBRC 105197 DNA, complete genome	blastn	29	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium ferruginis
26871841	26871841	PRJNA558770_P_NODE_273381_length_234_cov_1.844221_g271376_i0	PRJNA558770	273381	234	1.844221	4.31547714	Methanobacterium	2160	Archaea	Archaea	50.1	6.98e-5	NR	WP_100907503.1	2160	g271376	i0	95.8	1.84615384615385	24	1	30.8	0	3	74	213	236	WP_100907503.1 MULTISPECIES: SagB/ThcOx family dehydrogenase [Methanobacterium]	diamond	432	50.4	0.994047619047619	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium
26997855	26997855	PRJNA558770_P_NODE_221062_length_234_cov_3.060302_g219057_i0	PRJNA558770	221062	234	3.060302	7.16110668	Methanobacterium	2160	Archaea	Archaea	51.2	3.38e-5	NR	WP_232728046.1	2160	g219057	i0	95.8	2.46153846153846	24	1	30.8	0	74	3	502	525	WP_232728046.1 MULTISPECIES: PEP/pyruvate-binding domain-containing protein [Methanobacterium]	diamond	576	51.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium
27300168	27300168	PRJNA558770_P_NODE_193623_length_234_cov_4.035176_g191618_i0	PRJNA558770	193623	234	4.035176	9.44231184	Methanobacterium spitsbergense	2874285	Archaea	Archaea	48.1	4.25e-4	NR	WP_223792207.1	2874285	g191618	i0	100	0.294871794871795	23	0	29.5	0	7	75	73	95	WP_223792207.1 CHASE4 domain-containing protein [Methanobacterium spitsbergense]	diamond	69	48.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
27346033	27346033	PRJNA558770_P_NODE_236963_length_234_cov_2.618090_g234958_i0	PRJNA558770	236963	234	2.61809	6.1263306	Methanobacterium	2160	Archaea	Archaea	51.2	3.22e-5	NR	WP_281774230.1	2162	g234958	i0	100	1.23076923076923	24	0	30.8	0	161	232	57	80	WP_281774230.1 hypothetical protein [Methanobacterium formicicum]	diamond	288	51.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium formicicum
27931726	27931726	PRJNA558770_P_NODE_14825_length_499_cov_8.689655_g13075_i0	PRJNA558770	14825	499	8.689655	43.36137845	Methanobrevibacter sp.	66852	Archaea	Archaea	53.9	1.01e-5	NR	MBO7694409.1	66852	g13075	i0	50	1.03406813627255	44	22	26.5	0	363	494	25	68	MBO7694409.1 DUF3310 domain-containing protein [Methanobrevibacter sp.]	diamond	516	53.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28278813	28278813	PRJNA558770_P_NODE_127066_length_234_cov_8.417085_g125061_i0	PRJNA558770	127066	234	8.417085	19.6959789	Methanobacterium spitsbergense	2874285	Archaea	Archaea	43.9	0.0123	NR	MBZ2166225.1	2874285	g125061	i0	88	0.320512820512821	25	3	32.1	0	2	76	188	212	MBZ2166225.1 30S ribosomal protein S3 [Methanobacterium spitsbergense]	diamond	75	43.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
28563332	28563332	PRJNA558770_P_NODE_281167_length_234_cov_1.718593_g279162_i0	PRJNA558770	281167	234	1.718593	4.02150762	Methanobacterium spitsbergense	2874285	Archaea	Archaea	80.5	2.28e-16	NR	WP_223790895.1	2874285	g279162	i0	62.3	0.987179487179487	77	6	98.7	1	1	231	115	168	WP_223790895.1 triose-phosphate isomerase [Methanobacterium spitsbergense]	diamond	231	80.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
28658076	28658076	PRJNA558770_P_NODE_265907_length_234_cov_1.984925_g263902_i0	PRJNA558770	265907	234	1.984925	4.6447245	Methanobacterium sp. SMA-27	1495336	Archaea	Archaea	52.8	9.42e-6	NR	WP_048191139.1	1495336	g263902	i0	100	0.628205128205128	24	0	30.8	0	73	2	224	247	WP_048191139.1 methanogenesis marker 3 protein [Methanobacterium sp. SMA-27]	diamond	147	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. SMA-27
28784087	28784087	PRJNA558770_P_NODE_335227_length_233_cov_4.924242_g333222_i0	PRJNA558770	335227	233	4.924242	11.47348386	Methanobacterium spitsbergense	2874285	Archaea	Archaea	51.2	1.59e-5	NR	WP_223791761.1	2874285	g333222	i0	96	0.321888412017167	25	1	32.2	0	233	159	150	174	WP_223791761.1 serine O-acetyltransferase [Methanobacterium spitsbergense]	diamond	75	51.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
28924401	28924401	PRJNA558770_P_NODE_165768_length_234_cov_5.407035_g163763_i0	PRJNA558770	165768	234	5.407035	12.6524619	Methanobacterium	2160	Archaea	Archaea	50.4	2.2e-5	NR	WP_048082446.1	2160	g163763	i0	92	0.961538461538462	25	2	32.1	0	2	76	8	32	WP_048082446.1 MULTISPECIES: hypothetical protein [Methanobacterium]	diamond	225	50.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium
29289333	29289333	PRJNA558770_P_NODE_218309_length_234_cov_3.140704_g216304_i0	PRJNA558770	218309	234	3.140704	7.34924736	Methanobacterium spitsbergense	2874285	Archaea	Archaea	47	9.85e-4	NR	WP_223792325.1	2874285	g216304	i0	100	0.307692307692308	24	0	30.8	0	161	232	280	303	WP_223792325.1 hypothetical protein [Methanobacterium spitsbergense]	diamond	72	47	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
29478605	29478605	PRJNA558770_P_NODE_276930_length_234_cov_1.783920_g274925_i0	PRJNA558770	276930	234	1.78392	4.1743728	Methanobacterium sp.	2164	Archaea	Archaea	59.3	4.56e-8	NR	MCC7562881.1	2164	g274925	i0	35.7	1.61538461538462	126	32	98.7	1	233	3	33	158	MCC7562881.1 histidinol dehydrogenase [Methanobacterium sp.]	diamond	378	59.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
29492890	29492890	PRJNA558770_P_NODE_254630_length_234_cov_2.206030_g252625_i0	PRJNA558770	254630	234	2.20603	5.1621102	Methanobrevibacter	2172	Archaea	Archaea	52	1.39e-5	NR	MBE6499899.1	190975	g252625	i0	92	1.91025641025641	25	2	32.1	0	75	1	154	178	MBE6499899.1 tRNA (adenine-N1)-methyltransferase [Methanobrevibacter thaueri]	diamond	447	52	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter thaueri
30015840	30015840	PRJNA558770_P_NODE_257631_length_234_cov_2.145729_g255626_i0	PRJNA558770	257631	234	2.145729	5.02100586	Methanobacterium sp. SMA-27	1495336	Archaea	Archaea	51.2	3.32e-5	NR	WP_048190908.1	1495336	g255626	i0	100	0.307692307692308	24	0	30.8	0	2	73	52	75	WP_048190908.1 Ig-like domain-containing protein [Methanobacterium sp. SMA-27]	diamond	72	51.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. SMA-27
30458461	30458461	PRJNA558770_P_NODE_225913_length_234_cov_2.919598_g223908_i0	PRJNA558770	225913	234	2.919598	6.83185932	Methanobacterium spitsbergense	2874285	Archaea	Archaea	47.8	4.09e-4	NR	WP_223790354.1	2874285	g223908	i0	91.7	0.307692307692308	24	2	30.8	0	3	74	20	43	WP_223790354.1 potassium channel family protein [Methanobacterium spitsbergense]	diamond	72	47.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
30503756	30503756	PRJNA558770_P_NODE_213613_length_234_cov_3.291457_g211608_i0	PRJNA558770	213613	234	3.291457	7.70200938	root	1	Root_unresolved	Root_unresolved	46.6	6.77e-4	NR	MDO5819857.1	66852	g211608	i0	87	1.82051282051282	23	3	29.5	0	164	232	67	89	MDO5819857.1 VWA domain-containing protein [Methanobrevibacter sp.]	diamond	426	47	0.991489361702128	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30679045	30679045	PRJNA558770_P_NODE_221553_length_234_cov_3.045226_g219548_i0	PRJNA558770	221553	234	3.045226	7.12582884	Methanobacterium spitsbergense	2874285	Archaea	Archaea	58.9	6.17e-8	NR	WP_223790648.1	2874285	g219548	i0	56	0.961538461538462	75	18	96.2	1	233	9	300	359	WP_223790648.1 ABC transporter permease [Methanobacterium spitsbergense]	diamond	225	58.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium spitsbergense
30774163	30774163	PRJNA558770_P_NODE_210994_length_234_cov_3.376884_g208989_i0	PRJNA558770	210994	234	3.376884	7.90190856	Methanobacterium sp. SMA-27	1495336	Archaea	Archaea	52.8	7.59e-6	NR	WP_231551413.1	1495336	g208989	i0	100	0.307692307692308	24	0	30.8	0	3	74	216	239	WP_231551413.1 hypothetical protein [Methanobacterium sp. SMA-27]	diamond	72	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. SMA-27
31058725	31058725	PRJNA558770_P_NODE_282275_length_234_cov_1.698492_g280270_i0	PRJNA558770	282275	234	1.698492	3.97447128	Methanobrevibacter sp.	66852	Archaea	Archaea	45.1	0.00263	NR	MBO7732821.1	66852	g280270	i0	70.8	0.307692307692308	24	7	30.8	0	73	2	88	111	MBO7732821.1 HNH endonuclease [Methanobrevibacter sp.]	diamond	72	45.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31325232	31325232	PRJNA558770_P_NODE_265435_length_234_cov_1.994975_g263430_i0	PRJNA558770	265435	234	1.994975	4.6682415	root	1	Root_unresolved	Root_unresolved	43.9	0.0126	NR	WP_286009474.1	190976	g263430	i0	68	0.948717948717949	25	8	32.1	0	234	160	80	104	WP_286009474.1 glycosyltransferase [Methanobrevibacter woesei]	diamond	222	43.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
31564531	31564531	PRJNA558770_P_NODE_220876_length_234_cov_3.065327_g218871_i0	PRJNA558770	220876	234	3.065327	7.17286518	Methanobacterium sp. SMA-27	1495336	Archaea	Archaea	45.8	0.00268	NR	WP_048190747.1	1495336	g218871	i0	91.3	0.294871794871795	23	2	29.5	0	71	3	70	92	WP_048190747.1 hypothetical protein [Methanobacterium sp. SMA-27]	diamond	69	45.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. SMA-27
32242985	32242985	PRJNA558770_P_NODE_151478_length_234_cov_6.311558_g149473_i0	PRJNA558770	151478	234	6.311558	14.76904572	Methanobacterium	2160	Archaea	Archaea	48.5	3.06e-4	NR	WP_052375737.1	2160	g149473	i0	87.5	0.615384615384615	24	3	30.8	0	232	161	1365	1388	WP_052375737.1 MULTISPECIES: PAS domain S-box protein [Methanobacterium]	diamond	144	48.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium
32481930	32481930	PRJNA558770_P_NODE_321319_length_233_cov_8.515152_g319314_i0	PRJNA558770	321319	233	8.515152	19.84030416	Methanobacterium lacus	877455	Archaea	Archaea	46.6	9.04e-4	NR	WP_013645333.1	877455	g319314	i0	83.3	0.630901287553648	24	4	30.9	0	160	231	57	80	WP_013645333.1 potassium-transporting ATPase subunit KdpC [Methanobacterium lacus]	diamond	147	46.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium lacus
32545241	32545241	PRJNA558770_P_NODE_128399_length_234_cov_8.276382_g126394_i0	PRJNA558770	128399	234	8.276382	19.36673388	Methanobacterium sp. SMA-27	1495336	Archaea	Archaea	46.2	0.00199	NR	WP_052374109.1	1495336	g126394	i0	88	0.641025641025641	25	3	32.1	0	233	159	619	643	WP_052374109.1 PAS domain S-box protein [Methanobacterium sp. SMA-27]	diamond	150	46.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. SMA-27
32639339	32639339	PRJNA558770_P_NODE_260060_length_234_cov_2.095477_g258055_i0	PRJNA558770	260060	234	2.095477	4.90341618	Methanobacterium sp.	2164	Archaea	Archaea	82.8	2.56e-16	NR	MCC7564526.1	2164	g258055	i0	62.3	1.97435897435897	77	29	98.7	0	233	3	63	139	MCC7564526.1 PAS domain S-box protein [Methanobacterium sp.]	diamond	462	82.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.

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