NCBI
dbSNP

dbVar ClinVar GaP PubMed Nucleotide Protein
Search small variations in dbSNP or large structural variations in dbVar
transparent GIF
Spacer gif
Have a question about dbSNP? Try searching the SNP FAQ Archive!

Spacer gif
dbSNP Column Description for table: RsMergeArch

Table name and description
Beginning in 2018, dbSNP will no longer provide relational database table dumps on the FTP site or any general SQL support for future build releases (see announcement).

Table Description
"refSNP(rs) cluster is based on unique genome position. On new genome assembly, previously different contig may align. So different rs clusters map to the same location. In this case, we merge the rs. This table tracks this merging."

Table column and description

Column Description Type Byte Order
rsHigh Since rs# is assigned sequentially. Low number means the rs occurs early. So we always merge high rs number into low rs number. int 4 1
rsLow int 4 2
build_id dbSNP build id when this rsHigh was merged into rsLow. smallint 2 3
orien The orientation between rsHigh and rsLow. tinyint 1 4
create_time smalldatetime 4 5
last_updated_time smalldatetime 4 6
rsCurrent rsCurrent is the current rs for rsHigh. If rs9 is merged into rs5 which is later merged into rs2, then rsCurrent is 2 for rsHigh=9. int 4 7
orien2Current tinyint 1 8


This table/column description is last updated at: Mar 18 2015 02:51:00:000PM .

Search for descriptions of other table/column in data dictionary.


GENERAL: Contact Us | Homepage | Announcements |dbSNP Summary | Genome | FTP SERVER | Build History | Handle Request
DOCUMENTATION: FAQ | Searchable FAQ Archive | Overview | How to Submit | RefSNP Summary Info | Database Schema
SEARCH: Entrez SNP | Blast SNP | Batch Query | By Submitter |New Batches | Method | Population | Publication | Batch | Locus Info | Between Marker
NCBI: PubMed | Entrez | BLAST | OMIM | Taxonomy | Structure

Disclaimer     Privacy statement