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

9 rows where analysis = "diamond", bioproject = "PRJNA1022139" 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
26837364	26837364	PRJNA1022139_P_NODE_26761_length_278_cov_2.248780_g26656_i0	PRJNA1022139	26761	278	2.24878	6.2516084	root	1	Root_unresolved	Root_unresolved	53.5	8.21e-6	NR	HOI14343.1	90427	g26656	i0	53.3	1.94244604316547	45	21	48.6	0	135	1	53	97	HOI14343.1 GNAT family N-acetyltransferase [Methanoculleus sp.]	diamond	540	53.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
27098087	27098087	PRJNA1022139_P_NODE_17222_length_333_cov_1.776923_g17117_i0	PRJNA1022139	17222	333	1.776923	5.91715359	Methanoregula sp.	2052170	Archaea	Archaea	45.4	0.0124	NR	WP_300224501.1	2052170	g17117	i0	52	0.45045045045045	50	22	45	2	153	4	602	649	WP_300224501.1 C39 family peptidase [Methanoregula sp.]	diamond	150	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
27129303	27129303	PRJNA1022139_P_NODE_24782_length_285_cov_1.933962_g24677_i0	PRJNA1022139	24782	285	1.933962	5.5117917	Methanosarcinales archaeon	2250255	Archaea	Archaea	129	8.95e-33	NR	RYE85578.1	2250255	g24677	i0	60.6	0.989473684210526	94	37	98.9	0	283	2	360	453	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	282	129	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28298209	28298209	PRJNA1022139_P_NODE_29966_length_267_cov_1.417526_g29861_i0	PRJNA1022139	29966	267	1.417526	3.78479442	Methanoculleus sp. DTU	90427	Archaea	Archaea	75.9	1.13e-13	NR	WP_286680964.1	1671626	g29861	i0	46.5	2.8988764044943802	86	44	96.6	1	7	264	618	701	WP_286680964.1 Orn/Lys/Arg decarboxylase N-terminal domain-containing protein [Methanoculleus sp. DTU007]	diamond	774	75.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp. DTU007
28385144	28385144	PRJNA1022139_P_NODE_32086_length_259_cov_1.215054_g31981_i0	PRJNA1022139	32086	259	1.215054	3.14698986	root	1	Root_unresolved	Root_unresolved	42.7	0.0472	NR	MDH7597884.1	90426	g31981	i0	28.8	2.65250965250965	80	57	92.7	0	5	244	1230	1309	MDH7597884.1 N-6 DNA methylase [Methanothrix sp.]	diamond	687	43.1	0.990719257540603	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28479956	28479956	PRJNA1022139_P_NODE_666_length_1360_cov_2.125874_g630_i0	PRJNA1022139	666	1360	2.125874	28.9118864	Methanoculleus	45989	Archaea	Archaea	51.6	0.00712	NR	MFA7563037.1	90427	g630	i0	26.5	1.20220588235294	238	150	49.6	11	1154	480	45	270	MFA7563037.1 PQQ-binding-like beta-propeller repeat protein [Methanoculleus sp.]	diamond	1635	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
31868105	31868105	PRJNA1022139_P_NODE_4477_length_606_cov_2.791745_g4373_i0	PRJNA1022139	4477	606	2.791745	16.9179747	Haladaptatus sp. DYF46	2886041	Archaea	Archaea	92.8	1.98e-19	NR	WP_231186698.1	2886041	g4373	i0	28	4.74752475247525	182	126	90.1	2	580	35	9	185	WP_231186698.1 DUF4397 domain-containing protein [Haladaptatus sp. DYF46]	diamond	2877	92.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus sp. DYF46
32374616	32374616	PRJNA1022139_P_NODE_32539_length_257_cov_1.456522_g32434_i0	PRJNA1022139	32539	257	1.456522	3.74326154	Methanoregulaceae archaeon	2485498	Archaea	Archaea	57	4.18e-7	NR	HPD75598.1	2485498	g32434	i0	37.5	1.0272373540856	88	48	96.9	3	8	256	20	105	HPD75598.1 SpoIIE family protein phosphatase [Methanoregulaceae archaeon]	diamond	264	57	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
32374627	32374627	PRJNA1022139_P_NODE_40839_length_243_cov_1.694118_g40734_i0	PRJNA1022139	40839	243	1.694118	4.11670674	Methanospirillum stamsii	1277351	Archaea	Archaea	51.2	3.82e-5	NR	WP_181391457.1	1277351	g40734	i0	34.7	0.888888888888889	72	46	88.9	1	10	225	180	250	WP_181391457.1 NosD domain-containing protein [Methanospirillum stamsii]	diamond	216	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum stamsii

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);;