f100609c5d2e4a9b54074f4e374972ceb7cefc07
braney
  Fri Apr 29 09:30:10 2016 -0700
add knownAttrs table to capture what's in the wgEncodeGencodeAttrs table

diff --git src/hg/lib/knownAttrs.sql src/hg/lib/knownAttrs.sql
new file mode 100644
index 0000000..0dc664e
--- /dev/null
+++ src/hg/lib/knownAttrs.sql
@@ -0,0 +1,21 @@
+# knownAttrs.sql was originally generated by the autoSql program, which also 
+# generated knownAttrs.c and knownAttrs.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#Fields in Gencode attrs table that aren't in kgXref
+CREATE TABLE knownAttrs (
+    kgID varchar(255) not null,	# Known Gene ID
+    geneId varchar(255) not null,	# ENSG* locus identifier
+    geneStatus varchar(255) not null,	# KNOWN or NOVEL
+    geneType varchar(255) not null,	# gene function
+    transcriptName varchar(255) not null,	# transcript Name
+    transcriptType varchar(255) not null,	# transcript Type
+    transcriptStatus varchar(255) not null,	# KNOWN or NOVEL or PUTATIVE
+    havanaGeneId varchar(255) not null,	# Havana project Id
+    ccdsId varchar(255) not null,	# CCDS project Id
+    supportLevel varchar(255) not null,	# transcript support level
+    transcriptClass varchar(255) not null,	# pseudo, nonCoding, coding, or problem
+              #Indices
+    PRIMARY KEY(kgID)
+);