Automated Retrieval of Citations

This project will involve two major steps. The first step is to simply add a column to what is labeled as table4. For each protein in table 4, please use its name to search for a match in the [login to view URL] table (note there are 3 sheets in this workbook). Simply take the first match, it does not need to be an exact match but should contain the word. Once a match is found, please place the Genbank number in the final column of table 4. For the second phase of the project, you will use only Table 4. For each Genbank number in project 4, search it against the a publicly available web-based database. Use the following URL: [login to view URL] In this example, the number "76647810" is the Genbank ID being searched. It will retrieve a new number that begins with XP_ or NP_, take this entire number, record it in a new column in the spreadsheet and then search that number against this URL: [login to view URL] note that "NP_001103469" is the new number to be searched. In the record retrieved, please look on this page for a tag called PUBMED. It will have a number next to it. In retrieving the records, a PUBMED tag can have several numbers or no tag may exist at all. Please retrieve up to three of these and place them in another column in the spreadsheet (table 4). Finally, for each pubmed number, place it into the following URL: [login to view URL] Then, put the following information into the spreadsheet (use the example search result here to understand the fields) journal: Biol Chem year: 2006 title: Molecular identification and pharmacological profile of the bovine kinin B1 receptor. abstract: To support the study of kinin pharmacology... This process will be done for up to three PUBMED IDs per protein ID. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Any