Table 1 Semantics for translating the flatfile representation of a BioCyc reaction to columns of the BioWarehouse schema. The left column indicates source data from BioCyc; the right column indicates that data is transferred into the BioWarehouse. One row is added to the Reaction table for each flatfile reaction; rows to other tables are added as indicated. Table.Column indicates a column of a schema table. Attributes followed by [*] may occur multiple times per record. Note that some tables in this figure may not appear in Figure 2 because that figure is an abstraction of the full schema.
From: BioWarehouse: a bioinformatics database warehouse toolkit
BioCyc Attribute | Warehouse Semantics |
|---|---|
LEFT [*] | A row is added to A row is added to table Reactant. Value should match a Chemical.Name; its WID is stored as Product .WID. If a COEFFICIENT follows immediately, its value is stored as Reactant.Coefficient. Otherwise the value 1 is stored. |
RIGHT [*] | A row is added to table product. Value should match a chemical.Name; its WID is stored as product .WID. If a COEFFICIENT follows immediately, its value is stored as Product .Coefficient. Otherwise the value 1 is stored. |
COEFFICIENT | Reactant.Coefficient or Product.Coefficient for the immediately preceding LEFT or RIGHT attribute resp. |
COMMON-NAME | A row is added to SynonymTable where SynonymTable.Syn is this value and SynonymTable. OtherWID is the WID of this reaction. |
DELTAG0 | Reaction.DeltaG |
EC-NUMBER | Reaction.ECNumber |
SPONTANEOUS? | Reaction.Spontaneous |
SYNONYMS [*] | A row is added to SynonymTable where SynonymTable. Syn is this value and SynonymTable.OtherWID is the WID of this reaction |
UNIQUE-ID | A row is added to DBID where DBID.XID is this value. and DBID.OtherWID is the WID of this reaction. |