123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- <?php
- class data__protein_sequence extends ChadoField {
-
-
-
-
-
-
-
-
- public static $default_label = 'Protein Sequence';
-
- public static $description = 'polypeptide sequences.';
-
-
-
-
-
-
-
- public static $default_instance_settings = array(
-
- 'term_vocabulary' => 'data',
-
- 'term_name' => 'protein_sequence',
-
- 'term_accession' => '2976',
-
-
-
- 'term_fixed' => FALSE,
- );
-
-
- public static $download_formatters = array(
- 'TripalTabDownloader',
- 'TripalCSVDownloader',
- 'TripalProteinFASTADownloader',
- );
-
- public static $default_widget = 'data__protein_sequence_widget';
-
- public static $default_formatter = 'data__protein_sequence_formatter';
-
- public function elementInfo() {
- $field_term = $this->getFieldTermID();
- $info = array(
- $field_term => array(
- 'label' => 'Protein sequence',
- 'help' => 'The polypeptide sequence derived from mRNA',
- 'sortable' => FALSE,
- 'searchable' => FALSE,
- 'type' => 'xs:string',
- 'readonly' => FALSE,
- ),
- );
- return $info;
- }
-
- public function load($entity) {
- $field_name = $this->field['field_name'];
- $feature = $entity->chado_record;
- $num_seqs = 0;
-
- $entity->{$field_name}['und'][0] = array(
- 'value' => '',
- );
-
- $sql = "
- SELECT F.*
- FROM {feature_relationship} FR
- INNER JOIN {feature} F on FR.subject_id = F.feature_id
- INNER JOIN {cvterm} CVT on CVT.cvterm_id = F.type_id
- INNER JOIN {cvterm} RCVT on RCVT.cvterm_id = FR.type_id
- WHERE
- FR.object_id = :feature_id and
- CVT.name = 'polypeptide' and
- RCVT.name = 'derives_from'
- ORDER BY FR.rank ASC
- ";
- $proteins = chado_query($sql, array(':feature_id' => $feature->feature_id));
- while ($protein = $proteins->fetchObject()) {
- $entity->{$field_name}['und'][$num_seqs]['value'] = $protein->residues;
-
-
- $columns = get_object_vars($protein);
- foreach ($columns as $colname => $value) {
- $entity->{$field_name}['und'][$num_seqs]['chado-feature__' . $colname] = $value;
- }
- $num_seqs++;
- }
- }
- }
|