metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1182301" 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
26723580	26723580	PRJNA1182301_P_NODE_60381_length_243_cov_0.905882_g60256_i0	PRJNA1182301	60381	243	0.905882	2.20129326	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	89.7	7.25e-20	NR	HEX9613591.1	3045160	g60256	i0	54.2	2.02469135802469	83	35	98.8	1	242	3	121	203	HEX9613591.1 hypothetical protein [Candidatus Bathyarchaeia archaeon]	diamond	492	89.7	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
27514628	27514628	PRJNA1182301_P_NODE_29483_length_276_cov_1.256158_g29358_i0	PRJNA1182301	29483	276	1.256158	3.46699608	Thermoproteota archaeon	2056631	Archaea	Archaea	119	3.3e-30	NR	MDP8907050.1	2056631	g29358	i0	82.9	3.66304347826087	70	12	76.1	0	67	276	141	210	MDP8907050.1 EF-Tu/IF-2/RF-3 family GTPase [Thermoproteota archaeon]	diamond	1011	119	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
27861811	27861811	PRJNA1182301_P_NODE_57745_length_245_cov_0.895349_g57620_i0	PRJNA1182301	57745	245	0.895349	2.19360505	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	160	1.03e-44	NR	HEX5519150.1	2109671	g57620	i0	95.1	0.991836734693878	81	4	99.2	0	3	245	387	467	HEX5519150.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Nitrosocosmicus sp.]	diamond	243	160	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
28462025	28462025	PRJNA1182301_P_NODE_38986_length_263_cov_1.836842_g38861_i0	PRJNA1182301	38986	263	1.836842	4.83089446	Thermoproteota archaeon	2056631	Archaea	Archaea	46.6	7.76e-4	NR	MDQ3562092.1	2056631	g38861	i0	100	0.262357414448669	23	0	26.2	0	1	69	123	145	MDQ3562092.1 hypothetical protein [Thermoproteota archaeon]	diamond	69	46.6	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
29566825	29566825	PRJNA1182301_P_NODE_31630_length_273_cov_1.470000_g31505_i0	PRJNA1182301	31630	273	1.47	4.0131	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	173	2.44e-52	NR	HEX6027542.1	2169593	g31505	i0	93.4	3	91	6	100	0	1	273	93	183	HEX6027542.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	819	173	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30166845	30166845	PRJNA1182301_P_NODE_35052_length_268_cov_2.184615_g34927_i0	PRJNA1182301	35052	268	2.184615	5.8547682	Pyrobaculum sp.	2004705	Archaea	Archaea	101	9.58e-24	NR	MEM4965092.1	2004705	g34927	i0	85	0.671641791044776	60	9	67.2	0	54	233	5	64	MEM4965092.1 hypothetical protein [Pyrobaculum sp.]	diamond	180	101	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum sp.
30420111	30420111	PRJNA1182301_P_NODE_10573_length_341_cov_0.854478_g10448_i0	PRJNA1182301	10573	341	0.854478	2.91376998	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	120	4.189999999999999e-31	NR	HEX4919750.1	3045160	g10448	i0	47.1	2.07624633431085	119	57	99.4	1	339	1	85	203	HEX4919750.1 AAA family ATPase [Candidatus Bathyarchaeia archaeon]	diamond	708	120	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
30609199	30609199	PRJNA1182301_P_NODE_23013_length_284_cov_5.127962_g22888_i0	PRJNA1182301	23013	284	5.127962	14.56341208	Candidatus Methanomethylicota archaeon	2056631	Archaea	Archaea	44.3	0.00833	NR	MDI9643872.1	2250257	g22888	i0	41.7	0.507042253521127	48	28	50.7	0	276	133	102	149	MDI9643872.1 ribonuclease HI [Candidatus Methanomethylicota archaeon]	diamond	144	44.3	1	Archaea	Thermoproteati	Candidatus Methanomethylicota					Candidatus Methanomethylicota archaeon
31241151	31241151	PRJNA1182301_P_NODE_28355_length_277_cov_2.014706_g28230_i0	PRJNA1182301	28355	277	2.014706	5.58073562	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	147	9.42e-43	NR	HKG41931.1	2169593	g28230	i0	89.5	0.931407942238267	86	9	93.1	0	260	3	3	88	HKG41931.1 5-formyltetrahydrofolate cyclo-ligase [Nitrososphaeraceae archaeon]	diamond	258	147	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32777819	32777819	PRJNA1182301_P_NODE_25900_length_281_cov_1.182692_g25775_i0	PRJNA1182301	25900	281	1.182692	3.32336452	Thermoproteati	1783275	Archaea	Archaea	68.9	1.02e-11	NR	HWS20841.1	1971748	g25775	i0	88.9	1.11032028469751	36	4	38.4	0	110	3	16	51	HWS20841.1 histidine phosphatase family protein [Nitrososphaera sp.]	diamond	312	68.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera 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);;