Schema for submissionSet
  Database: visiGene    Primary Table: submissionSet    Row Count: 1,118   Data last updated: 2007-02-09
Format description: Info on a batch of images submitted at once
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of submission set
name mahoneyWhole01varchar(255) values Name of submission set
contributors Gray P.A., Fu H., Luo P., Z...longblob   Comma-separated list of contributors in format Kent W.J., Wu F.Y.
year 2004int(11) range Year of publication or submission
publication Mouse brain organization re...longblob   Name of publication
pubUrl http://www.ncbi.nlm.nih.gov...longblob   Publication URL
journal 1int(11) range Journal for publication
copyright 0int(11) range Copyright notice
submissionSource 1int(11) range Source of this submission
privateUser 0int(11) range  

Connected Tables and Joining Fields
        visiGene.copyright.id (via submissionSet.copyright)
      visiGene.image.submissionSet (via submissionSet.id)
      visiGene.imageFile.submissionSet (via submissionSet.id)
      visiGene.submissionContributor.submissionSet (via submissionSet.id)
      visiGene.journal.id (via submissionSet.journal)
      visiGene.antibodySource.submissionSource (via submissionSet.submissionSource)
      visiGene.submissionSource.id (via submissionSet.submissionSource)

Sample Rows
 
idnamecontributorsyearpublicationpubUrljournalcopyrightsubmissionSourceprivateUser
1mahoneyWhole01Gray P.A., Fu H., Luo P., Zhao Q., Yu J., Ferrari A., Tenzen T., Yuk D., Tsung E.F., Cai Z., Alberta J.A., Cheng L., Liu Y., Ste ...2004Mouse brain organization revealed through direct genome-scale TF expression analysishttp://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=156185181010
2mahoneySlices01Gray P.A., Fu H., Luo P., Zhao Q., Yu J., Ferrari A., Tenzen T., Yuk D., Tsung E.F., Cai Z., Alberta J.A., Cheng L., Liu Y., Ste ...2004Mouse brain organization revealed through direct genome-scale TF expression analysishttp://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=156185181010
2898jax96129Komohara Y.,Terasaki Y.,Kaikita K.,Suzuki H.,Kodama T.,Takeya M.,2005Clearance of apoptotic cells is not impaired in mouse embryos deficient in class A scavenger receptor types I and II (CD204).http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=155805715118670
2897jax96012Kishigami S.,Yoshikawa S.,Castranio T.,Okazaki K.,Furuta Y.,Mishina Y.,2004BMP signaling through ACVRI is required for left-right patterning in the early mouse embryo.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=155313733118570
2896jax95865Yoshida H.,Okabe Y.,Kawane K.,Fukuyama H.,Nagata S.,2005Lethal anemia caused by interferon-beta produced in mouse embryos carrying undigested DNA.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=1556802517118470
2895jax95532Jonker L.,Kist R.,Aw A.,Wappler I.,Peters H.,2004Pax9 is required for filiform papilla development and suppresses skin-specific differentiation of the mammalian tongue epitheliu ...http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=15454262968670
2894jax95449Tripodi M.,Filosa A.,Armentano M.,Studer M.,2004The COUP-TF nuclear receptors regulate cell migration in the mammalian basal forebrain.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=15548577268570
2893jax95448Haubst N.,Berger J.,Radjendirane V.,Graw J.,Favor J.,Saunders G.F.,Stoykova A.,Gotz M.,2004Molecular dissection of Pax6 function: the specific roles of the paired domain and homeodomain in brain development.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=15548580268470
2892jax95388Chan R.,Hardy W.R.,Dankort D.,Laing M.A.,Muller W.J.,2004Modulation of Erbb2 signaling during development: a threshold level of Erbb2 signaling is required for development.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=15496447268370
2890jax95245Bock-Marquette I.,Saxena A.,White M.D.,Dimaio J.M.,Srivastava D.,2004Thymosin beta4 activates integrin-linked kinase and promotes cardiac cell migration, survival and cardiac repair.http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=1556514546817-1

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.