Discover gists

We will get the cosine similarity of genes starting with CDK and PPARG using pure duckdb.

Get the ids

CREATE OR REPLACE TABLE jcp_symbol AS (SELECT Metadata_JCP2022,Metadata_Symbol FROM read_csv(['https://github.com/jump-cellpainting/datasets/raw/99c34b66f51c5971c85417c02e191f43057c22a8/metadata/crispr.csv.gz', 'https://github.com/jump-cellpainting/datasets/raw/99c34b66f51c5971c85417c02e191f43057c22a8/metadata/orf.csv.gz']) WHERE starts_with(Metadata_Symbol, 'CDK') OR starts_with(Metadata_Symbol, 'PPARG'));
SELECT * FROM jcp_symbol LIMIT 2;
SELECT COUNT(*) AS nrows FROM jcp_symbol;

	ENTITY: Ivane Shaorshadze · Sovereign Capsule Holder
	ID: 38001020161 · DOB: 12.05.1985
	PRIMARY CAPSULE: [email protected]
	COMPANY: Nita123 LLC · Capsule Identity
	REPOSITORY ROOT: Ivane120585 · GitHub Gist Sovereign Kernel
	COMPLETION CODE: 091119 · Universal Flame Code

	EVENT: Absolute Infinity Seal Ceremony · Eternal Infinity Confirmed

	DECLARATION:

	<?xml version="1.0" encoding="utf-8"?>
	<registrySnapshot xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<user>S-1-5-21-3245274011-4197289227-4083904764-1000</user>
	<keys>
	<key installerType="Unknown" displayName="VLC media player" displayVersion="3.0.22">
	<RegistryView>Registry64</RegistryView>
	<KeyPath>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\VLC media player</KeyPath>
	<DefaultValue />
	<InstallLocation><![CDATA[C:\Program Files\VideoLAN\VLC]]></InstallLocation>
	<UninstallString><![CDATA["C:\Program Files\VideoLAN\VLC\uninstall.exe"]]></UninstallString>

	Log uploaded on Thursday, December 4, 2025, 7:54:29 AM
	Loaded mods:
	Harmony(brrainz.harmony)[mv:2.4.2.0]: 0Harmony(2.4.1), HarmonyMod(2.4.2)
	Loading Progress(ilyvion.LoadingProgress): ilyvion.LoadingProgress(0.9.5)
	Core(Ludeon.RimWorld): (no assemblies)
	Royalty(Ludeon.RimWorld.Royalty): (no assemblies)
	Ideology(Ludeon.RimWorld.Ideology): (no assemblies)
	Biotech(Ludeon.RimWorld.Biotech): (no assemblies)
	Anomaly(Ludeon.RimWorld.Anomaly): (no assemblies)
	Odyssey(Ludeon.RimWorld.Odyssey): (no assemblies)

	Log uploaded on Thursday, December 4, 2025, 4:53:57 AM
	Loaded mods:
	Prepatcher(jikulopo.prepatcher): 0Harmony(2.4.1), 0PrepatcherAPI(1.2.0), 0PrepatcherDataAssembly(1.0.0), PrepatcherImpl(1.2.0), Prestarter(1.0.0)
	Harmony(brrainz.harmony)[mv:2.4.2.0]: 0Harmony(2.4.1), HarmonyMod(2.4.2)
	Core(Ludeon.RimWorld): (no assemblies)
	Royalty(Ludeon.RimWorld.Royalty): (no assemblies)
	Ideology(Ludeon.RimWorld.Ideology): (no assemblies)
	Biotech(Ludeon.RimWorld.Biotech): (no assemblies)
	Anomaly(Ludeon.RimWorld.Anomaly): (no assemblies)
	HugsLib(UnlimitedHugs.HugsLib)[ov:12.0.0]: 0Harmony(av:2.4.1,fv:1.2.0.1), HugsLib(av:1.0.0,fv:12.0.0)

	ENTITY: Ivane Shaorshadze · Sovereign Capsule Holder
	ID: 38001020161 · DOB: 12.05.1985
	PRIMARY CAPSULE: [email protected]
	COMPANY: Nita123 LLC · Capsule Identity
	REPOSITORY ROOT: Ivane120585 · GitHub Gist Sovereign Kernel
	COMPLETION CODE: 091119 · Universal Flame Code

	EVENT: Supreme Kernel Mirror Ceremony · Eternal Reflection Confirmed

	DECLARATION:

	# MediaSynth

	Personal video content automation tool.

	Contact: [email protected]