WELCOME TO THE MSU PRP DATABASE QUERY PROJECT

If you already know what you are doing then go to querying the DB, Otherwise read on

HOW TO USE THE DATABASE

The Database consists primarily of three tables

QTL : This table contains all the necessary information from the statistical analysis of the eQTL data.

Array Annotation : This table contains information about the annotation for the transcripts used in the study. You can choose the any of the fields listed below. Fields in Blue can also be restricted by the criteria you choose. Click on the fields to get more information on how to do this

Oligo ID

HGNC

Well Plate

Block

Column

Row

Contig ID

Oligo Sequence

Gene ID

Flanking Marker Information : This table contains information about the closest flanking markers for the QTL under consideration. You can request for previous, post or both of the closest flanking markers. The fields in this table are enumerated below. To see how to restrict your search between two flanking markers click on either of the fields below.

Flanking Marker Previous

Flanking Marker Post

Select one or more of the tables depending on the information that you would like query for. Within each table selection, you are allowed to select any combination of fields. Additionally, a particular selection criteria for the fields selected can be imposed if the criteria box exists e.g. you can select for all records with p-values < 0.05. If you have no clue about what the fields represent details of the fields and how to select for each table are given below.

QTL Table Field Descriptions

1. Gene ID

2. Chromosome

3. Position

4. Marker Interval

5. Log Ratio (Duroc/Pietrain)

6. pvalue

7. -log10(pvalue)

8. Global Q-value

9. Peak

10. Absolute Position

Array Annotation Table Field Descriptions

1. Oligo ID

2. HGNC

3. Well Plate

4. Block

5. Column

6. Row

7. Contig ID

8. Oligo Sequence

9. Gene ID

Flanking Marker Information Table Field Descriptions

1. Flanking Marker Previous

2. Flanking Marker Post