metadata: contig_metadata: 14 rows where bioproject = "PRJNA940501" and tax

14 rows where bioproject = "PRJNA940501" and tax_kingdom = "Thermoproteati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26898740	26898740	PRJNA940501_S_NODE_319901_length_163_cov_1.566667_g319083_i0	PRJNA940501	319901	163	1.566667	2.55366721	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	41.6	0.0195	NR	MEM1564341.1	3045160	g319083	i0	50	0.699386503067485	38	18	68.1	1	39	149	6	43	MEM1564341.1 hypothetical protein [Candidatus Bathyarchaeia archaeon]	diamond	114	41.6	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
28383193	28383193	PRJNA940501_S_NODE_102686_length_236_cov_1.797927_g101868_i0	PRJNA940501	102686	236	1.797927	4.24310772	Candidatus Brockarchaeota archaeon	2815303	Archaea	Archaea	42.7	0.0348	NR	MBO3842081.1	2815303	g101868	i0	31	0.73728813559322	58	39	73.7	1	27	200	734	790	MBO3842081.1 putative Ig domain-containing protein [Candidatus Brockarchaeota archaeon]	diamond	174	42.7	1	Archaea	Thermoproteati	Candidatus Brockarchaeota					Candidatus Brockarchaeota archaeon
30404761	30404761	PRJNA940501_S_NODE_206613_length_191_cov_1.270270_g205795_i0	PRJNA940501	206613	191	1.27027	2.4262157	Candidatus Methanomethylicia archaeon	2268187	Archaea	Archaea	41.2	0.0338	NR	HDI46417.1	2268187	g205795	i0	37	0.722513089005236	46	28	72.3	1	171	34	55	99	HDI46417.1 methanogenesis marker 6 protein [Candidatus Methanomethylicia archaeon]	diamond	138	41.2	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia				Candidatus Methanomethylicia archaeon
30600672	30600672	PRJNA940501_S_NODE_176813_length_201_cov_1.189873_g175995_i0	PRJNA940501	176813	201	1.189873	2.39164473	Thermoproteati	1783275	Archaea	Archaea	56.6	1.54e-7	NR	HDJ25957.1	2026714	g175995	i0	53.4	1.6865671641791	58	22	82.1	2	1	165	135	190	HDJ25957.1 ribonuclease HII [Candidatus Bathyarchaeota archaeon]	diamond	339	56.6	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30688539	30688539	PRJNA940501_S_NODE_14473_length_404_cov_13.177285_g13660_i0	PRJNA940501	14473	404	13.177285	53.2362314	Nitrosopumilus sp.	2024843	Archaea	Archaea	63.2	1.17e-8	NR	MDA7495390.1	2024843	g13660	i0	39.5	0.638613861386139	86	44	62.4	3	399	148	235	314	MDA7495390.1 hypothetical protein [Nitrosopumilus sp.]	diamond	258	63.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
30846702	30846702	PRJNA940501_S_NODE_208534_length_190_cov_1.918367_g207716_i0	PRJNA940501	208534	190	1.918367	3.6448973	Candidatus Nitrososphaera evergladensis	1459637	Archaea	Archaea	48.5	1.59e-4	NR	WP_148700525.1	1459637	g207716	i0	39.3	0.963157894736842	61	36	96.3	1	189	7	47	106	WP_148700525.1 polysaccharide deacetylase family protein [Candidatus Nitrososphaera evergladensis]	diamond	183	48.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera evergladensis
30878221	30878221	PRJNA940501_S_NODE_124074_length_224_cov_1.276243_g123256_i0	PRJNA940501	124074	224	1.276243	2.85878432	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	41.2	0.0377	NR	TMI43497.1	2026714	g123256	i0	39.7	0.910714285714286	68	29	75	2	37	204	47	114	TMI43497.1 MAG: hypothetical protein E6H19_09540 [Candidatus Bathyarchaeota archaeon]	diamond	204	41.2	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
31130802	31130802	PRJNA940501_S_NODE_74575_length_257_cov_2.415888_g73757_i0	PRJNA940501	74575	257	2.415888	6.20883216	Nitrosarchaeum sp.	2026886	Archaea	Archaea	48.9	3.01e-4	NR	HSA76138.1	2026886	g73757	i0	65.7	0.408560311284047	35	12	40.9	0	2	106	900	934	HSA76138.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrosarchaeum sp.]	diamond	105	48.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
31162336	31162336	PRJNA940501_S_NODE_117995_length_227_cov_1.532609_g117177_i0	PRJNA940501	117995	227	1.532609	3.47902243	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	43.5	0.0158	NR	HET7284302.1	2169593	g117177	i0	57.6	0.436123348017621	33	12	43.6	1	128	30	254	284	HET7284302.1 integrase [Nitrososphaeraceae archaeon]	diamond	99	43.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31384112	31384112	PRJNA940501_S_NODE_192276_length_195_cov_2.375000_g191458_i0	PRJNA940501	192276	195	2.375	4.63125	Desulfurococcaceae archaeon	2184738	Archaea	Archaea	44.3	0.00567	NR	MEM4558218.1	2184738	g191458	i0	32.8	0.938461538461538	61	33	83.1	2	13	174	114	173	MEM4558218.1 hypothetical protein [Desulfurococcaceae archaeon]	diamond	183	44.3	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae		Desulfurococcaceae archaeon
32238426	32238426	PRJNA940501_S_NODE_21738_length_355_cov_1.211538_g20920_i0	PRJNA940501	21738	355	1.211538	4.3009599	Staphylothermus sp.	2820299	Archaea	Archaea	68.6	1.25e-10	NR	MCD6196230.1	2820299	g20920	i0	45.7	1.76619718309859	70	36	57.5	1	1	204	987	1056	MCD6196230.1 cellobiose phosphorylase [Staphylothermus sp.]	diamond	627	68.6	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Staphylothermus	Staphylothermus sp.
32333393	32333393	PRJNA940501_S_NODE_192239_length_195_cov_2.473684_g191421_i0	PRJNA940501	192239	195	2.473684	4.8236838	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	76.3	4.71e-15	NR	MDR4491959.1	2109671	g191421	i0	57.9	2.58461538461538	57	24	87.7	0	180	10	147	203	MDR4491959.1 FkbM family methyltransferase [Candidatus Nitrosocosmicus sp.]	diamond	504	76.3	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32364888	32364888	PRJNA940501_S_NODE_68819_length_263_cov_1.068182_g68001_i0	PRJNA940501	68819	263	1.068182	2.80931866	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	44.3	0.0137	NR	MCJ7573923.1	2026714	g68001	i0	32.9	1.69961977186312	82	53	91.3	1	11	250	683	764	MCJ7573923.1 plasma-membrane proton-efflux P-type ATPase [Candidatus Bathyarchaeota archaeon]	diamond	447	44.3	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
32869462	32869462	PRJNA940501_S_NODE_32200_length_318_cov_3.581818_g31382_i0	PRJNA940501	32200	318	3.581818	11.39018124	Nitrosarchaeum sp.	2026886	Archaea	Archaea	68.2	1.1e-10	NR	HSA76138.1	2026886	g31382	i0	61.5	0.490566037735849	52	20	49.1	0	318	163	883	934	HSA76138.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrosarchaeum sp.]	diamond	156	68.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum 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);;