mysql> SELECT g.name, d.description, a.region FROM ass AS a INNER JOIN genome AS g ON a.genome=g.genome INNER JOIN des AS d on a.sf = d.id WHERE a.genid="hs_ENSP00000380309";
+-----------------------------------------------------------------+-----------------------------------+-----------------+
| name | description | region |
+-----------------------------------------------------------------+-----------------------------------+-----------------+
| <i>Homo sapiens</i> <release>47_36i</release> (all transcripts) | ARM repeat | 7-577 |
| <i>Homo sapiens</i> <release>47_36i</release> (all transcripts) | Clathrin adaptor appendage domain | 615-632,662-784 |
+-----------------------------------------------------------------+-----------------------------------+-----------------+