9007158bac3746b1eb7f76513c8e8631e1ca1ca2
braney
  Fri Mar 21 13:18:22 2025 -0700
add decipher SQL tracks to quickLift support

diff --git src/hg/makeDb/doc/genarkOrg.txt src/hg/makeDb/doc/genarkOrg.txt
new file mode 100644
index 00000000000..2197d4b1dcc
--- /dev/null
+++ src/hg/makeDb/doc/genarkOrg.txt
@@ -0,0 +1,6 @@
+ hgsql hgcentraltest -Ne "select taxId, gcAccession from genark"  | sort > /tmp/1
+ hgsql hgcentraltest -Ne "select taxId, genome from dbDb group by taxId"  | sort > /tmp/2
+ hgsql hgcentraltest -Ne "create table genarkOrg (gcAccession varchar(255), genome varchar(255))"
+ join -t $'\t' /tmp/1 /tmp/2 | cut -f 2- > /tmp/3
+ hgsql hgcentraltest -Ne "load data local infile '/tmp/3' into table genarkOrg"
+