1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165

# Standard namespaces
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix dc: <http://purl.org/dc/elements/1.1/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix : <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .

# Namespaces for this mapping
@prefix map: <http://openflydata.org/d2r-mapping/bdgp/> . # The namespace for this mapping
@prefix bdgp: <http://purl.org/net/bdgp/schema/> . # The bdgp schema as an OWL ontology


map:bdgp a :Database;
	:jdbcDriver "com.mysql.jdbc.Driver";
	:jdbcDSN "jdbc:mysql://localhost:3306/bdgp_20070309";
	:username "****";
	:password "****";
	.
	
# ========================================
# Class: Image
# ========================================
map:ImageClassMap a :ClassMap;
	:dataStorage map:bdgp;
	
	# uris for bdgp images
    :uriPattern "http://openflydata.org/id/bdgp/image-@@image.id@@";
    
    #type
    :class bdgp:Image ;
	.

# imagePath: points to the relative path of an image
map:ImagePath a :PropertyBridge ;
    :property bdgp:imagePath ;
	:column "image.image_path";
    :belongsToClassMap map:ImageClassMap ;
    .	

# ========================================
# Class: Evidence
# ========================================
map:EvidenceClassMap a :ClassMap;
	:dataStorage map:bdgp;
	
	# uris for evidences
    :uriPattern "http://openflydata.org/id/bdgp/evidence-@@evidence.id@@";
    
    #type
    :class bdgp:Evidence ;
    .
	
# evidence: between an evidence and a gene expression image
map:EvidenceImagePropertyBridge a :PropertyBridge ;
    :belongsToClassMap map:EvidenceClassMap ;
    :refersToClassMap map:ImageClassMap ;
    
    :property bdgp:evidence ;
	
    :join "image.dbxref_id = evidence.dbxref_id" ;
    .
    
# ========================================
# Class: Association
# ========================================
map:AssociationClassMap a :ClassMap;
	:dataStorage map:bdgp;
	
	# uris for evidences
    :uriPattern "http://openflydata.org/id/bdgp/association-@@association.id@@";
    
    #type
    :class bdgp:Association ;
    .
    
#associate: associates an association with an evidence
map:AssociationEvidencePropertyBridge a :PropertyBridge ;
    :belongsToClassMap map:AssociationClassMap ;
    :refersToClassMap map:EvidenceClassMap ;
    
    :property bdgp:associate ;
	
    :join "association.id = evidence.association_id" ;
    .
    
#geneProduct: associates an association with a gene product
map:AssociationGPPropertyBridge a :PropertyBridge ;
    :belongsToClassMap map:AssociationClassMap ;
    :refersToClassMap map:GeneProductClassMap ;
    
    :property bdgp:geneProduct ;
	
    :join "association.gene_product_id = gene_product.id" ;
    .
    
#term: associates an association with a term
map:AssociationTermPropertyBridge a :PropertyBridge ;
    :belongsToClassMap map:AssociationClassMap ;
    :refersToClassMap map:TermClassMap ;
    
    :property bdgp:term ;
	
    :join "association.term_id = term.id" ;
    .
	
# ========================================
# Class: gene_product
# ========================================

map:GeneProductClassMap a :ClassMap;
	:dataStorage map:bdgp;
    :uriPattern "http://openflydata.org/id/bdgp/geneproduct-@@gene_product.id@@";
    :class bdgp:GeneProduct ;
	.
	
# symbol
map:GeneProductSymbol a :PropertyBridge ;
    :property bdgp:symbol ;
	:column "gene_product.symbol";
    :belongsToClassMap map:GeneProductClassMap ;
    .	

# skos:altLabel
map:GeneProductPropertyExGO a :PropertyBridge ;
    :property skos:altLabel ;
	:column "gene_product_property.property_val";
    :belongsToClassMap map:GeneProductClassMap ;
    :join "gene_product_property.gene_product_id = gene_product.id" ;
    .	

	
# ========================================
# Class: term
# ========================================

map:TermClassMap a :ClassMap;
	:dataStorage map:bdgp;
    :uriPattern "http://openflydata.org/id/bdgp/term/@@term.id@@";
    :class bdgp:Term ;
	.
	
# term name (expression location and developmental stage)
map:TermName a :PropertyBridge ;
    :property bdgp:name ;
	:column "term.name";
    :belongsToClassMap map:TermClassMap ;
    .	
    
# accession (FBbt numbers or bdgp's own numbers)
map:AccessionProperty a :PropertyBridge ;
    :property bdgp:accession ;
	:column "term.acc";
    :belongsToClassMap map:TermClassMap ;
    .
    
# imageToTerm: the developmental stage term associated with an image
map:ImageToTermProperty a :PropertyBridge ;
	:property bdgp:imageToTerm ;
	:belongsToClassMap map:ImageClassMap ;
	:refersToClassMap map:TermClassMap ;
	:join "image.id=image2term.image_id" ;
	:join "image2term.term_id=term.id" ;
	.