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

9 rows where bioproject = "PRJNA796753", 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
15245201	15245201	PRJNA796753_P_NODE_6212_length_543_cov_2.165957_g5904_i0	PRJNA796753	6212	543	2.165957	11.76114651	Methanothrix	2222	Archaea	Archaea	987	0	NTclustered	gi\|507148322\|ref\|NR_103125.1\|	2223	g5904	i0	99.448	16.427255985267	543	3	100	0	1	543	726	184	Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence	blastn	8920	987	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix soehngenii
16083221	16083221	PRJNA796753_P_NODE_32053_length_273_cov_1.540000_g31741_i0	PRJNA796753	32053	273	1.54	4.2042	Haloferax sp. YSSS75	3388564	Archaea	Archaea	58.4	5.39e-4	NTclustered	gi\|2890410414\|gb\|CP177206.1\|	3388564	g31741	i0	97.059	0.124542124542125	34	1	12	0	90	123	360722	360755	Haloferax sp. YSSS75 chromosome, complete genome	blastn	34	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. YSSS75
19907570	19907570	PRJNA796753_P_NODE_416_length_1624_cov_2.987750_g333_i0	PRJNA796753	416	1624	2.98775	48.52106	Halorutilales archaeon Cl-col2-1	3242703	Archaea	Archaea	54.7	0.046	NTclustered	gi\|2801083086\|gb\|CP169074.1\|	3242703	g333	i0	100	0.0178571428571429	29	0	2	0	202	230	912412	912384	Halorutilales archaeon Cl-col2-1 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halorutilales			Halorutilales archaeon Cl-col2-1
28569694	28569694	PRJNA796753_P_NODE_37067_length_256_cov_1.683060_g36755_i0	PRJNA796753	37067	256	1.68306	4.3086336	Halarchaeum acidiphilum	489138	Archaea	Archaea	43.9	0.007	NR	WP_020222420.1	489138	g36755	i0	40.9	0.7734375	66	36	73.8	1	191	3	8	73	WP_020222420.1 DUF4129 domain-containing protein [Halarchaeum acidiphilum]	diamond	198	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halarchaeum	Halarchaeum acidiphilum
28853751	28853751	PRJNA796753_P_NODE_54948_length_235_cov_3.135802_g54636_i0	PRJNA796753	54948	235	3.135802	7.3691347	Haloplanus sp. CK5-1	2949994	Archaea	Archaea	42	0.0176	NR	WP_338740382.1	2949994	g54636	i0	48.9	0.574468085106383	45	19	52.3	1	74	196	11	55	WP_338740382.1 hypothetical protein [Haloplanus sp. CK5-1]	diamond	135	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus salilacus
29201357	29201357	PRJNA796753_P_NODE_11589_length_410_cov_0.964392_g11277_i0	PRJNA796753	11589	410	0.964392	3.9540072	Methanoregulaceae archaeon	2485498	Archaea	Archaea	44.7	0.0248	NR	HRY75955.1	2485498	g11277	i0	47.1	0.248780487804878	34	18	24.9	0	216	115	53	86	HRY75955.1 isoprenylcysteine carboxylmethyltransferase family protein [Methanoregulaceae archaeon]	diamond	102	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
29368288	29368288	PRJNA796753_P_NODE_53949_length_241_cov_0.916667_g53637_i0	PRJNA796753	53949	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	82	5.19e-16	NR	WP_321508096.1	1005933	g53637	i0	55	3.95850622406639	80	27	99.6	2	2	241	144	214	WP_321508096.1 carboxylesterase/lipase family protein [uncultured Methanoregula sp.]	diamond	954	82.8	0.990338164251208	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
30148458	30148458	PRJNA796753_P_NODE_41932_length_249_cov_0.875000_g41620_i0	PRJNA796753	41932	249	0.875	2.17875	Saliphagus infecundisoli	1849069	Archaea	Archaea	66.6	1.06e-10	NR	WP_224829651.1	1849069	g41620	i0	46.3	0.987951807228916	82	43	97.6	1	3	245	146	227	WP_224829651.1 methyltransferase domain-containing protein [Saliphagus infecundisoli]	diamond	246	66.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Saliphagus	Saliphagus infecundisoli
32866465	32866465	PRJNA796753_P_NODE_26660_length_291_cov_1.811927_g26348_i0	PRJNA796753	26660	291	1.811927	5.27270757	Methanocellales archaeon	2666334	Archaea	Archaea	58.9	2.24e-8	NR	MEM2934473.1	2666334	g26348	i0	62.7	0.525773195876289	51	19	52.6	0	247	95	4	54	MEM2934473.1 50S ribosomal protein L19e [Methanocellales archaeon]	diamond	153	58.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales			Methanocellales archaeon

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