Phenotype Table |
|---|
r_id
|
p_id
|
quality
|
role
|
entity
|
qualifier
|
|---|
0 | 0 | red PATO:0000322 | Â | eye MA:000261 | Â |
1 | 1 | concentration of PATO:0000033 | concentrator
N/A
| spleen MA:0000141 | abnormal PATO:0000460 |
2 | 1 | concentration of PATO:0000033 | concentrated
N/A
| iron CHEBI:18248 | abnormal PATO:0000460 |
3 | 2 | increased concentration PATO:0001162 | concentrator
N/A
| spleen MA:0000141 | Â |
4 | 2 | increased concentration PATO:0001162 | concentrated
N/A
| iron CHEBI:18248 | Â |
- Tables 2-4 form an integrated set of database tables, as an example of one implementation option for annotation databases. The present table stores pure phenotype descriptions. It supports non-relational and relational qualities, in the latter case of arbitrary arity and role type. For this purpose, role types do not correspond to columns (attributes) of the table, but they are stored in rows. Rows of a single phenotype description have the same phenotype identifier assigned to them. The sample entries repeat examples of the main text (with natural language terms for readability), but are arbitrary otherwise.
- Abbreviations: r_id: row identifier, p_id: phenotype identifier, N/A: not available. Empty positions are to be read as null values.
