Skip to content

Files

Latest commit

505e4ab · Nov 14, 2024

History

History
14 lines (11 loc) · 373 Bytes

HOW_TO.md

File metadata and controls

14 lines (11 loc) · 373 Bytes

How to

This page compiles common operations that you might want to do when using the MTP-DB.

How to find all GAP junctions?

This SQL gets you all the GAP junction ENSGs. They are best detected by their gene name, as the TCDB families seem to be incomplete:

SELECT ensg
FROM gene_names
WHERE
	hugo_gene_symbol like "GJ%" OR
	hugo_gene_symbol like "PANX%"