genome - scale experiments have accumulated massive information over recent years and have greatly contributed to our understanding of gene expression and its regulatory mechanisms .
these experiments have clearly revealed the ubiquitous nature of alternative splicing and isoform dosage effects ( 1,2 ) .
it is in this regard key to perform precise , quantitative measurements of selected genes and transcripts to assess specific expression patterns or functions .
such experiments typically involve the quantitative real - time polymerase chain reaction ( qpcr ) , and the value of these qpcr assays depends in large part on the quality of the selected primer pair for the respective , targeted transcription unit ( 3 ) .
we have therefore undertaken the systematic design of primer pairs for every known gene and transcript for organisms with well - annotated genome references with in silico verification of optimal specificity .
the design of these primer pairs follows the pipeline described in ( 4 ) , which we briefly recall here : for designing gene- or transcript - specific primers pairs , exon junctions that are included in respectively the largest or smallest number of isoforms for each gene are first identified after which the corresponding transcript is processed with perlprimer ( 5 ) for the best primer set that overlaps these junctions .
candidate primers are then filtered according to ( i ) genome - wide specificity ( running blast with an e - value of 100 ) and ( ii ) not spanning 5 or 3 untranslated regions ( utr ) , as well as ranked according to the number of isoforms they cover , amplicon length , and other primer quality parameters that were previously discussed ( 3,4 ) .
the top three primer pairs are then retained and displayed in the database with a star - based quality flag corresponding to the rank in this list .
if no pair passes the filters , then the original primer design constraints are progressively relaxed until a candidate pair emerges , hence the warnings associated with some primers ( the  warnings column that can be observed in figure 1 ) .
the figure shows  several of the 30 primer pairs found for human gene mdm1 .
the search is restricted to an organism , ensemble release , and a maximum number of lines ( the smaller the number , the faster the query ) .
each result line corresponds to a single primer pair , and displays its unique i d , the gene , and transcript(s ) it targets , its star - based rank ( among the best three pairs found for the gene ) , the fraction of isoforms it covers , the amplicon length , the primer sequences and their respective melting temperatures , and the ensembl annotation for the gene ( known or novel ) .
the last two columns provide respectively warnings if the primer search did not work with standard parameters and a link to a primer pair - specific page shown in figure 3 .
since its inception in 2011 , the database has been used continuously and access statistics show a large user base .
for example , the getprime web interface received nearly 1800 visits ( by 1000 users ) over the first 6 months of 2016 alone .
individual users also provided constructive feedback to further improve getprime , which in large part prompted the major update of the database ( 2.0 ) that is presented here .
getprime 2.0 cross - references a number of data sources to document gene structures , transcript sequences , genome sequences , and annotated variants .
the database now incorporates data from three versions of ensembl ( 6 ) : 50 ( july 2008 ) , 61 ( february 2011 ) , and 81 ( july 2015 ) .
this is to keep backward compatibility with the first release of getprime , while updates will be performed on a regular basis .
thanks to the uniform structure of the ensembl database for various species , we can now easily select additional species and we currently host yeast , chicken , macaque , chimpanzee , rat , platypus , pufferfish , and anolis carolinensis next to the previously established primers pairs for human , mouse , zebrafish , fly , and worm . compared to version 1.0 ( 4 ) , the database schema has been re - designed to improve the speed of queries via the web user interface and to provide two new interaction modes : a batch download capability and a programmatic interface ( restful api ) .
the user interface of getprime 2.0 has been re - designed to make it faster , friendlier , and richer .
it is based on a new 3-tier ruby on rails ( ror ) ( http://rubyonrails.org ) application . among many other features ,
this framework improves the efficiency of database queries and simplifies the rendering on web pages .
it also implements a restful api that allows programmers to access the data directly ( see documentation at http://bbcftools.epfl.ch/getprime/api_documentation ) .
a new search engine allows searching by gene name , ensembl gene i d or transcript i d or directly by the internal primer pair i d ( figure 1 ) .
the search box accepts up to 10 identifiers per search . when only one identifier is provided and does not match perfectly , a regular expression search is performed .
this search tool uses the jquery ( mostly the ajax method ) and datatables.js javascript libraries .
the ajax technology is used to update portions of the web pages following user selections without reloading the whole page .
primers are linked to a view in the ucsc genome browser ( 7 ) where they are displayed in their genomic context . in the ucsc view ,
primer pairs are identified by a unique numeric i d , by the gene and transcript they target , and by their rank in the list of candidates ( figure 2 ) .
this ucsc display is generated by uploading a single custom track ( as a bed file ) generated for each organism and ensembl version .
the bed file can be directly downloaded as well as the full database as tab - separated files .
each primer pair is clickable and linked back to the getprime website , and more specifically to the page containing details about the primer .
for example , next to the position in the genome of the primer sequences , the position and the length of the introns are reported when applicable .
the ucsc view of getprime 2.0 primer pairs . the two primers ( in black ) of each pair are displayed as thick bars connected by thin arrows revealing on which strand the pair of primers will amplify dna .
they are also mapped to their genomic coordinates , including the intron(s ) that each primer potentially spans . in this example
for the first three , both forward and reverse primers span an intron , whereas for the three other pairs , only the reverse primer spans an intron .
note that the format of the displayed identifier is the following : getprimeid|ensembl - gene - id_getprime - rank ( e.g. 2111376|ensg00000111554_3 ) and that the other primer pairs for mdm1 are not visible within this screenshot .
our knowledge of genomic variation within species and how such variants drive molecular and organismal diversity is rapidly increasing ( 812 ) .
one of the benefits of these advances is that we are now able to incorporate variant information ( when available ) in genomic experiments since such genetic variants may be an important source of experimental variability or even failure ( 13,14 ) .
thus , to reduce experimental error , we decided to start displaying the presence of known snps within the getprime 2.0 primers to aid users in the design and interpretation of their experiments .
so far , we were able to cover snps for human and mouse by importing them from dbsnp v145 ( 15 ) and to map these snps to the primers that overlap them .
corresponding positions in the primer sequences are then highlighted ( figure 3 ) and a link to the dbsnp - based evidence allows a more detailed evaluation of the nature and relevance of the polymorphism(s ) .
all information about one particular primer pair is summarized in this page : gene and transcript ids , getprime warnings , and detailed information about each forward and reverse primer . particularly relevant are the indication of snp positions ( in red ) and whether a primer spans an intron as well as the ucsc display link .
the getprime 2.0 database currently contains a total of 1 175 874 primer pairs ( 444 256 in human , 268 855 in mouse ) , corresponding to an average of six pairs per covered gene ( across 13 species ) . in human , there are more than 20 pairs per gene and 12 in mouse . on average , 92% of ensembl
protein - coding genes are covered by our database , the remainder corresponding to non - unique sequences for which specific primers could not be designed ( table 1 ) .
however , some species are still only partially covered due to differences in the ensembl annotation compared to the human database . in particular , for a.carolinensis or macaque , only a fraction of the annotated genes were processed in the pipeline ( table 1 ) .
moreover , the incomplete status of the macaque assembly led to a high failure rate of the pipeline probably due to the repetitive nature of unassembled contigs ( table 1 ) .
a total of 2 864 885 variants were mapped to human primers ( 492 968 in mouse ) , indicating that more than 80% of human primers overlap a documented variant , with an average of about three snps per primer .
getprime 2.0 cross - references a number of data sources to document gene structures , transcript sequences , genome sequences , and annotated variants . the database now incorporates data from three versions of ensembl ( 6 ) : 50 ( july 2008 ) , 61 ( february 2011 ) , and 81 ( july 2015 ) .
this is to keep backward compatibility with the first release of getprime , while updates will be performed on a regular basis .
thanks to the uniform structure of the ensembl database for various species , we can now easily select additional species and we currently host yeast , chicken , macaque , chimpanzee , rat , platypus , pufferfish , and anolis carolinensis next to the previously established primers pairs for human , mouse , zebrafish , fly , and worm . compared to version 1.0 ( 4 ) , the database schema has been re - designed to improve the speed of queries via the web user interface and to provide two new interaction modes : a batch download capability and a programmatic interface ( restful api ) .
the user interface of getprime 2.0 has been re - designed to make it faster , friendlier , and richer .
it is based on a new 3-tier ruby on rails ( ror ) ( http://rubyonrails.org ) application . among many other features ,
this framework improves the efficiency of database queries and simplifies the rendering on web pages .
it also implements a restful api that allows programmers to access the data directly ( see documentation at http://bbcftools.epfl.ch/getprime/api_documentation ) .
a new search engine allows searching by gene name , ensembl gene i d or transcript i d or directly by the internal primer pair i d ( figure 1 ) .
the search box accepts up to 10 identifiers per search . when only one identifier is provided and does not match perfectly , a regular expression search is performed .
this search tool uses the jquery ( mostly the ajax method ) and datatables.js javascript libraries .
the ajax technology is used to update portions of the web pages following user selections without reloading the whole page .
primers are linked to a view in the ucsc genome browser ( 7 ) where they are displayed in their genomic context . in the ucsc view ,
primer pairs are identified by a unique numeric i d , by the gene and transcript they target , and by their rank in the list of candidates ( figure 2 ) .
this ucsc display is generated by uploading a single custom track ( as a bed file ) generated for each organism and ensembl version .
the bed file can be directly downloaded as well as the full database as tab - separated files .
each primer pair is clickable and linked back to the getprime website , and more specifically to the page containing details about the primer .
for example , next to the position in the genome of the primer sequences , the position and the length of the introns are reported when applicable .
the two primers ( in black ) of each pair are displayed as thick bars connected by thin arrows revealing on which strand the pair of primers will amplify dna .
they are also mapped to their genomic coordinates , including the intron(s ) that each primer potentially spans . in this example
for the first three , both forward and reverse primers span an intron , whereas for the three other pairs , only the reverse primer spans an intron .
note that the format of the displayed identifier is the following : getprimeid|ensembl - gene - id_getprime - rank ( e.g. 2111376|ensg00000111554_3 ) and that the other primer pairs for mdm1 are not visible within this screenshot .
our knowledge of genomic variation within species and how such variants drive molecular and organismal diversity is rapidly increasing ( 812 ) .
one of the benefits of these advances is that we are now able to incorporate variant information ( when available ) in genomic experiments since such genetic variants may be an important source of experimental variability or even failure ( 13,14 ) .
thus , to reduce experimental error , we decided to start displaying the presence of known snps within the getprime 2.0 primers to aid users in the design and interpretation of their experiments .
so far , we were able to cover snps for human and mouse by importing them from dbsnp v145 ( 15 ) and to map these snps to the primers that overlap them .
corresponding positions in the primer sequences are then highlighted ( figure 3 ) and a link to the dbsnp - based evidence allows a more detailed evaluation of the nature and relevance of the polymorphism(s ) .
all information about one particular primer pair is summarized in this page : gene and transcript ids , getprime warnings , and detailed information about each forward and reverse primer . particularly relevant are the indication of snp positions ( in red ) and whether a primer spans an intron as well as the ucsc display link .
the getprime 2.0 database currently contains a total of 1 175 874 primer pairs ( 444 256 in human , 268 855 in mouse ) , corresponding to an average of six pairs per covered gene ( across 13 species ) . in human , there are more than 20 pairs per gene and 12 in mouse . on average , 92% of ensembl protein - coding genes
are covered by our database , the remainder corresponding to non - unique sequences for which specific primers could not be designed ( table 1 ) .
however , some species are still only partially covered due to differences in the ensembl annotation compared to the human database . in particular , for a.carolinensis or macaque , only a fraction of the annotated genes were processed in the pipeline ( table 1 ) . moreover , the incomplete status of the macaque assembly led to a high failure rate of the pipeline probably due to the repetitive nature of unassembled contigs ( table 1 ) .
regarding polymorphisms , a total of 2 864 885 variants were mapped to human primers ( 492 968 in mouse ) , indicating that more than 80% of human primers overlap a documented variant , with an average of about three snps per primer .
the steady access statistics of the getprime database are a testimony that the embedded primer information is useful and the release of getprime 2.0 responds to user feedback that we have received , namely : update the genomic data , extend to new species , and cross - reference new types of genomic data ( polymorphisms ) .
our plan for the future is to maintain the availability of the database , keep it up - to - date and add new species when possible .
in addition , we intend for getprime to closely follow and reflect the growth of genomic data resources at ensembl and elsewhere . one additional important aspect would be a broader experimental validation of our in silico - designed primers .
we intend to implement a system that would allow the flagging of primers that have been successfully ( or possibly even unsuccessfully ) used in experiments , including links to the respective papers .
swiss national science foundation grant [ # 31003a_162735 to b.d . ] ; sybit project of systemsx.ch ( to j.r . ) ; swiss federal institute of technology in lausanne ( epfl ) . the open access publication charge for this paper has been waived by oxford university press  nar editorial board members are entitled to one free paper per year in recognition of their work on behalf of the journal .
 getprime ( http://bbcftools.epfl.ch/getprime ) is a database with a web frontend providing gene- and transcript - specific , pre - computed qpcr primer pairs . 
 the primers have been optimized for genome - wide specificity and for allowing the selective amplification of one or several splice variants of most known genes . to ease selection , 
 primers have also been ranked according to defined criteria such as genome - wide specificity ( with blast ) , amplicon size , and isoform coverage . here , 
 we report a major upgrade ( 2.0 ) of the database : eight new species ( yeast , chicken , macaque , chimpanzee , rat , platypus , pufferfish , and anolis carolinensis ) now complement the five already included in the previous version ( human , mouse , zebrafish , fly , and worm ) . 
 furthermore , the genomic reference has been updated to ensembl v81 ( while keeping earlier versions for backward compatibility ) as a result of re - designing the back - end database and automating the import of relevant sections of the ensembl database in species - independent fashion . 
 this also allowed us to map known polymorphisms to the primers ( on average three per primer for human ) , with the aim of reducing experimental error when targeting specific strains or individuals . 
 another consequence is that the inclusion of future ensembl releases and other species has now become a relatively straightforward task . 
INTRODUCTION
Data integration
User interface
Sequence polymorphisms
Database content
CONCLUSION AND PERSPECTIVE
FUNDING