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

31 rows where bioproject = "PRJNA494251" 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
1106784	1106784	PRJNA494251_P_NODE_37581_length_251_cov_0.865169_g37267_i0	PRJNA494251	37581	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	73.2	9.55e-14	NR	HKZ62992.1	1906666	g37267	i0	64.3	2.71314741035857	56	20	66.9	0	2	169	19	74	HKZ62992.1 DUF5655 domain-containing protein [Thermoplasmata archaeon]	diamond	681	73.2	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
6210350	6210350	PRJNA494251_P_NODE_49265_length_241_cov_0.916667_g48951_i0	PRJNA494251	49265	241	0.916667	2.20916747	Methanomicrobiales	2191	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2006650972\|gb\|CP036172.1\|	126734	g48951	i0	100	0.37344398340249	30	0	12	0	160	189	59530	59559	Methanofollis aquaemaris strain N2F9704 chromosome, complete genome	blastn	90	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis aquaemaris
8128447	8128447	PRJNA494251_P_NODE_38187_length_250_cov_0.870056_g37873_i0	PRJNA494251	38187	250	0.870056	2.17514	Natronomonas salina	1710540	Archaea	Archaea	52.8	0.023	NTclustered	gi\|1865519430\|gb\|CP058335.1\|	1710540	g37873	i0	94.118	0.136	34	2	14	0	98	131	739519	739486	Natronomonas salina strain YPL13 chromosome, complete genome	blastn	34	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas salina
9403423	9403423	PRJNA494251_P_NODE_40328_length_248_cov_1.320000_g40014_i0	PRJNA494251	40328	248	1.32	3.2736	Haloglomus halophilum	2962672	Archaea	Archaea	62.1	3.73e-5	NTclustered	gi\|2273560679\|gb\|CP101166.1\|	2962672	g40014	i0	89.583	0.193548387096774	48	5	19	0	125	172	614724	614771	Haloglomus halophilum strain ZY41 chromosome, complete genome	blastn	48	62.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Haloglomus	Haloglomus halophilum
11954180	11954180	PRJNA494251_P_NODE_39630_length_249_cov_0.875000_g39316_i0	PRJNA494251	39630	249	0.875	2.17875	Natrinema pallidum	69527	Archaea	Archaea	56.5	0.002	NTclustered	gi\|1674549330\|gb\|CP040637.1\|	69527	g39316	i0	100	0.240963855421687	30	0	12	0	29	58	813772	813743	Natrinema pallidum strain BOL6-1 chromosome, complete genome	blastn	60	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema pallidum
15778069	15778069	PRJNA494251_P_NODE_40773_length_248_cov_0.880000_g40459_i0	PRJNA494251	40773	248	0.88	2.1824	uncultured marine group II/III euryarchaeote KM3_110_C01	1457851	Archaea	Archaea	52.8	0.022	NTclustered	gi\|663508794\|gb\|KF900564.1\|	1457851	g40459	i0	100	0.112903225806452	28	0	11	0	57	84	34025	33998	Uncultured marine group II/III euryarchaeote KM3_110_C01 genomic sequence	blastn	28	52.8	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured marine group II/III euryarchaeote KM3_110_C01
17052531	17052531	PRJNA494251_P_NODE_20194_length_316_cov_1.522634_g19880_i0	PRJNA494251	20194	316	1.522634	4.81152344	Halospeciosus flavus	3032283	Archaea	Archaea	54.7	0.008	NTclustered	gi\|2490484842\|gb\|CP122312.1\|	3032283	g19880	i0	100	0.0917721518987342	29	0	9	0	65	93	3051262	3051234	Halospeciosus flavus strain XZGYJ-43 chromosome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halospeciosus	Halospeciosus flavus
19601076	19601076	PRJNA494251_P_NODE_18736_length_326_cov_1.739130_g18422_i0	PRJNA494251	18736	326	1.73913	5.6695638	Natronococcus wangiae	3068275	Archaea	Archaea	58.4	6.59e-4	NTclustered	gi\|2563036162\|gb\|CP132294.1\|	3068275	g18422	i0	92.5	0.331288343558282	40	3	12	0	258	297	4001600	4001561	Natronococcus wangiae strain AD-5 chromosome, complete genome	blastn	108	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus wangiae
19601568	19601568	PRJNA494251_S_NODE_856_length_200_cov_4.881890_g841_i0	PRJNA494251	856	200	4.88189	9.76378	Thermoplasmatales archaeon	2268204	Archaea	Archaea	63.9	8.03e-6	NTclustered	gi\|2573961727\|gb\|CP133596.1\|	2268204	g841	i0	97.297	0.335	37	1	19	0	146	182	518158	518122	MAG: Thermoplasmatales archaeon isolate BR_05 chromosome, complete genome	blastn	67	63.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
24701336	24701336	PRJNA494251_P_NODE_34120_length_258_cov_2.529730_g33806_i0	PRJNA494251	34120	258	2.52973	6.5267034	Thermococcus indicus	2586643	Archaea	Archaea	52.8	0.023	NTclustered	gi\|1681065834\|gb\|CP040846.1\|	2586643	g33806	i0	100	0.108527131782946	28	0	11	0	18	45	2100561	2100534	Thermococcus indicus strain IOH1 chromosome, complete genome	blastn	28	52.8	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus indicus
24701412	24701412	PRJNA494251_P_NODE_40540_length_248_cov_0.880000_g40226_i0	PRJNA494251	40540	248	0.88	2.1824	halophilic archaeon DL31	756883	Archaea	Archaea	52.8	0.022	NTclustered	gi\|344319636\|gb\|CP002988.1\|	756883	g40226	i0	100	0.225806451612903	28	0	11	0	185	212	171503	171476	Halophilic archaeon DL31 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			halophilic archaeon DL31
26649174	26649174	PRJNA494251_P_NODE_5161_length_561_cov_1.262295_g4867_i0	PRJNA494251	5161	561	1.262295	7.08147495	Methanoregula	395331	Archaea	Archaea	79.7	1.73e-14	NR	HSQ94182.1	2052170	g4867	i0	26.2	9.77540106951872	191	129	99.5	4	3	560	47	230	HSQ94182.1 aquaporin Z [Methanoregula sp.]	diamond	5484	80.1	0.995006242197254	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
26776180	26776180	PRJNA494251_P_NODE_34741_length_257_cov_1.103261_g34427_i0	PRJNA494251	34741	257	1.103261	2.83538077	Stenosarchaea group	2290931	Archaea	Archaea	48.1	5.14e-4	NR	WP_199233658.1	1537267	g34427	i0	31.2	6.18677042801556	77	53	89.9	0	10	240	29	105	WP_199233658.1 NAD-dependent epimerase/dehydratase family protein, partial [Halorubrum sp. SP9]	diamond	1590	48.5	0.991752577319588	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. SP9
26887322	26887322	PRJNA494251_P_NODE_7721_length_471_cov_1.298995_g7418_i0	PRJNA494251	7721	471	1.298995	6.11826645	Methanosarcinales archaeon	2250255	Archaea	Archaea	51.6	2.4e-4	NR	RYE84638.1	2250255	g7418	i0	38	0.452229299363057	71	41	45.2	1	259	471	75	142	RYE84638.1 MAG: hypothetical protein EOO65_01930 [Methanosarcinales archaeon]	diamond	213	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
27772092	27772092	PRJNA494251_P_NODE_43844_length_245_cov_1.755814_g43530_i0	PRJNA494251	43844	245	1.755814	4.3017443	Methanobacteriota archaeon	2026739	Archaea	Archaea	68.9	1.64e-11	NR	RYF00025.1	2026739	g43530	i0	40	0.857142857142857	70	42	85.7	0	1	210	102	171	RYF00025.1 MAG: hypothetical protein EOO41_00120 [Methanobacteriota archaeon]	diamond	210	68.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28024578	28024578	PRJNA494251_P_NODE_41085_length_248_cov_0.880000_g40771_i0	PRJNA494251	41085	248	0.88	2.1824	Thermoplasmata archaeon	1906666	Archaea	Archaea	78.6	1.46e-15	NR	MEM4779004.1	1906666	g40771	i0	47.4	5.6491935483871	78	41	94.4	0	15	248	55	132	MEM4779004.1 ATP-binding cassette domain-containing protein [Thermoplasmata archaeon]	diamond	1401	78.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28308718	28308718	PRJNA494251_P_NODE_2926_length_716_cov_2.259720_g2657_i0	PRJNA494251	2926	716	2.25972	16.1795952	Methanosphaera sp.	2666342	Archaea	Archaea	57.8	1.32e-5	NR	MEE3325473.1	2666342	g2657	i0	25.4	1.88128491620112	244	128	96.8	13	697	5	100	302	MEE3325473.1 hypothetical protein [Methanosphaera sp.]	diamond	1347	57.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp.
28656039	28656039	PRJNA494251_P_NODE_24347_length_294_cov_1.361991_g24033_i0	PRJNA494251	24347	294	1.361991	4.00425354	Methanobrevibacter sp.	66852	Archaea	Archaea	102	2.41e-25	NR	MEE3444538.1	66852	g24033	i0	52.6	0.989795918367347	97	46	99	0	3	293	5	101	MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.]	diamond	291	102	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28797630	28797630	PRJNA494251_P_NODE_36127_length_253_cov_1.122222_g35813_i0	PRJNA494251	36127	253	1.122222	2.83922166	Archaea	2157	Archaea	Archaea	82.4	7.57e-18	NR	RZP10485.1	2163009	g35813	i0	47.5	2.83399209486166	80	40	94.9	1	252	13	56	133	RZP10485.1 MAG: PaaI family thioesterase, partial [Candidatus Poseidoniales archaeon]	diamond	717	82.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
29871425	29871425	PRJNA494251_P_NODE_39211_length_249_cov_0.875000_g38897_i0	PRJNA494251	39211	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	45.1	0.0063	NR	AIF23262.1	1456558	g38897	i0	32.4	5.49397590361446	71	45	85.5	1	214	2	2027	2094	AIF23262.1 RCC1 domain-containing protein [uncultured marine group II/III euryarchaeote SAT1000_14_B08]	diamond	1368	45.1	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured marine group II/III euryarchaeote SAT1000_14_B08
30108447	30108447	PRJNA494251_P_NODE_16032_length_348_cov_1.116364_g15719_i0	PRJNA494251	16032	348	1.116364	3.88494672	Candidatus Sysuiplasma superficiale	2823368	Archaea	Archaea	54.7	8.23e-6	NR	MBX8643924.1	2823368	g15719	i0	36.7	0.844827586206897	98	56	83.6	3	304	14	490	582	MBX8643924.1 AAA family ATPase [Candidatus Sysuiplasma superficiale]	diamond	294	54.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Sysuiplasmatales	Candidatus Sysuiplasmataceae	Candidatus Sysuiplasma	Candidatus Sysuiplasma superficiale
30171598	30171598	PRJNA494251_P_NODE_13072_length_378_cov_1.262295_g12764_i0	PRJNA494251	13072	378	1.262295	4.7714751	Methanobacteriota archaeon	2026739	Archaea	Archaea	156	2.96e-41	NR	MAD56215.1	2026739	g12764	i0	61.6	0.992063492063492	125	48	99.2	0	2	376	912	1036	MAD56215.1 hypothetical protein [Methanobacteriota archaeon]	diamond	375	156	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30393352	30393352	PRJNA494251_P_NODE_4233_length_612_cov_4.812616_g3943_i0	PRJNA494251	4233	612	4.812616	29.45320992	Haloplanus salinus	1126245	Archaea	Archaea	84.7	2.01e-16	NR	WP_114450628.1	1126245	g3943	i0	32.6	2.07843137254902	138	88	67.6	1	14	427	48	180	WP_114450628.1 DUF4397 domain-containing protein [Haloplanus salinus]	diamond	1272	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus salinus
30645432	30645432	PRJNA494251_P_NODE_31473_length_267_cov_1.231959_g31159_i0	PRJNA494251	31473	267	1.231959	3.28933053	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	80.1	7.83e-16	NR	HII50895.1	2666346	g31159	i0	53.7	3.01123595505618	67	31	75.3	0	216	16	3	69	HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	804	80.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
30835175	30835175	PRJNA494251_P_NODE_2914_length_717_cov_1.739130_g2645_i0	PRJNA494251	2914	717	1.73913	12.4695621	Haladaptatus caseinilyticus	2993314	Archaea	Archaea	79.7	4.29e-13	NR	WP_266077698.1	2993314	g2645	i0	30.4	1.88284518828452	148	99	60.7	3	22	456	123	269	WP_266077698.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus]	diamond	1350	79.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus caseinilyticus
30929989	30929989	PRJNA494251_P_NODE_10474_length_415_cov_1.798246_g10168_i0	PRJNA494251	10474	415	1.798246	7.4627209	Haloarculaceae archaeon	2497615	Archaea	Archaea	45.4	0.0167	NR	MEF8842997.1	2497615	g10168	i0	40	0.650602409638554	90	46	60.7	3	19	270	60	147	MEF8842997.1 MBL fold metallo-hydrolase [Haloarculaceae archaeon]	diamond	270	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae		Haloarculaceae archaeon
31229777	31229777	PRJNA494251_P_NODE_5415_length_549_cov_3.508403_g5120_i0	PRJNA494251	5415	549	3.508403	19.26113247	Archaea	2157	Archaea	Archaea	49.3	3.64e-4	NR	HID25561.1	1906666	g5120	i0	49	1.51366120218579	51	26	27.9	0	37	189	4	54	HID25561.1 50S ribosomal protein P1 [Thermoplasmata archaeon]	diamond	831	49.3	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31340879	31340879	PRJNA494251_P_NODE_17636_length_334_cov_1.750958_g17322_i0	PRJNA494251	17636	334	1.750958	5.84819972	Methanobacteriota archaeon	2026739	Archaea	Archaea	90.1	1.5e-19	NR	RMG30150.1	2026739	g17322	i0	45.9	1.77844311377246	98	53	88	0	299	6	7	104	RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon]	diamond	594	90.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31546421	31546421	PRJNA494251_P_NODE_20136_length_316_cov_2.432099_g19822_i0	PRJNA494251	20136	316	2.432099	7.68543284	Methanomicrobiales	2191	Archaea	Archaea	60.5	4.82e-8	NR	WP_318622147.1	394967	g19822	i0	39.4	3.9493670886076	104	52	98.7	3	314	3	33	125	WP_318622147.1 peptide chain release factor aRF-1 [Methanoculleus receptaculi]	diamond	1248	60.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus receptaculi
31641041	31641041	PRJNA494251_P_NODE_37256_length_251_cov_0.865169_g36942_i0	PRJNA494251	37256	251	0.865169	2.17157419	Methanobacteriati	3366610	Archaea	Archaea	48.9	2.68e-4	NR	MAY05171.1	2026739	g36942	i0	51.4	0.884462151394422	37	18	44.2	0	249	139	176	212	MAY05171.1 hypothetical protein [Methanobacteriota archaeon]	diamond	222	49.3	0.991886409736308	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32068341	32068341	PRJNA494251_P_NODE_43258_length_246_cov_0.890173_g42944_i0	PRJNA494251	43258	246	0.890173	2.18982558	Methanobacteriota archaeon	2026739	Archaea	Archaea	80.5	1.93e-15	NR	RMG40079.1	2026739	g42944	i0	50	0.951219512195122	78	34	95.1	1	239	6	445	517	RMG40079.1 MAG: S9 family peptidase [Methanobacteriota archaeon]	diamond	234	80.5	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);;