metadata: contig_metadata: 10 rows where bioproject = "PRJNA283169" and tax

10 rows where bioproject = "PRJNA283169" 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
27737841	27737841	PRJNA283169_P_NODE_5104_length_189_cov_1.107143_g5041_i0	PRJNA283169	5104	189	1.107143	2.09250027	Thermoproteota archaeon	2056631	Archaea	Archaea	45.8	0.00154	NR	RLG45042.1	2056631	g5041	i0	39.7	1.96825396825397	63	37	100	1	189	1	770	831	RLG45042.1 MAG: hypothetical protein DRN81_02945 [Thermoproteota archaeon]	diamond	372	45.8	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
28053157	28053157	PRJNA283169_P_NODE_6785_length_167_cov_0.881356_g6722_i0	PRJNA283169	6785	167	0.881356	1.47186452	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	73.9	2.13e-14	NR	NDF35231.1	2202732	g6722	i0	61.8	0.988023952095808	55	21	98.8	0	1	165	108	162	NDF35231.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	165	73.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
29979344	29979344	PRJNA283169_S_NODE_2891_length_171_cov_0.122951_g2877_i0	PRJNA283169	2891	171	0.122951	0.21024621	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	43.5	0.00103	NR	MCK4435361.1	2026714	g2877	i0	40.4	2.43859649122807	47	28	82.5	0	147	7	17	63	MCK4435361.1 KTSC domain-containing protein [Candidatus Bathyarchaeota archaeon]	diamond	417	43.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30422062	30422062	PRJNA283169_S_NODE_3413_length_162_cov_0.194690_g3399_i0	PRJNA283169	3413	162	0.19469	0.3153978	Nitrososphaerales archaeon	2268197	Archaea	Archaea	41.2	0.0374	NR	MFI5421441.1	2268197	g3399	i0	41.7	0.666666666666667	36	21	66.7	0	54	161	97	132	MFI5421441.1 hypothetical protein [Nitrososphaerales archaeon]	diamond	108	41.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales archaeon
30611110	30611110	PRJNA283169_P_NODE_8233_length_158_cov_2.348624_g8170_i0	PRJNA283169	8233	158	2.348624	3.71082592	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	57	8.99e-9	NR	HLL60944.1	2109671	g8170	i0	47.9	0.911392405063291	48	25	91.1	0	13	156	2	49	HLL60944.1 hypothetical protein [Candidatus Nitrosocosmicus sp.]	diamond	144	57	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
30832382	30832382	PRJNA283169_P_NODE_4374_length_202_cov_0.947712_g4311_i0	PRJNA283169	4374	202	0.947712	1.91437824	Candidatus Nitrosotenuis sp.	2507556	Archaea	Archaea	87.8	2.85e-18	NR	MEM3008302.1	2507556	g4311	i0	61.2	0.995049504950495	67	26	99.5	0	1	201	402	468	MEM3008302.1 hypothetical protein [Candidatus Nitrosotenuis sp.]	diamond	201	87.8	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp.
31211083	31211083	PRJNA283169_P_NODE_7915_length_163_cov_0.877193_g7852_i0	PRJNA283169	7915	163	0.877193	1.42982459	Nitrososphaerota archaeon	2026795	Archaea	Archaea	108	3.89e-27	NR	MBI3842283.1	2026795	g7852	i0	96.3	0.993865030674847	54	2	99.4	0	162	1	94	147	MBI3842283.1 lysine biosynthesis protein LysX [Nitrososphaerota archaeon]	diamond	162	108	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31717634	31717634	PRJNA283169_S_NODE_1277_length_240_cov_0.099476_g1263_i0	PRJNA283169	1277	240	0.099476	0.2387424	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	133	1.7999999999999998e-35	NR	HEY5631632.1	2169593	g1263	i0	78.2	1.95	78	17	97.5	0	1	234	121	198	HEY5631632.1 MoxR family ATPase [Nitrososphaeraceae archaeon]	diamond	468	133	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32382100	32382100	PRJNA283169_S_NODE_1659_length_215_cov_0.120482_g1645_i0	PRJNA283169	1659	215	0.120482	0.2590363	Thermoproteota archaeon	2056631	Archaea	Archaea	75.5	1.23e-14	NR	RDJ35095.1	2056631	g1645	i0	55.4	0.906976744186046	65	28	89.3	1	205	14	2	66	RDJ35095.1 MAG: metallophosphoesterase [Thermoproteota archaeon]	diamond	195	75.5	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
32508879	32508879	PRJNA283169_P_NODE_3859_length_213_cov_0.908537_g3796_i0	PRJNA283169	3859	213	0.908537	1.93518381	Nitrososphaerota archaeon	2026795	Archaea	Archaea	89.7	7.35e-19	NR	MDE1812259.1	2026795	g3796	i0	62	1	71	25	97.2	1	4	210	834	904	MDE1812259.1 6-bladed beta-propeller [Nitrososphaerota archaeon]	diamond	213	89.7	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota 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);;