4c3e9c5bca8c085e7cb5c7caece08a6ea93222be
hiram
  Tue Aug 29 12:54:45 2023 -0700
adding new hprc row to grp table refs #31561

diff --git src/hg/makeDb/doc/hg38/hg38.txt src/hg/makeDb/doc/hg38/hg38.txt
index b563a9f..f45ee29 100644
--- src/hg/makeDb/doc/hg38/hg38.txt
+++ src/hg/makeDb/doc/hg38/hg38.txt
@@ -7202,15 +7202,58 @@
         -query2Bit=/hive/data/genomes/hg38/hg38.2bit \
         -querySizes=/hive/data/genomes/hg38/chrom.sizes \
         -ooc=/hive/data/genomes/asmHubs/genbankBuild/GCA/018/503/275/GCA_018503275.1_NA19240.pri.mat.f1_v2/GCA_018503275.1_NA19240.pri.mat.f1_v2.11.ooc \
          GCA_018503275.1 hg38) > liftOverToHg38.log 2>&1
     # real    5082m17.500s
 
     # this is interesting, this alignment completed and actually has good
     # coverage:
     cat fb.GCA_018503275.1.chain.Hg38Link.txt
     # 2928654519 bases of 3032066086 (96.589%) in intersection
 
     # see if the liftOver menus function in the browser from GCA_018503275.1
     #    to hg38
 
 ##############################################################################
+## update grp table add new row for HPRC (DONE - 2023-08-29 - Hiram)
+## existing structure:
+
+    hgsql -e 'desc grp;' hg38
+
++-----------------+-----------+------+-----+---------+-------+
+| Field           | Type      | Null | Key | Default | Extra |
++-----------------+-----------+------+-----+---------+-------+
+| name            | char(255) | NO   | PRI |         |       |
+| label           | char(255) | NO   |     |         |       |
+| priority        | float     | NO   |     | 0       |       |
+| defaultIsClosed | int(11)   | YES  |     | NULL    |       |
++-----------------+-----------+------+-----+---------+-------+
+
+    #  add one new row:
+    hgsql hg38 \
+      -e "INSERT INTO grp VALUES ('hprc', 'Human Pangenome - HPRC', 3.6, 0);"
+
+    # resulting table:
+
+    hgsql -e 'select * from grp order by priority;' hg38
++------------+------------------------------------+----------+-----------------+
+| name       | label                              | priority | defaultIsClosed |
++------------+------------------------------------+----------+-----------------+
+| user       | Custom Tracks                      |        1 |               0 |
+| remc       | Reference Epigenome Mapping Center |      1.2 |               1 |
+| map        | Mapping and Sequencing             |        2 |               0 |
+| genes      | Genes and Gene Predictions         |        3 |               0 |
+| phenDis    | Phenotype and Literature           |      3.4 |               0 |
+| pub        | Literature                         |      3.5 |               0 |
+| hprc       | Human Pangenome - HPRC             |      3.6 |               0 |
+| covid      | COVID-19                           |      3.6 |               0 |
+| singleCell | Single Cell RNA-seq                |      3.7 |               0 |
+| rna        | mRNA and EST                       |        4 |               0 |
+| expression | Expression                         |      4.5 |               0 |
+| regulation | Regulation                         |        5 |               0 |
+| compGeno   | Comparative Genomics               |        6 |               0 |
+| varRep     | Variation                          |        7 |               0 |
+| rep        | Repeats                            |        8 |               0 |
+| x          | Experimental                       |       10 |               1 |
++------------+------------------------------------+----------+-----------------+
+
+##############################################################################