Difference between revisions of "iRefIndex MITAB Mapping"

From irefindex
Line 103: Line 103:
 
| 6||aliasB(First)||Interactor_B||int_name||First entry object_shortlbl||10,11
 
| 6||aliasB(First)||Interactor_B||int_name||First entry object_shortlbl||10,11
 
|-
 
|-
| 5||aliasA(From second)||Interactor_A||int_name||object_alias||
+
| 5||aliasA(From second)||Interactor_A||int_name||object_alias||14
 
|-
 
|-
| 6||aliasB(From second)||Interactor_B||int_name||object_alias||
+
| 6||aliasB(From second)||Interactor_B||int_name||object_alias||14
 
|-
 
|-
 
| 7||Method (MI identfier)||Experiment||int_xref||int_detection_primaryref||6
 
| 7||Method (MI identfier)||Experiment||int_xref||int_detection_primaryref||6

Revision as of 16:33, 10 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 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_alias
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
pmids pubmed:identifier int_experiment.ex_bib_pri = identifier (not applicable)
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

Summary mapping

Column_Number Column_Name UID_to _use Table_to_use Category_to_use Category_ID
1 uidA Interactor_A int_xref object_primaryref 2
2 uidB Interactor_B int_xref object_primaryref 2
3 altA Interactor_A int_xref object_secondaryref 3
4 altB Interactor_B int_xref object_secondaryref 4
5 aliasA (First ) Interactor_A int_name First entry object_shortlbl 10,11
6 aliasB(First) Interactor_B int_name First entry object_shortlbl 10,11
5 aliasA(From second) Interactor_A int_name object_alias 14
6 aliasB(From second) Interactor_B int_name object_alias 14
7 Method (MI identfier) Experiment int_xref int_detection_primaryref 6
7 Method (name) Experiment int_name int_detection_shortlbl 24
8 author Experiment int_name experim_shortlbl 18
9 Pmids (frist one) Experiment int_xref bib_primaryref 4
9 Pmids (Second one onwards) Experiment int_xref bib_secondaryref 5
10 taxa (used with uidA)
11 taxb (used with uidB)
12 interactionType Interaction int_name int_type_sh 27
13 sourcedb (used with interactionIdentifier)
14 interactionIdentifier Interaction int_xref interaction_primaryref 0