metadata: contig_metadata: 6 rows where bioproject = "PRJNA980585" and tax

6 rows where bioproject = "PRJNA980585" 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_species
27310866	27310866	PRJNA980585_P_NODE_13363_length_377_cov_0.990132_g13109_i0	PRJNA980585	13363	377	0.990132	3.73279764	Promethearchaeota archaeon	2053489	Archaea	Archaea	67.8	2.15e-10	NR	MCK4687431.1	2053489	g13109	i0	61.2	1.36870026525199	49	19	39	0	231	377	3	51	MCK4687431.1 ABC transporter ATP-binding protein [Promethearchaeota archaeon]	diamond	516	67.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon
28074524	28074524	PRJNA980585_P_NODE_48885_length_247_cov_0.885057_g48631_i0	PRJNA980585	48885	247	0.885057	2.18609079	Archaea	2157	Archaea	Archaea	43.9	0.0118	NR	OLS32927.1	1841596	g48631	i0	31.5	3.98380566801619	73	47	88.7	2	237	19	139	208	OLS32927.1 MAG: hypothetical protein HeimAB125_04100 [Candidatus Heimdallarchaeota archaeon AB_125]	diamond	984	43.9	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon AB_125
29363112	29363112	PRJNA980585_P_NODE_47569_length_248_cov_0.880000_g47315_i0	PRJNA980585	47569	248	0.88	2.1824	Promethearchaeota archaeon	2053489	Archaea	Archaea	49.3	1.77e-4	NR	TFG13801.1	2053489	g47315	i0	33.3	0.725806451612903	60	40	72.6	0	246	67	241	300	TFG13801.1 MAG: DUF4430 domain-containing protein [Promethearchaeota archaeon]	diamond	180	49.3	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon
29906106	29906106	PRJNA980585_P_NODE_11411_length_400_cov_2.278287_g11157_i0	PRJNA980585	11411	400	2.278287	9.113148	root	1	Root_unresolved	Root_unresolved	89.7	5.07e-19	NR	MDH5401859.1	2026747	g11157	i0	39.7	2.8125	121	73	90.8	0	21	383	8	128	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	1125	89.7	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
30405724	30405724	PRJNA980585_P_NODE_2633_length_739_cov_1.384384_g2394_i0	PRJNA980585	2633	739	1.384384	10.23059776	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	155	6.349999999999999e-43	NR	MDH5401859.1	2026747	g2394	i0	36.6	0.86468200270636	213	133	86.1	2	30	665	10	221	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	639	155	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
32807420	32807420	PRJNA980585_P_NODE_26000_length_291_cov_1.174312_g25746_i0	PRJNA980585	26000	291	1.174312	3.41724792	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	84.7	1.16e-17	NR	MDH5401859.1	2026747	g25746	i0	43	0.958762886597938	93	53	95.9	0	290	12	11	103	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	279	84.7	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);;