Chr22 dbSNP JSON Breakdown Table

gistfile1.txt

idx     count   name    ptlp    opp     mism    mol     alt     chrom   patch   top     rsids
1       9139281 38.p12  True    False   False   genomic False   True    False   True    782,783,795
2       8315064 37.p13  False   False   False   genomic False   True    False   True    782,783,800
3       310452  38.p12  False   False   False   genomic True    False   False   True    1964,2719,3484
4       206704  37.p13  False   False   False   genomic False   False   True    True    7245,10248,10794
5       198592  37.p13  False   True    False   genomic False   True    False   True    10083,117222,131488
6       120216  37.p13  False   False   False   genomic False   False   False   True    366279,366777,372180
7       73063   38.p12  False   False   False   genomic False   False   False   False   504728,545765,656963
8       72307   38.p12  False   False   False   genomic False   False   True    True    10451,16947,131198
9       66116   37.p13  False   True    False   genomic False   False   False   True    79883,364621,369381
10      7792    38.p12  False   True    False   genomic False   False   False   True    408896,410993,3895592
11      5241    37.p13  False   False   True    genomic False   True    False   True    7104,7117,11109
12      2493    38.p12  False   True    False   genomic False   True    False   True    1946100,34109265,34453600
13      2455    37.p13  False   True    False   genomic False   False   True    True    1946100,34109265,34453600
14      1489    37.p13  False   False   True    genomic False   False   True    True    25274,78489,131515
15      1033    38.p12  False   False   True    genomic True    False   False   True    16947,23669,28557
16      809     37.p13  False   True    True    genomic False   True    False   True    738829,738830,915675
17      751     37.p13  True    False   False   genomic False   True    False   True    695520,2818600,3047462
18      536     38.p12  False   False   True    genomic False   False   True    True    7245,713811,714002
19      254     38.p12  False   True    True    genomic False   True    False   True    1894501,1946101,1946102
20      217     37.p13  False   True    True    genomic False   False   True    True    1894501,1946101,1946102
21      163     37.p13  False   True    True    genomic False   False   False   True    1818579,1962473,2007219
22      27      38.p12  False   True    True    genomic False   False   False   True    1807482,2379834,5748858
23      7       38.p12  False   False   False   genomic False   True    False   True    375611631,782043702,782502812

Only entries with On Chromosome True:

$ awk '{if ($9 != "False") print; }' tmp/analyze-chr22.txt 
idx     count   name    ptlp    opp     mism    mol     alt     chrom   patch   top     rsids   
1       9139281 38.p12  True    False   False   genomic False   True    False   True    782,783,795
2       8315064 37.p13  False   False   False   genomic False   True    False   True    782,783,800
5       198592  37.p13  False   True    False   genomic False   True    False   True    10083,117222,131488
11      5241    37.p13  False   False   True    genomic False   True    False   True    7104,7117,11109
12      2493    38.p12  False   True    False   genomic False   True    False   True    1946100,34109265,34453600
16      809     37.p13  False   True    True    genomic False   True    False   True    738829,738830,915675
17      751     37.p13  True    False   False   genomic False   True    False   True    695520,2818600,3047462
19      254     38.p12  False   True    True    genomic False   True    False   True    1894501,1946101,1946102
23      7       38.p12  False   False   False   genomic False   True    False   True    375611631,782043702,782502812

Only entries with On Chromosome True and no mismatches:

$ awk '{if ($9 != "False" && $6 != "True" ) print; }' tmp/analyze-chr22.txt 
idx     count   name    ptlp    opp     mism    mol     alt     chrom   patch   top     rsids   
1       9139281 38.p12  True    False   False   genomic False   True    False   True    782,783,795
2       8315064 37.p13  False   False   False   genomic False   True    False   True    782,783,800
5       198592  37.p13  False   True    False   genomic False   True    False   True    10083,117222,131488
12      2493    38.p12  False   True    False   genomic False   True    False   True    1946100,34109265,34453600
17      751     37.p13  True    False   False   genomic False   True    False   True    695520,2818600,3047462
23      7       38.p12  False   False   False   genomic False   True    False   True    375611631,782043702,782502812