next up previous contents
Next: Query 5. Up: OPM Query Examples Previous: Query 3.

Query 4.

Retrieve attributes of all Maps containing the cytogenetic region q21-q31. This query involves looking for maps of chromosome 1 that contain (different) MapElements pointing to GenomicSegments q21 and q31. 

SELECT M(displayName, accessionID, units, objectClass, minCoord, maxCoord)
FROM M IN Map, 
     C IN M.chromosome[Chromosome]searchName,
     GS1 IN  M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName,
     GS2 IN  M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName
WHERE C = "1" AND GS1 = "q21" AND GS2 = "q31"
ORDER BY M.displayName;