src/hg/lib/gbCdnaInfo.as 1.4
1.4 2010/04/28 19:55:51 markd
update schema doc
Index: src/hg/lib/gbCdnaInfo.as
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/gbCdnaInfo.as,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 1000000 -r1.3 -r1.4
--- src/hg/lib/gbCdnaInfo.as 14 Mar 2007 23:29:14 -0000 1.3
+++ src/hg/lib/gbCdnaInfo.as 28 Apr 2010 19:55:51 -0000 1.4
@@ -1,26 +1,26 @@
table gbCdnaInfo
"Links together various info associated with a GenBank mRNA or EST"
(
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."
+ enum('EST','mRNA') type; "Either EST or mRNA.
+ enum('5','3','0') direction; "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"
)