Schema for esRegMotif
  Database: sacCer2    Primary Table: esRegMotif    Row Count: 90   Data last updated: 2009-02-17
Format description: A gapless DNA motif
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ABF1_01varchar(16) values Motif name.
columnCount 22int(11) range Count of columns in motif.
aProb 0.110000,-0.170000,0.930000...longblob   Probability of A's in each column.
cProb 0.240000,0.910000,-5.750000...longblob   Probability of C's in each column.
gProb -0.790000,-0.450000,-0.4500...longblob   Probability of G's in each column.
tProb 0.180000,-0.670000,0.120000...longblob   Probability of T's in each column.

Connected Tables and Joining Fields
        sacCer2.esRegGeneToMotif.name (via esRegMotif.name)

Sample Rows
 
namecolumnCountaProbcProbgProbtProb
ABF1_01220.110000,-0.170000,0.930000,-0.750000,1.130000,-6.100000,-2.650000,1.400000,-6.100000,-2.650000,0.690000,-0.750000,0.930000,-0.1 ...0.240000,0.910000,-5.750000,0.180000,-5.750000,-5.750000,2.110000,-5.750000,0.910000,-0.790000,-0.390000,-0.390000,-1.350000,-0. ...-0.790000,-0.450000,-0.450000,-0.450000,0.700000,-2.340000,-5.800000,-0.130000,-5.800000,-0.450000,-0.850000,-2.340000,-0.450000 ...0.180000,-0.670000,0.120000,0.630000,-6.030000,1.830000,-6.030000,-2.570000,1.110000,1.310000,-0.090000,1.210000,-0.350000,0.310 ...
ABF_C15-0.420000,1.190000,-5.460000,-5.460000,1.270000,-5.460000,-1.510000,0.490000,-0.750000,0.670000,0.430000,1.800000,-5.460000,-5.4 ...0.260000,-5.100000,-5.100000,2.160000,-2.200000,1.260000,-0.990000,0.090000,-0.160000,0.260000,-0.770000,-5.100000,2.160000,-5.1 ...-0.200000,0.580000,-5.160000,-5.160000,-0.550000,-5.160000,-0.230000,-0.520000,-0.590000,-0.860000,0.170000,-5.160000,-5.160000, ...0.290000,-5.380000,1.880000,-5.380000,-1.210000,0.790000,1.160000,-0.350000,0.850000,-0.730000,-0.200000,-5.380000,-5.380000,-5. ...
ADR1_016-0.580000,-5.530000,-5.530000,0.400000,-5.440000,-4.570000,0.500000,-5.170000,-5.170000,-5.170000,-5.080000,-0.750000,-0.840000,2.100000,2.100000,1.430000,2.100000,0.690000,0.480000,-5.450000,-5.450000,-5.450000,-5.360000,0.870000,
CAT8_Q610-4.870000,-4.870000,1.470000,-4.870000,-4.870000,-1.410000,0.080000,-0.480000,-4.870000,-4.870000,2.140000,2.140000,-4.520000,-1.060000,-1.060000,1.160000,-0.120000,-1.060000,2.140000,2.140000,-4.570000,-4.570000,-0.180000,-1.110000,-4.570000,0.380000,1.100000,-0.180000,-4.570000,-4.570000,-4.800000,-4.800000,-4.800000,1.540000,1.710000,-1.340000,-4.800000,0.880000,-4.800000,-4.800000,
CBF1_B100.690000,0.490000,-5.320000,-5.320000,1.800000,-5.320000,0.350000,-5.320000,-5.320000,0.920000,-2.150000,-4.920000,-4.960000,2.150000,-4.960000,2.120000,-4.960000,-4.960000,-4.960000,0.000000,0.080000,1.200000,-5.020000,-5.020000,-5.020000,-5.020000,1.450000,-5.020000,2.100000,-0.740000,-0.080000,-1.900000,1.870000,-5.240000,-5.240000,-3.070000,-5.240000,1.870000,-5.240000,-1.290000,
GAL4_0123-1.550000,0.670000,-0.050000,-1.550000,-5.010000,-5.010000,0.350000,-1.550000,-0.610000,1.140000,-1.550000,0.350000,-1.550000,-5 ...1.020000,-0.260000,-0.260000,2.010000,-4.650000,-1.190000,0.310000,0.310000,0.710000,-4.650000,1.690000,-1.190000,0.310000,-0.26 ...0.250000,-1.250000,-1.250000,-4.710000,1.950000,1.950000,0.250000,0.650000,0.650000,-0.310000,-0.310000,-4.710000,0.970000,-1.25 ...-0.540000,0.030000,0.740000,-4.930000,-1.470000,-4.930000,-1.470000,0.030000,-1.470000,-0.540000,-4.930000,1.000000,-0.540000,1. ...
GAL4_C22-0.860000,-1.970000,-4.950000,-4.950000,0.670000,-0.810000,0.120000,0.900000,-0.930000,0.150000,-1.780000,-4.950000,-1.810000,-4 ...-0.440000,2.050000,-4.590000,-1.210000,0.030000,0.520000,0.880000,-4.590000,1.650000,-4.590000,0.460000,0.140000,1.250000,1.0000 ...-1.380000,-4.650000,2.090000,1.950000,0.060000,0.680000,-0.140000,0.150000,-0.580000,-4.650000,0.740000,-1.480000,0.060000,0.380 ...1.150000,-4.870000,-4.870000,-4.870000,-1.590000,-0.780000,-1.700000,-0.340000,-4.870000,1.330000,-0.210000,1.320000,-0.760000,- ...
GBF_Q69-0.470000,-3.930000,-0.470000,-0.470000,-3.930000,-3.930000,-3.930000,-3.930000,-0.470000,-3.570000,-3.570000,-3.570000,-3.570000,-3.570000,-3.570000,-3.570000,-3.570000,-3.570000,-3.630000,-3.630000,1.330000,1.730000,2.040000,1.730000,2.040000,-3.630000,1.330000,1.510000,1.820000,-0.390000,-3.850000,-3.850000,-0.390000,-3.850000,1.820000,-0.390000,
GCN4_01270.010000,-1.050000,0.450000,-1.450000,-1.090000,-0.490000,-0.600000,-1.060000,-0.790000,0.680000,-6.940000,-6.940000,1.820000,-6 ...0.950000,1.070000,0.590000,0.660000,0.240000,-0.450000,0.880000,0.860000,0.150000,-0.610000,-6.580000,-6.580000,-6.580000,2.1700 ...-0.650000,0.530000,-1.000000,0.960000,0.190000,0.800000,0.180000,0.390000,0.370000,0.640000,-6.630000,2.120000,-6.630000,-6.6300 ...-0.870000,-1.900000,-0.660000,-1.380000,0.370000,-0.150000,-0.840000,-0.670000,0.150000,-2.430000,1.900000,-6.860000,-6.860000,- ...
GCN4_C100.290000,1.210000,0.950000,-4.510000,-4.510000,1.770000,-4.510000,-4.510000,-4.510000,0.760000,0.520000,-4.160000,-4.160000,-4.160000,-4.160000,-4.160000,1.780000,-4.160000,2.130000,0.120000,-0.010000,0.500000,0.450000,-4.210000,2.070000,-4.210000,-4.210000,-4.210000,-4.210000,-4.070000,-1.250000,-4.430000,-1.020000,1.850000,-4.430000,-4.430000,-0.280000,1.850000,-4.430000,0.020000,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.