Correlation between cation disorder and flux pinning in the YBa2Cu3O7 coated conductor