1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
:SELECT
feature.uniquename,
feature.name,
synonym.name
:FROM
feature
INNER JOIN cvterm AS ftype ON (feature.type_id = cvterm.name)
INNER JOIN feature_synonym USING (feature_id)
INNER JOIN synonym USING (synonym_id)
:WHERE
[feature.name = &name&]
[feature.uniquename = &uniquename&]
[synonyn.name = &synonym&]
[ftype.name = &type&]
:USE NESTING (set(feature(synonym)))
// -------------------------------------------
schema: chado
desc: feature name to synonym mapping
example_input: name => SELECT name FROM feature
|
