Schema for lsSnpPdb
  Database: hg18    Primary Table: lsSnpPdb    Row Count: 143,301   Data last updated: 2009-09-14
Format description: Mapping of SNPs to protein structures obtained from LS-SNP PDB
On download server: MariaDB table dump directory
fieldexampleSQL type info description
protId O60701varchar(255) values Protein Id
pdbId 2q3evarchar(255) values PDB id
structType XRayenum('XRay', 'NMR') values type of structure
chain Achar(1) values PDB chain id
snpId rs10010387varchar(255) values dbSNP id
snpPdbLoc 363int(11) range location of SNP in PDB chain (1-based AA index)

Connected Tables and Joining Fields
        uniProt.extDbRef.extAcc1 (via lsSnpPdb.pdbId)
      uniProt.extDbRef.acc (via lsSnpPdb.protId)
      hg18.snp130.name (via lsSnpPdb.snpId)

Sample Rows
 
protIdpdbIdstructTypechainsnpIdsnpPdbLoc
O607012q3eXRayArs10010387363
O607012qg4XRayArs10010387363
O948553efoXRayBrs1002920643
O948553eg9XRayBrs1002920643
Q9NP971z09XRayArs1003671
Q9NP972b95XRayArs1003681
Q9NP972e8jXRayArs1003671
Q9NP972hz5XRayArs1003671
Q930881lt7XRayArs10037809290
Q930881lt8XRayArs10037809290

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.