System Resources Source Organism

• List of all Organisms for which gene models may be loaded into database.

• Fields

• Add New Source Organism
• Remove Rows
• Undo
• Load Source Organism File
• Save Source Organism File
• Save Source Organism
• Close Source Organism
• Refresh Source Organism
• View NCBI URL

• General Comments
• See Also

Fields

• Src No is the unique database number in a Sesame instance for the Source Organism.
• Genus is the genus of the Source Organism.
• Species is the species of the Source Organism.
• Strain is the strain of the Source Organism.
• NCBI tax. ID is the unique NCBI taxonomy ID for the Source Organism.

Add New Source Organism

This adds a new row to the Source Organism resource table.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Add New Source Organism.

Note

• The table must be saved before changes in the database occur.

Remove Rows

This removes the selected rows from the Source Organism resource table.

1. Make the Source Organism window active in the Board.
2. Select one or more rows in the table.
3. On the Source Organism menu click Remove Rows.

Note

• The table must be saved before changes in the database occur.

Undo

This cancels the last change to the Source Organism resource table.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Undo.

Note

• The table must be saved before changes in the database occur.

Load Source Organism File

This loads a comma separated value file and adds the data to the Source Organism resource table.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Load Source Organism File.
3. In the folder list, locate and open the folder that contains the file.
4. Click the file, and then click Open.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.
• To see the exact file format, do a save file for a table with entries.
• The data in the table will be replaced with the data in the file.
• Src No must be 0 (zero) for new Source Organisms, i.e. those that are not in the table already.
• The table must be saved before changes in the database occur.

Save Source Organism File

This saves the Source Organism resource table as a comma separated value file.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Save Source Organism File.
3. If you want to save the file in a different folder, locate and open the folder.
4. In the File Name box, type a name for the file.
5. Click Save.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.

Save Source Organism

This saves the Source Organism in the database.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Save Source Organism, or click the Save Source Organism button in the button bar.

Note

• This will replace the information for the current Source Organism in the database.

Close Source Organism

This closes the window.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Close Source Organism, or click the X button on the window's Title bar.

Note

• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

Refresh Source Organism

This reverts the data for the Source Organism to the version in the database.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click Refresh Source Organism.

Note

• This will reload the Source Organism from the database.
• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

View NCBI URL

This will display the NCBI web page for the selected Source Organism in a browser.

1. Make the Source Organism window active in the Board.
2. On the Source Organism menu click View NCBI URL.

Note

• NCBI home page
  

General Comments

• To open the system Source Organism window in the Board, on the Options menu select System Resources then click Source Organism.
• To make the Source ORganism window active if it is already in the Board, on the Board's Window menu click Source Organism, or click on the Source Organism window's Title bar.
• This System Resource is maintained by a Sesame user, usually a Sesame administrator, with a Can Do privilege.
• To give the Can Do privilege for this resource to user JoeSmith, execute the following SQL statement:
  insert into candothis values ('JoeSmith', 'SYS_RSC_SRCORGANISM', 'Sesame', 'SYS');
• To revoke the Can Do privilege for this resource from user JoeSmith, execute the following SQL statement:
  delete from candothis where user_name='JoeSmith' and what='SYS_RSC_SRCORGANISM' and ass_name='Sesame' and ass_type='SYS';

See also

• Lab Resources Source Organism

Copyright © 1999-2008 Zsolt Zolnai, and the University of Wisconsin - Madison