TBroTeam / TBro

Visualization and management of denovo transcriptomes
https://tbroteam.github.io/TBro/
10 stars 6 forks source link

Add db alias and db description to quick search #34

Closed fbemm closed 8 years ago

fbemm commented 8 years ago

Laura DeMare from Genome Research requested to include the alias (synonym) and the description of unigenes/isogorms to be indexed and searchable. Would be great if we can get this done. Would make things easier for people that search for their favorite gene. In parallel we should add a descriptive page to TBro that explains what annotation comes from where and how reliable it is.

greatfireball commented 8 years ago

Index means creating a database index (which might not be verified by any reviewer and has only impact on search speed) or creating of a special index page listing all alias and makes no sense for descriptions.

greatfireball commented 8 years ago

For the second issue "Description page" I created another issue #35

Therefore this issue should only cover the search part of @fbemm request.

iimog commented 8 years ago

The db name (fullname) is already searched for in the quicksearch, the description can be included as well. It might slow down the search but I will try. As for the index I need further clarification.

iimog commented 8 years ago

I extended the search on the description field. screenshot_desc screenshot_syn

I further expanded the expression to allow matches that are not at the beginning of the string. Performance does not seem to be impacted too much (the LIMIT in the SQL statement prevents overly long execution times).

@fbemm please confirm that the issue is thereby resolved or specify what else has to be done. As soon as I have your go I will apply the changes on the production machine (for now I have them only locally)

fbemm commented 8 years ago

Looks good! +1