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

10 rows where bioproject = "PRJNA533114" 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
26649359	26649359	PRJNA533114_P_NODE_108781_length_245_cov_1.343023_g108529_i0	PRJNA533114	108781	245	1.343023	3.29040635	root	1	Root_unresolved	Root_unresolved	119	1.27e-29	NR	MCE7733718.1	2026747	g108529	i0	63.4	8.97551020408163	82	28	98	1	243	4	205	286	MCE7733718.1 FAD-dependent monooxygenase [Candidatus Heimdallarchaeota archaeon]	diamond	2199	119	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
28608585	28608585	PRJNA533114_P_NODE_120507_length_241_cov_0.916667_g120255_i0	PRJNA533114	120507	241	0.916667	2.20916747	Promethearchaeati	1935183	Archaea	Archaea	67.8	5.45e-11	NR	UCG04291.1	2026747	g120255	i0	38.8	4.9792531120332	80	41	99.6	1	240	1	313	384	UCG04291.1 MAG: aryl-sulfate sulfotransferase [Candidatus Heimdallarchaeota archaeon]	diamond	1200	68.2	0.994134897360704	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
29572268	29572268	PRJNA533114_P_NODE_76770_length_276_cov_1.517241_g76518_i0	PRJNA533114	76770	276	1.517241	4.18758516	Promethearchaeota archaeon	2053489	Archaea	Archaea	81.6	1.19e-15	NR	TXT67626.1	2053489	g76518	i0	44	0.989130434782609	91	47	96.7	2	7	273	665	753	TXT67626.1 MAG: hypothetical protein BAJALOKI1v1_40029 [Promethearchaeota archaeon]	diamond	273	81.6	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
30394032	30394032	PRJNA533114_P_NODE_20073_length_505_cov_1.129630_g19824_i0	PRJNA533114	20073	505	1.12963	5.7046315	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	165	5.059999999999999e-46	NR	TET28087.1	2026747	g19824	i0	49.7	3.92673267326733	165	83	98	0	503	9	130	294	TET28087.1 MAG: arsenic resistance protein [Candidatus Heimdallarchaeota archaeon]	diamond	1983	165	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
30598090	30598090	PRJNA533114_P_NODE_61213_length_305_cov_0.995690_g60961_i0	PRJNA533114	61213	305	0.99569	3.0368545	Promethearchaeati	1935183	Archaea	Archaea	64.3	2.03e-9	NR	UCG03455.1	2026747	g60961	i0	35.4	4.65245901639344	96	54	93.4	2	300	16	217	305	UCG03455.1 MAG: aryl-sulfate sulfotransferase [Candidatus Heimdallarchaeota archaeon]	diamond	1419	64.3	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
31563246	31563246	PRJNA533114_P_NODE_122016_length_235_cov_2.302469_g121764_i0	PRJNA533114	122016	235	2.302469	5.41080215	Promethearchaeia archaeon	3067280	Archaea	Archaea	150	4.33e-40	NR	MFO7795213.1	3067280	g121764	i0	98.7	0.982978723404255	77	1	98.3	0	3	233	616	692	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	231	150	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
31721166	31721166	PRJNA533114_P_NODE_3317_length_1157_cov_2.998155_g3175_i0	PRJNA533114	3317	1157	2.998155	34.68865335	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	57.8	2.65e-5	NR	MCE7737425.1	2026747	g3175	i0	25.2	1.08902333621435	210	133	54.2	7	221	847	33	219	MCE7737425.1 transporter substrate-binding domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	1260	57.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
32069188	32069188	PRJNA533114_P_NODE_91058_length_254_cov_1.624309_g90806_i0	PRJNA533114	91058	254	1.624309	4.12574486	Promethearchaeia archaeon	3067280	Archaea	Archaea	166	1.24e-45	NR	MFO7795213.1	3067280	g90806	i0	96.4	0.992125984251969	84	3	99.2	0	1	252	695	778	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	252	166	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
32638093	32638093	PRJNA533114_P_NODE_58200_length_312_cov_0.966527_g57948_i0	PRJNA533114	58200	312	0.966527	3.01556424	Promethearchaeota archaeon	2053489	Archaea	Archaea	47	0.00279	NR	MBD3211208.1	2053489	g57948	i0	28.7	1.98076923076923	94	56	82.7	4	55	312	47	137	MBD3211208.1 hypothetical protein [Promethearchaeota archaeon]	diamond	618	47	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
32669826	32669826	PRJNA533114_P_NODE_95660_length_250_cov_1.497175_g95408_i0	PRJNA533114	95660	250	1.497175	3.7429375	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	45.1	0.00614	NR	MCE7735883.1	2026747	g95408	i0	44.4	1.356	54	26	64.8	1	85	246	32	81	MCE7735883.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon]	diamond	339	45.1	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota 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);;