Difference between revisions of "iRefIndex MITAB Mapping"
From irefindex
PaulBoddie (talk | contribs) (Added link to external specification.) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Unlike the parsing of PSI MI XML files, whose attributes correspond to certain tables and columns in the iRefIndex schema, the parsing and interpretation of MITAB files involves a separate mapping of MITAB format columns to such tables and columns in the schema. | + | Unlike the parsing of PSI MI XML files, whose attributes correspond to certain tables and columns in the iRefIndex schema, the parsing and interpretation of [http://code.google.com/p/psicquic/wiki/PsimiTabFormat PSI-MI TAB] (MITAB) files involves a separate mapping of MITAB format columns to such tables and columns in the schema. |
{| border="1" cellspacing="0" cellpadding="5" style="margin: 2em" | {| border="1" cellspacing="0" cellpadding="5" style="margin: 2em" | ||
| Line 7: | Line 7: | ||
! iRefIndex table and column assignments | ! iRefIndex table and column assignments | ||
! iRefIndex category | ! iRefIndex category | ||
| − | |||
|- | |- | ||
| uidA | | uidA | ||
| Line 24: | Line 23: | ||
| aliasA | | aliasA | ||
| rowspan="2" | <tt>int_name.name = ''identifier''</tt><br><tt>int_name.MI = 'MI:0000'</tt> | | rowspan="2" | <tt>int_name.name = ''identifier''</tt><br><tt>int_name.MI = 'MI:0000'</tt> | ||
| − | | rowspan="2" | object_alias | + | | rowspan="2" | object_shortlbl (first entry)<br>object_alias (second and subsequent entries) |
|- | |- | ||
| aliasB | | aliasB | ||
| Line 40: | Line 39: | ||
| (free text) | | (free text) | ||
| rowspan="2" | Experiment | | rowspan="2" | Experiment | ||
| − | | | + | | <tt>int_name.MI = 'MI:0000'</tt><br><tt>int.name.name = ''authors''</tt> |
| − | | | + | | experim_shortlbl |
|- | |- | ||
| pmids | | pmids | ||
| <tt>pubmed:''identifier''</tt> | | <tt>pubmed:''identifier''</tt> | ||
| − | | <tt> | + | | <tt>int_xref.dbid = id('pubmed')</tt><br><tt>int_xref.acc = ''identifier''</tt> |
| − | | ( | + | | bib_primaryref (first entry)<br>bib_secondaryref (second and subsequent entries) |
|- | |- | ||
| taxA | | taxA | ||
| Line 82: | Line 81: | ||
| | | | ||
|} | |} | ||
| + | |||
| + | [[Category:iRefIndex]] | ||
Latest revision as of 15:37, 29 June 2011
Unlike the parsing of PSI MI XML files, whose attributes correspond to certain tables and columns in the iRefIndex schema, the parsing and interpretation of PSI-MI TAB (MITAB) files involves a separate mapping of MITAB format columns to such tables and columns in the schema.
| MITAB columns | Data components | Entity | iRefIndex table and column assignments | iRefIndex category |
|---|---|---|---|---|
| uidA | database:identifier | Interactor | int_xref.dbid = id(database) int_xref.acc = identifier |
object_primaryref |
| uidB | ||||
| altA | object_secondaryref | |||
| altB | ||||
| aliasA | int_name.name = identifier int_name.MI = 'MI:0000' |
object_shortlbl (first entry) object_alias (second and subsequent entries) | ||
| aliasB | ||||
| method | code(description) | Experiment | int_xref.dbid = id('psi-mi') int_xref.acc = code |
int_ditection_primaryref |
| int_name.MI = code int_name.name = description |
int_ditection_shortlbl | |||
| authors | (free text) | Experiment | int_name.MI = 'MI:0000' int.name.name = authors |
experim_shortlbl |
| pmids | pubmed:identifier | int_xref.dbid = id('pubmed') int_xref.acc = identifier |
bib_primaryref (first entry) bib_secondaryref (second and subsequent entries) | |
| taxA | taxid:identifier | Interactor | int_xref.taxid = identifier | (part of interactor entries labelled with object_primaryref and object_secondaryref only) |
| taxB | ||||
| interactionType | code(description) | Interaction | int_xref.dbid = id('psi-mi') int_xref.acc = code |
int_type_primaryref |
| int_name.MI = code int_name.name = description |
int_type_sh | |||
| sourcedb | Interactor/interaction | int_source.source = id(description) int_object.source = id(description) int_source2object.source = id(description) |
(not applicable) | |
| interactionIdentifiers | database:identifier | Interaction | int_xref.dbid = database int_xref.acc = identifier |
interaction_primaryref |
| confidence |
