select chrom,chromStart,name,avHet from snp129 where avHet>0 limit 300
chrom
chromStart
name
avHet
chr1
4332
rs3210717
NULL
chr1
4363
rs1045871
0.4278
chr1
4375
rs1045862
NULL
chr1
4384
rs17149433
0.1958
chr1
4404
rs17149429
0.1128
chr1
4561
rs16925319
0.2822
chr1
4573
rs17353727
0.495
chr1
4614
rs17157186
0.4118
chr1
4640
rs3210688
NULL
chr1
6105
rs17157183
0.4422
chr1
6242
rs17041378
0.4032
chr1
6316
rs2758114
0.4838
chr1
6357
rs3210724
0.1958
chr1
6396
rs15642
0.4712
chr1
6479
rs2974802
0.2952
chr1
6811
rs708637
0.255
chr1
6836
rs1045474
0.2112
chr1
6858
rs1045472
0.18
chr1
6912
rs1128412
0.0768
chr1
7557
rs7357853
0.0582
chr1
7590
rs3185335
0.3542
chr1
7861
rs17407614
0.4488
chr1
7889
rs17410271
0.4872
chr1
8026
rs3892543
0.455
chr1
8361
rs3889803
0.4998
chr1
8573
rs16990303
0.2688
chr1
10414
rs380047
0.0768
chr1
10490
rs3877521
0.095
chr1
10666
rs453142
0.48
chr1
14107
rs10496451
0.450446
chr1
14673
rs17157111
0.3848
chr1
18725
rs16924801
0.375
chr1
18767
rs11490616
0.2688
chr1
18767
rs17017339
0.32
chr1
18821
rs16990158
0.4032
chrom
chromStart
name
avHet
chr1
18821
rs17040995
0.2822
chr1
19052
rs17041006
0.095
chr1
19883
rs3892753
0.1302
chr1
24617
rs364868
0.5
chr1
24633
rs11053
0.32
chr1
24633
rs16994639
0.32
chr1
24656
rs1047170
0.4662
chr1
25620
rs410129
0.3432
chr1
27827
rs403917
0.457812
chr1
39344
rs2531294
0.4872
chr1
40378
rs1968110
0.061952
chr1
45412
rs2949421
0.065498
chr1
72433
rs4030303
0.004773
chr1
78031
rs940550
0.019932
chr1
78034
rs940551
0.1472
chr1
78127
rs940552
0.011049
chr1
79380
rs1464800
0.2688
chr1
79710
rs940553
0.3432
chr1
81751
rs17160650
0.4608
chr1
81802
rs15554
0.427038
chr1
81848
rs17146326
0.5
chr1
96481
rs1851940
0.013582
chr1
121810
rs17009015
0.059489
chr1
124948
rs17092651
0.3432
chr1
124953
rs17129079
0.2952
chr1
124987
rs17129080
0.4352
chr1
140645
rs17160678
0.48
chr1
154259
rs17064996
0.2262
chr1
154359
rs1137442
0.4032
chr1
154420
rs1137445
0.42
chr1
218201
rs17041365
0.2688
chr1
218241
rs3207075
0.3318
chr1
218455
rs547577
0.32
chr1
218509
rs16961041
0.455
chr1
218637
rs4050212
0.336735
chr1
223121
rs17063668
0.4488
chrom
chromStart
name
avHet
chr1
226971
rs17143775
0.42
chr1
228078
rs17160650
0.4608
chr1
228129
rs15554
0.427038
chr1
228129
rs17358985
0.4278
chr1
228164
rs17354850
0.32
chr1
242796
rs1851940
0.013582
chr1
310996
rs16999667
0.3848
chr1
318043
rs17129081
0.4118
chr1
318054
rs16990355
0.4712
chr1
318055
rs17052835
0.2262
chr1
318091
rs17129080
0.4352
chr1
318125
rs17129079
0.2952
chr1
318130
rs17092651
0.3432
chr1
318401
rs17408614
0.18
chr1
325493
rs4006867
0.004796
chr1
360984
rs7462951
0.395175
chr1
365265
rs454591
0.4608
chr1
392552
rs4030303
0.004773
chr1
396549
rs9661032
0.475546
chr1
408163
rs1825700
0.4902
chr1
417918
rs4538760
0.026485
chr1
443765
rs17052815
0.095
chr1
451266
rs17354850
0.32
chr1
451301
rs17358985
0.4278
chr1
451352
rs17160650
0.4608
chr1
452459
rs17143775
0.42
chr1
456297
rs17063668
0.4488
chr1
456411
rs16874460
0.4352
chr1
457479
rs4599694
0.006689
chr1
460898
rs16961041
0.455
chr1
511806
rs1057858
0.1472
chr1
511809
rs1057859
0.4278
chr1
511861
rs17160650
0.4608
chr1
511912
rs17358985
0.4278
chr1
511927
rs1057863
0.42
chr1
511947
rs12633
0.323582
chrom
chromStart
name
avHet
chr1
511947
rs17354850
0.32
chr1
546413
rs4538760
0.026485
chr1
554460
rs6594028
0.005089
chr1
554483
rs10458597
0.014388
chr1
554635
rs9629043
0.078032
chr1
555232
rs45572638
0.028163
chr1
555236
rs45594535
0.082041
chr1
555295
rs9701055
0.05935
chr1
555590
rs28357984
0.195057
chr1
557588
rs28358874
0.160669
chr1
557609
rs28358875
0.059989
chr1
557615
rs11510103
0.032778
chr1
558037
rs28358879
0.03737
chr1
558184
rs9699599
0.060547
chr1
558389
rs11497407
0.004796
chr1
559112
rs2000975
0.1128
chr1
559405
rs45574137
0.009478
chr1
559632
rs7520428
0.015503
chr1
559665
rs2096045
0.032778
chr1
562031
rs1825700
0.4902
chr1
573647
rs9661032
0.475546
chr1
577636
rs4030303
0.004773
chr1
593626
rs405899
0.3078
chr1
604152
rs454591
0.4608
chr1
608433
rs7462951
0.395175
chr1
648174
rs17009015
0.059489
chr1
651314
rs17092651
0.3432
chr1
651319
rs17129079
0.2952
chr1
651353
rs17129080
0.4352
chr1
651389
rs17052835
0.2262
chr1
651390
rs16990355
0.4712
chr1
651401
rs17129081
0.4118
chr1
657784
rs12054489
0.409331
chr1
676331
rs17160678
0.48
chr1
690099
rs17064996
0.2262
chr1
690199
rs1137442
0.4032
chrom
chromStart
name
avHet
chr1
690260
rs1137445
0.42
chr1
707291
rs17359089
0.4118
chr1
711152
rs12565286
0.112969
chr1
713681
rs11804171
0.27555
chr1
713753
rs2977670
0.402938
chr1
718104
rs3131977
0.024688
chr1
719810
rs2977656
0.042135
chr1
722590
rs4442343
0.004796
chr1
723299
rs10107465
0.302708
chr1
728872
rs2488515
0.03314
chr1
730719
rs12082473
0.14456
chr1
736077
rs17361447
0.014184
chr1
738653
rs1817837
0.4608
chr1
740097
rs12138618
0.11504
chr1
741227
rs4101518
0.005479
chr1
742428
rs3094315
0.411038
chr1
743403
rs2073813
0.442375
chr1
744054
rs3131968
0.478424
chr1
750162
rs11564776
0.073965
chr1
750671
rs1048486
0.4982
chr1
750775
rs1048489
0.18
chr1
750784
rs3882068
0.014184
chr1
751543
rs1057215
0.4838
chr1
751566
rs1057214
0.4998
chr1
751594
rs2286139
0.489796
chr1
755131
rs11240776
0.032778
chr1
755810
rs2519016
0.205056
chr1
756900
rs12756876
0.208118
chr1
756932
rs12741327
0.142449
chr1
758310
rs12562034
0.371351
chr1
759413
rs2519012
0.009524
chr1
761383
rs17160620
0.065782
chr1
763909
rs12022420
0.133239
chr1
765521
rs2905035
0.203342
chr1
766408
rs12124819
0.184577
chr1
766984
rs2980319
0.384386
chrom
chromStart
name
avHet
chr1
767375
rs6672353
0.081778
chr1
768150
rs17276778
0.168469
chr1
768607
rs1055606
0.263466
chr1
769184
rs4040617
0.363406
chr1
769605
rs41498448
0.192132
chr1
769889
rs2977613
0.03737
chr1
770647
rs2977612
0.376792
chr1
773885
rs17160939
0.115688
chr1
774766
rs2519068
0.009524
chr1
774912
rs2905062
0.496564
chr1
775851
rs2980300
0.491302
chr1
780026
rs41411546
0.169193
chr1
782125
rs1044922
0.4928
chr1
782342
rs2905036
0.051607
chr1
787888
rs4951864
0.192132
chr1
788663
rs12132517
0.228884
chr1
788821
rs11240777
0.494163
chr1
789325
rs4245756
0.046593
chr1
789869
rs6681049
0.210618
chr1
791720
rs17276806
0.028979
chr1
793444
rs17080269
0.48
chr1
793458
rs17080266
0.3318
chr1
793761
rs17001528
0.0582
chr1
798174
rs12749692
0.004819
chr1
802605
rs6605064
0.127066
chr1
803502
rs16973606
0.352653
chr1
807096
rs4970387
0.191327
chr1
807680
rs1807152
0.4838
chr1
812669
rs658784
0.4838
chr1
824694
rs4411087
0.363894
chr1
825361
rs4422948
0.371351
chr1
830947
rs1574243
0.3432
chr1
836726
rs950122
0.318127
chr1
843667
rs3748591
0.392723
chr1
843816
rs1806509
0.467433
chr1
871489
rs2272757
0.5
chrom
chromStart
name
avHet
chr1
871780
rs35471880
0.052593
chr1
871895
rs2272756
0.217852
chr1
872665
rs2340582
0.120306
chr1
874677
rs4246503
0.130926
chr1
876246
rs3748594
0.118633
chr1
876679
rs10465241
0.32
chr1
877024
rs17160698
0.041361
chr1
877422
rs3748595
0.089219
chr1
877663
rs3828047
0.118726
chr1
878501
rs3748596
0.125182
chr1
878521
rs3748597
0.130737
chr1
879100
rs3828049
0.109718
chr1
879500
rs13303206
0.188951
chr1
880883
rs13302957
0.231799
chr1
881957
rs17160703
0.014814
chr1
884435
rs13303010
0.304857
chr1
887187
rs4970441
0.101893
chr1
899100
rs3829740
0.293357
chr1
900797
rs2340592
0.450765
chr1
900963
rs3748588
0.297752
chr1
906696
rs6694632
0.491931
chr1
908100
rs28552711
0.28307
chr1
908435
rs2341354
0.47805
chr1
916293
rs4970403
0.160669
chr1
922319
rs1891910
0.223413
chr1
930065
rs35940137
0.039411
chr1
933330
rs3121567
0.192189
chr1
933549
rs2465140
0.43102
chr1
934426
rs3128117
0.434363
chr1
936896
rs2465126
0.25265
chr1
938554
rs2341365
0.299147
chr1
938783
rs15842
0.154731
chr1
939099
rs3748598
0.136025
chr1
939470
rs1921
0.4278
chr1
947502
rs6657048
0.05551
chr1
947760
rs2799064
0.432133
chrom
chromStart
name
avHet
chr1
949093
rs4039721
0.497202
chr1
952072
rs3128126
0.405077
chr1
957520
rs4970349
0.492866
chr1
967432
rs2710876
0.066992
chr1
967491
rs3748600
0.014493
chr1
967642
rs2710875
0.066992
chr1
972435
rs3813192
0.006689
chr1
972856
rs10267
0.1638
chr1
975128
rs2275813
0.26195
chr1
975688
rs17160775
0.132653
chr1
975762
rs17160776
0.093731
chr1
976305
rs2710887
0.349137
chr1
976599
rs17160781
0.177743
chr1
977004
rs17778478
0.013985
chr1
980242
rs3121561
0.433884
chr1
980279
rs2465136
0.456417
chr1
980379
rs2710872
0.121928
chr1
980701
rs13129
0.120306
chr1
980846
rs8014
0.499925
chr1
988363
rs3813193
0.335169
chr1
988736
rs7526509
0.082794
chr1
993491
rs4075116
0.355129
chr1
995668
rs3934834
0.363894
chr1
1000868
rs11809988
0.00881
chr1
1007032
rs3766193
0.478214
chr1
1007059
rs3766192
0.496493
chr1
1007078
rs6667248
0.093669
chr1
1007203
rs1133647
0.32
chr1
1007449
rs3766191
0.304192
chr1
1007460
rs12096277
0.068207
chr1
1008006
rs9442395
0.4872
chr1
1008424
rs9442371
0.498861
chr1
1008566
rs9442372
0.458103
chr1
1008828
rs11800256
0.004751
chr1
1011208
rs10907177
0.316258
chr1
1011270
rs11260587
0.11504
chrom
chromStart
name
avHet
chr1
1011277
rs3737728
0.312882
chr1
1011445
rs10907178
0.21875
chr1
1011520
rs11260588
0.136723
chr1
1011557
rs9442398
0.390067
chr1
1011899
rs6701114
0.475779
chr1
1015163
rs9442400
0.255363
chr1
1016569
rs4074137
0.440661
chr1
1020236
rs12731175
0.033403
chr1
1020427
rs6687776
0.40521
chr1
1020495
rs6678318
0.435479
chr1
1020922
rs7545952
0.0202
chr1
1021402
rs9651273
0.195875
chr1
1023856
rs6698368
0.459861