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

32 rows where bioproject = "PRJEB75230" 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
3962206	3962206	PRJEB75230_P_NODE_127244_length_250_cov_0.870056_g127062_i0	PRJEB75230	127244	250	0.870056	2.17514	Methanococcus maripaludis	39152	Archaea	Archaea	52.8	0.023	NTclustered	gi\|132662671\|gb\|CP000609.1\|	402880	g127062	i0	100	0.224	28	0	11	0	188	215	481881	481908	Methanococcus maripaludis C5, complete genome	blastn	56	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanococcaceae	Methanococcus	Methanococcus maripaludis
3962828	3962828	PRJEB75230_P_NODE_173624_length_242_cov_0.911243_g173442_i0	PRJEB75230	173624	242	0.911243	2.20520806	Natronomonas moolapensis	416273	Archaea	Archaea	99	2.76e-16	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g173442	i0	84.314	0.421487603305785	102	14	42	2	141	241	1335935	1335835	Natronomonas moolapensis 8.8.11 complete genome	blastn	102	99	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
4824204	4824204	PRJEB75230_P_NODE_49124_length_313_cov_1.604167_g48942_i0	PRJEB75230	49124	313	1.604167	5.02104271	root	1	Root_unresolved	Root_unresolved	87.9	8.03e-13	NTclustered	gi\|2388587735\|gb\|CP113361.1\|	2199	g48942	i0	88.732	1.23003194888179	71	8	23	0	194	264	1189421	1189351	Methanogenium organophilum strain DSM 3596 chromosome, complete genome	blastn	385	87.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium organophilum
5238402	5238402	PRJEB75230_P_NODE_112245_length_254_cov_1.977901_g112063_i0	PRJEB75230	112245	254	1.977901	5.02386854	Methanococcus voltae	2188	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2891705001\|gb\|CP178160.1\|	523842	g112063	i0	100	0.114173228346457	29	0	11	0	129	157	475071	475099	Methanococcus voltae PS chromosome, complete genome	blastn	29	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanococcaceae	Methanococcus	Methanococcus voltae
13749554	13749554	PRJEB75230_P_NODE_46511_length_317_cov_1.299180_g46329_i0	PRJEB75230	46511	317	1.29918	4.1184006	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2324023557\|gb\|CP109979.1\|	2934937	g46329	i0	100	1.12618296529968	30	0	9	0	288	317	1129155	1129184	Halocatena marina strain QDMS1 chromosome, complete genome	blastn	357	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halocatena	Halocatena marina
17988837	17988837	PRJEB75230_P_NODE_47275_length_316_cov_1.267490_g47093_i0	PRJEB75230	47275	316	1.26749	4.0052684	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	52.8	0.03	NTclustered	gi\|2874253877\|emb\|OY969932.1\|	176233	g47093	i0	100	0.0886075949367089	28	0	9	0	93	120	1240580	1240553	MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
19262459	19262459	PRJEB75230_P_NODE_23856_length_369_cov_1.040541_g23674_i0	PRJEB75230	23856	369	1.040541	3.83959629	Halococcus dombrowskii	179637	Archaea	Archaea	571	2.1799999999999993e-158	NTclustered	gi\|2221492933\|gb\|CP095007.1\|	179637	g23674	i0	94.595	148.49864498645	370	19	100	1	1	369	129959	129590	Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence	blastn	54796	571	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
19263420	19263420	PRJEB75230_P_NODE_86536_length_274_cov_1.472637_g86354_i0	PRJEB75230	86536	274	1.472637	4.03502538	Halobium salinum	1364940	Archaea	Archaea	144	5.95e-41	NR	WP_267624594.1	1364940	g86354	i0	72.2	2.95620437956204	90	25	98.5	0	272	3	54	143	WP_267624594.1 beta-ketoacyl-ACP reductase [Halobium salinum]	diamond	810	144	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobium	Halobium salinum
20537466	20537466	PRJEB75230_P_NODE_162437_length_244_cov_0.900585_g162255_i0	PRJEB75230	162437	244	0.900585	2.1974274	Methanosarcina barkeri	2208	Archaea	Archaea	52.8	0.022	NTclustered	gi\|805403216\|gb\|CP009528.1\|	1434108	g162255	i0	94.286	0.14344262295082	35	1	14	1	195	228	1624588	1624622	Methanosarcina barkeri MS, complete genome	blastn	35	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
24363171	24363171	PRJEB75230_P_NODE_49860_length_312_cov_1.610879_g49678_i0	PRJEB75230	49860	312	1.610879	5.02594248	Methanobrevibacter arboriphilus	39441	Archaea	Archaea	54.7	0.008	NTclustered	gi\|2047640843\|dbj\|AP019779.1\|	39441	g49678	i0	94.286	0.112179487179487	35	2	11	0	3	37	1418270	1418304	Methanobrevibacter arboriphilus SA DNA, complete genome	blastn	35	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter arboriphilus
26646840	26646840	PRJEB75230_P_NODE_14741_length_417_cov_1.139535_g14559_i0	PRJEB75230	14741	417	1.139535	4.75186095	root	1	Root_unresolved	Root_unresolved	55.1	1.27e-5	NR	WP_394697838.1	183759	g14559	i0	29.1	3.62589928057554	134	86	95	4	21	416	451	577	WP_394697838.1 choice-of-anchor L domain-containing protein [uncultured Methanomethylovorans sp.]	diamond	1512	55.5	0.992792792792793	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	uncultured Methanomethylovorans sp.
26812724	26812724	PRJEB75230_P_NODE_118901_length_251_cov_0.865169_g118719_i0	PRJEB75230	118901	251	0.865169	2.17157419	Halococcus sp.	29286	Archaea	Archaea	132	9.01e-34	NR	HET7322943.1	29286	g118719	i0	75.9	0.99203187250996006	83	20	99.2	0	249	1	133	215	HET7322943.1 hypothetical protein [Halococcus sp.]	diamond	249	132	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp.
26907645	26907645	PRJEB75230_P_NODE_40402_length_327_cov_1.212598_g40220_i0	PRJEB75230	40402	327	1.212598	3.96519546	Halocatena salina	2934340	Archaea	Archaea	44.3	0.0275	NR	WP_247995243.1	2934340	g40220	i0	40.9	0.403669724770642	44	26	40.4	0	310	179	334	377	WP_247995243.1 molybdopterin oxidoreductase family protein [Halocatena salina]	diamond	132	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halocatena	Halocatena salina
27058586	27058586	PRJEB75230_P_NODE_133102_length_249_cov_0.875000_g132920_i0	PRJEB75230	133102	249	0.875	2.17875	Halococcus	2249	Archaea	Archaea	105	2.49e-24	NR	WP_010612085.1	332168	g132920	i0	63.2	2.09638554216867	87	28	100	1	249	1	318	404	WP_010612085.1 hypothetical protein [Halococcus hamelinensis]	diamond	522	105	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus hamelinensis
27090245	27090245	PRJEB75230_P_NODE_31842_length_345_cov_0.849265_g31660_i0	PRJEB75230	31842	345	0.849265	2.92996425	root	1	Root_unresolved	Root_unresolved	48.5	9.06e-4	NR	MDB2320089.1	2163009	g31660	i0	35.9	2.39130434782609	92	49	80	3	301	26	110	191	MDB2320089.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	825	48.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
28329037	28329037	PRJEB75230_P_NODE_28926_length_352_cov_1.200717_g28744_i0	PRJEB75230	28926	352	1.200717	4.22652384	Halobacterium hubeiense	1407499	Archaea	Archaea	46.2	0.00774	NR	WP_059056282.1	1407499	g28744	i0	40.7	0.732954545454545	86	46	69.9	2	95	340	296	380	WP_059056282.1 beta-glucosidase [Halobacterium hubeiense]	diamond	258	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium hubeiense
28543116	28543116	PRJEB75230_P_NODE_68247_length_290_cov_1.566820_g68065_i0	PRJEB75230	68247	290	1.56682	4.543778	root	1	Root_unresolved	Root_unresolved	60.5	3.75e-8	NR	MEN6343108.1	45200	g68065	i0	48.3	1.41724137931034	58	21	50.7	1	260	114	208	265	MEN6343108.1 PKD domain-containing protein [Methanospirillum sp.]	diamond	411	60.8	0.995065789473684	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum sp.
28771107	28771107	PRJEB75230_P_NODE_170667_length_243_cov_0.905882_g170485_i0	PRJEB75230	170667	243	0.905882	2.20129326	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	150	5.71e-40	NR	MDZ7849557.1	1980530	g170485	i0	88.8	2.96296296296296	80	9	98.8	0	3	242	70	149	MDZ7849557.1 dihydropteroate synthase [Halodesulfurarchaeum sp.]	diamond	720	150	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum sp.
29654818	29654818	PRJEB75230_P_NODE_167830_length_243_cov_0.905882_g167648_i0	PRJEB75230	167830	243	0.905882	2.20129326	Natrinema sp. DC36	2878680	Archaea	Archaea	90.5	1.02e-19	NR	WP_226041227.1	2878680	g167648	i0	51.3	0.938271604938272	76	37	93.8	0	242	15	159	234	WP_226041227.1 hypothetical protein [Natrinema sp. DC36]	diamond	228	90.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. DC36
30097287	30097287	PRJEB75230_P_NODE_157432_length_245_cov_0.895349_g157250_i0	PRJEB75230	157432	245	0.895349	2.19360505	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.1	0.0286	NR	MEM4257999.1	2806419	g157250	i0	38.9	0.661224489795918	54	30	66.1	1	10	171	603	653	MEM4257999.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	162	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30413635	30413635	PRJEB75230_P_NODE_139773_length_248_cov_0.880000_g139591_i0	PRJEB75230	139773	248	0.88	2.1824	Haloferacaceae archaeon	2080321	Archaea	Archaea	43.9	0.0128	NR	MFB6154786.1	2080321	g139591	i0	47.5	0.967741935483871	40	21	48.4	0	3	122	139	178	MFB6154786.1 aldo/keto reductase [Haloferacaceae archaeon]	diamond	240	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae		Haloferacaceae archaeon
30666067	30666067	PRJEB75230_P_NODE_66633_length_292_cov_1.328767_g66451_i0	PRJEB75230	66633	292	1.328767	3.87999964	Thermoplasmata archaeon	1906666	Archaea	Archaea	48.9	4.62e-4	NR	UCH88004.1	1906666	g66451	i0	42	0.832191780821918	81	31	68.8	3	88	288	262	340	UCH88004.1 MAG: PQQ-binding-like beta-propeller repeat protein [Thermoplasmata archaeon]	diamond	243	48.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31290727	31290727	PRJEB75230_P_NODE_118355_length_251_cov_0.865169_g118173_i0	PRJEB75230	118355	251	0.865169	2.17157419	Halococcus	2249	Archaea	Archaea	99.8	1.43e-24	NR	WP_004055893.1	2250	g118173	i0	64	2.04382470119522	86	24	98	3	2	247	37	119	WP_004055893.1 multiprotein-bridging factor 1 family protein [Halococcus morrhuae]	diamond	513	100	0.998	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus morrhuae
31290730	31290730	PRJEB75230_P_NODE_21395_length_378_cov_1.681967_g21213_i0	PRJEB75230	21395	378	1.681967	6.35783526	Methanomicrobia	224756	Archaea	Archaea	49.7	6.08e-4	NR	MCX6685123.1	2052170	g21213	i0	36.2	1.42063492063492	58	35	44.4	1	209	376	14	71	MCX6685123.1 MEDS domain-containing protein [Methanoregula sp.]	diamond	537	50.1	0.992015968063872	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
31456375	31456375	PRJEB75230_P_NODE_16996_length_401_cov_1.121951_g16814_i0	PRJEB75230	16996	401	1.121951	4.49902351	Candidatus Hadarchaeota archaeon	3097284	Archaea	Archaea	44.7	0.0413	NR	MEW6592824.1	3097284	g16814	i0	30.6	0.807980049875312	108	68	78.6	3	15	329	406	509	MEW6592824.1 methionine--tRNA ligase [Candidatus Hadarchaeota archaeon]	diamond	324	44.7	1	Archaea		Methanobacteriati	Candidatus Hadarchaeota					Candidatus Hadarchaeota archaeon
31645924	31645924	PRJEB75230_P_NODE_90497_length_271_cov_1.166667_g90315_i0	PRJEB75230	90497	271	1.166667	3.16166757	Halomarina halobia	3033386	Archaea	Archaea	43.9	0.0204	NR	WP_276306821.1	3033386	g90315	i0	36.2	0.763837638376384	69	43	75.3	1	241	38	293	361	WP_276306821.1 class I adenylate-forming enzyme family protein [Halomarina halobia]	diamond	207	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina halobia
31804075	31804075	PRJEB75230_P_NODE_62817_length_296_cov_1.381166_g62635_i0	PRJEB75230	62817	296	1.381166	4.08825136	Candidatus Hydrothermarchaeaceae archaeon	3107143	Archaea	Archaea	43.9	0.0177	NR	MEE8401213.1	3107143	g62635	i0	35.2	0.719594594594595	71	43	69.9	2	262	56	99	168	MEE8401213.1 class I SAM-dependent methyltransferase [Candidatus Hydrothermarchaeaceae archaeon]	diamond	213	43.9	1	Archaea		Methanobacteriati	Candidatus Hydrothermarchaeota	Candidatus Hydrothermarchaeia	Candidatus Hydrothermarchaeales	Candidatus Hydrothermarchaeaceae		Candidatus Hydrothermarchaeaceae archaeon
31899134	31899134	PRJEB75230_P_NODE_157117_length_245_cov_0.895349_g156935_i0	PRJEB75230	157117	245	0.895349	2.19360505	Halococcus salifodinae	36738	Archaea	Archaea	108	1.26e-25	NR	WP_049909851.1	36738	g156935	i0	65.4	1.98367346938776	81	28	99.2	0	2	244	77	157	WP_049909851.1 hypothetical protein [Halococcus salifodinae]	diamond	486	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus salifodinae
32025734	32025734	PRJEB75230_P_NODE_49578_length_313_cov_0.962500_g49396_i0	PRJEB75230	49578	313	0.9625	3.012625	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	43.5	0.0307	NR	MDC0655692.1	2666346	g49396	i0	39.3	0.536741214057508	56	34	53.7	0	92	259	34	89	MDC0655692.1 hypothetical protein [Candidatus Poseidoniaceae archaeon]	diamond	168	43.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
32342319	32342319	PRJEB75230_P_NODE_5199_length_606_cov_1.917448_g5018_i0	PRJEB75230	5199	606	1.917448	11.61973488	ANME-2 cluster archaeon	2056317	Archaea	Archaea	84	2.19e-16	NR	MCL7413678.1	2056317	g5018	i0	43	0.52970297029703	107	54	50.5	4	592	287	8	112	MCL7413678.1 hypothetical protein [ANME-2 cluster archaeon]	diamond	321	84	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			ANME-2 cluster archaeon
32429831	32429831	PRJEB75230_P_NODE_180179_length_241_cov_0.916667_g179997_i0	PRJEB75230	180179	241	0.916667	2.20916747	Methanobacteriati	3366610	Archaea	Archaea	43.5	0.0191	NR	MBR79650.1	2026739	g179997	i0	39.2	1.84232365145228	74	44	90.9	1	9	227	158	231	MBR79650.1 hypothetical protein [Methanobacteriota archaeon]	diamond	444	43.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32437282	32437282	PRJEB75230_P_NODE_22039_length_376_cov_1.000000_g21857_i0	PRJEB75230	22039	376	1	3.76	Methanomicrobiales archaeon	2184052	Archaea	Archaea	48.1	0.00142	NR	NLV28328.1	2184052	g21857	i0	36.6	0.566489361702128	71	38	52.7	2	355	158	23	91	NLV28328.1 hypothetical protein [Methanomicrobiales archaeon]	diamond	213	48.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales 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);;