...
Looking at this specific link, that page is driven off this row. Note the query was generated by adding a clause from the URL parameter Study=syn5550419
to the studies table - SELECT * FROM syn17083367 where Study = 'syn5550419'
To see the actual portals code which configures this page, see here.
...