igf1-db-ex.txt

igf1-db-ex.txt

sqlite> select * from igf1_studydata limit 10;
chr         pos18       pos19       ref         var         refvar      novel       offtarget   thresh      maxmaf      meanmaf     highqual    superhighqual
----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  -------------
12          101266026   102741896   C           A           C/A         0           0           0.05        0.362       0.252       1           1
12          101266373   102742243   C           A           C/A         0           0           0.05        0.0805      0.0131      1           1
12          101267346   102743216   T           G           T/G         0           0           0.05        0.6937      0.4321      1           1
12          101267684   102743554   C           T           C/T         0           0           0.05        0.0772      0.0353      1           1
12          101268423   102744293   A           G           A/G         0           0           0.05        0.0888      0.0203      1           1
12          101268571   102744441   A           C           A/C         0           0           0.05        0.0684      0.0222      1           1
12          101268619   102744489   T           C           T/C         0           0           0.05        0.1422      0.0537      1           1
12          101268621   102744491   A           G           A/G         0           0           0.05        0.1376      0.0539      1           1
12          101268828   102744698   C           T           C/T         0           0           0.05        0.1986      0.0609      1           1
12          101269190   102745060   T           A           T/A         0           0           0.05        0.8674      0.6098      1           1


sqlite> select * from igf1_1000g_polymorphic limit 10;
chrom       pos19       pos18       ref         var         refvar      maf
----------  ----------  ----------  ----------  ----------  ----------  ----------
12          102741896   101266026   C           A           C/A         0.344828
12          102742243   101266373   C           A           C/A         0.00862069
12          102742544   101266674   T           C           T/C         0.00574713
12          102743216   101267346   T           G           T/G         0.54023
12          102743377   101267507   C           T           C/T         0.00287356
12          102743554   101267684   C           T           C/T         0.0287356
12          102744293   101268423   A           G           A/G         0.0258621
12          102744441   101268571   A           C           A/C         0.0316092
12          102744489   101268619   T           C           T/C         0.00862069
12          102744491   101268621   A           G           A/G         0.00862069

sqlite> select * from igf1_union_nomismatch limit 10,10;
pos18       pos19       alleles_study  novel       offtarget   thresh      maxmaf      meanmaf     highqual    superhighqual  alleles_1000g  maf1000g    bestmaf
----------  ----------  -------------  ----------  ----------  ----------  ----------  ----------  ----------  -------------  -------------  ----------  ----------
101268828   102744698   C/T            0           0           0.05        0.1986      0.0609      1           1              C/T            0.0517241   0.0609
101269130   102745000   NULL           NULL        NULL        NULL        NULL        NULL        NULL        NULL           T/A            0.00574713  0.00574713
101269190   102745060   T/A            0           0           0.05        0.8674      0.6098      1           1              T/A            0.755747    0.755747
101269348   102745218   G/C            0           0           0.05        0.1756      0.0416      1           1              G/C            0.0632184   0.0632184
101269385   102745255   NULL           NULL        NULL        NULL        NULL        NULL        NULL        NULL           C/T            0.00574713  0.00574713
101269406   102745276   NULL           NULL        NULL        NULL        NULL        NULL        NULL        NULL           A/G            0.0143678   0.0143678
101269514   102745384   A/C            0           0           0.05        0.0804      0.0203      1           1              A/C            0.0143678   0.0203
101269585   102745455   NULL           NULL        NULL        NULL        NULL        NULL        NULL        NULL           G/A            0.00287356  0.00287356
101269677   102745547   T/C            0           0           0.05        0.0859      0.0212      1           1              T/C            0.0143678   0.0212
101269720   102745590   C/A            1           0           0.05        0.0579      0.0048      1           1              NULL           NULL        0.0048