| Gene | |||||
|---|---|---|---|---|---|
| number INT |
name VARCHAR NOT NULL |
species VARCHAR NOT NULL |
chromosome VARCHAR |
first INT |
last INT |
| 1 | 'Son of sevenless' | 'Drosophila melanogaster' | 'II' | 123456 | 124891 |
| 24 | 'OB' | 'Homo sapiens' | '21' | 900001 | 899023 |
| 11 | 'OB' | 'Mus musculus' | '6' | NULL | NULL |
| 12 | 'Toll' | 'Drosophila melanogaster' | 'III' | 3049580 | 3049952 |
| Protein | |||||
|---|---|---|---|---|---|
| number INT |
name VARCHAR NOT NULL |
species VARCHAR |
gene INT FK* |
seqlength INT |
seq CLOB |
| 3 | 'leptin' | 'Homo sapiens' | 24 | 301 | ANCDTLKER... |
| 25 | 'myoglobin' | 'Mus musculus' | NULL | 158 | MHAGBQWTT... |
| 11 | 'peptide X341' | NULL | NULL | 13 | DFVLPQWDFGGGA |
FK* = Foreign key: column 'gene' refers to column 'number' in table 'Gene'.