projects
/
htsworkflow.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Test htsworkflow under several different django & python versions
[htsworkflow.git]
/
encode_submission
/
entex-donor.sql
1
-- \pset format unaligned
2
-- \pset fieldsep '\t'
3
with gtex as (
4
select distinct uri as Donor,
5
substring(jsonb_array_elements_text(payload->'aliases'), '([a-zA-Z0-9]+):') as AliasPrefix
6
from item
7
where object_type = 'HumanDonor'
8
)
9
select Donor, AliasPrefix
10
from gtex
11
where AliasPrefix = 'gtex'
12
;