i2b2 on Genomics Data
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When one queries by dbSNP rs identifier, an example SQL query looks like:

 

Code Block
languagesql
themeEclipse
titleExample rs identifier SQL query
select count(distinct patient_num)

...


  from observation_fact

...


  where contains(observation_blob, 'FAM148 AND (stop_loss OR missense)')

 

When one queries by gene name, an example SQL query looks like:

 

...

Code Block
languagesql
themeEclipse
titleExample gene name SQL query
select count(distinct patient_num)

...


  from observation_fact

...


  where contains(observation_blob, 'rs183605470 AND heterozygous')