CanGEM
 
Friday, December 15, 2017
Logged in as guest | Register
Login: Password:
Karyotypes
CG-PLM-6

Ensembl
from Ensembl Database
Homo sapiens
This "platform" contains the cytogenetic bands of the human chromosomes imported from the Ensembl database.
The files were generated with the following commands:

echo "SELECT CONCAT(name, band) Band, name Chr, seq_region_start Start, seq_region_end End FROM karyotype JOIN seq_region USING (seq_region_id) WHERE name IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','X','Y') ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 5306 -u anonymous -p homo_sapiens_core_56_37a > GRCh37.txt

echo "SELECT CONCAT(name, band) Band, name Chr, seq_region_start Start, seq_region_end End FROM karyotype JOIN seq_region USING (seq_region_id) WHERE name IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','X','Y') ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 5306 -u anonymous -p homo_sapiens_core_54_36p > NCBI36.txt

echo "SELECT CONCAT(name, band) Band, name Chr, seq_region_start Start, seq_region_end End FROM karyotype JOIN seq_region USING (seq_region_id) WHERE name IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','X','Y') ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 3306 -u anonymous -p homo_sapiens_core_37_35j > NCBI35.txt

echo "SELECT CONCAT(name, band) Band, name Chr, seq_region_start Start, seq_region_end End FROM karyotype JOIN seq_region USING (seq_region_id) WHERE name IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','X','Y') ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 3306 -u anonymous -p homo_sapiens_core_25_34e > NCBI34.txt
Data Files
GRCh37.txt (23.68 KB)
NCBI36.txt (23.68 KB)
NCBI35.txt (23.68 KB)
NCBI34.txt (23.67 KB)

2005-09-29 17:30:29 by Ilari Scheinin
2010-02-26 12:13:49 by Ilari Scheinin

GUID: {FB485F0C-606A-416E-9DB4-A14CB5A7E12D}