metadata: contig_metadata: 9 rows where bioproject = "PRJNA390533" and tax

9 rows where bioproject = "PRJNA390533" 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
409851	409851	PRJNA390533_P_NODE_4621_length_891_cov_5.515258_g4017_i0	PRJNA390533	4621	891	5.515258	49.14094878	Halovalidus salilacus	3075124	Archaea	Archaea	54.7	0.025	NTclustered	gi\|2581323319\|gb\|CP134700.1\|	3075124	g4017	i0	100	0.0325476992143659	29	0	3	0	385	413	3648312	3648340	Halovalidus salilacus strain CCL63 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovalidus	Halovalidus salilacus
10613469	10613469	PRJNA390533_P_NODE_26109_length_306_cov_2.101124_g25082_i0	PRJNA390533	26109	306	2.101124	6.42943944	Halomicrobium sp. HM KBTZ05	3242663	Archaea	Archaea	84.2	1.01e-11	NTclustered	gi\|2794134197\|gb\|CP168057.1\|	3242663	g25082	i0	85.185	4.46078431372549	81	12	26	0	1	81	792059	791979	Halomicrobium sp. HM KBTZ05 chromosome, complete genome	blastn	1365	84.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halomicrobium	Halomicrobium sp. HM KBTZ05
14438655	14438655	PRJNA390533_P_NODE_39612_length_182_cov_1.972028_g38585_i0	PRJNA390533	39612	182	1.972028	3.58909096	halophilic archaeon DL31	756883	Archaea	Archaea	71.3	4.27e-8	NTclustered	gi\|344319636\|gb\|CP002988.1\|	756883	g38585	i0	97.561	0.725274725274725	41	1	23	0	54	94	596487	596527	Halophilic archaeon DL31 chromosome, complete genome	blastn	132	71.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			halophilic archaeon DL31
27454677	27454677	PRJNA390533_P_NODE_13923_length_507_cov_1.297009_g12944_i0	PRJNA390533	13923	507	1.297009	6.57583563	Halobacteriales archaeon QS_8_69_26	1919187	Archaea	Archaea	70.9	3.46e-11	NR	PSQ19632.1	1919187	g12944	i0	57.7	1.06508875739645	52	22	30.8	0	391	236	185	236	PSQ19632.1 MAG: cyclase [Halobacteriales archaeon QS_8_69_26]	diamond	540	70.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon QS_8_69_26
30075136	30075136	PRJNA390533_P_NODE_36432_length_199_cov_1.243750_g35405_i0	PRJNA390533	36432	199	1.24375	2.4750625	Methanococcoides sp. NM1	1201013	Archaea	Archaea	53.1	4.33e-6	NR	WP_135605603.1	1201013	g35405	i0	41	0.919597989949749	61	36	92	0	188	6	302	362	WP_135605603.1 BREX-1 system phosphatase PglZ type A [Methanococcoides sp. NM1]	diamond	183	53.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanococcoides	Methanococcoides sp. NM1
30454716	30454716	PRJNA390533_P_NODE_33413_length_220_cov_1.149171_g32386_i0	PRJNA390533	33413	220	1.149171	2.5281762	Candidatus Methanophagaceae archaeon	3386247	Archaea	Archaea	107	3.67e-25	NR	KAF5433530.1	3386247	g32386	i0	68.1	7.85454545454545	72	23	98.2	0	218	3	81	152	KAF5433530.1 SEFIR domain-containing protein [Candidatus Methanophagaceae archaeon]	diamond	1728	107	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales	Candidatus Methanophagaceae		Candidatus Methanophagaceae archaeon
31086350	31086350	PRJNA390533_P_NODE_42455_length_171_cov_1.234848_g41428_i0	PRJNA390533	42455	171	1.234848	2.11159008	Natronococcus wangiae	3068275	Archaea	Archaea	83.2	6.04e-17	NR	WP_306052390.1	3068275	g41428	i0	64.3	1.96491228070175	56	20	98.2	0	169	2	158	213	WP_306052390.1 cation:proton antiporter [Natronococcus wangiae]	diamond	336	83.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus wangiae
31086354	31086354	PRJNA390533_P_NODE_46575_length_159_cov_1.108333_g45548_i0	PRJNA390533	46575	159	1.108333	1.76224947	Natronococcus wangiae	3068275	Archaea	Archaea	60.5	6.39e-9	NR	WP_306052390.1	3068275	g45548	i0	62	14.4716981132075	50	19	94.3	0	9	158	288	337	WP_306052390.1 cation:proton antiporter [Natronococcus wangiae]	diamond	2301	60.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus wangiae
31971819	31971819	PRJNA390533_P_NODE_50958_length_150_cov_0.945946_g49931_i0	PRJNA390533	50958	150	0.945946	1.418919	Candidatus Methanogaster sp. ANME-2c ERB4	2759911	Archaea	Archaea	44.3	0.00309	NR	QNO50037.1	2759911	g49931	i0	52.3	0.88	44	20	86	1	10	138	506	549	QNO50037.1 hypothetical protein MMAJBCMK_00020 [Candidatus Methanogaster sp. ANME-2c ERB4]	diamond	132	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanogasteraceae	Candidatus Methanogaster	Candidatus Methanogaster sp. ANME-2c ERB4

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