Paper Tables in Postgres

List of Paper Tables in Postgres (Alphabetical)

pap_affiliation

Contains the affiliation (location) of one or more authors of the paper, meeting abstract, or gazette article

For papers, this table mostly contains legacy information that was imported from the CGC when WormBase starting curating paper data, as PubMed currently does not curate all author affiliations for papers.

For meeting abstracts and gazette articles, this table contains the full list of affiliations, but the affiliations are not mapped to specific individuals.

pap_author

Contains the author_id

pap_author_index

author_id as joinkey

pap_author_possible

author_id as joinkey

pap_author_sent

author_id as joinkey

pap_author_verified

author_id as joinkey