[Bio] / FigKernelPackages / FIG.pm Repository:
ViewVC logotype

Diff of /FigKernelPackages/FIG.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.604, Mon Jul 9 19:23:32 2007 UTC revision 1.605, Mon Jul 16 16:34:29 2007 UTC
# Line 6042  Line 6042 
6042    }    }
6043    
6044    my $rdbH = $self->db_handle;    my $rdbH = $self->db_handle;
6045    my $relational_db_response = $rdbH->SQL("SELECT id, location, aliases, type, minloc, maxloc, assigned_function, made_by, quality FROM (SELECT id, location, aliases, type, minloc, maxloc FROM features LEFT OUTER JOIN deleted_fids ON features.id = deleted_fids.fid WHERE features.genome = '" . $genome . "' " . $contig_line . $minmax . "AND fid IS NULL) AS t1 LEFT OUTER JOIN assigned_functions on t1.id = assigned_functions.prot");    my $relational_db_response = $rdbH->SQL("SELECT id, location, aliases, type, minloc, maxloc, assigned_function, made_by, quality, subsystem FROM (SELECT id, location, aliases, type, minloc, maxloc FROM features LEFT OUTER JOIN deleted_fids ON features.id = deleted_fids.fid WHERE features.genome = '" . $genome . "' " . $contig_line . $minmax . "AND fid IS NULL) AS t1 LEFT OUTER JOIN assigned_functions on t1.id = assigned_functions.prot LEFT OUTER JOIN subsystem_index on t1.id = subsystem_index.protein");
6046    
6047    return $relational_db_response || ();    return $relational_db_response || ();
6048    

Legend:
Removed from v.1.604  
changed lines
  Added in v.1.605

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3