7d0d819ed29f8a0501c3e8e99930b83ccdbf65e4
hiram
  Mon Apr 12 14:01:50 2021 -0700
genark table definition to relate GC accession to hub url refs #27285

diff --git src/hg/lib/genark.sql src/hg/lib/genark.sql
new file mode 100644
index 0000000..17503cc
--- /dev/null
+++ src/hg/lib/genark.sql
@@ -0,0 +1,16 @@
+# genark.sql was originally generated by the autoSql program, which also 
+# generated genark.c and genark.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#index to UCSC assembly hubs
+CREATE TABLE genark (
+    gcAccession varchar(255) not null,	# GC[AF] accssion identifier, e.g.: GCF_000001405.39
+    hubUrl varchar(255) not null,	# path name to hub.txt: GCF/000/001/405/GCF_000001405.39/hub.txt
+    asmName varchar(255) not null,	# assembly name: GRCh38.p13
+    scientificName varchar(255) not null,	# scientific name: Homo sapiens
+    commonName varchar(255) not null,	# common name: human
+    taxId int not null,	# taxon id: 9606
+              #Indices
+    PRIMARY KEY(gcAccession)
+);