diff options
| author | Pjotr Prins | 2024-01-01 16:26:48 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2024-03-02 17:11:23 -0600 |
| commit | 047f236857d075b9cf9d1447b8c65bc0d7089a8a (patch) | |
| tree | 454a867cacbb036e899ce0f4770358f13d7e037c | |
| parent | 7a241fac2234c1d0cc50bc5574cff6d4b859ee75 (diff) | |
| download | genenetwork2-047f236857d075b9cf9d1447b8c65bc0d7089a8a.tar.gz | |
Doc database layout
| -rw-r--r-- | doc/database.org | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/database.org b/doc/database.org index 8bf2a404..82026697 100644 --- a/doc/database.org +++ b/doc/database.org @@ -32,6 +32,7 @@ select table_name,round(((data_length + index_length) / 1024 / 1024), 2) `Size i | ProbeSet | 2880.21 | ProbeSetInfo <- trait, e.g. 100001_at | ProbeSetFreeze | 0.22 | DatasetInfo <- dataset, e.g. "Hippocampus_BXD_Jun06" | Probe | 2150.30 | ProbeInfo <- trait info incl sequence +| ProbeFreeze | 0.06 | | Phenotype | 6.50 | PhenotypeMeta <- "Hippocampus weight" | ProbeXRef | 743.38 | ProbeFreezeDataIDs <- link ProbeFreezeId,ProbeId with DataId | Datasets | 2.31 | DatasetMeta <- "Data generated by..." @@ -42,6 +43,7 @@ select table_name,round(((data_length + index_length) / 1024 / 1024), 2) `Size i | PublishData | 22.54 | PublishStrainValues <- id, strainId, value (3M traits) | PublishSE | 4.71 | Published SE (300K traits) | PublishXRef | 2.18 | List of changes on editing data (mostly Rob) +| InbredSet | 0.01 | InbredSetMeta -> Id,SpeciesId,FullName +-------------------------+------------+ Less commonly used tables: @@ -53,7 +55,7 @@ Less commonly used tables: | SnpAll | 15484.67 | | SnpPattern | 9177.05 | | QuickSearch | 5972.86 | -| GenoData | 3291.91 | +| GenoData | 3291.91 | Strain by genotype - only used in GN1 | CeleraINFO_mm6 | 989.80 | | pubmedsearch | 1032.50 | | GeneRIF_BASIC | 448.54 | @@ -63,7 +65,7 @@ Less commonly used tables: | Genbank | 37.71 | | AccessLog | 42.38 | | GeneList | 34.11 | -| Geno | 33.90 | +| Geno | 33.90 | Marker probe info (incl. sequence) | MachineAccessLog | 28.34 | | IndelAll | 22.42 | | ProbeH2 | 13.26 | @@ -94,7 +96,6 @@ Less commonly used tables: | TableFieldAnnotation | 0.05 | | DatasetMapInvestigator | 0.05 | | User | 0.04 | -| ProbeFreeze | 0.06 | | TableComments | 0.02 | | Investigators | 0.02 | | DBList | 0.03 | @@ -102,11 +103,10 @@ Less commonly used tables: | GeneChip | 0.01 | | GeneCategory | 0.01 | | SampleXRef | 0.01 | -| InbredSet | 0.01 | InbredSetMeta -> Id,SpeciesId,FullName | SnpAllele_to_be_deleted | 0.00 | | Organizations | 0.01 | | PublishFreeze | 0.00 | -| GenoFreeze | 0.00 | +| GenoFreeze | 0.00 | Used for public/private | Chr_Length | 0.01 | | SnpSource | 0.00 | | AvgMethod | 0.00 | |