CanGEM
 
Sunday, December 17, 2017
Logged in as guest | Register
Login: Password:
Chromosomes
CG-PLM-37

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

echo "SELECT seq_region.name Name, seq_region.name Chr, 1 Start, length End FROM seq_region JOIN coord_system USING (coord_system_id) WHERE seq_region.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','MT') AND version = 'GRCh37' ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 WHEN 'MT' THEN 25 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 seq_region.name Name, seq_region.name Chr, 1 Start, length End FROM seq_region JOIN coord_system USING (coord_system_id) WHERE seq_region.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','MT') AND version = 'NCBI36' ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 WHEN 'MT' THEN 25 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 5306 -u anonymous -p homo_sapiens_core_56_37a > NCBI36.txt

echo "SELECT seq_region.name Name, seq_region.name Chr, 1 Start, length End FROM seq_region JOIN coord_system USING (coord_system_id) WHERE seq_region.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','MT') AND version = 'NCBI35' ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 WHEN 'MT' THEN 25 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 5306 -u anonymous -p homo_sapiens_core_56_37a > NCBI35.txt

echo "SELECT seq_region.name Name, seq_region.name Chr, 1 Start, length End FROM seq_region JOIN coord_system USING (coord_system_id) WHERE seq_region.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','MT') AND version = 'NCBI34' ORDER BY CAST((CASE Chr WHEN 'X' THEN 23 WHEN 'Y' THEN 24 WHEN 'MT' THEN 25 ELSE Chr END) AS UNSIGNED), Start" | mysql -h ensembldb.ensembl.org -P 5306 -u anonymous -p homo_sapiens_core_56_37a > NCBI34.txt
Data Files
GRCh37.txt (435 bytes)
NCBI36.txt (435 bytes)
NCBI35.txt (435 bytes)
NCBI34.txt (421 bytes)

2010-04-22 14:20:16 by Ilari Scheinin
2010-04-22 14:35:48 by Ilari Scheinin

GUID: {E88C0B59-42C3-4446-A38C-D3C84537DF17}