metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax

9 rows where analysis = "diamond", 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
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.
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);;