species

Identifier

ensembl.species

Description

Selected Ensembl and Ensembl Genomes species and genome assemblies.

The independently released Ensembl collections and their release numbers identify the source for each row.

One row per selected assembly.

Use genbank_assembly_accession to select its downstream annotation partitions.

Related tables: ensembl.genes (join on genbank_assembly_accession).

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Provenance for the release species file.
release	TEXT	Ensembl or Ensembl Genomes release number for this row.
ensembl_division	TEXT	Ensembl publishing division: vertebrates, bacteria, fungi, metazoa, plants, or protists.
ensembl_collection	TEXT	Ensembl Genomes collection directory for bacterial species, if applicable.
species_name	TEXT	Ensembl’s lowercase, underscore-separated species key (e.g. homo_sapiens).
taxon_id	TEXT	NCBI taxonomy ID for the species (e.g. 9606 for human).
scientific_name	TEXT	Binomial scientific name (e.g. Homo sapiens).
common_name	TEXT	Common name of the species (e.g. human). May be null.
assembly_name	TEXT	Reference genome assembly name (e.g. GRCh38).
genbank_assembly_accession	TEXT	GenBank assembly accession (e.g. GCA_000001405.29). May be null.