transposable_elements

Identifier

ensembl.transposable_elements

Description

Annotated transposable-element loci.

One row per verified transposable_element_gene and transposable_element GFF3 parent-child pair.

Materialization requires exactly one child per parent with identical sequence and coordinates, so this table represents each locus once.

It does not describe active transposition in an individual organism.

Partitions

• genbank_assembly_accession
  • 'GCA_000001215.4'
  • 'GCA_000146045.2'

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Provenance for the GFF3 feature records.
release	TEXT	Ensembl release number the annotation was drawn from.
genbank_assembly_accession	TEXT	Partition column. GenBank assembly accession (partition column).
element_id	TEXT	Transposable-element locus identifier from the parent GFF3 gene_id attribute.
element_name	TEXT	Transposable-element name from parent GFF3 Name, if supplied. May be null.
description	TEXT	Parent GFF3 description, if supplied. May be null.
analysis_name	TEXT	Ensembl analysis name from parent GFF3 logic_name.
sequence_id	TEXT	GFF3 sequence ID on which the transposable element is located.
start_position	INT	1-based start coordinate of the transposable-element locus.
end_position	INT	1-based end coordinate of the transposable-element locus.
is_forward_strand	BOOLEAN	Whether the transposable element is on the forward strand.
element_source	TEXT	Annotation source in parent GFF3 column 2.