Entering WBG Articles
Entering WBG Article into Postgres
We would like to enter WBG articles to postgres as soon as they become available on line so they can be incorporated into WormBase as WBPapers.
- Check abstract titles, authors, and affiliations for special characters (e.g. vowels with accents) and convert them to standard characters, since ACeDB doesn't allow special characters.
- Articles can be read into the development database and checked using the paper editor on mangolassi.caltech.edu
General File Format
Here is a general file format for uploading to postgres, followed by a specific example.
Note that for WBG articles, there are some values that do not change, e.g. Status (Valid), Type (Gazette_article), Journal (Worm Breeder's Gazette), and Primary_data (not_designated). Also, the identifiers are created according to the information in the volume, number, and page. These special fields are italicized below.
Identifier wbg.nn.n.nnnn (where n = a number)
Status Valid
Title First letter capitalized
Journal Worm Breeder's Gazette
Volume nn (where n = a number) We currently don't have a field for number in postgres, so could we create Volume numbers that are 18.2 or 18.3 using information from the Number of the latest Gazette issue? --K.)
Year 20nn (where n = a number)
Month nn (where n = a number)
Page n or nn (where n = a number)
Author listed as Last Name, First Name//Last Name, First Name//Last Name, First Name etc.
Affiliation list all affiliations We need to check for cases where there are multiple affiliations and add them all. Comma separate? --K.)
URL - corresponds to the URL of the article in the PDF document
Type Gazette_article
Primary_data not_designated
Specific Example
A specific example with all information dispayed:
Identifier wbg18.2.0002
Status Valid
Title Antibiotic markers for rapid selection and easy maintenance of transgenic nematodes
Journal Worm Breeder's Gazette
Volume 18
Year 2010
Month 06
Page 2
Author Giordano-Santini, Rosina//Semple, Jennifer//Dupuy, Denis//Lehner, Ben
Affiliation Genome Regulation and Evolution, Inserm Unit 869, and Institut Europeen de Chimie et Biologie, Bordeaux, France
URL http://www.wormbook.org/wbg/volumes/volume-18-number-2/pdf/wbg-volume-18-number-2.02.pdf
Type Gazette_article
Primary_data not_designated
Back to Paper Pipeline