Off topic:Basic Queries Using Ucsc Table Browser
0
1
Entering edit mode
13.2 years ago
User 6659 ▴ 970

Hello

This is a very practical question. I've been looking at the UCSC browser and going through some online tutorials. However I couldn't see how to do something like get the human SNPs in dbSNP, say dbSNP 131, that have a link to an OMIM entry.

There was no field to filter on the dbSNP table relating to OMIM. I also couldn't find an annotation track for OMIM SNPs to overlap with all SNPs

This seemed quite a simple thing so I assumed I must be taking the wrong approach.

Edit - I am not specifically looking to answer this biological question (get the snps associated with a disease) but I was curious as to why i couldn't answer this question using the table browser. It turns out you have know what tables are related to the 'known gene' table that contain the information pertaining to OMIM. How do you find the tables that might contain the information you want? Do you have to look at the database schema to find tables whose names contain words relevant to information you are interested in. So if i wanted to get GO terms i would look for table names containing GO. Is there some crucial document that I am missing such as a schema description.

I'm also not sure how you know if the data you want is in an annotation track or a table.

thanks

ucsc • 2.1k views
ADD COMMENT
This thread is not open. No new answers may be added
Traffic: 1799 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6