metadata: contig_metadata: 33 rows where bioproject = "PRJNA940501" and tax

33 rows where bioproject = "PRJNA940501" and tax_kingdom = "Methanobacteriati"

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
1257707	1257707	PRJNA940501_S_NODE_243001_length_180_cov_3.014599_g242183_i0	PRJNA940501	243001	180	3.014599	5.4262782	Haloarcula	2237	Archaea	Archaea	52.8	0.015	NTclustered	gi\|1822681844\|gb\|CP050014.1\|	2716717	g242183	i0	100	0.311111111111111	28	0	16	0	41	68	1603196	1603169	Haloarcula sp. JP-L23 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula sp. JP-L23
6024531	6024531	PRJNA940501_S_NODE_401185_length_150_cov_0.878505_g400367_i0	PRJNA940501	401185	150	0.878505	1.3177575	uncultured Methanoregulaceae archaeon	1392423	Archaea	Archaea	54.7	0.003	NTclustered	gi\|2874254018\|emb\|OY970343.1\|	1392423	g400367	i0	94.444	0.24	36	1	23	1	57	91	1284585	1284620	MAG: uncultured Methanoregulaceae archaeon isolate MFD00082.bin.c.4 genome assembly, chromosome: 1	blastn	36	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		uncultured Methanoregulaceae archaeon
7296699	7296699	PRJNA940501_S_NODE_16866_length_383_cov_5.411765_g16050_i0	PRJNA940501	16866	383	5.411765	20.72705995	Halovivax cerinus	1487865	Archaea	Archaea	52.8	0.037	NTclustered	gi\|2279709464\|gb\|CP101824.1\|	1487865	g16050	i0	100	0.0731070496083551	28	0	7	0	262	289	1011176	1011203	Halovivax cerinus strain IBRC-M 10256 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax cerinus
9847200	9847200	PRJNA940501_S_NODE_209548_length_190_cov_1.278912_g208730_i0	PRJNA940501	209548	190	1.278912	2.4299328	Methanosarcinales archaeon Met12	1914862	Archaea	Archaea	54.7	0.005	NTclustered	gi\|2647574341\|gb\|CP017966.2\|	1914862	g208730	i0	96.97	0.468421052631579	33	0	17	1	139	171	198103	198134	MAG: Methanosarcinales archaeon Met12 chromosome, complete genome	blastn	89	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon Met12
9847477	9847477	PRJNA940501_S_NODE_227588_length_185_cov_0.992958_g226770_i0	PRJNA940501	227588	185	0.992958	1.8369723	Natrialba magadii	13769	Archaea	Archaea	63.9	7.3e-6	NTclustered	gi\|289529249\|gb\|CP001932.1\|	547559	g226770	i0	100	41.8	34	0	18	0	73	106	3095408	3095375	Natrialba magadii ATCC 43099, complete sequence	blastn	7733	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba magadii
10185950	10185950	PRJNA940501_S_NODE_132968_length_219_cov_2.085227_g132150_i0	PRJNA940501	132968	219	2.085227	4.56664713	root	1	Root_unresolved	Root_unresolved	80.5	8.89e-11	NTclustered	gi\|2515741548\|gb\|CP117271.1\|	2209	g132150	i0	100	7.78538812785388	43	0	20	0	1	43	275528	275570	Mutant Methanosarcina mazei strain Mm Mut 208, complete genome	blastn	1705	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
10187303	10187303	PRJNA940501_S_NODE_98208_length_239_cov_1.724490_g97390_i0	PRJNA940501	98208	239	1.72449	4.1215311	root	1	Root_unresolved	Root_unresolved	99.4	4.16e-22	NR	WP_015300700.1	387341	g97390	i0	79	7.07949790794979	62	13	77.8	0	50	235	574	635	WP_015300700.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Halovivax ruber]	diamond	1692	100	0.994	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax ruber
11124971	11124971	PRJNA940501_S_NODE_40969_length_299_cov_4.265625_g40151_i0	PRJNA940501	40969	299	4.265625	12.75421875	Haloprofundus halobius	2876194	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2099489103\|gb\|CP083666.1\|	2876194	g40151	i0	100	0.100334448160535	30	0	10	0	164	193	2092621	2092592	Haloprofundus halobius strain SEDH52 chromosome, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus halobius
14947255	14947255	PRJNA940501_S_NODE_222232_length_186_cov_1.643357_g221414_i0	PRJNA940501	222232	186	1.643357	3.05664402	Haloarcula litorea	3032579	Archaea	Archaea	161	2.53e-35	NTclustered	gi\|2463595526\|gb\|CP119779.1\|	3032579	g221414	i0	84.118	7.78494623655914	170	23	90	4	1	168	301873	301706	Haloarcula litorea strain GDY20 chromosome, complete genome	blastn	1448	161	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula litorea
17497944	17497944	PRJNA940501_S_NODE_24214_length_344_cov_2.083056_g23396_i0	PRJNA940501	24214	344	2.083056	7.16571264	Methanocaldococcus villosus	667126	Archaea	Archaea	52.8	0.033	NTclustered	gi\|2891703609\|gb\|CP178163.1\|	1069083	g23396	i0	100	0.0813953488372093	28	0	8	0	135	162	242273	242246	Methanocaldococcus villosus KIN24-T80 chromosome, complete genome	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus
21321075	21321075	PRJNA940501_S_NODE_199057_length_193_cov_1.866667_g198239_i0	PRJNA940501	199057	193	1.866667	3.60266731	Methanosphaera sp. ISO3-F5	1452353	Archaea	Archaea	52.8	0.017	NTclustered	gi\|2695672541\|gb\|CP118754.2\|	1452353	g198239	i0	100	0.145077720207254	28	0	15	0	110	137	141740	141713	Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. ISO3-F5
22595668	22595668	PRJNA940501_S_NODE_180298_length_199_cov_3.852564_g179480_i0	PRJNA940501	180298	199	3.852564	7.66660236	Methanosalsum zhilinae	39669	Archaea	Archaea	56.5	0.001	NTclustered	gi\|335929340\|gb\|CP002101.1\|	679901	g179480	i0	100	0.150753768844221	30	0	15	0	87	116	1665138	1665167	Methanosalsum zhilinae DSM 4017, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosalsum	Methanosalsum zhilinae
27436286	27436286	PRJNA940501_S_NODE_65823_length_266_cov_1.264574_g65005_i0	PRJNA940501	65823	266	1.264574	3.36376684	Methanosphaera sp. rholeuAM13	2666342	Archaea	Archaea	42	0.0473	NR	RAP54450.1	1945578	g65005	i0	34.2	0.890977443609023	79	47	83.5	1	240	19	54	132	RAP54450.1 MAG: hypothetical protein BZ137_02130 [Methanosphaera sp. rholeuAM130]	diamond	237	42	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. rholeuAM130
27815153	27815153	PRJNA940501_S_NODE_272684_length_173_cov_1.661538_g271866_i0	PRJNA940501	272684	173	1.661538	2.87446074	Thermoplasmatota archaeon	2806419	Archaea	Archaea	39.7	0.0449	NR	MCL4325421.1	2806419	g271866	i0	36.7	0.84971098265896	49	30	85	1	159	13	7	54	MCL4325421.1 helix-turn-helix domain-containing protein [Thermoplasmatota archaeon]	diamond	147	39.7	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27941323	27941323	PRJNA940501_S_NODE_322465_length_163_cov_1.108333_g321647_i0	PRJNA940501	322465	163	1.108333	1.80658279	Methanobrevibacter sp.	66852	Archaea	Archaea	94.7	5.790000000000001e-21	NR	MDO5827583.1	66852	g321647	i0	88.7	0.975460122699387	53	6	97.5	0	161	3	275	327	MDO5827583.1 hypothetical protein [Methanobrevibacter sp.]	diamond	159	94.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28162349	28162349	PRJNA940501_S_NODE_120745_length_225_cov_3.115385_g119927_i0	PRJNA940501	120745	225	3.115385	7.00961625	Methanobrevibacter smithii	2173	Archaea	Archaea	52	9.42e-6	NR	WP_217423167.1	2173	g119927	i0	55.6	0.6	45	20	60	0	40	174	128	172	WP_217423167.1 hypothetical protein, partial [Methanobrevibacter smithii]	diamond	135	52	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
28193622	28193622	PRJNA940501_S_NODE_222006_length_186_cov_1.748252_g221188_i0	PRJNA940501	222006	186	1.748252	3.25174872	Methanobacteriota archaeon	2026739	Archaea	Archaea	43.9	0.00663	NR	MDI9437242.1	2026739	g221188	i0	24.1	1.87096774193548	58	44	93.5	0	9	182	28	85	MDI9437242.1 UPF0104 family protein [Methanobacteriota archaeon]	diamond	348	43.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28288357	28288357	PRJNA940501_S_NODE_133506_length_219_cov_1.602273_g132688_i0	PRJNA940501	133506	219	1.602273	3.50897787	Methanobrevibacter smithii	2173	Archaea	Archaea	59.3	1.57e-8	NR	WP_217423167.1	2173	g132688	i0	62.2	0.616438356164384	45	17	61.6	0	82	216	127	171	WP_217423167.1 hypothetical protein, partial [Methanobrevibacter smithii]	diamond	135	59.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
28446531	28446531	PRJNA940501_S_NODE_164146_length_205_cov_3.728395_g163328_i0	PRJNA940501	164146	205	3.728395	7.64320975	Methanobacteriota archaeon	2026739	Archaea	Archaea	42.4	0.0304	NR	MDE1822239.1	2026739	g163328	i0	38.3	0.878048780487805	60	36	86.3	1	202	26	103	162	MDE1822239.1 hypothetical protein [Methanobacteriota archaeon]	diamond	180	42.4	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28604277	28604277	PRJNA940501_S_NODE_23227_length_348_cov_2.049180_g22409_i0	PRJNA940501	23227	348	2.04918	7.1311464	Haloferax sp. Atlit-12N	2077203	Archaea	Archaea	62	1.68e-8	NR	WP_115883272.1	2077203	g22409	i0	38.8	1.35344827586207	85	46	69.8	3	14	256	228	310	WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N]	diamond	471	62	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-12N
29015016	29015016	PRJNA940501_S_NODE_114808_length_229_cov_1.263441_g113990_i0	PRJNA940501	114808	229	1.263441	2.89327989	Methanobrevibacter sp.	66852	Archaea	Archaea	159	4.36e-44	NR	MDO5827839.1	66852	g113990	i0	100	2.98689956331878	76	0	99.6	0	1	228	7	82	MDO5827839.1 bifunctional N(6)-L-threonylcarbamoyladenine synthase/serine/threonine protein kinase [Methanobrevibacter sp.]	diamond	684	159	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29046437	29046437	PRJNA940501_S_NODE_5388_length_653_cov_3.552459_g4769_i0	PRJNA940501	5388	653	3.552459	23.19755727	Methanobacteriota archaeon	2026739	Archaea	Archaea	48.1	0.0114	NR	MBV23123.1	2026739	g4769	i0	33.3	0.385911179173047	84	45	38.6	3	11	262	224	296	MBV23123.1 hypothetical protein [Methanobacteriota archaeon]	diamond	252	48.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29046443	29046443	PRJNA940501_S_NODE_62108_length_270_cov_1.035242_g61290_i0	PRJNA940501	62108	270	1.035242	2.7951534	Methanobacterium sp.	2164	Archaea	Archaea	154	1.69e-44	NR	MCC7564358.1	2164	g61290	i0	90.6	0.944444444444444	85	8	94.4	0	256	2	124	208	MCC7564358.1 TatD family hydrolase [Methanobacterium sp.]	diamond	255	154	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
30063545	30063545	PRJNA940501_S_NODE_7631_length_532_cov_2.192229_g6887_i0	PRJNA940501	7631	532	2.192229	11.66265828	root	1	Root_unresolved	Root_unresolved	53.9	8.44e-5	NR	WP_405271529.1	66852	g6887	i0	27.8	8.28947368421053	151	87	85.2	4	515	63	262	390	WP_405271529.1 AMP-binding protein, partial [Methanobrevibacter sp.]	diamond	4410	53.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30783524	30783524	PRJNA940501_S_NODE_55914_length_277_cov_1.769231_g55096_i0	PRJNA940501	55914	277	1.769231	4.90076987	Methanobrevibacter sp.	66852	Archaea	Archaea	43.1	0.0396	NR	MBO7692507.1	66852	g55096	i0	59.5	0.8014440433213	37	13	40.1	1	230	120	228	262	MBO7692507.1 hypothetical protein [Methanobrevibacter sp.]	diamond	222	43.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30909982	30909982	PRJNA940501_S_NODE_100734_length_237_cov_2.592784_g99916_i0	PRJNA940501	100734	237	2.592784	6.14489808	Methanofollis sp.	2052835	Archaea	Archaea	42.7	0.0359	NR	MDK2974911.1	2052835	g99916	i0	30.6	0.784810126582278	62	36	69.6	2	40	204	483	544	MDK2974911.1 hypothetical protein [Methanofollis sp.]	diamond	186	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis sp.
31068057	31068057	PRJNA940501_S_NODE_5635_length_634_cov_4.622673_g4995_i0	PRJNA940501	5635	634	4.622673	29.30774682	Methanosarcinales archaeon	2250255	Archaea	Archaea	122	6.57e-29	NR	RYE84491.1	2250255	g4995	i0	55.4	2.69242902208202	112	47	51.6	1	27	353	124	235	RYE84491.1 MAG: hypothetical protein EOO65_02170 [Methanosarcinales archaeon]	diamond	1707	122	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31074766	31074766	PRJNA940501_S_NODE_111095_length_231_cov_1.489362_g110277_i0	PRJNA940501	111095	231	1.489362	3.44042622	root	1	Root_unresolved	Root_unresolved	47.4	7.5e-4	NR	MEM4728511.1	1906666	g110277	i0	46.5	3.22077922077922	43	22	55.8	1	59	187	168	209	MEM4728511.1 putative Ig domain-containing protein [Thermoplasmata archaeon]	diamond	744	47.8	0.99163179916318	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31668594	31668594	PRJNA940501_S_NODE_238377_length_182_cov_1.014388_g237559_i0	PRJNA940501	238377	182	1.014388	1.84618616	Methanobacterium sp. ACI-7	3240853	Archaea	Archaea	41.6	0.0413	NR	WP_414469478.1	3240853	g237559	i0	40.4	0.93956043956044	57	28	85.7	2	181	26	32	87	WP_414469478.1 radical SAM protein [Methanobacterium sp. ACI-7]	diamond	171	41.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. ACI-7
31858355	31858355	PRJNA940501_S_NODE_322217_length_163_cov_1.175000_g321399_i0	PRJNA940501	322217	163	1.175	1.91525	Methanosarcinales archaeon	2250255	Archaea	Archaea	100	6.839999999999999e-23	NR	RYE85578.1	2250255	g321399	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	46	99	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	162	100	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32016586	32016586	PRJNA940501_S_NODE_168218_length_204_cov_1.459627_g167400_i0	PRJNA940501	168218	204	1.459627	2.97763908	Methanobacteriota archaeon	2026739	Archaea	Archaea	89	1.16e-18	NR	MAD56215.1	2026739	g167400	i0	67.2	1.97058823529412	67	21	98.5	1	2	202	953	1018	MAD56215.1 hypothetical protein [Methanobacteriota archaeon]	diamond	402	89	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32428047	32428047	PRJNA940501_S_NODE_129499_length_221_cov_1.584270_g128681_i0	PRJNA940501	129499	221	1.58427	3.5012367	Methanoregula sp.	2052170	Archaea	Archaea	42	0.0331	NR	MDD1680356.1	2052170	g128681	i0	37.2	1.05882352941176	78	30	82.8	3	208	26	56	131	MDD1680356.1 hypothetical protein [Methanoregula sp.]	diamond	234	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
32523153	32523153	PRJNA940501_S_NODE_203339_length_192_cov_1.261745_g202521_i0	PRJNA940501	203339	192	1.261745	2.4225504	Methanobacteriota archaeon	2026739	Archaea	Archaea	89	3.53e-19	NR	MBT6072467.1	2026739	g202521	i0	60.9	2	64	25	100	0	192	1	47	110	MBT6072467.1 hypothetical protein [Methanobacteriota archaeon]	diamond	384	89	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota 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);;