Difference between revisions of "Paper Tables in Postgres"

From WormBaseWiki
Jump to navigationJump to search
Line 45: Line 45:
 
Contains one of five values for information on how the paper should be treated in subsequent pipelines, RNAi data, and the status of the gene-paper associations.
 
Contains one of five values for information on how the paper should be treated in subsequent pipelines, RNAi data, and the status of the gene-paper associations.
  
functional_annotation
+
functional_annotation - this tag is placed on papers that are used to compose concise descriptions, but for which there is no curatable ''C. elegans'' data.
  
genestudied_done
+
genestudied_done - this tag is placed on papers when the gene-paper associations are complete.
  
Phenotype2GO
+
Phenotype2GO - this tag is placed on papers that will be used to create Phenotype2GO annotations.
  
 
rnai_curation
 
rnai_curation

Revision as of 15:22, 2 May 2011

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

pap_contained_in

Contains the WBPaper IDs for books in which book chapters are found.

pap_contains

Currently empty. May be able to delete.

Information is already found in the pap_contained_in table.

pap_curation_flags

Contains one of five values for information on how the paper should be treated in subsequent pipelines, RNAi data, and the status of the gene-paper associations.

functional_annotation - this tag is placed on papers that are used to compose concise descriptions, but for which there is no curatable C. elegans data.

genestudied_done - this tag is placed on papers when the gene-paper associations are complete.

Phenotype2GO - this tag is placed on papers that will be used to create Phenotype2GO annotations.

rnai_curation

rnai_int_done


Back to Paper Pipeline