Skip to content
bedrock.bio

sequence_regions

Identifier

Section titled “Identifier”
refseq.sequence_regions

Description

Section titled “Description”

RefSeq sequence-level metadata and rare region-form repeat annotations from explicit genomic GFF3 region rows.

Partitions

Section titled “Partitions”
  • assembly_accession
    • 'GCF_000001215.4'
    • 'GCF_000001405.25'
    • 'GCF_000001405.40'
    • 'GCF_000001635.20'
    • 'GCF_000001635.27'
    • 'GCF_000001895.5'
    • 'GCF_000002035.6'
    • 'GCF_000002285.3'
    • 'GCF_000002985.6'
    • 'GCF_000003025.6'
    • 'GCF_000003625.3'
    • 'GCF_000005845.2'
    • 'GCF_000146045.2'
    • 'GCF_003339765.1'
    • 'GCF_012559485.2'
    • 'GCF_015227675.2'
    • 'GCF_036323735.1'
    • 'GCF_037993035.2'
    • 'GCF_049350105.2'
    • 'GCF_052040795.1'
    • 'GCF_054392235.1'
    • 'GCF_964237555.1'

Schema

Section titled “Schema”
Column Type Description
sources STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[] Original external inputs used to produce the row. Each item contains its source URL, filename, HTTP Last-Modified timestamp when available, and computed SHA-256 checksum.
assembly_accession TEXT Partition column. Versioned RefSeq assembly accession (GCF accession).
sequence_accession TEXT Versioned RefSeq nucleotide sequence accession described by the region; joins refseq.assembly_sequences.sequence_accession.
start INT 1-based inclusive start coordinate of the region.
end INT 1-based inclusive end coordinate of the region.
is_forward_strand BOOLEAN Whether the region is on the forward strand; null when unspecified.
region_id TEXT Local GFF3 ID of the region; not a stable RefSeq identifier.
annotation_method TEXT NCBI GFF column-2 annotation method or source, if supplied.
db_xrefs STRUCT(db TEXT, id TEXT)[] Database cross-references from GFF Dbxref; each item has a database and identifier, which may contain colons.
region_class TEXT Source GFF gbkey, distinguishing source (Src) and exceptional repeat-region records.
sequence_name TEXT Source sequence name from GFF Name, if supplied.
chromosome TEXT Chromosome assignment from GFF chromosome, if supplied.
genome_type TEXT Genome context from GFF genome, such as chromosome or mitochondrion, if supplied.
molecule_type TEXT Molecule type from GFF mol_type, if supplied.
map_location TEXT Map placement from GFF map, if supplied.
is_circular BOOLEAN Whether GFF Is_circular=true marks the region’s sequence circular.
country TEXT Source country metadata, if supplied.
isolation_source TEXT Source isolation-source metadata, if supplied.
tissue_type TEXT Source tissue-type metadata, if supplied.
repeat_class TEXT Repeat classification from GFF rpt_type, if supplied.
satellite_type TEXT Satellite classification from GFF satellite, if supplied.
experiments TEXT[] Percent-decoded experimental-evidence entries from the comma-separated GFF experiment attribute.
note TEXT Free-text GFF note annotation, if supplied.