123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168 |
- <?php
- class data__sequence extends TripalField {
-
-
-
-
-
-
-
-
-
-
-
-
- public static $term = 'data:2044';
-
- public static $label = 'Sequence';
-
- public static $description = 'A field for managing nucleotide and protein residues.';
-
-
-
- public static $settings = array(
- 'chado_table' => '',
- 'chado_column' => '',
- 'base_table' => '',
- );
-
-
-
-
- public static $instance_settings = array();
-
-
- public static $storage = 'tripal_no_storage';
-
- public static $default_widget = 'data__sequence_widget';
-
- public static $default_formatter = 'data__sequence_formatter';
- /**
- * @see TripalField::load()
- */
- public function load($entity, $details = array()) {
- $field_name = $this->field['field_name'];
- $feature = $details['record'];
-
-
-
- if(strcmp($feature->type_id->name,'scaffold') != 0 and
- strcmp($feature->type_id->name,'chromosome') != 0 and
- strcmp($feature->type_id->name,'supercontig') != 0 and
- strcmp($feature->type_id->name,'pseudomolecule') != 0) {
- $feature = chado_expand_var($feature,'field','feature.residues');
- $entity->{$field_name}['und'][0]['value'] = $feature->residues;
- }
- /*
- $options = array(
- 'return_array' => 1,
- 'include_fk' => array(
- 'srcfeature_id' => array(
- 'type_id' => 1
- ),
- 'feature_id' => array(
- 'type_id' => 1
- ),
- ),
- );
- $feature = chado_expand_var($feature, 'table', 'featureloc', $options);
- $featureloc_sequences = $this->get_featureloc_sequences($feature->feature_id, $feature->featureloc->feature_id);
-
-
- $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
- INNER JOIN {featureloc} FL on FL.feature_id = F.feature_id
- WHERE
- FR.object_id = :feature_id and
- CVT.name = 'CDS' and
- RCVT.name = 'part_of'
- ORDER BY FR.rank ASC
- ";
- $results = chado_query($sql, array(':feature_id' => $feature->feature_id));
- $coding_seq = '';
- while ($CDS = $results->fetchObject()) {
- if ($CDS->residues) {
- $coding_seq .= $CDS->residues;
- }
- }
- if ($coding_seq) {
- $entity->{$field_name}['und'][$num_seqs++]['value'] = array(
- '@type' => 'SO:0000316',
- 'type' => 'coding_sequence',
- 'label' => 'Coding sequence (CDS)',
- 'defline' => tripal_get_fasta_defline($feature, 'CDS', NULL, '', strlen($coding_seq)),
- 'residues' => $coding_seq,
- );
- }
- foreach($featureloc_sequences as $src => $attrs){
-
-
-
-
-
-
-
- $entity->{$field_name}['und'][$num_seqs++]['value'] = array(
- 'residues' => $attrs['residues'],
- '@type' => 'SO:0000110',
- 'type' => 'sequence_feature',
- 'defline' => tripal_get_fasta_defline($feature, '', $attrs['featureloc'], 'CDS', strlen($attrs['residues'])),
- 'label' => 'Sequence from alignment at ' . $attrs['location'],
- );
-
- $cds_sequence = tripal_get_feature_sequences(
- array(
- 'feature_id' => $feature->feature_id,
- 'parent_id' => $attrs['featureloc']->srcfeature_id->feature_id,
- 'name' => $feature->name,
- 'featureloc_id' => $attrs['featureloc']->featureloc_id,
- ),
- array(
- 'derive_from_parent' => 1,
- 'aggregate' => 1,
- 'sub_feature_types' => array('CDS'),
- 'is_html' => 0
- )
- );
- if (count($cds_sequence) > 0) {
-
-
-
-
- if ($cds_sequence[0]['residues']) {
- $entity->{$field_name}['und'][$num_seqs++]['value'] = array(
- 'residues' => $cds_sequence[0]['residues'],
- '@type' => 'SO:0000316',
- 'type' => 'coding_sequence',
- 'defline' => tripal_get_fasta_defline($feature, '', $attrs['featureloc'], 'CDS', $cds_sequence[0]['length']),
- 'label' => 'Coding sequence (CDS) from alignment at ' . $attrs['location'],
- );
- }
- }
- } */
- }
- }
|