Versions Compared

Old Version 1

changes.mady.by.user Robert Allaway

Saved on

compared with

New Version Current

changes.mady.by.user Robert Allaway

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


I’m doing table queries here to show my desired results, but in reality, the users would be working on the data portal and only have “search” surfaced to them - they wouldn’t be working with the table directly.

search term

actual results

what I was looking for

actual results

ipNF

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiaXBuZiJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQeyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclaXBuZiUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclaXBuZiUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQeyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiaXBuZiJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

cagg

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY2FnZyJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQeyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclY2FnZyUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclY2FnZyUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQeyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY2FnZyJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

corielle (this is a typo)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbGUifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0=eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbCJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbCJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQeyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiY29yaWVsbGUifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0=

biobank (the summary mentions “biospecimen and xenograft bank”)

https://www.synapse.org/Synapse:syn52694652/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUyNjk0NjUyIHdoZXJlIHN0dWR5SWQgPSAnc3luNDkzOTkwMiciLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

https://www.synapse.org/Synapse:syn52694652/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUyNjk0NjUyIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiYmlvYmFuayJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ

lambda (note, λ also doesn’t work because it’s too short)

https://www.synapse.org/Synapse:syn52694652syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoibGFtYmRhIn1dLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

90-8 (also tried 90.8)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIHdoZXJlIHJlc291cmNlTmFtZSBsaWtlICclOTAtOCUnIiwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiOTAtOCJ9XSwgImluY2x1ZGVFbnRpdHlFdGFnIjp0cnVlLCAibGltaXQiOjI1fQ==

NF1+/R1947X pigs (technically in the results, but nowhere near the top) or minipigs (no results)

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoiTmYxcEFyZzE5NDdtcDEifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0

https://www.synapse.org/Synapse:syn51730943/tables

https://www.synapse.org/Synapse:syn51730943/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUxNzMwOTQzIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuVGV4dE1hdGNoZXNRdWVyeUZpbHRlciIsICJzZWFyY2hFeHByZXNzaW9uIjoibWluaXBpZ3MifV0sICJpbmNsdWRlRW50aXR5RXRhZyI6dHJ1ZSwgImxpbWl0IjoyNX0

syn35632706

https://www.synapse.org/Synapse:syn16858331/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjE2ODU4MzMxIHdoZXJlIHByb2plY3RJZCA9ICdzeW4zNTYzMjcwNiciLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

https://www.synapse.org/Synapse:syn16858331/tables/#query/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjUyNjk0NjUyIHdoZXJlIHN0dWR5SWQgPSAnc3luNDkzOTkwMiciLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjE2ODU4MzMxIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuQ29sdW1uU2luZ2xlVmFsdWVRdWVyeUZpbHRlciIsICJ2YWx1ZXMiOlsic3luMzU2MzI3MDYiXSwgImNvbHVtbk5hbWUiOiJpZCIsICJvcGVyYXRvciI6IklOIn1dLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9