next up previous contents
Next: Query 4. Up: OPM Query Examples Previous: Query 2.

Query 3.

Retrieve attributes of all Linkage and Cytogenetic Maps containing MapElements associated with GenomicSegments CFTR and DMD.

SELECT M(displayName, accessionID, units, objectClass, minCoord, maxCoord)
FROM M IN Map, 
     GS1 IN  M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName,
     GS2 IN  M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName,
     OC IN M.objectClass
WHERE GS1 ="cftr" AND GS2 ="dmd"
  AND OC IN { "string", "LinkageMap", "CytogeneticMap" }
ORDER BY M.displayName;

The comment for query 2 above also applies to query 3.