metadata: contig_metadata: 9 rows where bioproject = "PRJNA1204310", tax_clade = "Stenosarchaea group" and tax

9 rows where bioproject = "PRJNA1204310", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

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
27786591	27786591	PRJNA1204310_P_NODE_20324_length_401_cov_1.536585_g20027_i0	PRJNA1204310	20324	401	1.536585	6.16170585	root	1	Root_unresolved	Root_unresolved	73.2	3.83e-12	NR	WP_214021670.1	90427	g20027	i0	54.5	3.99501246882793	66	27	49.4	1	328	131	4	66	WP_214021670.1 molecular chaperone DnaJ [Methanoculleus sp.]	diamond	1602	73.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sp.
27799351	27799351	PRJNA1204310_P_NODE_57264_length_247_cov_0.896552_g56967_i0	PRJNA1204310	57264	247	0.896552	2.21448344	Methanosarcinales archaeon	2250255	Archaea	Archaea	93.6	4.7e-20	NR	RYE85578.1	2250255	g56967	i0	49.4	1.05668016194332	87	39	99.6	1	2	247	432	518	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	261	93.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28209419	28209419	PRJNA1204310_P_NODE_18706_length_416_cov_1.160350_g18409_i0	PRJNA1204310	18706	416	1.16035	4.827056	Methanothrix sp.	90426	Archaea	Archaea	62	4.51e-8	NR	TFH52534.1	90426	g18409	i0	58.8	0.663461538461538	51	18	34.6	1	94	237	590	640	TFH52534.1 MAG: hypothetical protein E4G89_01470 [Methanothrix sp.]	diamond	276	62	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28620251	28620251	PRJNA1204310_P_NODE_62167_length_242_cov_0.923077_g61870_i0	PRJNA1204310	62167	242	0.923077	2.23384634	Halorhabdus sp.	1961697	Archaea	Archaea	45.1	0.00559	NR	MFB6202023.1	1961697	g61870	i0	33.8	0.991735537190083	80	37	79.3	3	195	4	177	256	MFB6202023.1 hypothetical protein [Halorhabdus sp.]	diamond	240	45.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorhabdus	Halorhabdus sp.
28746380	28746380	PRJNA1204310_P_NODE_62567_length_242_cov_0.923077_g62270_i0	PRJNA1204310	62567	242	0.923077	2.23384634	Halosimplex pelagicum	869886	Archaea	Archaea	42.4	0.0338	NR	WP_179918470.1	869886	g62270	i0	41.5	0.65702479338843	53	28	62	2	51	200	110	162	WP_179918470.1 hypothetical protein [Halosimplex pelagicum]	diamond	159	42.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex pelagicum
30925925	30925925	PRJNA1204310_P_NODE_50214_length_254_cov_5.464088_g49917_i0	PRJNA1204310	50214	254	5.464088	13.87878352	Methanosarcinales archaeon	2250255	Archaea	Archaea	51.2	5.71e-6	NR	MCD4843809.1	2250255	g49917	i0	48.4	0.755905511811024	64	33	75.6	0	60	251	6	69	MCD4843809.1 50S ribosomal protein P1 [Methanosarcinales archaeon]	diamond	192	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31178183	31178183	PRJNA1204310_P_NODE_48555_length_261_cov_1.659574_g48258_i0	PRJNA1204310	48555	261	1.659574	4.33148814	methanogenic archaeon mixed culture ISO4-G1	1452364	Archaea	Archaea	57	2.11e-7	NR	AMK14294.1	1452364	g48258	i0	37	0.839080459770115	73	46	83.9	0	232	14	127	199	AMK14294.1 metallophosphoesterase [methanogenic archaeon mixed culture ISO4-G1]	diamond	219	57	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			methanogenic archaeon mixed culture ISO4-G1
32601886	32601886	PRJNA1204310_P_NODE_60300_length_244_cov_0.912281_g60003_i0	PRJNA1204310	60300	244	0.912281	2.22596564	Methanocella paludicola	570267	Archaea	Archaea	78.2	9.09e-15	NR	WP_012901309.1	570267	g60003	i0	49.4	0.971311475409836	79	35	97.1	2	244	8	181	254	WP_012901309.1 PQQ-dependent sugar dehydrogenase [Methanocella paludicola]	diamond	237	78.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales	Methanocellaceae	Methanocella	Methanocella paludicola
32683454	32683454	PRJNA1204310_P_NODE_28980_length_345_cov_1.147059_g28683_i0	PRJNA1204310	28980	345	1.147059	3.95735355	root	1	Root_unresolved	Root_unresolved	152	1.45e-40	NR	WP_245249312.1	547055	g28683	i0	62.8	12.7826086956522	113	42	98.3	0	2	340	466	578	WP_245249312.1 propionyl-CoA synthetase [Methanolinea mesophila]	diamond	4410	153	0.993464052287582	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanolinea	Methanolinea mesophila

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