Convert #Ss To #Rs Snp Ids

Question

[explodecomputer]

Hi

I have about 500k #ss SNPs (from an Affy 5.0 chip). I would like to find the #rs numbers for each of these SNPs. Would anyone happen to know how would I go about doing this? I also have allele names for each #ss number, but no physical or genetic positions.

Thanks very much!

Answer 1

[Pierre Lindenbaum]

A table linking the #ss to the #rs is available at ncbi at : ftp://ftp.ncbi.nih.gov/snp/organisms/human_9606/database/organism_data/SNPSubSNPLink.bcp.gz

CREATE TABLE [SNPSubSNPLink]
(
[subsnp_id] [int] NULL ,
[snp_id] [int] NULL ,
[substrand_reversed_flag] [tinyint] NULL ,
[create_time] [datetime] NULL ,
[last_updated_time] [datetime] NULL ,
[build_id] [int] NULL ,
[comment] [varchar](255) NULL
)

[explodecomputer]

Sorry for my slow response to your very quick one. Many thanks for this info!

[keerthuguna96]

sir.. is there any method available to convert #rs to#ss id??