Schema for decipherRaw
  Database: hg19    Primary Table: decipherRaw    Row Count: 38,339   Data last updated: 2020-08-10
On download server: MariaDB table dump directory
fieldexampleSQL type info
id 1002varchar(40) values
chr 9varchar(40) values
start 97336045int(10) range
end 102019119int(10) range
mean_ratio -0.8varchar(255) values
genotype Heterozygoustext values
variant_class Deletiontext values
inheritance De novotext values
pathogenicity Unknowntext values
contribution Unknowntext values
phenotypes Feeding difficulties in inf...text values

Connected Tables and Joining Fields
        hg19.decipher.name (via decipherRaw.id)
      hg19.knownCanonToDecipher.value (via decipherRaw.id)
      hg19.knownToDecipher.value (via decipherRaw.id)

Sample Rows
 
idchrstartendmean_ratiogenotypevariant_classinheritancepathogenicitycontributionphenotypes
1002997336045102019119-0.8HeterozygousDeletionDe novoUnknownUnknownFeeding difficulties in infancy|Hyperactivity|Intellectual disability|Large for gestational age|Muscular hypotonia|Pectus excava ...
10039138932676141153431-1HeterozygousDeletionUnknownUnknownUnknownAtrial septal defect|Cryptorchidism|Hypospadias|Intellectual disability|Microcephaly|Micropenis|Multiple renal cysts|Muscular hy ...
1005221977135519771891-0.6HeterozygousDeletionUnknownUnknownUnknownAutism|Intellectual disability
101314104522565107289540-1HeterozygousDeletionDe novoUnknownUnknownAbnormality of the forehead|Blepharophimosis|Bulbous nose|Clinodactyly of the 5th finger|High palate|Hypertelorism|Intellectual ...
10151220916999226162869-0.5HeterozygousDeletionDe novoUnknownUnknownCleft palate|Coarse facial features|Congenital diaphragmatic hernia|Delayed cranial suture closure|Depressed nasal bridge|Infra- ...
1016224557422451244566-1HeterozygousDeletionDe novoUnknownUnknownAbnormality of the face|Delayed speech and language development|Intellectual disability|Muscular hypotonia
10183142672191155803488-0.8327HeterozygousDeletionDe novoUnknownUnknownAnteverted nares|Aplasia cutis congenita of scalp|Blepharophimosis|Broad thumb|Delayed speech and language development|Fine hair ...
1019161723036817409257-0.9419HeterozygousDeletionUnknownUnknownUnknownArachnodactyly|Delayed speech and language development|Intellectual disability|Kyphosis|Microcephaly|Open mouth|Pes cavus|Propor ...
1020128005638092843830-0.7659HeterozygousDeletionUnknownUnknownUnknownIntellectual disability|Macroglossia|Strabismus|Tongue fasciculations
1024185329458953497081-0.6HeterozygousDeletionUnknownUnknownUnknownAbnormality of the hand|Ataxia|Delayed speech and language development|Hypoplasia of the corpus callosum|Intellectual disability ...

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