/
Examples of Limitations of Table Search

Examples of Limitations of Table Search

The purpose of this article is to provide examples “failed” search terms in table search as of late 2024, focusing on a MySQL FTS-backed service. In these cases, we know there is a target result we know exists and want to find.


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

what I was looking for

actual results

search term

what I was looking for

actual results

ipNF

Resource_CellLine_AnimalModel_GeneticReagent_Antibody_Biobank_Devel...

 

Resource_CellLine_AnimalModel_GeneticReagent_Antibody_Biobank_Devel...

cagg

Resource_CellLine_AnimalModel_GeneticReagent_Antibody_Biobank_Devel...

Resource_CellLine_AnimalModel_GeneticReagent_Antibody_Biobank_Devel...

corielle (this is a typo)

Resource_CellLine_AnimalModel_GeneticReagent_Antibody_Biobank_Devel...

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

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:syn51730943/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/eyJzcWwiOiJTRUxFQ1QgKiBGUk9NIHN5bjE2ODU4MzMxIiwgImFkZGl0aW9uYWxGaWx0ZXJzIjpbeyJjb25jcmV0ZVR5cGUiOiJvcmcuc2FnZWJpb25ldHdvcmtzLnJlcG8ubW9kZWwudGFibGUuQ29sdW1uU2luZ2xlVmFsdWVRdWVyeUZpbHRlciIsICJ2YWx1ZXMiOlsic3luMzU2MzI3MDYiXSwgImNvbHVtbk5hbWUiOiJpZCIsICJvcGVyYXRvciI6IklOIn1dLCAiaW5jbHVkZUVudGl0eUV0YWciOnRydWUsICJsaW1pdCI6MjV9

 

Related content

Table Search Options
Table Search Options
More like this
LLM integration with the Synapse API
LLM integration with the Synapse API
Read with this
Tips for Search
More like this
Full Text Search Integration
Full Text Search Integration
More like this
Sample Data
Sample Data
More like this