(New page: The formats for the tables which record the tissue information can be found below. Any changes to how data is stored will also be listed here. == Table Names == All tissue data is contai...) |
|||
Line 2: | Line 2: | ||
== Table Names == | == Table Names == | ||
- | All tissue data is contained in | + | All tissue data is contained in fourteen tables. A summary table called '''BTO_ids''' contains summary information about each release of information such as release number, release date and a short description. The other fourteen tables correspond to the fourteen tissue types, and are named accordingly. |
== Data Format == | == Data Format == | ||
The tables listed below have the following columns, in the order presented. | The tables listed below have the following columns, in the order presented. | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
Line 35: | Line 19: | ||
|BTO_id | |BTO_id | ||
|Text < 256 characters | |Text < 256 characters | ||
- | |||
- | |||
- | |||
- | |||
|Always Present | |Always Present | ||
|- | |- | ||
Line 47: | Line 27: | ||
|release_date | |release_date | ||
|date as YYYY-MM-DD | |date as YYYY-MM-DD | ||
- | |||
- | |||
- | |||
- | |||
|Always Present | |Always Present | ||
|- | |- | ||
Line 64: | Line 40: | ||
{|border="1" cellspacing="0" cellpadding="3" align="center" | {|border="1" cellspacing="0" cellpadding="3" align="center" | ||
- | |+''' | + | |+All '''tissue''' tables |
!Column Name | !Column Name | ||
!Data Type | !Data Type | ||
Line 76: | Line 52: | ||
|non-negative integer | |non-negative integer | ||
|Always present | |Always present | ||
- | |||
- | |||
- | |||
- | |||
|- | |- | ||
|HGNC | |HGNC | ||
Line 97: | Line 69: | ||
|Always Present | |Always Present | ||
|- | |- | ||
+ | |min_expect | ||
+ | |floating point number | ||
+ | |Always Present | ||
+ | |- | ||
+ | |max_expect | ||
+ | |floating point number | ||
+ | |Always Present | ||
+ | |- | ||
+ | |count | ||
+ | |non-negative integer | ||
+ | |Always Present | ||
|} | |} |
The formats for the tables which record the tissue information can be found below. Any changes to how data is stored will also be listed here.
All tissue data is contained in fourteen tables. A summary table called BTO_ids contains summary information about each release of information such as release number, release date and a short description. The other fourteen tables correspond to the fourteen tissue types, and are named accordingly.
The tables listed below have the following columns, in the order presented.
Column Name | Data Type | Notes |
---|---|---|
BTO_id | Text < 256 characters | Always Present |
release_id | non-negative integer | Always Present |
release_date | date as YYYY-MM-DD | Always Present |
tissue_type | Text <= 50 characters | Always Present |
Column Name | Data Type | Notes |
---|---|---|
ENSEMBL | text <= 40 characters | Always Present |
release_id | non-negative integer | Always present |
HGNC | text <= 30 characters | Always Present |
Entrez_ID | non-negative integer | |
Uniprot | text <= 15 characters | Always Present |
description | text | Always Present |
min_expect | floating point number | Always Present |
max_expect | floating point number | Always Present |
count | non-negative integer | Always Present |