Difference between revisions of "Table"

From Dynamo
Jump to: navigation, search
Line 11: Line 11:
  
  
As they are matrices, Matlab tools (like <tt>find<\tt>,<tt>plot<\tt>,<tt>hist<\tt>) are easily customizable to explore and visualize the contents of a table. Additionally, ''Dynamo'' includes many specific utilities.
+
As they are matrices, Matlab tools (like <tt>find</tt>,<tt>plot</tt>,<tt>hist</tt>) are easily customizable to explore and visualize the contents of a table. Additionally, ''Dynamo'' includes many specific utilities.
 
<tt>dapropos table</tt> will give you a list of basic commands that you can use for table manipulation.
 
<tt>dapropos table</tt> will give you a list of basic commands that you can use for table manipulation.
  
Line 33: Line 33:
 
=== Basic info <tt>dinfo </tt>===
 
=== Basic info <tt>dinfo </tt>===
  
<tt>dinfo \<table\> <\tt> just plots on screen a summary of the contents of the table on each column.  
+
<tt>dinfo <table> </tt> just plots on screen a summary of the contents of the table on each column.  
  
 
=== Command line <tt>dtplot</tt> ===
 
=== Command line <tt>dtplot</tt> ===
Line 40: Line 40:
  
 
=== Basic plots <tt>dtshow<tt> ===
 
=== Basic plots <tt>dtshow<tt> ===
<tt> dtshow \<table\> <\tt> opens a lightweight GUI that allows quick plotting of the contents of the table, and also a GUI access to all the plotting options of  <tt>dtplot</tt
+
<tt> dtshow <table> </tt> opens a lightweight GUI that allows quick plotting of the contents of the table, and also a GUI access to all the plotting options of  <tt>dtplot</tt>
  
=== Complex plots <tt>dtview<tt> ===
+
=== Complex plots <tt>dtview</tt> ===
 
<tt>dtview</tt> is a more complicated browser for table contents.
 
<tt>dtview</tt> is a more complicated browser for table contents.
  
Line 49: Line 49:
 
=== Creating tables  ===
 
=== Creating tables  ===
  
An easy way to create a blank table compatible with a given data folder is <tt>dynamo_table_blank</tt>.  
+
An easy way to create a blank table compatible with a given data folder is <tt>dynamo_table_blank</tt>.
  
 
=== Selection of parts of a table ===
 
=== Selection of parts of a table ===

Revision as of 13:59, 14 March 2016


Tables are the basical metadata system in Dynamo. They are just matrices that describe the properties of sets of particles. The property coded on each column is fixed.

A table can be seen as the metadata of a given data folder. The first column in a table is just an integer number (which we call a tag) that identifies a particle. In the data folder, this particle is identified by the name of the file that contains it, i.e.


<MyFolder>/particle_00003.em


As they are matrices, Matlab tools (like find,plot,hist) are easily customizable to explore and visualize the contents of a table. Additionally, Dynamo includes many specific utilities. dapropos table will give you a list of basic commands that you can use for table manipulation.



Format convention in a table

Template:Table Convention

The convention can be consulted each time by the command dthelp


Reading and writing tables

Tables are customarily stored as text files with extension '.tbl'.

Tables can be read and write into the matlab worspace with the standard commands dwrite and dread.

For specially long tables, you can use the extension '.tbl', which will write the files in binary formays

Visualization of tables

Basic info dinfo

dinfo </tt> just plots on screen a summary of the contents of the table on each column.

Command line dtplot

dtplot allows the creation of graphs like: positions of particles in a volume, orientations, distributions of orientations. One example of use of the command is to check if all the particles in a reference (column = 34) have a similar missing wedge orientation (the tilt angle is coded in column 8).

Basic plots dtshow<tt>

<tt> dtshow
</tt> opens a lightweight GUI that allows quick plotting of the contents of the table, and also a GUI access to all the plotting options of dtplot

Complex plots dtview

dtview is a more complicated browser for table contents.

Table manipulation

Creating tables

An easy way to create a blank table compatible with a given data folder is dynamo_table_blank.

Selection of parts of a table

Use dtgrep. It's applicability ranges from just selecting an explicitely defined range of particle tags to the computation of particles pointing in a direction.

Conversion tools for other software packages

dapropos compatibility<\tt> will print a selection of functions that can be used to import and export particle metadata with the format expected by other packages, as AV3, jsubtomo and XMIPP