The MySQL database consists of a dump of specific tables. The general organizational scheme is that each segmented object has its own ID. This is 'objID'. Many parts of the image analysis can be done on these objects without reference to whether they are connected to other objects (e.g. through time as the same cell). When objects need to be grouped into cells, the main key for this is 'foID' (first object ID) which is the object ID of the first frame in which that cell appears. 'cellID' is also sometimes used. This is unique within an experiment but not between experiments. foID is used exclusively in the R analysis. Each experiment has its own unique ID coded as 'uID' Relevant tables are: - GUIcurationProgress - This is used by yeastMarkControlCellsGUI to record progress in annotating and training the bad/control/experimental classifier - RFscores - A record of the random forest scores for each object ID and each class - badGoodFromTransRF - Scores for classifying cells as alive/dead based on the trans image - cellData - A central table. Has the fluorescence and area data for each object - cellLabels - class and other information per objID - cellLocs - x,y locations for each objID - cellStatsForRF - statistics on each object used in the bad/control/experimental RF classification - experimentInfo - specific information on timing and galactose addition for the experiments - percent100s - used for the plateau identification in the R analysis - foIDHistory - connects objID to foID (firstObjID) - maxCellID - stores info on the maximum objID and cellID for each experiment This database was generated by the command: $ mysqldump -u username sarahgalproject GUIcurationProgress RFscores badGoodFromTransRF cellData cellLabels cellLocs cellStatsForRF experimentInfo percent100s foIDHistory maxCellID paths > StockwellRifkin_MySQLDatabase_dump.sql It can be used to recreate the tables via: $ mysql -u username -p -h databasename < StockwellRifkin_MySQLDatabase_dump.sql