metadata: contig_metadata: 24 rows where bioproject = "PRJEB14803" and tax

24 rows where bioproject = "PRJEB14803" 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
21450	21450	PRJEB14803_P_NODE_21341_length_248_cov_1.502347_g20875_i0	PRJEB14803	21341	248	1.502347	3.72582056	root	1	Root_unresolved	Root_unresolved	66.2	1.77e-10	NR	WP_377074857.1	926360	g20875	i0	45.8	5.37096774193548	72	37	85.9	2	248	36	107	177	WP_377074857.1 carotenoid oxygenase family protein, partial [Natronoarchaeum mannanilyticum]	diamond	1332	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natronoarchaeum	Natronoarchaeum mannanilyticum
21454	21454	PRJEB14803_P_NODE_22521_length_239_cov_1.470588_g22055_i0	PRJEB14803	22521	239	1.470588	3.51470532	Halobacterium hubeiense	1407499	Archaea	Archaea	54.7	0.006	NTclustered	gi\|966204314\|emb\|LN831302.1\|	1407499	g22055	i0	100	0.121338912133891	29	0	12	0	42	70	122258	122286	Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium hubeiense
1295694	1295694	PRJEB14803_P_NODE_36682_length_175_cov_1.121429_g36216_i0	PRJEB14803	36682	175	1.121429	1.96250075	Natronococcus zhouii	2951804	Archaea	Archaea	54.7	0.004	NTclustered	gi\|2259612910\|gb\|CP099391.1\|	2951804	g36216	i0	96.875	0.182857142857143	32	1	18	0	120	151	3793030	3793061	Natronococcus zhouii strain CG52 chromosome, complete genome	blastn	32	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus zhouii
5123808	5123808	PRJEB14803_P_NODE_20325_length_256_cov_1.968326_g19859_i0	PRJEB14803	20325	256	1.968326	5.03891456	Natronomonas marina	2961939	Archaea	Archaea	65.8	2.99e-6	NTclustered	gi\|2273574514\|gb\|CP101154.1\|	2961939	g19859	i0	93.182	0.390625	44	3	17	0	13	56	2308486	2308529	Natronomonas marina strain ZY43 chromosome, complete genome	blastn	100	65.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas marina
11499531	11499531	PRJEB14803_P_NODE_3810_length_724_cov_2.506531_g3450_i0	PRJEB14803	3810	724	2.506531	18.14728444	uncultured Methanoregulaceae archaeon	1392423	Archaea	Archaea	58.4	0.002	NTclustered	gi\|2874254037\|emb\|OY970361.1\|	1392423	g3450	i0	92.683	0.102209944751381	41	2	6	1	447	487	589713	589674	MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1	blastn	74	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		uncultured Methanoregulaceae archaeon
21698076	21698076	PRJEB14803_P_NODE_17278_length_285_cov_1.744000_g16812_i0	PRJEB14803	17278	285	1.744	4.9704	Halogeometricum borinquense	60847	Archaea	Archaea	52.8	0.026	NTclustered	gi\|1810666233\|gb\|CP048739.1\|	60847	g16812	i0	100	0.0982456140350877	28	0	10	0	48	75	1622897	1622924	Halogeometricum borinquense strain wsp4 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halogeometricum	Halogeometricum borinquense
21698112	21698112	PRJEB14803_P_NODE_23138_length_234_cov_3.261307_g22672_i0	PRJEB14803	23138	234	3.261307	7.63145838	Salinilacihabitans rarus	2961596	Archaea	Archaea	75	4.47e-9	NTclustered	gi\|2273363716\|gb\|CP100762.1\|	2961596	g22672	i0	95.652	14.9786324786325	46	2	20	0	16	61	2579002	2579047	Salinilacihabitans rarus strain AD-4 chromosome, complete genome	blastn	3505	75	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Salinilacihabitans	Salinilacihabitans rarus
24247279	24247279	PRJEB14803_P_NODE_28220_length_206_cov_1.280702_g27754_i0	PRJEB14803	28220	206	1.280702	2.63824612	Thermococcus profundus	49899	Archaea	Archaea	56.5	0.001	NTclustered	gi\|1214545799\|gb\|CP014862.1\|	49899	g27754	i0	89.362	0.228155339805825	47	1	22	3	98	142	838812	838856	Thermococcus profundus strain DT 5432, complete genome	blastn	47	56.5	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus profundus
26716154	26716154	PRJEB14803_P_NODE_44681_length_155_cov_1.650000_g44215_i0	PRJEB14803	44681	155	1.65	2.5575	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	51.6	8.28e-6	NR	HWR97478.1	2032688	g44215	i0	51	1.89677419354839	49	24	94.8	0	151	5	339	387	HWR97478.1 NAD-dependent malic enzyme [Candidatus Methanoperedens sp.]	diamond	294	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
27064668	27064668	PRJEB14803_P_NODE_21922_length_243_cov_2.418269_g21456_i0	PRJEB14803	21922	243	2.418269	5.87639367	Methanoculleus oceani	2184756	Archaea	Archaea	42.4	0.0493	NR	WP_250986302.1	2184756	g21456	i0	36.4	0.679012345679012	55	35	67.9	0	5	169	229	283	WP_250986302.1 cytosine permease [Methanoculleus oceani]	diamond	165	42.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus oceani
27190989	27190989	PRJEB14803_P_NODE_10742_length_389_cov_3.056497_g10277_i0	PRJEB14803	10742	389	3.056497	11.88977333	Halobellus rarus	1126237	Archaea	Archaea	49.3	7.72e-4	NR	WP_256419884.1	1126237	g10277	i0	40.5	0.609254498714653	79	46	60.2	1	102	335	214	292	WP_256419884.1 transcription initiation factor IIB [Halobellus rarus]	diamond	237	49.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus rarus
27879611	27879611	PRJEB14803_P_NODE_905_length_1421_cov_8.309524_g765_i0	PRJEB14803	905	1421	8.309524	118.07833604	root	1	Root_unresolved	Root_unresolved	374	3.1500000000000006e-123	NR	MDQ1255229.1	2026739	g765	i0	49.7	16.6678395496129	398	170	83	9	1396	218	8	380	MDQ1255229.1 hypothetical protein [Methanobacteriota archaeon]	diamond	23685	375	0.997333333333333	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28991374	28991374	PRJEB14803_P_NODE_21848_length_244_cov_1.531100_g21382_i0	PRJEB14803	21848	244	1.5311	3.735884	Methanobacteriota archaeon	2026739	Archaea	Archaea	95.5	5.209999999999999e-23	NR	RAH05560.1	2026739	g21382	i0	59.5	1.95491803278689	79	32	97.1	0	243	7	44	122	RAH05560.1 MAG: hypothetical protein CMA00_003965 [Methanobacteriota archaeon]	diamond	477	95.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29457979	29457979	PRJEB14803_P_NODE_22210_length_241_cov_2.058252_g21744_i0	PRJEB14803	22210	241	2.058252	4.96038732	root	1	Root_unresolved	Root_unresolved	41.6	0.0459	NR	WP_159902310.1	1198300	g21744	i0	31.2	1.70539419087137	77	50	92.1	1	236	15	32	108	WP_159902310.1 universal stress protein [Salinirussus salinus]	diamond	411	41.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Salinirussus	Salinirussus salinus
29906850	29906850	PRJEB14803_P_NODE_1211_length_1280_cov_8.338153_g1029_i0	PRJEB14803	1211	1280	8.338153	106.7283584	candidate division MSBL1 archaeon SCGC-AAA261O19	1698277	Archaea	Archaea	58.2	2.76e-5	NR	KXB04061.1	1698277	g1029	i0	35.9	0.4828125	103	65	24.1	1	531	839	89	190	KXB04061.1 hypothetical protein AKJ48_03430, partial [candidate division MSBL1 archaeon SCGC-AAA261O19]	diamond	618	58.2	1	Archaea	candidate division MSBL1	Methanobacteriati	Methanobacteriota					candidate division MSBL1 archaeon SCGC-AAA261O19
30127599	30127599	PRJEB14803_P_NODE_15412_length_307_cov_3.672794_g14946_i0	PRJEB14803	15412	307	3.672794	11.27547758	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	111	1.11e-26	NR	MBX7076500.1	2099680	g14946	i0	80.3	3.88925081433225	66	13	64.5	0	108	305	12	77	MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon]	diamond	1194	111	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
30791374	30791374	PRJEB14803_P_NODE_20334_length_256_cov_1.809955_g19868_i0	PRJEB14803	20334	256	1.809955	4.6334848	Methanobacteriota archaeon	2026739	Archaea	Archaea	57.8	2.27e-7	NR	MAB36253.1	2026739	g19868	i0	42.7	2.87109375	82	40	93.8	3	241	2	498	574	MAB36253.1 hypothetical protein [Methanobacteriota archaeon]	diamond	735	57.8	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31233579	31233579	PRJEB14803_P_NODE_27175_length_211_cov_1.346591_g26709_i0	PRJEB14803	27175	211	1.346591	2.84130701	Methanogenium sp.	2196	Archaea	Archaea	43.1	0.0129	NR	MFA5397836.1	2196	g26709	i0	37.5	1.50710900473934	48	30	68.2	0	209	66	91	138	MFA5397836.1 HAD domain-containing protein [Methanogenium sp.]	diamond	318	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium sp.
31613315	31613315	PRJEB14803_P_NODE_24336_length_227_cov_1.416667_g23870_i0	PRJEB14803	24336	227	1.416667	3.21583409	Methanobacteriota archaeon	2026739	Archaea	Archaea	44.7	0.00513	NR	HEQ78652.1	2026739	g23870	i0	32.2	1.14977973568282	87	46	99.1	3	3	227	13	98	HEQ78652.1 hydrogenase accessory protein HypB [Methanobacteriota archaeon]	diamond	261	44.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31613338	31613338	PRJEB14803_P_NODE_37856_length_171_cov_1.470588_g37390_i0	PRJEB14803	37856	171	1.470588	2.51470548	Methanomethylophilus sp.	2774294	Archaea	Archaea	39.7	0.0424	NR	MBO4502158.1	2774294	g37390	i0	44.2	0.912280701754386	52	29	91.2	0	11	166	8	59	MBO4502158.1 50S ribosomal protein P1 [Methanomethylophilus sp.]	diamond	156	39.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus sp.
31613361	31613361	PRJEB14803_P_NODE_8416_length_455_cov_2.264286_g7956_i0	PRJEB14803	8416	455	2.264286	10.3025013	Halospeciosus flavus	3032283	Archaea	Archaea	45.8	0.0242	NR	WP_382218444.1	3032283	g7956	i0	30.9	2.67032967032967	81	56	53.4	0	267	25	292	372	WP_382218444.1 PQQ-binding-like beta-propeller repeat protein [Halospeciosus flavus]	diamond	1215	45.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halospeciosus	Halospeciosus flavus
31866176	31866176	PRJEB14803_P_NODE_18577_length_272_cov_1.556962_g18111_i0	PRJEB14803	18577	272	1.556962	4.23493664	Halosegnis rubeus	2212850	Archaea	Archaea	53.9	6.34e-6	NR	WP_152120952.1	2212850	g18111	i0	36.6	4.19117647058824	71	44	77.2	1	218	9	654	724	WP_152120952.1 PAS domain S-box protein [Halosegnis rubeus]	diamond	1140	53.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halosegnis	Halosegnis rubeus
32271432	32271432	PRJEB14803_P_NODE_10638_length_392_cov_1.380952_g10173_i0	PRJEB14803	10638	392	1.380952	5.41333184	root	1	Root_unresolved	Root_unresolved	62.4	2.73e-8	NR	MBR1611664.1	66852	g10173	i0	35.8	5.46428571428571	123	67	94.1	3	14	382	482	592	MBR1611664.1 hypothetical protein [Methanobrevibacter sp.]	diamond	2142	62.8	0.993630573248408	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32271448	32271448	PRJEB14803_P_NODE_40218_length_165_cov_1.230769_g39752_i0	PRJEB14803	40218	165	1.230769	2.03076885	Methanobacteriota	28890	Archaea	Archaea	60.8	5.37e-9	NR	WP_297125773.1	35749	g39752	i0	62.8	3.2	43	16	78.2	0	28	156	92	134	WP_297125773.1 alpha-mannosidase [Thermococcus sp.]	diamond	528	61.2	0.993464052287582	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus 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);;