Jack Adam Tuszynski

Year	Rank	Type	Title / Venue / Authors
2026	J	`jnl`	A Unified Holographic Framework for neural computation and consciousness: From lipid membranes to the Schumann resonance. Biosyst. Marco Cavaglià, Jack Adam Tuszynski
2026	J	`jnl`	EMI model: A scale free biophysical framework for human consciousness, cognition and behaviour. Biosyst. Tommaso Firaux, Jack Adam Tuszynski, Marco Cavaglià
2026	J	`jnl`	Molecular simulations of paclitaxel binding to mutant β-tubulin: insights into chemotherapy resistance. J. Comput. Aided Mol. Des. Paola Vottero, Martina Centroni, Ebenezea Gitari, Philip Winter, Jack Adam Tuszynski, Maral Aminpour
2025	J	`jnl`	A comprehensive primer and review of PROTACs and their In Silico design. Comput. Methods Programs Biomed. Jacopo Zattoni, Paola Vottero, Gea Carena, Chiara Uliveto, Giulia Pozzati, Benedetta Morabito, Ebenezea Gitari, Jack Adam Tuszynski, Maral Aminpour
2024	J	`jnl`	Non-Equilibrium Quantum Brain Dynamics: Water Coupled with Phonons and Photons. Entropy Akihiro Nishiyama, Shigenori Tanaka, Jack Adam Tuszynski
2024	J	`jnl`	Quantum Brain Dynamics and Virtual Reality. Biosyst. Akihiro Nishiyama, Shigenori Tanaka, Jack Adam Tuszynski
2023	J	`jnl`	Modeling non-genetic information dynamics in cells using reservoir computing. CoRR Dipesh Niraula, Issam El-Naqa, Jack Adam Tuszynski, Robert A. Gatenby
2022	J	`jnl`	Editorial: Big Data and machine learning in cancer theranostics. Frontiers Big Data Fabrício Alves Barbosa da Silva, Jack Adam Tuszynski, Helder I. Nakaya, Channing J. Paller
2022	J	`jnl`	In Silico Analysis of the Multi-Targeted Mode of Action of Ivermectin and Related Compounds. Comput. Maral Aminpour, Marco Cannariato, Jordane Preto, M. Ehsan Safaeeardebili, Alexia Moracchiato, Domiziano Doria, Francesca Donato, Eric Adriano Zizzi, Marco Agostino Deriu, David E. Scheim, Alessandro D. Santin, Jack Adam Tuszynski
2022	J	`jnl`	The Effect of the Protein Synthesis Entropy Reduction on the Cell Size Regulation and Division Size of Unicellular Organisms. Entropy Mohammad Razavi, Seyed Majid Saberi Fathi, Jack Adam Tuszynski
2021	J	`jnl`	Editorial: Waves in fertilization, cell division and embryogenesis. Biosyst. Luigia Santella, Richard Gordon, Zhan Chen, Jack Adam Tuszynski
2021	J	`jnl`	Modeling the structure of the frameshift-stimulatory pseudoknot in SARS-CoV-2 reveals multiple possible conformers. PLoS Comput. Biol. Sara Ibrahim Omar, Meng Zhao, Rohith Vedhthaanth Sekar, Sahar Arbabi Moghadam, Jack Adam Tuszynski, Michael T. Woodside
2020	J	`jnl`	A search for the physical basis of the genetic code. Biosyst. S. Arbabi Moghadam, Mariusz Klobukowski, Jack Adam Tuszynski
2020	J	`jnl`	Non-Equilibrium Quantum Electrodynamics in Open Systems as a Realizable Representation of Quantum Field Theory of the Brain. Entropy Akihiro Nishiyama, Shigenori Tanaka, Jack Adam Tuszynski
2020	J	`jnl`	Testing amino acid-codon affinity hypothesis using molecular docking. Biosyst. S. Arbabi Moghadam, Jordane Preto, Mariusz Klobukowski, Jack Adam Tuszynski
2019	J	`jnl`	Actin Networks Voltage Circuits. CoRR Stefano Siccardi, Andrew Adamatzky, Jack Adam Tuszynski, Florian Huber, Jörg Schnauß
2019	J	`jnl`	How signals of calcium ions initiate the beats of cilia and flagella. Biosyst. Miljko V. Sataric, Tomas Nemes, Dalibor L. Sekulic, Jack Adam Tuszynski
2019	J	`jnl`	Molecular orbitals of delocalized electron clouds in neuronal domains. Biosyst. Roman R. Poznanski, Lleuvelyn A. Cacha, Ahmad Zubaidi Abdul Latif, Sheikh Hussain Salleh, Jalil Ali, Preecha P. Yupapin, Jack Adam Tuszynski, Tengku M. Ariff
2019	J	`jnl`	Non-Equilibrium Quantum Brain Dynamics: Super-Radiance and Equilibration in 21 Dimensions+. Entropy Akihiro Nishiyama, Shigenori Tanaka, Jack Adam Tuszynski
2019	—	`ch.`	Towards Cytoskeleton Computers. A Proposal. From Parallel to Emergent Computing Andrew Adamatzky, Jack Adam Tuszynski, Joerg Pieper, Dan V. Nicolau, Rosaria Rinaldi, Georgios Ch. Sirakoulis, Victor Erokhin, Jörg Schnauß, David M. Smith
2018	J	`jnl`	Integration of intracellular signaling: Biological analogues of wires, processors and memories organized by a centrosome 3D reference system. Biosyst. Nadezhda Barvitenko, Alfons Lawen, Muhammad Aslam, Antonella Pantaleo, Carlota Saldanha, Elisaveta Skverchinskaya, Marco Regolini, Jack Adam Tuszynski
2018	J	`jnl`	Nonlinear calcium ion waves along actin filaments control active hair-bundle motility. Biosyst. Jack Adam Tuszynski, Miljko V. Sataric, Dalibor L. Sekulic, Bogdan M. Sataric, Slobodan Zdravkovic
2018	J	`jnl`	Towards Cytoskeleton Computers. A proposal. CoRR Andrew Adamatzky, Jack Adam Tuszynski, Joerg Pieper, Dan V. Nicolau, Rossalia Rinalndi, Georgios Ch. Sirakoulis, Victor Erokhin, Joerg Schnauss, David M. Smith
2016	J	`jnl`	Josephin Domain Structural Conformations Explored by Metadynamics in Essential Coordinates. PLoS Comput. Biol. Marco Agostino Deriu, Gianvito Grasso, Jack Adam Tuszynski, Diego Gallo, Umberto Morbiducci, Andrea Danani
2015	J	`jnl`	A Refined Model of the HCV NS5A Protein Bound to Daclatasvir Explains Drug-Resistant Mutations and Activity against Divergent Genotypes. J. Chem. Inf. Model. Khaled H. Barakat, Anwar Anwar-Mohamed, Jack Adam Tuszynski, Morris J. Robins, D. Lorne Tyrrell, Michael Houghton
2015	J	`jnl`	Biological wires, communication systems, and implications for disease. Biosyst. Douglas E. Friesen, Travis J. A. Craddock, Aarat P. Kalra, Jack Adam Tuszynski
2015	J	`jnl`	Boolean gates on actin filaments. CoRR Stefano Siccardi, Jack Adam Tuszynski, Andrew Adamatzky
2015	J	`jnl`	Detailed Per-residue Energetic Analysis Explains the Driving Force for Microtubule Disassembly. PLoS Comput. Biol. Ahmed T. Ayoub, Mariusz Klobukowski, Jack Adam Tuszynski
2015	J	`jnl`	The use of compressive sensing and peak detection in the reconstruction of microtubules length time series in the process of dynamic instability. Comput. Biol. Medicine Majid Mahrooghy, Shantia Yarahmadian, Vineetha Menon, Vahid Rezania, Jack Adam Tuszynski
2014	J	`jnl`	Maximum Entropy in Drug Discovery. Entropy Chih-Yuan Tseng, Jack Adam Tuszynski
2014	J	`jnl`	Rational Drug Design: One Target, Many Paths to It. Int. J. Comput. Model. Algorithms Medicine Khaled H. Barakat, Michael Houghton, D. Lorne Tyrrell, Jack Adam Tuszynski
2013	J	`jnl`	Detailed Computational Study of the Active Site of the Hepatitis C Viral RNA Polymerase to Aid Novel Drug Design. J. Chem. Inf. Model. Khaled H. Barakat, John Law, Alessio Prunotto, Wendy C. Magee, David H. Evans, D. Lorne Tyrrell, Jack Adam Tuszynski, Michael Houghton
2013	J	`jnl`	Self-organization and entropy reduction in a living cell. Biosyst. Paul C. W. Davies, Elisabeth Rieper, Jack Adam Tuszynski
2012	J	`jnl`	A mean field Ising model for cortical rotation in amphibian one-cell stage embryos. Biosyst. Jack Adam Tuszynski, Richard Gordon
2012	J	`jnl`	An investigation of the plausibility of stochastic resonance in tubulin dimers. Biosyst. Aditya A. Saha, Travis J. A. Craddock, Jack Adam Tuszynski
2012	J	`jnl`	Cytoskeletal Signaling: Is Memory Encoded in Microtubule Lattices by CaMKII Phosphorylation? PLoS Comput. Biol. Travis J. A. Craddock, Jack Adam Tuszynski, Stuart R. Hameroff
2012	J	`jnl`	Simulation of the effects of microtubules in the cortical rotation of amphibian embryos in normal and zero gravity. Biosyst. Comron Nouri, Jack Adam Tuszynski, Mark W. Wiebe, Richard Gordon
2011	—	`ch.`	Virtual Screening: An Overview on Methods and Applications. Handbook of Research on Computational and Systems Biology Khaled H. Barakat, Jonathan Y. Mane, Jack Adam Tuszynski
2010	J	`jnl`	Using Entropy Leads to a Better Understanding of Biological Systems. Entropy Chih-Yuan Tseng, Jack Adam Tuszynski
2009	J	`jnl`	Identification and Characterization of an Intermediate Taxol Binding Site Within Microtubule Nanopores and a Mechanism for Tubulin Isotype Binding Selectivity. J. Chem. Inf. Model. Holly Freedman, J. Torin Huzil, Tyler Luchko, Richard F. Luduena, Jack Adam Tuszynski
2009	J	`jnl`	Information processing mechanisms in microtubules at physiological temperature: Model predictions for experimental tests. Biosyst. Travis J. A. Craddock, Catherine Beauchemin, Jack Adam Tuszynski
2008	J	`jnl`	Free Energy Calculations on the Binding of Colchicine and Its Derivatives with the α/β-Tubulin Isoforms. J. Chem. Inf. Model. Jonathan Y. Mane, Mariusz Klobukowski, J. Torin Huzil, Jack Adam Tuszynski
2005	J	`jnl`	Molecular dynamics simulations of tubulin structure and calculations of electrostatic properties of microtubules. Math. Comput. Model. Jack Adam Tuszynski, J. A. Brown, E. Crawford, E. J. Carpenter, M. L. A. Nip, J. M. Dixon, Miljko V. Sataric
2003	—	`conf`	Molecular Dynamics Calculations of the Electrostatic Properties of Tubulin and Their Consequences for Microtubules. ICMENS Jack Adam Tuszynski, E. J. Carpenter, E. Crawford, J. A. Brown, W. Malinski, J. M. Dixon

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Definitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import clickhouse_connect"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "ch_TEST_client = clickhouse_connect.get_client(host='e.rationaledge.io', port=443, username='default', password='werioubTGwvf0-dsbv_', database='redb', verify=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "ch_TEST_BETA_client = clickhouse_connect.get_client(host='k.rationaledge.io', port=443, username='default', password='werioubTGwvf0-dsbv_', database='default', verify=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method HttpClient.close_connections of <clickhouse_connect.driver.httpclient.HttpClient object at 0x105fd64d0>>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ch_TEST_BETA_client.close_connections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<clickhouse_connect.driver.summary.QuerySummary at 0x11f900810>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ch_TEST_BETA_client.command(\"\"\"\n",
    "RENAME DATABASE redb TO orig_redb;\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## DB Creation (schema 2025-08-02)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ch_TEST_client.command(\"\"\"\n",
    "CREATE DATABASE IF NOT EXISTS redb;\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Define General Tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "### CREATE FULL REDB DATABASE\n",
    "def create_redb_with_all_tables(client):\n",
    "    client.command(\"\"\"\n",
    "        CREATE DATABASE IF NOT EXISTS redb\n",
    "    \"\"\")\n",
    "    create_all_general_tables(client)\n",
    "    create_all_pe_tables(client)\n",
    "\n",
    "#### CREATE FULL TABLES\n",
    "def create_all_general_tables(client):\n",
    "    create_basic_properties_dbtable(client)\n",
    "    create_hashes_dbtable(client)\n",
    "    create_capa_dbtable(client)\n",
    "    create_die_dbtable(client)\n",
    "    create_extra_findings_dbtable(client)\n",
    "\n",
    "\n",
    "##################################\n",
    "#### CREATE INDIVIDUAL TABLES ####\n",
    "##################################\n",
    "\n",
    "#### GENERAL TABLES ####\n",
    "# All tables have SETTINGS index_granularity = 8192\n",
    "def create_basic_properties_dbtable(client):\n",
    "    # Create samples_metadata table\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_basic_properties (\n",
    "            sha256 FixedString(64), -- primary key\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            filename Nullable(String),\n",
    "            sample_name String,\n",
    "            filesize UInt64,\n",
    "            file_entropy Float64,\n",
    "            filetype LowCardinality(String),\n",
    "            filetype_mime LowCardinality(String),\n",
    "            filetype_magika LowCardinality(String),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "def create_hashes_dbtable(client):\n",
    "    # Create hashes table\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_hashes (\n",
    "            sha256 FixedString(64), -- primary key\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            ssdeep_hash Nullable(String),\n",
    "            tlsh_hash Nullable(String),\n",
    "            authentihash Nullable(String),\n",
    "            imphash Nullable(String),\n",
    "            impfuzzy Nullable(String),\n",
    "            typerefhash Nullable(String),\n",
    "            richhash Nullable(String),\n",
    "            richpe_hash Nullable(String),\n",
    "            richpv_hash Nullable(String),\n",
    "            richpv_hash_sorted Nullable(String),\n",
    "            dhash Nullable(String),\n",
    "            analysis_date DateTime64(3, 'UTC')\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "def create_capa_dbtable(client):\n",
    "    # Create sample_capabilities table\n",
    "    client.command(\"\"\"\n",
    "        SET enable_json_type = 1;\n",
    "    \"\"\")\n",
    "    client.command(\"\"\"\n",
    "        -- Base table for CAPA analysis results\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            -- Store full JSON dumps as strings for flexibility\n",
    "            capa_dump JSON CODEC(ZSTD(3)),\n",
    "            attack_dump JSON CODEC(ZSTD(3)),\n",
    "            mbc_dump JSON CODEC(ZSTD(3))\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY sha256;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for capabilities and namespaces\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_capabilities (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            namespace LowCardinality(String),\n",
    "            capability LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, namespace, capability);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for capability statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_capabilities_stats (\n",
    "            namespace LowCardinality(String),\n",
    "            capability LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (namespace, capability)\n",
    "        AS SELECT\n",
    "            namespace,\n",
    "            capability,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_capabilities\n",
    "        GROUP BY namespace, capability;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for MITRE ATT&CK mappings\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_attack (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            tactic LowCardinality(String),\n",
    "            technique LowCardinality(String),\n",
    "            technique_id LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, tactic, technique_id);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for ATT&CK statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_attack_stats (\n",
    "            tactic LowCardinality(String),\n",
    "            technique LowCardinality(String),\n",
    "            technique_id LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (tactic, technique_id)\n",
    "        AS SELECT\n",
    "            tactic,\n",
    "            technique,\n",
    "            technique_id,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_attack\n",
    "        GROUP BY tactic, technique, technique_id;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for MBC mappings\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_mbc (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            objective LowCardinality(String),\n",
    "            behavior LowCardinality(String),\n",
    "            behavior_id LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, objective, behavior_id);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for MBC statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_mbc_stats (\n",
    "            objective LowCardinality(String),\n",
    "            behavior LowCardinality(String),\n",
    "            behavior_id LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (objective, behavior_id)\n",
    "        AS SELECT\n",
    "            objective,\n",
    "            behavior,\n",
    "            behavior_id,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_mbc\n",
    "        GROUP BY objective, behavior, behavior_id;\n",
    "    \"\"\")\n",
    "\n",
    "def create_die_dbtable(client):\n",
    "    # Create sample_die table\n",
    "    client.command(\"\"\"\n",
    "        SET enable_json_type = 1;\n",
    "    \"\"\")\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_die (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            die_info JSON CODEC(ZSTD(3)),\n",
    "            analysis_date DateTime64(3, 'UTC')\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        CREATE MATERIALIZED VIEW redb_die_mv\n",
    "        (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            compiler LowCardinality(Nullable(String)),\n",
    "            compiler_full Nullable(String),\n",
    "            format LowCardinality(Nullable(String)),\n",
    "            format_full Nullable(String),\n",
    "            installer LowCardinality(Nullable(String)),\n",
    "            installer_full Nullable(String),\n",
    "            joiner LowCardinality(Nullable(String)),\n",
    "            joiner_full Nullable(String),\n",
    "            language LowCardinality(Nullable(String)),\n",
    "            language_full Nullable(String),\n",
    "            library LowCardinality(Nullable(String)),\n",
    "            library_full Nullable(String),\n",
    "            linker LowCardinality(Nullable(String)),\n",
    "            linker_full Nullable(String),\n",
    "            operation_system LowCardinality(Nullable(String)),\n",
    "            operation_system_full Nullable(String),\n",
    "            packer LowCardinality(Nullable(String)),\n",
    "            packer_full Nullable(String),\n",
    "            protector LowCardinality(Nullable(String)),\n",
    "            protector_full Nullable(String),\n",
    "            sfx LowCardinality(Nullable(String)),\n",
    "            sfx_full Nullable(String),\n",
    "            sign_tool LowCardinality(Nullable(String)),\n",
    "            sign_tool_full Nullable(String),\n",
    "            stub LowCardinality(Nullable(String)),\n",
    "            stub_full Nullable(String),\n",
    "            tool LowCardinality(Nullable(String)),\n",
    "            tool_full Nullable(String),   \n",
    "            -- overlay JSON CODEC(ZSTD(3)),\n",
    "            -- resource JSON CODEC(ZSTD(3)),\n",
    "            has_overlay UInt8,\n",
    "            has_resources UInt8,\n",
    "            is_packed UInt8\n",
    "        )\n",
    "        ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256)\n",
    "        POPULATE\n",
    "        AS SELECT\n",
    "            sha256,\n",
    "            md5,\n",
    "            sha1,\n",
    "            analysis_date,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'compiler'), '') AS compiler,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'compiler(full)'), '') AS compiler_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'format'), '') AS format,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'format(full)'), '') AS format_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'installer'), '') AS installer,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'installer(full)'), '') AS installer_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'joiner'), '') AS joiner,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'joiner(full)'), '') AS joiner_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'language'), '') AS language,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'language(full)'), '') AS language_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'library'), '') AS library,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'library(full)'), '') AS library_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'linker'), '') AS linker,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'linker(full)'), '') AS linker_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'operation_system'), '') AS operation_system,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'operation_system(full)'), '') AS operation_system_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'packer'), '') AS packer,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'packer(full)'), '') AS packer_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'protector'), '') AS protector,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'protector(full)'), '') AS protector_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sfx'), '') AS sfx,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sfx(full)'), '') AS sfx_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sign_tool'), '') AS sign_tool,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sign_tool(full)'), '') AS sign_tool_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'stub'), '') AS stub,\n",
    "            nullIf(JSONExtractString(toString(die_info),