src/hg/lib/gbSeq.as 1.2

Index: src/hg/lib/gbSeq.as
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/gbSeq.as,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/lib/gbSeq.as	4 Jul 2009 07:14:20 -0000	1.1
+++ src/hg/lib/gbSeq.as	29 Apr 2010 03:40:21 -0000	1.2
@@ -1,14 +1,26 @@
-table gbSeq
-"Information about sequences contained in files described in gbExtFile"
+table gbCdnaInfo
+"Links together various info associated with a GenBank mRNA or EST"
     (
-    uint id;		"ID/index"
-    string acc;		"Accession of sequence"
-    int version;        "Genbank version"
-    uint size;		"Size of sequence (number of bases)"
-    uint gbExtFile;	"ID/index of file in gbExtFile"
-    bigint file_offset;	"byte offset of sequence in file"
-    uint file_size;	"byte size of sequence in file"
-    enum('EST','mRNA','PEP')  type;   "Type of sequence"
-    enum('GenBank','RefSeq','Other') srcDb;  "Source database"
+    uint id;	"Unique numerical id for cDNA"
+    string acc; "Genbank/EMBL accession (without .version)"
+    ushort version; "Version number in Genbank"
+    string moddate; "Date last modified, in SQL DATE format/ascii YYYY-MM-DD"
+    string type; "Either EST or mRNA.  In SQL an ENUM"
+    string direction; "Enum 5, 3 for read direction 5'/3', or 0 unknown."
+    uint source;      "Link to id in source table saying where cDNA came from"
+    uint organism;    "Link to id in organism table."
+    uint library;     "Link to id in library table."
+    uint mrnaClone;   "Link to id in mrnaClone table."
+    uint sex;         "Link to id in sex table"
+    uint tissue;      "Link to id in tissue table"
+    uint development; "Link to id in development table"
+    uint cell;        "Link to id in cell table"
+    uint cds;         "Link to id in cds table"
+    uint keyword;     "Link to id in keyword table"
+    uint description; "Link to id in description table"
+    uint geneName;    "Link to id in geneName table"
+    uint productName; "Link to id in productName table"
+    uint author;      "Link to id in author table"
+    uint gi;          "Genbank identifier"
+    enum ('DNA', 'RNA', 'ds-RNA', 'ds-mRNA', 'ds-rRNA', 'mRNA', 'ms-DNA', 'ms-RNA', 'rRNA', 'scRNA', 'snRNA', 'snoRNA', 'ss-DNA', 'ss-RNA', 'ss-snoRNA', 'tRNA') mol; "molecule type"
     )
-