metadata: contig_metadata: 16 rows where bioproject = "PRJNA1035005" and tax

16 rows where bioproject = "PRJNA1035005" and tax_clade = "Stenosarchaea 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
1443875	1443875	PRJNA1035005_P_NODE_84202_length_242_cov_1.757396_g83796_i0	PRJNA1035005	84202	242	1.757396	4.25289832	Natronomonas moolapensis	416273	Archaea	Archaea	195	3.42e-45	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g83796	i0	81.624	1.89669421487603	234	43	97	0	9	242	470106	469873	Natronomonas moolapensis 8.8.11 complete genome	blastn	459	195	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
5271814	5271814	PRJNA1035005_P_NODE_57805_length_252_cov_0.871508_g57399_i0	PRJNA1035005	57805	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	79.7	3.19e-15	NR	MCX9085574.1	2032688	g57399	i0	48.2	9.77380952380952	83	42	98.8	1	249	1	215	296	MCX9085574.1 DEAD/DEAH box helicase [Candidatus Methanoperedens sp.]	diamond	2463	79.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
9936056	9936056	PRJNA1035005_P_NODE_7068_length_408_cov_3.495522_g6666_i0	PRJNA1035005	7068	408	3.495522	14.26172976	Halalkalicoccus	332246	Archaea	Archaea	747	0	NTclustered	gi\|254971262\|ref\|NR_028180.1\|	175632	g6666	i0	99.754	104.18137254902	407	1	99	0	2	408	1451	1045	Halalkalicoccus tibetensis strain DS12 16S ribosomal RNA, complete sequence	blastn	42506	747	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus tibetensis
12486685	12486685	PRJNA1035005_P_NODE_32970_length_278_cov_6.082927_g32564_i0	PRJNA1035005	32970	278	6.082927	16.91053706	Halalkalicoccus	332246	Archaea	Archaea	508	1.26e-139	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g32564	i0	99.64	154.978417266187	278	1	100	0	1	278	2906	2629	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	43084	508	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
14197551	14197551	PRJNA1035005_P_NODE_47732_length_260_cov_1.181818_g47326_i0	PRJNA1035005	47732	260	1.181818	3.0727268	Natrinema caseinilyticum	2961570	Archaea	Archaea	289	1.66e-73	NTclustered	gi\|2270264148\|gb\|CP100445.1\|	2961570	g47326	i0	86.822	15.3461538461538	258	34	99	0	3	260	198465	198208	Natrinema caseinilyticum strain ZJ2 chromosome, complete genome	blastn	3990	289	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema caseinilyticum
20134326	20134326	PRJNA1035005_P_NODE_7116_length_407_cov_3.074850_g6714_i0	PRJNA1035005	7116	407	3.07485	12.5146395	Halalkalicoccus	332246	Archaea	Archaea	691	0	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g6714	i0	97.297	195.277641277641	407	11	100	0	1	407	2624	2218	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	79478	691	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
21409920	21409920	PRJNA1035005_P_NODE_557_length_2097_cov_3.277668_g433_i0	PRJNA1035005	557	2097	3.277668	68.73269796	Halalkalicoccus	332246	Archaea	Archaea	3474	0	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g433	i0	96.567	160.995231282785	2097	72	100	0	1	2097	2124	28	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	337607	3474	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
21845824	21845824	PRJNA1035005_P_NODE_47538_length_260_cov_1.443850_g47132_i0	PRJNA1035005	47538	260	1.44385	3.75401	Halanaeroarchaeum sp. HSR-CO	2866382	Archaea	Archaea	303	5.92e-78	NTclustered	gi\|2295222443\|gb\|CP087724.1\|	2866382	g47132	i0	87.938	2.43846153846154	257	31	99	0	1	257	918847	918591	Halanaeroarchaeum sp. HSR-CO chromosome, complete genome	blastn	634	303	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp. HSR-CO
27161300	27161300	PRJNA1035005_P_NODE_58762_length_251_cov_1.443820_g58356_i0	PRJNA1035005	58762	251	1.44382	3.6239882	Haloferax sp. Atlit-1	2253	Archaea	Archaea	112	2.64e-30	NR	WP_119712927.1	2077204	g58356	i0	88.6	0.836653386454183	70	8	83.7	0	251	42	31	100	WP_119712927.1 hypothetical protein [Haloferax sp. Atlit-10N]	diamond	210	112	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-10N
27627618	27627618	PRJNA1035005_P_NODE_24544_length_290_cov_1.078341_g24138_i0	PRJNA1035005	24544	290	1.078341	3.1271889	root	1	Root_unresolved	Root_unresolved	47	0.00203	NR	WP_109968281.1	668570	g24138	i0	51.6	0.589655172413793	31	15	32.1	0	138	230	273	303	WP_109968281.1 Coenzyme F420 hydrogenase/dehydrogenase, beta subunit C-terminal domain [Methanospirillum lacunae]	diamond	171	47	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum lacunae
27659219	27659219	PRJNA1035005_P_NODE_26744_length_287_cov_1.224299_g26338_i0	PRJNA1035005	26744	287	1.224299	3.51373813	Methanobacteriota	28890	Archaea	Archaea	85.1	7.28e-17	NR	MCZ7358014.1	2032688	g26338	i0	58	2.05923344947735	69	28	72.1	1	80	286	305	372	MCZ7358014.1 proline--tRNA ligase [Candidatus Methanoperedens sp.]	diamond	591	85.5	0.9953216374269	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
28298412	28298412	PRJNA1035005_P_NODE_40986_length_268_cov_1.600000_g40580_i0	PRJNA1035005	40986	268	1.6	4.288	Haloarcula sp. K1	1622207	Archaea	Archaea	152	1.59e-41	NR	WP_064289135.1	1622207	g40580	i0	80.7	0.985074626865672	88	17	98.5	0	266	3	133	220	WP_064289135.1 DUF6610 family protein [Haloarcula sp. K1]	diamond	264	152	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula sp. K1
28488059	28488059	PRJNA1035005_P_NODE_87127_length_239_cov_2.090361_g86721_i0	PRJNA1035005	87127	239	2.090361	4.99596279	Halorarum salinum	2743089	Archaea	Archaea	87.4	2.27e-19	NR	WP_179269447.1	2743089	g86721	i0	66.1	0.740585774058577	59	20	74.1	0	230	54	9	67	WP_179269447.1 hypothetical protein [Halorarum salinum]	diamond	177	87.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorarum	Halorarum salinum
29151354	29151354	PRJNA1035005_P_NODE_26089_length_288_cov_1.097674_g25683_i0	PRJNA1035005	26089	288	1.097674	3.16130112	Natronomonas sp. LN261	2750669	Archaea	Archaea	190	3.2400000000000002e-59	NR	WP_181691241.1	2750669	g25683	i0	98.9	0.989583333333333	95	1	99	0	286	2	54	148	WP_181691241.1 DUF7114 family protein [Natronomonas sp. LN261]	diamond	285	190	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
32564813	32564813	PRJNA1035005_P_NODE_41519_length_267_cov_2.979381_g41113_i0	PRJNA1035005	41519	267	2.979381	7.95494727	Haladaptatus sp. CMSO5	3120514	Archaea	Archaea	63.9	1.7e-9	NR	WP_332900305.1	3120514	g41113	i0	42.2	0.932584269662921	83	48	93.3	0	262	14	228	310	WP_332900305.1 archaea-specific SMC-related protein [Haladaptatus sp. CMSO5]	diamond	249	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus sp. CMSO5
32784816	32784816	PRJNA1035005_P_NODE_4080_length_529_cov_1.614035_g3682_i0	PRJNA1035005	4080	529	1.614035	8.53824515	Methanoregula sp.	2052170	Archaea	Archaea	60.8	3.45e-7	NR	MFA7304797.1	2052170	g3682	i0	29.8	1.32703213610586	114	73	64.7	3	525	184	22	128	MFA7304797.1 NosD domain-containing protein [Methanoregula sp.]	diamond	702	60.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula 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);;