Skip to content

Instantly share code, notes, and snippets.

@dlebauer

dlebauer/PI_cultivars.txt

Created July 3, 2020 01:39
Show Gist options
  • Save dlebauer/4cc207cd60248355a8fdf2aedd97676e to your computer and use it in GitHub Desktop.
Save dlebauer/4cc207cd60248355a8fdf2aedd97676e to your computer and use it in GitHub Desktop.
Download ZIP
renaming cultivars so that they follow the PIXYZ convention rather thant PI_XYZ see https://github.com/terraref/data-paper/issues/24
Raw
cultivar_dupes.R
library(dplyr)
pi <- readr::read_tsv('metadata/PIcultivars.txt', col_names = c('id', 'name'))
pi_ <- readr::read_tsv('metadata/PI_cultivars.txt', col_names = c('oldid', 'oldname')) %>%
mutate(name = gsub('_', '', oldname))
dupes <- pi %>% full_join(pi_, by = 'name') %>% filter(!is.na(oldid)) %>% filter(!is.na(id))
z1 <- dupes %>%
rowwise %>%
summarize(paste0("update traits set cultivar_id =", id, " where cultivar_id = ",oldid,";")) %>%
readr::write_csv('z1')
z1.01 <- dupes %>%
rowwise %>%
summarize(paste0("update sites_cultivars set cultivar_id =", id, " where cultivar_id = ",oldid,";")) %>%
readr::write_csv('z1.01')
z1.1 <- dupes %>%
rowwise %>%
summarize(paste0("delete from cultivars where id =", oldid,";")) %>%
readr::write_csv('z1.1')
notdupes <- pi %>% full_join(pi_, by = 'name') %>% filter(!is.na(oldid)) %>% filter(is.na(id))
z3 <- notdupes %>%
rowwise %>%
summarize(paste0("update cultivars set name ='", name, "' where name = '", oldname,"';")) %>%
readr::write_csv('z3')
Raw
PI_cultivars.txt
6000001885 PI_598070
6000001886 PI_533997
6000001887 PI_597946
6000001888 PI_533937
6000001889 PI_655984
6000001890 PI_659695
6000001891 PI_656058
6000001892 PI_533769
6000001893 PI_576364
6000001894 PI_533750
6000001895 PI_533855
6000001896 PI_656112
6000001897 PI_656081
6000001898 PI_552856
6000001899 PI_641836
6000001900 PI_534096
6000001901 PI_533911
6000001902 PI_534114
6000001903 PI_534047
6000001904 PI_533970
6000001905 PI_655977
6000001906 PI_533766
6000001907 PI_534139
6000001908 PI_613536
6000001909 PI_655986
6000001910 PI_651492
6000001911 PI_656005
6000001912 PI_655988
6000001913 PI_656001
6000001914 PI_534138
6000001915 PI_534075
6000001916 PI_656052
6000001917 PI_656031
6000001918 PI_656054
6000001919 PI_576332
6000001920 PI_655974
6000001921 PI_656083
6000001922 PI_17548
6000001923 PI_534092
6000001924 PI_533754
6000001925 PI_534148
6000001926 PI_656023
6000001927 PI_576339
6000001928 PI_653617
6000001929 PI_534037
6000001930 PI_534145
6000001931 PI_533991
6000001932 PI_656109
6000001933 PI_595740
6000001934 PI_576337
6000001935 PI_642992
6000001936 PI_656079
6000001937 PI_534046
6000001938 PI_656096
6000001939 PI_540816
6000001940 PI_533961
6000001941 PI_533955
6000001942 PI_533954
6000001943 PI_655972
6000001944 PI_656037
6000001945 PI_533833
6000001946 PI_533845
6000001947 PI_533936
6000001948 PI_533755
6000001949 PI_656095
6000001950 PI_656008
6000001951 PI_656116
6000001952 PI_533752
6000001953 PI_656121
6000001954 PI_576385
6000001955 PI_597980
6000001956 PI_533830
6000001957 PI_659691
6000001958 PI_597951
6000001959 PI_576345
6000001960 PI_533967
6000001961 PI_533986
6000001962 PI_533839
6000001963 PI_533776
6000001964 PI_533915
6000001965 PI_656087
6000001966 PI_533938
6000001967 PI_655991
6000001968 PI_576399
6000001969 PI_597961
6000001970 PI_533912
6000001971 PI_533877
6000001972 PI_656013
6000001973 PI_656009
6000001974 PI_533863
6000001975 PI_533871
6000001976 PI_655987
6000001977 PI_656015
6000001978 PI_533762
6000001979 PI_576394
6000001980 PI_656119
6000001981 PI_585291
6000001982 PI_585295
6000001983 PI_597957
6000001984 PI_533979
6000001985 PI_552861
6000001986 PI_656016
6000001987 PI_329440
6000001988 PI_576340
6000001989 PI_656073
6000001990 PI_576418
6000001991 PI_533987
6000001992 PI_533807
6000001993 PI_533788
6000001994 PI_576422
6000001995 PI_576376
6000001996 PI_597967
6000001997 PI_595720
6000001998 PI_576390
6000001999 PI_534108
6000002000 PI_534088
6000002001 PI_656085
6000002002 PI_642791
6000002003 PI_655978
6000002004 PI_656115
6000002005 PI_533799
6000002006 PI_533927
6000002007 PI_533980
6000002008 PI_656078
6000002009 PI_656060
6000002010 PI_533794
6000002011 PI_576373
6000002012 PI_656041
6000002013 PI_576435
6000002014 PI_656074
6000002015 PI_576352
6000002016 PI_656105
6000002017 PI_533913
6000002018 PI_534079
6000002019 PI_656098
6000002020 PI_533956
6000002021 PI_656059
6000002022 PI_656018
6000002023 PI_656089
6000002024 PI_656055
6000002025 PI_656019
6000002026 PI_533998
6000002027 PI_534105
6000002028 PI_534167
6000002029 PI_533792
6000002030 PI_152651
6000002031 PI_533866
6000002032 PI_655998
6000002033 PI_655994
6000002034 PI_533910
6000002035 PI_597965
6000002036 PI_659694
6000002037 PI_564163
6000002038 PI_576428
6000002039 PI_656107
6000002040 PI_576387
6000002041 PI_533965
6000002042 PI_656093
6000002043 PI_656102
6000002044 PI_533876
6000002045 PI_576380
6000002046 PI_656117
6000002047 PI_561071
6000002048 PI_656094
6000002049 PI_656003
6000002050 PI_595718
6000002051 PI_597966
6000002052 PI_656104
6000002053 PI_656086
6000002054 PI_533996
6000002055 PI_659696
6000002056 PI_533882
6000002057 PI_329435
6000002058 PI_629059
6000002059 PI_656101
6000002060 PI_656118
6000002061 PI_656106
6000002062 PI_534101
6000002063 PI_576425
6000002064 PI_595744
6000002065 PI_48770
6000002066 PI_576396
6000002067 PI_656088
6000002068 PI_642998
6000002069 PI_534097
6000002070 PI_533948
6000002071 PI_534063
6000002072 PI_656034
6000002073 PI_655990
6000002074 PI_576375
6000002075 PI_655979
6000002076 PI_576347
6000002077 PI_656035
6000002078 PI_533789
6000002079 PI_656030
6000002080 PI_656113
6000002081 PI_534070
6000002082 PI_656022
6000002083 PI_534123
6000002084 PI_576348
6000002085 PI_35038
6000002086 PI_595714
6000002087 PI_597950
6000002088 PI_656076
6000002089 PI_534117
6000002090 PI_597949
6000002091 PI_656000
6000002092 PI_533841
6000002093 PI_576350
6000002094 PI_548797
6000002095 PI_576437
6000002096 PI_659693
6000002097 PI_656050
6000002098 PI_533901
6000002099 PI_656108
6000002100 PI_533939
6000002101 PI_534137
6000002102 PI_533757
6000002103 PI_656053
6000002104 PI_597960
6000002105 PI_656065
6000002106 PI_576349
6000002107 PI_656002
6000002108 PI_656042
6000002109 PI_655989
6000002110 PI_533962
6000002111 PI_534163
6000002112 PI_533949
6000002113 PI_533785
6000002114 PI_542406
Raw
PIcultivars.txt
6000001377 PI156018
6000001378 PI181899
6000000751 PI257600
6000001379 PI250583
6000001380 PI291246
6000001381 PI365512
6000001383 PI521281
6000001384 PI534047
6000001385 PI552851
6000001386 PI561072
6000001387 PI562717
6000001388 PI641834
6000001390 PI300119
6000001391 PI569446
6000001392 PI453106
6000001393 PI453177
6000001394 PI329583
6000001395 PI329617
6000001396 PI330167
6000001397 PI586499
6000001398 PI673843
6000001399 PI185573
6000001400 PI533752
6000001401 PI213901
6000001402 PI302221
6000001403 PI656020
6000001404 PI655986
6000001405 PI655988
6000001406 PI655995
6000001407 PI329573
6000001408 PI330122
6000001410 PI656051
6000001411 PI534157
6000001412 PI606706
6000001413 PI329551
6000001414 PI329554
6000001415 PI570039
6000001382 PI452544
6000001389 PI300118
6000001409 PI576366
6000000213 PI535785
6000000218 PI571107
6000000224 PI297130
6000000229 PI506069
6000000234 PI533759
6000000754 PI273465
6000000755 PI273969
6000000756 PI276837
6000001416 PI656030
6000001417 PI533863
6000001418 PI239439
6000001419 PI629059
6000001420 PI474825
6000001421 PI656044
6000001422 PI655996
6000001423 PI595741
6000001424 PI595699
6000001425 PI656023
6000001880 PI_533903
6000001881 PI_565121
6000001882 PI_542718
6000001883 PI_576333
6000001884 PI_629034
6000000460 PI144134
6000000461 PI145619
6000000462 PI145626
6000000463 PI145632
6000000464 PI145633
6000000465 PI146890
6000000466 PI147224
6000000467 PI152591
6000000468 PI152651
6000000469 PI152694
6000000470 PI152727
6000000471 PI152728
6000000472 PI152730
6000000473 PI152733
6000000474 PI152751
6000000788 PI329518
6000000789 PI329519
6000000790 PI329541
6000000791 PI329545
6000000792 PI329546
6000000793 PI329550
6000000794 PI329569
6000000795 PI329570
6000000796 PI329584
6000000797 PI329585
6000000798 PI329604
6000000799 PI329614
6000000800 PI329615
6000000801 PI329618
6000000802 PI329632
6000000803 PI329644
6000000804 PI329645
6000000805 PI329646
6000000806 PI329665
6000000807 PI329673
6000000808 PI329699
6000000809 PI329702
6000000562 PI329333
6000000563 PI329338
6000000564 PI329351
6000000565 PI329394
6000000566 PI329403
6000000567 PI329435
6000000568 PI329440
6000000569 PI329465
6000000570 PI329466
6000000571 PI329471
6000000572 PI329473
6000000573 PI329478
6000000574 PI329480
6000000575 PI329501
6000000576 PI329506
6000000577 PI329510
6000000578 PI329511
6000000579 PI329517
6000000685 PI152771
6000000686 PI152816
6000000687 PI152828
6000000688 PI152860
6000000825 PI330796
6000000826 PI330803
6000000827 PI330807
6000000828 PI330833
6000000829 PI330858
6000000830 PI337680
6000000833 PI452542
6000000834 PI452619
6000000835 PI452692
6000000836 PI453696
6000000837 PI455217
6000000838 PI455221
6000000932 PI569453
6000000933 PI569454
6000000934 PI569455
6000000935 PI569457
6000000936 PI569458
6000001056 PI563355
6000001057 PI534165
6000001059 PI329605
6000001060 PI513898
6000001061 PI542718
6000001062 PI534120
6000001063 PI535792
6000000232 PI656056
6000000207 PI651496
6000000208 PI651491
6000000209 PI651495
6000000210 PI653616
6000000211 PI653411
6000000212 PI586537
6000000214 PI583832
6000000215 PI641824
6000000216 PI641825
6000000217 PI566819
6000000219 PI505722
6000000220 PI505735
6000000221 PI562730
6000000222 PI297171
6000000223 PI506122
6000000225 PI154844
6000000226 PI508366
6000000227 PI506114
6000000228 PI506030
6000000230 PI267573
6000000231 PI564163
6000000233 PI533964
6000000235 PI35038
6000000236 PI561472
6000000752 PI266927
6000000810 PI329710
6000000811 PI329711
6000000812 PI329841
6000000813 PI329843
6000000814 PI329864
6000000815 PI329865
6000000816 PI330168
6000000817 PI330169
6000000818 PI330181
6000000819 PI330182
6000000820 PI330184
6000000821 PI330185
6000000822 PI330195
6000000823 PI330196
6000000550 PI297155
6000000824 PI330199
6000000552 PI302252
6000000553 PI303658
6000000554 PI329256
6000000555 PI329286
6000000556 PI329299
6000000557 PI329300
6000000558 PI329301
6000000559 PI329310
6000000560 PI329319
6000000561 PI329326
6000000689 PI152862
6000000690 PI152923
6000000691 PI152961
6000000692 PI152963
6000000693 PI152965
6000000694 PI152966
6000000695 PI152967
6000000696 PI152971
6000000697 PI153877
6000000698 PI154750
6000000700 PI154846
6000000701 PI154944
6000000702 PI154987
6000000703 PI154988
6000000704 PI155149
6000000705 PI155516
6000000706 PI155760
6000000707 PI155885
6000000708 PI156178
6000000625 PI337689
6000000709 PI156203
6000000710 PI156217
6000000711 PI156268
6000000712 PI156326
6000000713 PI156330
6000000714 PI156393
6000000715 PI156463
6000000716 PI156487
6000000717 PI156871
6000000718 PI156890
6000000719 PI157030
6000000720 PI157033
6000000721 PI157035
6000000722 PI157804
6000000723 PI167093
6000000724 PI170787
6000000725 PI175919
6000000726 PI176766
6000000727 PI179749
6000000728 PI180348
6000000729 PI181080
6000000730 PI181083
6000000731 PI195754
6000000732 PI196049
6000000733 PI196583
6000000734 PI196586
6000000735 PI196598
6000000736 PI197542
6000000737 PI19770
6000000738 PI213900
6000000739 PI217691
6000000740 PI218112
6000000741 PI221548
6000000742 PI221651
6000000743 PI226096
6000000744 PI22913
6000000745 PI229841
6000000746 PI251672
6000000747 PI253986
6000000748 PI255239
6000000749 PI255744
6000000750 PI257599
6000000839 PI455280
6000000840 PI455301
6000000841 PI455307
6000000842 PI505717
6000000850 PI510757
6000000851 PI511355
6000000852 PI513878
6000000853 PI514456
6000000854 PI521019
6000000855 PI521152
6000000856 PI521280
6000000857 PI521290
6000000858 PI524475
6000000859 PI525049
6000000860 PI52606
6000000861 PI526905
6000000862 PI527045
6000000863 PI533792
6000000864 PI533902
6000000865 PI533998
6000000866 PI535783
6000000868 PI535793
6000000869 PI535794
6000000870 PI535795
6000000871 PI535796
6000000872 PI540518
6000000873 PI550604
6000000874 PI561840
6000000875 PI562718
6000000877 PI562732
6000000878 PI562781
6000000879 PI562897
6000000880 PI562970
6000000881 PI562971
6000000882 PI562981
6000000883 PI562982
6000000884 PI562985
6000000885 PI562990
6000000886 PI562991
6000000887 PI562994
6000000888 PI562997
6000000889 PI562998
6000000890 PI563002
6000000891 PI563006
6000000892 PI563009
6000000893 PI563020
6000000894 PI563021
6000000895 PI563022
6000000896 PI563032
6000000897 PI563196
6000000898 PI563222
6000000899 PI563295
6000000900 PI563329
6000000901 PI563330
6000000902 PI563331
6000000903 PI563332
6000000904 PI563338
6000000905 PI563348
6000000906 PI563350
6000000907 PI563353
6000000910 PI568717
6000000911 PI569090
6000000912 PI569097
6000000913 PI569148
6000000914 PI569244
6000000915 PI569264
6000000916 PI569416
6000000917 PI569418
6000000918 PI569419
6000000919 PI569420
6000000920 PI569421
6000000921 PI569422
6000000922 PI569423
6000000923 PI569425
6000000924 PI569427
6000000925 PI569433
6000000926 PI569435
6000000927 PI569443
6000000928 PI569444
6000000929 PI569445
6000000930 PI569447
6000000931 PI569452
6000000937 PI569459
6000000938 PI569460
6000000939 PI569462
6000000940 PI569465
6000000941 PI569886
6000000942 PI570031
6000000943 PI570038
6000000944 PI570042
6000000945 PI570047
6000000946 PI570053
6000000947 PI570071
6000000948 PI570073
6000000949 PI570074
6000000950 PI570075
6000000951 PI570076
6000000952 PI570085
6000000953 PI570087
6000000954 PI570090
6000000955 PI570091
6000000956 PI570096
6000000957 PI570106
6000000958 PI570109
6000000959 PI570110
6000000960 PI570114
6000000961 PI570145
6000000962 PI570254
6000000963 PI570371
6000000964 PI570373
6000000965 PI570388
6000000966 PI570393
6000000967 PI570400
6000000968 PI570431
6000000969 PI573193
6000000970 PI576399
6000000971 PI576401
6000000973 PI585406
6000000974 PI585448
6000000975 PI585452
6000000976 PI585454
6000000977 PI585461
6000000978 PI585467
6000000979 PI585577
6000000980 PI585608
6000000981 PI585954
6000000982 PI585961
6000000983 PI585966
6000000984 PI586435
6000000985 PI586443
6000000986 PI586541
6000000987 PI593916
6000000988 PI619807
6000000989 PI619838
6000000990 PI620072
6000000991 PI620157
6000000992 PI63715
6000000994 PI641810
6000000995 PI641815
6000000996 PI641817
6000000997 PI641821
6000000999 PI641829
6000001000 PI641830
6000001001 PI641835
6000001002 PI641836
6000001003 PI641850
6000001004 PI641860
6000001005 PI641862
6000001006 PI641892
6000001007 PI641909
6000001008 PI642998
6000001009 PI643008
6000001010 PI643016
6000001011 PI646242
6000001012 PI646251
6000001013 PI646266
6000001015 PI651493
6000001018 PI651497
6000001020 PI653617
6000001021 PI655972
6000001022 PI655978
6000001023 PI655981
6000001024 PI655983
6000001025 PI656015
6000001026 PI656026
6000001027 PI656035
6000001028 PI656065
6000001029 PI92270
6000000993 PI641807
Raw
z1.01.sql
update sites_cultivars set cultivar_id =6000001384 where cultivar_id = 6000001903;
update sites_cultivars set cultivar_id =6000001400 where cultivar_id = 6000001952;
update sites_cultivars set cultivar_id =6000001404 where cultivar_id = 6000001909;
update sites_cultivars set cultivar_id =6000001405 where cultivar_id = 6000001912;
update sites_cultivars set cultivar_id =6000001416 where cultivar_id = 6000002079;
update sites_cultivars set cultivar_id =6000001417 where cultivar_id = 6000001974;
update sites_cultivars set cultivar_id =6000001419 where cultivar_id = 6000002058;
update sites_cultivars set cultivar_id =6000001425 where cultivar_id = 6000001926;
update sites_cultivars set cultivar_id =6000000468 where cultivar_id = 6000002030;
update sites_cultivars set cultivar_id =6000000567 where cultivar_id = 6000002057;
update sites_cultivars set cultivar_id =6000000568 where cultivar_id = 6000001987;
update sites_cultivars set cultivar_id =6000000231 where cultivar_id = 6000002037;
update sites_cultivars set cultivar_id =6000000235 where cultivar_id = 6000002085;
update sites_cultivars set cultivar_id =6000000863 where cultivar_id = 6000002029;
update sites_cultivars set cultivar_id =6000000865 where cultivar_id = 6000002026;
update sites_cultivars set cultivar_id =6000000970 where cultivar_id = 6000001968;
update sites_cultivars set cultivar_id =6000001002 where cultivar_id = 6000001899;
update sites_cultivars set cultivar_id =6000001008 where cultivar_id = 6000002068;
update sites_cultivars set cultivar_id =6000001020 where cultivar_id = 6000001928;
update sites_cultivars set cultivar_id =6000001021 where cultivar_id = 6000001943;
update sites_cultivars set cultivar_id =6000001022 where cultivar_id = 6000002003;
update sites_cultivars set cultivar_id =6000001025 where cultivar_id = 6000001977;
update sites_cultivars set cultivar_id =6000001027 where cultivar_id = 6000002077;
update sites_cultivars set cultivar_id =6000001028 where cultivar_id = 6000002105;
Raw
z1.1.sql
delete from cultivars where id =6000001903;
delete from cultivars where id =6000001952;
delete from cultivars where id =6000001909;
delete from cultivars where id =6000001912;
delete from cultivars where id =6000002079;
delete from cultivars where id =6000001974;
delete from cultivars where id =6000002058;
delete from cultivars where id =6000001926;
delete from cultivars where id =6000002030;
delete from cultivars where id =6000002057;
delete from cultivars where id =6000001987;
delete from cultivars where id =6000002037;
delete from cultivars where id =6000002085;
delete from cultivars where id =6000002029;
delete from cultivars where id =6000002026;
delete from cultivars where id =6000001968;
delete from cultivars where id =6000001899;
delete from cultivars where id =6000002068;
delete from cultivars where id =6000001928;
delete from cultivars where id =6000001943;
delete from cultivars where id =6000002003;
delete from cultivars where id =6000001977;
delete from cultivars where id =6000002077;
delete from cultivars where id =6000002105;
Raw
z1.sql
update traits set cultivar_id =6000001384 where cultivar_id = 6000001903;
update traits set cultivar_id =6000001400 where cultivar_id = 6000001952;
update traits set cultivar_id =6000001404 where cultivar_id = 6000001909;
update traits set cultivar_id =6000001405 where cultivar_id = 6000001912;
update traits set cultivar_id =6000001416 where cultivar_id = 6000002079;
update traits set cultivar_id =6000001417 where cultivar_id = 6000001974;
update traits set cultivar_id =6000001419 where cultivar_id = 6000002058;
update traits set cultivar_id =6000001425 where cultivar_id = 6000001926;
update traits set cultivar_id =6000000468 where cultivar_id = 6000002030;
update traits set cultivar_id =6000000567 where cultivar_id = 6000002057;
update traits set cultivar_id =6000000568 where cultivar_id = 6000001987;
update traits set cultivar_id =6000000231 where cultivar_id = 6000002037;
update traits set cultivar_id =6000000235 where cultivar_id = 6000002085;
update traits set cultivar_id =6000000863 where cultivar_id = 6000002029;
update traits set cultivar_id =6000000865 where cultivar_id = 6000002026;
update traits set cultivar_id =6000000970 where cultivar_id = 6000001968;
update traits set cultivar_id =6000001002 where cultivar_id = 6000001899;
update traits set cultivar_id =6000001008 where cultivar_id = 6000002068;
update traits set cultivar_id =6000001020 where cultivar_id = 6000001928;
update traits set cultivar_id =6000001021 where cultivar_id = 6000001943;
update traits set cultivar_id =6000001022 where cultivar_id = 6000002003;
update traits set cultivar_id =6000001025 where cultivar_id = 6000001977;
update traits set cultivar_id =6000001027 where cultivar_id = 6000002077;
update traits set cultivar_id =6000001028 where cultivar_id = 6000002105;
Raw
z3.sql
update cultivars set name ='PI598070' where name = 'PI_598070';
update cultivars set name ='PI533997' where name = 'PI_533997';
update cultivars set name ='PI597946' where name = 'PI_597946';
update cultivars set name ='PI533937' where name = 'PI_533937';
update cultivars set name ='PI655984' where name = 'PI_655984';
update cultivars set name ='PI659695' where name = 'PI_659695';
update cultivars set name ='PI656058' where name = 'PI_656058';
update cultivars set name ='PI533769' where name = 'PI_533769';
update cultivars set name ='PI576364' where name = 'PI_576364';
update cultivars set name ='PI533750' where name = 'PI_533750';
update cultivars set name ='PI533855' where name = 'PI_533855';
update cultivars set name ='PI656112' where name = 'PI_656112';
update cultivars set name ='PI656081' where name = 'PI_656081';
update cultivars set name ='PI552856' where name = 'PI_552856';
update cultivars set name ='PI534096' where name = 'PI_534096';
update cultivars set name ='PI533911' where name = 'PI_533911';
update cultivars set name ='PI534114' where name = 'PI_534114';
update cultivars set name ='PI533970' where name = 'PI_533970';
update cultivars set name ='PI655977' where name = 'PI_655977';
update cultivars set name ='PI533766' where name = 'PI_533766';
update cultivars set name ='PI534139' where name = 'PI_534139';
update cultivars set name ='PI613536' where name = 'PI_613536';
update cultivars set name ='PI651492' where name = 'PI_651492';
update cultivars set name ='PI656005' where name = 'PI_656005';
update cultivars set name ='PI656001' where name = 'PI_656001';
update cultivars set name ='PI534138' where name = 'PI_534138';
update cultivars set name ='PI534075' where name = 'PI_534075';
update cultivars set name ='PI656052' where name = 'PI_656052';
update cultivars set name ='PI656031' where name = 'PI_656031';
update cultivars set name ='PI656054' where name = 'PI_656054';
update cultivars set name ='PI576332' where name = 'PI_576332';
update cultivars set name ='PI655974' where name = 'PI_655974';
update cultivars set name ='PI656083' where name = 'PI_656083';
update cultivars set name ='PI17548' where name = 'PI_17548';
update cultivars set name ='PI534092' where name = 'PI_534092';
update cultivars set name ='PI533754' where name = 'PI_533754';
update cultivars set name ='PI534148' where name = 'PI_534148';
update cultivars set name ='PI576339' where name = 'PI_576339';
update cultivars set name ='PI534037' where name = 'PI_534037';
update cultivars set name ='PI534145' where name = 'PI_534145';
update cultivars set name ='PI533991' where name = 'PI_533991';
update cultivars set name ='PI656109' where name = 'PI_656109';
update cultivars set name ='PI595740' where name = 'PI_595740';
update cultivars set name ='PI576337' where name = 'PI_576337';
update cultivars set name ='PI642992' where name = 'PI_642992';
update cultivars set name ='PI656079' where name = 'PI_656079';
update cultivars set name ='PI534046' where name = 'PI_534046';
update cultivars set name ='PI656096' where name = 'PI_656096';
update cultivars set name ='PI540816' where name = 'PI_540816';
update cultivars set name ='PI533961' where name = 'PI_533961';
update cultivars set name ='PI533955' where name = 'PI_533955';
update cultivars set name ='PI533954' where name = 'PI_533954';
update cultivars set name ='PI656037' where name = 'PI_656037';
update cultivars set name ='PI533833' where name = 'PI_533833';
update cultivars set name ='PI533845' where name = 'PI_533845';
update cultivars set name ='PI533936' where name = 'PI_533936';
update cultivars set name ='PI533755' where name = 'PI_533755';
update cultivars set name ='PI656095' where name = 'PI_656095';
update cultivars set name ='PI656008' where name = 'PI_656008';
update cultivars set name ='PI656116' where name = 'PI_656116';
update cultivars set name ='PI656121' where name = 'PI_656121';
update cultivars set name ='PI576385' where name = 'PI_576385';
update cultivars set name ='PI597980' where name = 'PI_597980';
update cultivars set name ='PI533830' where name = 'PI_533830';
update cultivars set name ='PI659691' where name = 'PI_659691';
update cultivars set name ='PI597951' where name = 'PI_597951';
update cultivars set name ='PI576345' where name = 'PI_576345';
update cultivars set name ='PI533967' where name = 'PI_533967';
update cultivars set name ='PI533986' where name = 'PI_533986';
update cultivars set name ='PI533839' where name = 'PI_533839';
update cultivars set name ='PI533776' where name = 'PI_533776';
update cultivars set name ='PI533915' where name = 'PI_533915';
update cultivars set name ='PI656087' where name = 'PI_656087';
update cultivars set name ='PI533938' where name = 'PI_533938';
update cultivars set name ='PI655991' where name = 'PI_655991';
update cultivars set name ='PI597961' where name = 'PI_597961';
update cultivars set name ='PI533912' where name = 'PI_533912';
update cultivars set name ='PI533877' where name = 'PI_533877';
update cultivars set name ='PI656013' where name = 'PI_656013';
update cultivars set name ='PI656009' where name = 'PI_656009';
update cultivars set name ='PI533871' where name = 'PI_533871';
update cultivars set name ='PI655987' where name = 'PI_655987';
update cultivars set name ='PI533762' where name = 'PI_533762';
update cultivars set name ='PI576394' where name = 'PI_576394';
update cultivars set name ='PI656119' where name = 'PI_656119';
update cultivars set name ='PI585291' where name = 'PI_585291';
update cultivars set name ='PI585295' where name = 'PI_585295';
update cultivars set name ='PI597957' where name = 'PI_597957';
update cultivars set name ='PI533979' where name = 'PI_533979';
update cultivars set name ='PI552861' where name = 'PI_552861';
update cultivars set name ='PI656016' where name = 'PI_656016';
update cultivars set name ='PI576340' where name = 'PI_576340';
update cultivars set name ='PI656073' where name = 'PI_656073';
update cultivars set name ='PI576418' where name = 'PI_576418';
update cultivars set name ='PI533987' where name = 'PI_533987';
update cultivars set name ='PI533807' where name = 'PI_533807';
update cultivars set name ='PI533788' where name = 'PI_533788';
update cultivars set name ='PI576422' where name = 'PI_576422';
update cultivars set name ='PI576376' where name = 'PI_576376';
update cultivars set name ='PI597967' where name = 'PI_597967';
update cultivars set name ='PI595720' where name = 'PI_595720';
update cultivars set name ='PI576390' where name = 'PI_576390';
update cultivars set name ='PI534108' where name = 'PI_534108';
update cultivars set name ='PI534088' where name = 'PI_534088';
update cultivars set name ='PI656085' where name = 'PI_656085';
update cultivars set name ='PI642791' where name = 'PI_642791';
update cultivars set name ='PI656115' where name = 'PI_656115';
update cultivars set name ='PI533799' where name = 'PI_533799';
update cultivars set name ='PI533927' where name = 'PI_533927';
update cultivars set name ='PI533980' where name = 'PI_533980';
update cultivars set name ='PI656078' where name = 'PI_656078';
update cultivars set name ='PI656060' where name = 'PI_656060';
update cultivars set name ='PI533794' where name = 'PI_533794';
update cultivars set name ='PI576373' where name = 'PI_576373';
update cultivars set name ='PI656041' where name = 'PI_656041';
update cultivars set name ='PI576435' where name = 'PI_576435';
update cultivars set name ='PI656074' where name = 'PI_656074';
update cultivars set name ='PI576352' where name = 'PI_576352';
update cultivars set name ='PI656105' where name = 'PI_656105';
update cultivars set name ='PI533913' where name = 'PI_533913';
update cultivars set name ='PI534079' where name = 'PI_534079';
update cultivars set name ='PI656098' where name = 'PI_656098';
update cultivars set name ='PI533956' where name = 'PI_533956';
update cultivars set name ='PI656059' where name = 'PI_656059';
update cultivars set name ='PI656018' where name = 'PI_656018';
update cultivars set name ='PI656089' where name = 'PI_656089';
update cultivars set name ='PI656055' where name = 'PI_656055';
update cultivars set name ='PI656019' where name = 'PI_656019';
update cultivars set name ='PI534105' where name = 'PI_534105';
update cultivars set name ='PI534167' where name = 'PI_534167';
update cultivars set name ='PI533866' where name = 'PI_533866';
update cultivars set name ='PI655998' where name = 'PI_655998';
update cultivars set name ='PI655994' where name = 'PI_655994';
update cultivars set name ='PI533910' where name = 'PI_533910';
update cultivars set name ='PI597965' where name = 'PI_597965';
update cultivars set name ='PI659694' where name = 'PI_659694';
update cultivars set name ='PI576428' where name = 'PI_576428';
update cultivars set name ='PI656107' where name = 'PI_656107';
update cultivars set name ='PI576387' where name = 'PI_576387';
update cultivars set name ='PI533965' where name = 'PI_533965';
update cultivars set name ='PI656093' where name = 'PI_656093';
update cultivars set name ='PI656102' where name = 'PI_656102';
update cultivars set name ='PI533876' where name = 'PI_533876';
update cultivars set name ='PI576380' where name = 'PI_576380';
update cultivars set name ='PI656117' where name = 'PI_656117';
update cultivars set name ='PI561071' where name = 'PI_561071';
update cultivars set name ='PI656094' where name = 'PI_656094';
update cultivars set name ='PI656003' where name = 'PI_656003';
update cultivars set name ='PI595718' where name = 'PI_595718';
update cultivars set name ='PI597966' where name = 'PI_597966';
update cultivars set name ='PI656104' where name = 'PI_656104';
update cultivars set name ='PI656086' where name = 'PI_656086';
update cultivars set name ='PI533996' where name = 'PI_533996';
update cultivars set name ='PI659696' where name = 'PI_659696';
update cultivars set name ='PI533882' where name = 'PI_533882';
update cultivars set name ='PI656101' where name = 'PI_656101';
update cultivars set name ='PI656118' where name = 'PI_656118';
update cultivars set name ='PI656106' where name = 'PI_656106';
update cultivars set name ='PI534101' where name = 'PI_534101';
update cultivars set name ='PI576425' where name = 'PI_576425';
update cultivars set name ='PI595744' where name = 'PI_595744';
update cultivars set name ='PI48770' where name = 'PI_48770';
update cultivars set name ='PI576396' where name = 'PI_576396';
update cultivars set name ='PI656088' where name = 'PI_656088';
update cultivars set name ='PI534097' where name = 'PI_534097';
update cultivars set name ='PI533948' where name = 'PI_533948';
update cultivars set name ='PI534063' where name = 'PI_534063';
update cultivars set name ='PI656034' where name = 'PI_656034';
update cultivars set name ='PI655990' where name = 'PI_655990';
update cultivars set name ='PI576375' where name = 'PI_576375';
update cultivars set name ='PI655979' where name = 'PI_655979';
update cultivars set name ='PI576347' where name = 'PI_576347';
update cultivars set name ='PI533789' where name = 'PI_533789';
update cultivars set name ='PI656113' where name = 'PI_656113';
update cultivars set name ='PI534070' where name = 'PI_534070';
update cultivars set name ='PI656022' where name = 'PI_656022';
update cultivars set name ='PI534123' where name = 'PI_534123';
update cultivars set name ='PI576348' where name = 'PI_576348';
update cultivars set name ='PI595714' where name = 'PI_595714';
update cultivars set name ='PI597950' where name = 'PI_597950';
update cultivars set name ='PI656076' where name = 'PI_656076';
update cultivars set name ='PI534117' where name = 'PI_534117';
update cultivars set name ='PI597949' where name = 'PI_597949';
update cultivars set name ='PI656000' where name = 'PI_656000';
update cultivars set name ='PI533841' where name = 'PI_533841';
update cultivars set name ='PI576350' where name = 'PI_576350';
update cultivars set name ='PI548797' where name = 'PI_548797';
update cultivars set name ='PI576437' where name = 'PI_576437';
update cultivars set name ='PI659693' where name = 'PI_659693';
update cultivars set name ='PI656050' where name = 'PI_656050';
update cultivars set name ='PI533901' where name = 'PI_533901';
update cultivars set name ='PI656108' where name = 'PI_656108';
update cultivars set name ='PI533939' where name = 'PI_533939';
update cultivars set name ='PI534137' where name = 'PI_534137';
update cultivars set name ='PI533757' where name = 'PI_533757';
update cultivars set name ='PI656053' where name = 'PI_656053';
update cultivars set name ='PI597960' where name = 'PI_597960';
update cultivars set name ='PI576349' where name = 'PI_576349';
update cultivars set name ='PI656002' where name = 'PI_656002';
update cultivars set name ='PI656042' where name = 'PI_656042';
update cultivars set name ='PI655989' where name = 'PI_655989';
update cultivars set name ='PI533962' where name = 'PI_533962';
update cultivars set name ='PI534163' where name = 'PI_534163';
update cultivars set name ='PI533949' where name = 'PI_533949';
update cultivars set name ='PI533785' where name = 'PI_533785';
update cultivars set name ='PI542406' where name = 'PI_542406';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment