diff options
| author | Munyoki Kilyungi | 2023-06-06 14:45:16 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2023-06-12 19:06:36 +0300 |
| commit | 0f9e3501be54e951c9101d448e8003ad693f6834 (patch) | |
| tree | a111d1c2b1cc12925fe57fec35e25aa3144f0095 | |
| parent | b6f9d895600a330ddf59bf5c8c55828fe7c613c2 (diff) | |
| download | gn-transform-databases-0f9e3501be54e951c9101d448e8003ad693f6834.tar.gz | |
Add missing Species join when dumping datasets
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/dump-dataset-metadata.scm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index bdf8a7d..7519582 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -85,6 +85,7 @@ (left-join GenoFreeze "ON InfoFiles.InfoPageName = GenoFreeze.Name") (left-join ProbeSetFreeze "ON InfoFiles.InfoPageName = ProbeSetFreeze.Name") (left-join InbredSet "ON InfoFiles.InbredSetId = InbredSet.InbredSetId") + (left-join Species "ON InfoFiles.SpeciesId = Species.SpeciesId") (left-join Datasets "USING (DatasetId)") (left-join DatasetStatus "USING (DatasetStatusId)") (left-join Tissue "USING (TissueId)") |