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" +