assembly_sequences

Identifier

refseq.assembly_sequences

Description

Sequence records from RefSeq assembly reports.

Maps NCBI sequence names to versioned RefSeq and GenBank accessions.

Includes primary assembled molecules, alternate loci, unlocalized sequences, and unplaced sequences.

To map chromosomes, select rows where sequence_role is assembled-molecule.

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

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_name	TEXT	NCBI sequence name within the assembly, such as 1, X, MT, or a scaffold name.
sequence_role	TEXT	NCBI role assigned to the sequence, such as assembled-molecule, unlocalized-scaffold, or unplaced-scaffold.
assigned_molecule	TEXT	Chromosome or other assigned molecule, if NCBI provides one.
assigned_molecule_location_type	TEXT	NCBI location/type of the assigned molecule, such as Chromosome.
genbank_sequence_accession	TEXT	Versioned GenBank sequence accession, if supplied.
relationship	TEXT	NCBI relationship between the RefSeq and GenBank sequence records, if supplied.
sequence_accession	TEXT	Versioned RefSeq sequence accession; use this identifier when matching RefSeq-based resources such as dbSNP VCF contig names.
unit_name	TEXT	NCBI assembly unit containing the sequence, such as Primary Assembly or PATCHES.
sequence_length	BIGINT	Sequence length in base pairs.
ucsc_name	TEXT	UCSC-style sequence name, if NCBI provides one.