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

10 rows where bioproject = "PRJNA867519" and tax_kingdom = "Promethearchaeati"

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_species
26611817	26611817	PRJNA867519_P_NODE_9301_length_369_cov_1.489865_g9147_i0	PRJNA867519	9301	369	1.489865	5.49760185	Promethearchaeota archaeon	2053489	Archaea	Archaea	77.4	1.04e-13	NR	MCK4381457.1	2053489	g9147	i0	39.1	0.934959349593496	115	65	92.7	4	2	343	392	502	MCK4381457.1 hypothetical protein [Promethearchaeota archaeon]	diamond	345	77.4	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
26801897	26801897	PRJNA867519_P_NODE_30461_length_245_cov_0.895349_g30307_i0	PRJNA867519	30461	245	0.895349	2.19360505	Promethearchaeia archaeon	3067280	Archaea	Archaea	60.8	1.54e-8	NR	HMF30488.1	3067280	g30307	i0	34.8	5.00816326530612	69	45	84.5	0	3	209	238	306	HMF30488.1 MFS transporter [Promethearchaeia archaeon]	diamond	1227	60.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
28728949	28728949	PRJNA867519_P_NODE_17387_length_287_cov_1.439252_g17233_i0	PRJNA867519	17387	287	1.439252	4.13065324	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	48.5	2.98e-4	NR	MEM2142739.1	2053491	g17233	i0	36.9	3.93031358885017	65	38	64.8	1	226	41	113	177	MEM2142739.1 Rab family GTPase [Candidatus Thorarchaeota archaeon]	diamond	1128	48.5	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota		Candidatus Thorarchaeota archaeon
29297266	29297266	PRJNA867519_P_NODE_4049_length_524_cov_4.230599_g3897_i0	PRJNA867519	4049	524	4.230599	22.16833876	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	49.7	3.54e-4	NR	MDH5402954.1	2026747	g3897	i0	29.1	0.727099236641221	127	88	72.7	2	492	112	3	127	MDH5402954.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	381	49.7	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
29865614	29865614	PRJNA867519_P_NODE_7511_length_402_cov_2.951368_g7357_i0	PRJNA867519	7511	402	2.951368	11.86449936	Promethearchaeia archaeon	3067280	Archaea	Archaea	76.3	2.38e-13	NR	HEY0088341.1	3067280	g7357	i0	54.7	0.559701492537313	75	33	56	1	3	227	255	328	HEY0088341.1 GTP-binding protein [Promethearchaeia archaeon]	diamond	225	76.3	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
30023742	30023742	PRJNA867519_P_NODE_31611_length_244_cov_0.900585_g31457_i0	PRJNA867519	31611	244	0.900585	2.1974274	Candidatus Sigynarchaeota archaeon	3036967	Archaea	Archaea	103	1.1099999999999999e-23	NR	MEX2719049.1	3036967	g31457	i0	55.7	0.971311475409836	79	35	97.1	0	7	243	958	1036	MEX2719049.1 SIR2 family protein [Candidatus Sigynarchaeota archaeon]	diamond	237	103	1	Archaea	Promethearchaeati	Candidatus Sigynarchaeota		Candidatus Sigynarchaeota archaeon
30537196	30537196	PRJNA867519_P_NODE_28493_length_247_cov_1.724138_g28339_i0	PRJNA867519	28493	247	1.724138	4.25862086	Archaea	2157	Archaea	Archaea	48.9	2.61e-4	NR	MBN1329189.1	2026747	g28339	i0	53.5	2.55060728744939	43	20	52.2	0	1	129	251	293	MBN1329189.1 MFS transporter [Candidatus Heimdallarchaeota archaeon]	diamond	630	48.9	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
30750319	30750319	PRJNA867519_P_NODE_21614_length_268_cov_2.148718_g21460_i0	PRJNA867519	21614	268	2.148718	5.75856424	Candidatus Sigynarchaeota archaeon	3036967	Archaea	Archaea	58.9	1.01e-7	NR	MEX2719049.1	3036967	g21460	i0	41.9	1.65671641791045	74	42	81.7	1	266	48	781	854	MEX2719049.1 SIR2 family protein [Candidatus Sigynarchaeota archaeon]	diamond	444	58.9	1	Archaea	Promethearchaeati	Candidatus Sigynarchaeota		Candidatus Sigynarchaeota archaeon
32173440	32173440	PRJNA867519_P_NODE_6938_length_416_cov_2.206997_g6784_i0	PRJNA867519	6938	416	2.206997	9.18110752	Promethearchaeia archaeon	3067280	Archaea	Archaea	45.8	0.0185	NR	MEE9379182.1	3067280	g6784	i0	32.4	0.735576923076923	102	62	70.7	4	321	28	10	108	MEE9379182.1 methyltransferase domain-containing protein [Promethearchaeia archaeon]	diamond	306	45.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
32553199	32553199	PRJNA867519_P_NODE_32819_length_242_cov_0.911243_g32665_i0	PRJNA867519	32819	242	0.911243	2.20520806	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	53.5	1.74e-6	NR	MBE0526880.1	2053491	g32665	i0	44.7	6.2603305785124	76	38	89.3	1	217	2	51	126	MBE0526880.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Thorarchaeota archaeon]	diamond	1515	53.5	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota		Candidatus Thorarchaeota 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);;