Detailed Documentation of Form and Scripts

Currently, on mangolassi the ccc.cgi and other scripts and files are here:

azurebrd/public_html/cgi-bin/forms/ccc

• accession
  • This is a file that maps WB WBPaper IDs to PMIDs.
  • For WB, this file is generated each time the search is performed.
• ccc_celegans_2013only
  • I believe these are old test files that can be deleted.
• ccc.cgi
  • This is the code for the curation form.
  • ccc.cgi Documentation
• ccc.js
  • This is the ccc form javascript code.
  • If we want to change the number of characters needed to begin autocomplete, we can do that here.
• c_elegans.WS234.xrefs.txt and c_elegans.WS236.xrefs.txt
  • These are files generated with each WB build that were used to create the WB gpi file.
• generate_gpi.pl
  • This is the script that will be used to manually generate a new gpi file for WB.
• jquery
  • This directory contains...
• notes
  • This file contains a short bit about mapping WBGene IDs to UniProtKB accessions for the gpi file.
• scripts
  • This directory contains:
    • accession file - This is a mapping file that contains the mappings between WBPaper IDs and PMIDs as well as TAIR doc IDs and PMIDs. Note that we need PMIDs to send annotations to Protein2GO.
    • create_ccc_pgcuration.pl - This perl script creates two postgres tables for a given Textpresso source file:

creates these two tables:

ccc_sentenceclassification
  ccc_mod text,
  ccc_file text,
  ccc_paper text, 
  ccc_section text,
  ccc_sentnum text, 
  ccc_sentenceclassification text,
  ccc_comment text,
  ccc_curator text, 
  ccc_timestamp text,

ccc_sentenceannotation
  ccc_mod text,
  ccc_file text,
  ccc_paper text,
  ccc_section text,
  ccc_sentnum text,
  ccc_geneproduct text,
  ccc_component text,
  ccc_goterm text,
  ccc_evidencecode text,
  ccc_with text,
  ccc_alreadycurated text,
  ccc_comment text,
  ccc_valid text,
  ccc_ptgoid text,
  ccc_curator text,
  ccc_timestamp

• • • create_ccc_pgindices.pl - This script creates the following two tables for each Textpresso source file:

ccc_geneprodindex

ccc_mod ccc_file ccc_paper ccc_section ccc_sentnum ccc_

ccc_timestamp worm    | 20130426_WB_ccc1        | PMID:23022657 | discussion      | 51          | ABI-1|WBGene00015146|UniProtKB:Q10929   MIG-10|WBGene00003243|UniProtKB:P34400  UNC-53|WBGene00006788|UniProtKB:C8JQR2&UniProtKB:G5EBX1&UniProtKB:G5EEU6&UniProtKB:Q7YSI9 | 2013-05-03 11:56:47.739088-07 Back to WormBase