File: feature.sqlapi

package info (click to toggle)
libchado-perl 1.23-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 23,976 kB
  • ctags: 10,378
  • sloc: xml: 192,540; sql: 165,945; perl: 28,339; sh: 101; python: 73; makefile: 46
file content (8 lines) | stat: -rw-r--r-- 550 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
 
IMPORT get_organism_id(TEXT) FROM organism;
IMPORT get_feature_type_id(TEXT) FROM 'sequence-cv-helper';

DECLARE FUNCTION get_feature_id(uniquename VARCHAR,
                                type       VARCHAR,
                                organism   VARCHAR) RETURNS INT;
COMMENT ON FUNCTION get_feature_id(VARCHAR,VARCHAR,VARCHAR) IS 'returns feature_id based on uniquename type organism. Type is assumed to be from sequence ontology. Organism is a binomial string';
EXAMPLE SELECT get_feature_id('2L','chromosome_arm','Drosophila melanogaster');