Estimated economic burden on the NHS of GPCR targeting drugs
Calculations
The economic burden was estimated by:
estimated economic burden per drug (£) = NHS cost per drug per year (£) x
% individuals with a MV in a functional site of the respective drug targets
where:
- The average NHS cost is the average yearly cost over a 4-year period (2013-2016) per GPCR drug that is listed (2012 and 2017 have uncomplete sales data).
- % Individuals is the percentage of affected individuals with a missense variant in a functional site of the respective drug target(s) (2,504 individuals from 1,000 Genomes Project Phase 3 genotype data)
- The fraction of affected individuals was calculated using two different criteria (a) considering only individuals who have a variation in a functional site in both alleles (homozygous), which is more conservative and (b) individuals if they have a variation in a functional site in at least one allele (i.e. homozygous and heterozygous), which is less conservative.
- Functional sites were distinguished into (a) known functional sites that included ligand binding, effector binding, PTM site, sodium binding site and microswitches (more conservative) and (b) putative functional site as those predicted to be deleterious based on SIFT or PolyPhen (less conservative).
More specifically, for each drug we collected the respective targets and computed economic burden using the following four categories: i) individuals with homozygous alleles in known functional sites ii) individuals with at least one variant allele in a known functional site, iii) individuals with homozygous alleles in known or putative functional sites iv) individuals with at least one variant allele in a known or putative functional sites. For these estimates, we consider that each prescription (NHS data) is made for a unique individual, due to patient anonymity.
Sales and variation information per drug
Download
Package | Name | Version |
---|---|---|
Django | 2.2.1 | |
Python | 3.6.7 | |
debug_toolbar | Debug Toolbar | 1.11 |
polymorphic | Polymorphic | 2.0.3 |
rest_framework | Django REST framework | 3.9.3 |
rest_framework_swagger | Rest_Framework_Swagger | 2.2.0 |
Resource usage
Resource | Value |
---|---|
User CPU time | 8444.152 msec |
System CPU time | 720.294 msec |
Total CPU time | 9164.446 msec |
Elapsed time | 22700.716 msec |
Context switches | 2338 voluntary, 443 involuntary |
Browser timing
Timing attribute | Timeline | Milliseconds since navigation start (+length) |
---|
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ADMINS | [] |
ALLOWED_HOSTS | ['*'] |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
AUTH_PASSWORD_VALIDATORS | '********************' |
AUTH_USER_MODEL | 'auth.User' |
BASE_DIR | '/home/protwis/gpcrdb_test' |
BUILD_CACHE_DIR | '/home/protwis/gpcrdb_data/cache' |
CACHES | {'alignments': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache',
'LOCATION': '/home/protwis/caches/test_alignment',
'OPTIONS': {'MAX_ENTRIES': 1000}},
'default': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache',
'LOCATION': '/home/protwis/caches/test/',
'OPTIONS': {'MAX_ENTRIES': 10000000}}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CSRF_COOKIE_AGE | 31449600 |
CSRF_COOKIE_DOMAIN | None |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_NAME | 'csrftoken' |
CSRF_COOKIE_PATH | '/' |
CSRF_COOKIE_SAMESITE | 'Lax' |
CSRF_COOKIE_SECURE | False |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
CSRF_TRUSTED_ORIGINS | [] |
CSRF_USE_SESSIONS | False |
DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': 'localhost',
'NAME': 'protwis_202107',
'OPTIONS': {},
'PASSWORD': '********************',
'PORT': '',
'TEST': {'CHARSET': None,
'COLLATION': None,
'MIRROR': None,
'NAME': None},
'TIME_ZONE': None,
'USER': 'protwis'}} |
DATABASE_ROUTERS | [] |
DATA_DIR | '/home/protwis/gpcrdb_data' |
DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
DATA_UPLOAD_MAX_NUMBER_FIELDS | 1000 |
DATETIME_FORMAT | 'N j, Y, P' |
DATETIME_INPUT_FORMATS | ['%Y-%m-%d %H:%M:%S',
'%Y-%m-%d %H:%M:%S.%f',
'%Y-%m-%d %H:%M',
'%Y-%m-%d',
'%m/%d/%Y %H:%M:%S',
'%m/%d/%Y %H:%M:%S.%f',
'%m/%d/%Y %H:%M',
'%m/%d/%Y',
'%m/%d/%y %H:%M:%S',
'%m/%d/%y %H:%M:%S.%f',
'%m/%d/%y %H:%M',
'%m/%d/%y'] |
DATE_FORMAT | 'N j, Y' |
DATE_INPUT_FORMATS | ['%Y-%m-%d',
'%m/%d/%Y',
'%m/%d/%y',
'%b %d %Y',
'%b %d, %Y',
'%d %b %Y',
'%d %b, %Y',
'%B %d %Y',
'%B %d, %Y',
'%d %B %Y',
'%d %B, %Y'] |
DEBUG | True |
DEBUG_PROPAGATE_EXCEPTIONS | False |
DEBUG_TOOLBAR_PATCH_SETTINGS | False |
DECIMAL_SEPARATOR | '.' |
DEFAULT_CHARSET | 'utf-8' |
DEFAULT_CONTENT_TYPE | 'text/html' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_NUMBERING_SCHEME | 'gpcrdb' |
DEFAULT_PROTEIN_STATE | 'inactive' |
DEFAULT_SITE | 'gpcr' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
DOCUMENTATION_URL | 'https://docs.gpcrdb.org/' |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
EMAIL_HOST | 'localhost' |
EMAIL_HOST_PASSWORD | '********************' |
EMAIL_HOST_USER | '' |
EMAIL_PORT | 25 |
EMAIL_SSL_CERTFILE | None |
EMAIL_SSL_KEYFILE | '********************' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_TIMEOUT | None |
EMAIL_USE_LOCALTIME | False |
EMAIL_USE_SSL | False |
EMAIL_USE_TLS | False |
FILE_CHARSET | 'utf-8' |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler',
'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
FILE_UPLOAD_PERMISSIONS | None |
FILE_UPLOAD_TEMP_DIR | None |
FIRST_DAY_OF_WEEK | 0 |
FIXTURE_DIRS | [] |
FORCE_SCRIPT_NAME | None |
FORMAT_MODULE_PATH | None |
FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
GOOGLE_ANALYTICS_API | '********************' |
GOOGLE_ANALYTICS_KEY | '********************' |
IGNORABLE_404_URLS | [] |
INSTALLED_APPS | ('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.humanize',
'debug_toolbar',
'rest_framework',
'rest_framework_swagger',
'polymorphic',
'common',
'api',
'news',
'pages',
'home',
'protein',
'family',
'residue',
'alignment',
'similaritysearch',
'similaritymatrix',
'structure',
'ligand',
'interaction',
'mutation',
'phylogenetic_trees',
'sitesearch',
'build_gpcr',
'construct',
'tools',
'drugs',
'signprot',
'signprot2',
'mutational_landscape',
'contactnetwork',
'seqsign',
'angles',
'hotspots') |
INTERNAL_IPS | '10.0.2.2' |
LANGUAGES | [('af', 'Afrikaans'),
('ar', 'Arabic'),
('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('dsb', 'Lower Sorbian'),
('el', 'Greek'),
('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy', 'Frisian'),
('ga', 'Irish'),
('gd', 'Scottish Gaelic'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hsb', 'Upper Sorbian'),
('hu', 'Hungarian'),
('hy', 'Armenian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('io', 'Ido'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kab', 'Kabyle'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('mr', 'Marathi'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('pa', 'Punjabi'),
('pl', 'Polish'),
('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'),
('ru', 'Russian'),
('sk', 'Slovak'),
('sl', 'Slovenian'),
('sq', 'Albanian'),
('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'),
('sw', 'Swahili'),
('ta', 'Tamil'),
('te', 'Telugu'),
('th', 'Thai'),
('tr', 'Turkish'),
('tt', 'Tatar'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')] |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
LANGUAGE_CODE | 'en-us' |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_COOKIE_DOMAIN | None |
LANGUAGE_COOKIE_NAME | 'django_language' |
LANGUAGE_COOKIE_PATH | '/' |
LOCALE_PATHS | [] |
LOGGING | {'disable_existing_loggers': False,
'formatters': {'verbose': {'datefmt': '%d/%b/%Y %H:%M:%S',
'format': '[%(asctime)s] %(levelname)s '
'[%(name)s:%(lineno)s] %(message)s'},
'verbose_low': {'datefmt': '%d/%b/%Y %H:%M:%S',
'format': '[%(asctime)s] %(levelname)s '
'[%(name)s:%(lineno)s]'}},
'handlers': {'build': {'class': 'logging.FileHandler',
'filename': 'logs/build.log',
'formatter': 'verbose',
'level': 'DEBUG'},
'django': {'class': 'logging.FileHandler',
'filename': 'logs/django.log',
'formatter': 'verbose',
'level': 'WARNING'},
'protwis': {'class': 'logging.FileHandler',
'filename': 'logs/protwis.log',
'formatter': 'verbose',
'level': 'DEBUG'}},
'loggers': {'build': {'handlers': ['build'], 'level': 'DEBUG'},
'django': {'handlers': ['django'],
'level': 'WARNING',
'propagate': True},
'protwis': {'handlers': ['protwis'], 'level': 'DEBUG'}},
'version': 1} |
LOGGING_CONFIG | 'logging.config.dictConfig' |
LOGIN_REDIRECT_URL | '/accounts/profile/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_REDIRECT_URL | None |
MANAGERS | [] |
MEDIA_ROOT | '/protwis/media/protwis' |
MEDIA_URL | '/media/' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
MIDDLEWARE | ('common.middleware.stats.StatsMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware') |
MIGRATION_MODULES | {} |
MONTH_DAY_FORMAT | 'F j' |
NUMBER_GROUPING | 0 |
PASSWORD_HASHERS | '********************' |
PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
PREPEND_WWW | False |
REFERENCE_POSITIONS | {'D1S1': 'D1S1x50',
'D1S2': 'D1S2x50',
'D1T1': 'D1T1x50',
'D1e1': 'D1e1x50',
'ECL1': '23x50',
'ECL2': '45x50',
'H8': '8x50',
'ICL1': '12x50',
'ICL2': '34x50',
'TM1': '1x50',
'TM2': '2x50',
'TM3': '3x50',
'TM4': '4x50',
'TM5': '5x50',
'TM6': '6x50',
'TM7': '7x50'} |
ROOT_URLCONF | 'protwis.urls' |
SECRET_KEY | '********************' |
SECURE_BROWSER_XSS_FILTER | False |
SECURE_CONTENT_TYPE_NOSNIFF | False |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
SECURE_HSTS_PRELOAD | False |
SECURE_HSTS_SECONDS | 0 |
SECURE_PROXY_SSL_HEADER | None |
SECURE_REDIRECT_EXEMPT | [] |
SECURE_SSL_HOST | None |
SECURE_SSL_REDIRECT | False |
SERVER_EMAIL | 'root@localhost' |
SESSION_CACHE_ALIAS | 'default' |
SESSION_COOKIE_AGE | 86400 |
SESSION_COOKIE_DOMAIN | None |
SESSION_COOKIE_HTTPONLY | True |
SESSION_COOKIE_NAME | 'sessionid' |
SESSION_COOKIE_PATH | '/' |
SESSION_COOKIE_SAMESITE | 'Lax' |
SESSION_COOKIE_SECURE | False |
SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
SESSION_FILE_PATH | None |
SESSION_SAVE_EVERY_REQUEST | False |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.PickleSerializer' |
SETTINGS_MODULE | 'protwis.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SILENCED_SYSTEM_CHECKS | [] |
SITE_NAME | 'gpcr' |
SITE_TITLE | 'GPCRdb' |
STATICFILES_DIRS | ('/home/protwis/gpcrdb_test/static',) |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '/home/protwis/static_test/' |
STATIC_URL | '/static/' |
SWAGGER_SETTINGS | {'USE_SESSION_AUTH': False} |
TEMPLATES | [{'APP_DIRS': True,
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': [],
'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth',
'django.template.context_processors.debug',
'django.template.context_processors.i18n',
'django.template.context_processors.media',
'django.template.context_processors.static',
'django.template.context_processors.tz',
'django.contrib.messages.context_processors.messages',
'protwis.context_processors.current_site',
'protwis.context_processors.canonical_tag',
'protwis.context_processors.documentation_url',
'protwis.context_processors.google_analytics',
'protwis.context_processors.site_title'],
'debug': True}}] |
TEST_NON_SERIALIZED_APPS | [] |
TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
THOUSAND_SEPARATOR | ',' |
TIME_FORMAT | 'P' |
TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
TIME_ZONE | 'Europe/Copenhagen' |
USE_I18N | True |
USE_L10N | True |
USE_THOUSAND_SEPARATOR | False |
USE_TZ | True |
USE_X_FORWARDED_HOST | False |
USE_X_FORWARDED_PORT | False |
WSGI_APPLICATION | None |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
YEAR_MONTH_FORMAT | 'F Y' |
Request headers
Key | Value |
---|---|
Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Accept-Encoding | br,gzip |
Accept-Language | en-US,en;q=0.5 |
Connection | close |
Host | test.gpcrdb.org |
User-Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
X-Forwarded-For | 3.236.221.156 |
X-Forwarded-Proto | https |
X-Real-Ip | 3.236.221.156 |
Response headers
Key | Value |
---|---|
Cache-Control | max-age=1814400 |
Content-Length | 278953 |
Content-Type | text/html; charset=utf-8 |
Expires | Thu, 21 Jul 2022 09:37:10 GMT |
Vary | Cookie |
X-Frame-Options | SAMEORIGIN |
WSGI environ
Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.
Key | Value |
---|---|
PATH_INFO | /mutational_landscape/economicburden |
QUERY_STRING | |
REMOTE_ADDR | |
REQUEST_METHOD | GET |
SCRIPT_NAME | |
SERVER_NAME | test.gpcrdb.org |
SERVER_PORT | 443 |
SERVER_PROTOCOL | HTTP/1.0 |
SERVER_SOFTWARE | gunicorn/19.9.0 |
View information
View function | Arguments | Keyword arguments | URL name |
---|---|---|---|
mutational_landscape.views.economicburden |
() |
{} |
statistics |
No cookies
No session data
No GET data
No POST data
- default 13769.72 ms (1714 queries including 1679 similar and 720 duplicates )
Query | Timeline | Time (ms) | Action | ||
---|---|---|---|---|---|
+ |
SELECT ••• DISTINCT "drugs"."name", "drugs_nhs"."bnf_section" FROM "drugs_nhs" INNER JOIN "drugs" ON ("drugs_nhs"."drugname_id" = "drugs"."id")
|
0.33537192594564286% |
46.18 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(710) for drug in nhs_sections: |
|||||
+ |
SELECT ••• "drugs"."name", AVG("drugs_nhs"."actual_cost") AS "actual_cost__avg", AVG("drugs_nhs"."items") AS "items__avg", AVG("drugs_nhs"."quantity") AS "quantity__avg" FROM "drugs_nhs" INNER JOIN "drugs" ON ("drugs_nhs"."drugname_id" = "drugs"."id") GROUP BY "drugs"."name"
|
0.18265279138015958% |
25.15 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(720) for i in nhs_data: |
|||||
+ |
SELECT ••• DISTINCT "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" INNER JOIN "drugs_target" ON ("protein"."id" = "drugs_target"."protein_id") INNER JOIN "drugs" ON ("drugs_target"."drugs_id" = "drugs"."id") WHERE "drugs"."name" = 'dinoprostone'
|
0.09516852806350451% |
13.10 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(735) targets = [p.entry_name.split('_human')[0].upper() for p in list(protein_targets)] |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 171
|
0.04045060680844902% |
5.57 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.021598359272690403% |
2.97 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.14740178958180267% |
20.30 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 171) ORDER BY "residue"."sequence_number" ASC
|
0.1333076221551793% |
18.36 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0015721749414464394% |
0.22 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.00566363902364681% |
0.78 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 171) ORDER BY "residue"."sequence_number" ASC
|
0.00546798289106592% |
0.75 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.001909811630413461% |
0.26 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004555498095755046% |
0.63 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 171) ORDER BY "residue"."sequence_number" ASC
|
0.014270777387006117% |
1.97 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 229
|
0.002879434942318754% |
0.40 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_004\_008\_003%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
6.365471422976059% |
876.51 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (71428, 71556, 71430, 71432, 71435, 71436, 71437, 71565, 71439, 71441, 71443, 71571, 71418, 71068, 71212, 71214, 71221, 71223, 71225, 71227, 71229, 71231, 71233, 71235, 71236, 71238, 71240, 71242, 71632, 71637, 71638, 71512, 71641, 71514, 71643, 71644, 71645, 71518, 71646, 71647, 71521, 71649, 71522, 71526, 71529, 71402, 71531, 71405, 71537, 71539, 71546, 71423)
|
0.07689805451488906% |
10.59 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 172
|
0.008982867396722606% |
1.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.0017920716568249613% |
0.25 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.005597843156053236% |
0.77 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 172) ORDER BY "residue"."sequence_number" ASC
|
0.028212575436044367% |
3.88 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0017782198952263142% |
0.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.005493954944063384% |
0.76 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 172) ORDER BY "residue"."sequence_number" ASC
|
0.00621597801739286% |
0.86 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.0017678310740273288% |
0.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004688821301142024% |
0.65 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 172) ORDER BY "residue"."sequence_number" ASC
|
0.0076808018064497855% |
1.06 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 230
|
0.0019392466238105858% |
0.27 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_004\_008\_004%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
1.1926124330607129% |
164.22 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (23648792, 23648796, 70689, 70718, 70721, 71261, 71267, 71276, 70766, 71279, 70770, 71282, 71285, 70261, 71287, 70776, 71290, 71297, 71299, 70789, 23573126, 70792, 70794, 70795, 70796, 70797, 70798, 70799, 71306, 70801, 71310, 70283, 71328, 23573164, 23573167, 23573168, 23723700, 23573175, 23723703, 23573198, 71379, 71380, 70358, 23723738, 23723741, 23723742, 23723749, 71401, 71409, 71411, 71415, 71417, 71419, 23723772, 70398, 71424, 71426, 71433, 23573267, 71462, 71469, 71471, 23648565, 23648569, 70462, 23723842, 23648603, 23648606, 23648607, 23648610, 23648614, 23573354, 23573358, 71535, 23573361, 71543, 71545, 71034, 23648637, 71550, 71039, 23648640, 71553, 71555, 71557, 71559, 71560, 71563, 71057, 23723927, 71065, 23723931, 23723938, 23648706, 23648707)
|
0.037692374780118436% |
5.19 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 173
|
0.0025712332467488575% |
0.35 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.00234094771017135% |
0.32 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.007131925753103396% |
0.98 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 173) ORDER BY "residue"."sequence_number" ASC
|
0.04269112924703019% |
5.88 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0023392162399715195% |
0.32 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.006704252613745169% |
0.92 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 173) ORDER BY "residue"."sequence_number" ASC
|
0.00802536437621613% |
1.11 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.00218338392198674% |
0.30 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.008894562416531233% |
1.22 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 173) ORDER BY "residue"."sequence_number" ASC
|
0.007019380190114389% |
0.97 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 231
|
0.0016379708090400126% |
0.23 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_004\_008\_005%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
1.0433510444842917% |
143.67 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (65280, 65283, 23567748, 65285, 65286, 65287, 65288, 65289, 65291, 23599504, 65044, 23599508, 65175, 23567767, 65178, 23567770, 23567771, 23599514, 23567678, 65186, 65189, 65192, 65193, 65194, 65195, 65196, 65197, 65199, 65200, 64944, 23567537, 64952, 65209, 65210, 65082, 65212, 65213, 65214, 23567677, 65216, 65217, 65218, 65091, 65092, 65220, 65221, 65095, 65096, 65097, 65098, 65099, 65100, 65101, 65102, 65103, 65104, 65105, 65106, 65228, 65232, 65234, 23599324, 65224, 23567586, 23599416, 23599417, 23599347, 23567608, 65274, 65279)
|
0.03898058860879261% |
5.37 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 174
|
0.013160904988914522% |
1.81 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.002058718067598917% |
0.28 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.00505416151330634% |
0.70 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 174) ORDER BY "residue"."sequence_number" ASC
|
0.014546081148779226% |
2.00 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.001953098385409233% |
0.27 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.004377156665172466% |
0.60 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 174) ORDER BY "residue"."sequence_number" ASC
|
0.0062661906531879565% |
0.86 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.0027582320283305924% |
0.38 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004744228347536612% |
0.65 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 174) ORDER BY "residue"."sequence_number" ASC
|
0.00655015176596022% |
0.90 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 232
|
0.0058679525072268535% |
0.81 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_004\_008\_006%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
0.9624238588143963% |
132.52 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (23594008, 69150, 69155, 23577665, 23637057, 23637060, 23637061, 23577707, 23577710, 23577714, 23577718, 23594102, 23594105, 23594106, 69244, 68742, 69257, 68751, 68752, 68755, 68756, 68757, 68758, 68759, 68760, 68761, 68762, 68763, 68764, 68765, 68766, 69284, 23577806, 23577807, 68827, 68830, 68838, 68841, 68844, 68845, 68846, 68847, 68848, 68849, 68851, 68852, 68854, 68855, 68857, 68880, 68887, 68894, 68897, 68898, 68900, 68901, 68902, 68904, 68905, 68906, 68908, 68909, 68912, 68916, 23577908, 23577911, 68920, 23577912, 68922, 23636817, 68955, 68960, 68961, 68964, 68966, 68967, 68968, 68969, 68970, 68972, 68973, 68989, 23593862, 23636870, 23636874, 69009, 69012, 69014, 69017, 69024, 69029, 69035, 23593915, 23593919, 23636963)
|
0.023760965552279172% |
3.27 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score", COUNT("mutation_natural"."id") AS "count_putative_func" FROM "mutation_natural" WHERE ("mutation_natural"."protein_id" IN (SELECT ••• DISTINCT U0."id" FROM "protein" U0 INNER JOIN "drugs_target" U1 ON (U0."id" = U1."protein_id") INNER JOIN "drugs" U2 ON (U1."drugs_id" = U2."id") WHERE U2."name" = 'dinoprostone') AND ("mutation_natural"."sift_score" <= 0.05 OR "mutation_natural"."polyphen_score" >= 0.1)) GROUP BY "mutation_natural"."id"
|
0.05449283012907746% |
7.50 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(746) putative_func = len(NaturalMutations.objects.filter(Q(protein__in=protein_targets), Q(sift_score__lte=0.05) | Q(polyphen_score__gte=0.1)).annotate(count_putative_func=Count('id'))) |
|||||
+ |
SELECT ••• DISTINCT "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" INNER JOIN "drugs_target" ON ("protein"."id" = "drugs_target"."protein_id") INNER JOIN "drugs" ON ("drugs_target"."drugs_id" = "drugs"."id") WHERE "drugs"."name" = 'nizatidine'
|
0.00714058310410255% |
0.98 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(735) targets = [p.entry_name.split('_human')[0].upper() for p in list(protein_targets)] |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 33
|
0.003054313432501673% |
0.42 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.001982533378806358% |
0.27 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.005530315818259832% |
0.76 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 33) ORDER BY "residue"."sequence_number" ASC
|
0.03173958023309987% |
4.37 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0017314701998308805% |
0.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.004361573433373987% |
0.60 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 33) ORDER BY "residue"."sequence_number" ASC
|
0.0054368164274689644% |
0.75 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.0017280072594312188% |
0.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.00420920405578887% |
0.58 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 33) ORDER BY "residue"."sequence_number" ASC
|
0.006609021752754471% |
0.91 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 42
|
0.0017297387296310494% |
0.24 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_001\_005\_002%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
0.9184341269174929% |
126.47 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (14240, 14245, 14246, 14249, 14251, 14252, 14253, 14254, 14255, 14257, 14130, 14133, 14141, 14144, 14147, 14148, 14149, 14150, 14151, 14152, 14154, 14155, 14163, 14164, 14166, 14167, 14168, 14170, 14171, 14172, 14045, 14175, 14178, 14054, 14055, 14185, 14058, 14059, 14060, 14061, 14062, 14063, 14064, 14065, 14066, 14067, 14068, 14069, 14192, 14200, 14204)
|
0.02676333487878592% |
3.69 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score", COUNT("mutation_natural"."id") AS "count_putative_func" FROM "mutation_natural" WHERE ("mutation_natural"."protein_id" IN (SELECT ••• DISTINCT U0."id" FROM "protein" U0 INNER JOIN "drugs_target" U1 ON (U0."id" = U1."protein_id") INNER JOIN "drugs" U2 ON (U1."drugs_id" = U2."id") WHERE U2."name" = 'nizatidine') AND ("mutation_natural"."sift_score" <= 0.05 OR "mutation_natural"."polyphen_score" >= 0.1)) GROUP BY "mutation_natural"."id"
|
0.025376427248721384% |
3.49 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(746) putative_func = len(NaturalMutations.objects.filter(Q(protein__in=protein_targets), Q(sift_score__lte=0.05) | Q(polyphen_score__gte=0.1)).annotate(count_putative_func=Count('id'))) |
|||||
+ |
SELECT ••• DISTINCT "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" INNER JOIN "drugs_target" ON ("protein"."id" = "drugs_target"."protein_id") INNER JOIN "drugs" ON ("drugs_target"."drugs_id" = "drugs"."id") WHERE "drugs"."name" = 'buprenorphine'
|
0.017235054369116584% |
2.37 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(735) targets = [p.entry_name.split('_human')[0].upper() for p in list(protein_targets)] |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 83
|
0.02342159739311232% |
3.23 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.001580832292445594% |
0.22 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.004072417910002231% |
0.56 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 83) ORDER BY "residue"."sequence_number" ASC
|
0.036224088050661844% |
4.99 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0017003037362339245% |
0.23 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.004082806731201216% |
0.56 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 83) ORDER BY "residue"."sequence_number" ASC
|
0.005038578281507862% |
0.69 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.0015340825970501602% |
0.21 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004008353512608488% |
0.55 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 83) ORDER BY "residue"."sequence_number" ASC
|
0.006936269620522507% |
0.96 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 116
|
0.00245868768375985% |
0.34 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_002\_022\_001%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
0.9583878017785904% |
131.97 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (27147, 27161, 27164, 27166, 23702065, 23702088, 23702092, 23688796, 23688799, 23688803, 23570022, 23688806, 23570025, 23570026, 23570029, 23570032, 23688826, 23611570, 23611573, 23611574, 23611577, 23746264, 23746294, 23746298, 23611644, 23611645, 23611659, 23611662, 23607080, 23607083, 26939, 26948, 26949, 26952, 26953, 23611722, 26954, 26955, 26956, 26957, 26958, 26959, 26960, 26961, 26962, 26963, 23611726, 23611749, 23611753, 23607165, 23607168, 27014, 27016, 23746440, 23746443, 23746444, 23746447, 27025, 23746450, 27028, 27036, 23701918, 27039, 23701921, 27042, 27043, 27044, 27045, 27046, 23701922, 23701925, 23746466, 23746474, 27054, 27055, 27057, 27058, 27059, 27061, 27062, 27063, 27065, 27066, 27069, 23607229, 23607232, 27073, 23607235, 27077, 27079, 23688656, 23688657, 23607251, 23569876, 23569877, 23688660, 23569880, 27112, 23701992, 23701993, 27117, 27118, 27121, 27123, 27124, 27125, 27126, 27127, 27129)
|
0.025215400520137113% |
3.47 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 84
|
0.012622417756767118% |
1.74 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.0022405224385811592% |
0.31 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.005119957380899913% |
0.71 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 84) ORDER BY "residue"."sequence_number" ASC
|
0.0231289789293409% |
3.18 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0022941980147759165% |
0.32 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.004645534546146252% |
0.64 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 84) ORDER BY "residue"."sequence_number" ASC
|
0.005850637805228545% |
0.81 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.002387697405566784% |
0.33 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004706136003140332% |
0.65 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 84) ORDER BY "residue"."sequence_number" ASC
|
0.006731956136942463% |
0.93 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 117
|
0.0023392162399715195% |
0.32 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_002\_022\_002%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
0.9541214592062073% |
131.38 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (26753, 26755, 26756, 26757, 26758, 26759, 26761, 23679754, 23679758, 23585553, 26772, 23585556, 23585557, 23585560, 26781, 23679775, 26658, 23585698, 23679779, 26661, 23585705, 23600940, 26669, 23600856, 26672, 26801, 26675, 26676, 26677, 26678, 26679, 26683, 26685, 26687, 26688, 26690, 26691, 26692, 23585730, 26694, 26695, 26696, 26569, 26698, 26699, 26702, 23679695, 26448, 23600849, 26578, 26579, 26706, 23600852, 26582, 26583, 26584, 26585, 26586, 26587, 26588, 26589, 26590, 26591, 26592, 26593, 26462, 23600997, 23679589, 23601004, 23679599, 26710, 23679603, 23679607, 26744, 26712, 26749, 26750, 23601023)
|
0.01684027916355514% |
2.32 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• DISTINCT "residue_ptm"."residue_id" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" = 85
|
0.012347113994994009% |
1.70 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(646) ptms = list(PTMs.objects.filter(protein=protein).values_list('residue', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
|
0.0015150364248520203% |
0.21 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(649) micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
|
0.004077612320601723% |
0.56 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(651) for residue in micro_switches_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 85) ORDER BY "residue"."sequence_number" ASC
|
0.02483274560597449% |
3.42 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(654) ms_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
|
0.0015964155242440717% |
0.22 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(657) sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket") |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
|
0.003999696161609333% |
0.55 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(659) for residue in sodium_pocket_rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 85) ORDER BY "residue"."sequence_number" ASC
|
0.00499529152651209% |
0.69 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(661) sp_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=ms_label).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
|
0.002401549167165431% |
0.33 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(666) rset = ResiduePositionSet.objects.get(name='G-protein interface') |
|||||
+ |
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
|
0.004714793354139487% |
0.65 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(668) for residue in rset.residue_position.all(): |
|||||
+ |
SELECT ••• DISTINCT "residue"."id", "residue"."sequence_number" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('7x55', '6x28', '8x48', '7x56', '6x32', '6x33', '6x37', '6x40', '3x53', '3x54', '3x55', '3x56', '34x50', '34x51', '34x52', '8x49', '6x25', '5x61', '5x64', '5x65', '5x66', '5x67', '5x68', '5x69', '5x71', '3x50', '5x74', '34x53', '34x54', '34x55', '34x56', '34x57', '8x51', '6x29', '8x47', '5x75', '6x36', '6x26', '5x72') AND "protein_conformation"."protein_id" = 85) ORDER BY "residue"."sequence_number" ASC
|
0.0068808625741279186% |
0.95 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(670) GP_object = list(Residue.objects.filter(protein_conformation__protein=protein, generic_number__label__in=gprotein_generic_set).values_list('id', flat=True).distinct()) |
|||||
+ |
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 118
|
0.0023859659353669535% |
0.33 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(675) orthologs = Protein.objects.filter(family__slug__startswith=protein.family.slug, sequence_type__slug='wt').prefetch_related('protein__family') |
|||||
+ |
SELECT ••• DISTINCT "structure_rotamer"."residue_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") INNER JOIN "structure_rotamer" ON ("interaction_residue_fragment"."rotamer_id" = "structure_rotamer"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug"::text LIKE '001\_002\_022\_003%' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
|
0.847277627585243% |
116.67 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) /home/protwis/gpcrdb_test/mutational_landscape/views.py in <genexpr>(680) known_function_sites = set(x for l in [GP_object,sp_object,ms_object,ptms,interaction_residues] for x in l) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score" FROM "mutation_natural" WHERE "mutation_natural"."residue_id" IN (23740452, 23740456, 28714, 23740459, 28725, 28727, 23740474, 28733, 28737, 23740482, 28739, 28741, 28743, 28745, 28756, 23727712, 23727722, 23727723, 28778, 28782, 23727726, 23727727, 23727730, 28818, 23565466, 23565468, 28837, 28846, 28847, 23727815, 28374, 28391, 28393, 28395, 28399, 28401, 28402, 28404, 28406, 28408, 28410, 28412, 28414, 28416, 28418, 23727875, 28420, 28422, 23727879, 23727897, 23727901, 23727905, 28989, 23565645, 28540, 28543, 23740300, 28559, 23740303, 23740304, 23740307, 28565, 28571, 28573, 28575, 28577, 28584, 28592, 23565746, 28595, 23565751, 23565753, 28607, 23565759, 28609, 28613, 28615, 28616, 28620, 28621, 28622, 28624, 28626, 28632, 28640, 28647, 28651, 23565803, 23565810)
|
0.029722417450296894% |
4.09 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(742) function_sites = get_functional_sites(target) /home/protwis/gpcrdb_test/mutational_landscape/views.py in get_functional_sites(682) return len(NMs) |
|||||
+ |
SELECT ••• "mutation_natural"."id", "mutation_natural"."protein_id", "mutation_natural"."residue_id", "mutation_natural"."amino_acid", "mutation_natural"."type", "mutation_natural"."allele_frequency", "mutation_natural"."allele_count", "mutation_natural"."allele_number", "mutation_natural"."number_homozygotes", "mutation_natural"."sift_score", "mutation_natural"."polyphen_score", COUNT("mutation_natural"."id") AS "count_putative_func" FROM "mutation_natural" WHERE ("mutation_natural"."protein_id" IN (SELECT ••• DISTINCT U0."id" FROM "protein" U0 INNER JOIN "drugs_target" U1 ON (U0."id" = U1."protein_id") INNER JOIN "drugs" U2 ON (U1."drugs_id" = U2."id") WHERE U2."name" = 'buprenorphine') AND ("mutation_natural"."sift_score" <= 0.05 OR "mutation_natural"."polyphen_score" >= 0.1)) GROUP BY "mutation_natural"."id"
|
0.4073179756890156% |
56.09 | ||
Connection: default /usr/lib/python3.6/concurrent/futures/thread.py in _worker(69) work_item.run() /usr/lib/python3.6/concurrent/futures/thread.py in run(56) result = self.fn(*self.args, **self.kwargs) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279) keepalive = self.handle_request(req, conn) /home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328) respiter = self.wsgi(environ, resp.start_response) /home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34) response = self.get_response(request) /home/protwis/gpcrdb_test/mutational_landscape/views.py in economicburden(746) putative_func = len(NaturalMutations.objects.filter(Q(protein__in=protein_targets), Q(sift_score__lte=0.05) | Q(polyphen_score__gte=0.1)).annotate(count_putative_func=Count('id'))) |
|||||
+ |
SELECT ••• DISTINCT "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" INNER JOIN "drugs_target" ON ("protein"."id" = "drugs_target"."protein_id") INNER JOIN "drugs" ON ("drugs_target"."drugs_id" = "drugs"."id") WHERE "drugs"."name" = 'atropine'
|
0.006325060639982206% |
0.87 |