Good Morning Joshua: Please note, you can view the table schema for any table in the genome browser via the "tables" link in the blue navigation bar. Select group: "Regulation", track "CpG Islands" and then "describe table schema"
bin 585 smallint(6) range Indexing field to speed chromosome range queries. chrom chr1 varchar(255) values Reference sequence chromosome or scaffold chromStart 28735 int(10) unsigned range Start position in chromosome chromEnd 29810 int(10) unsigned range End position in chromosome name CpG: 116 varchar(255) values CpG Island length 1075 int(10) unsigned range Island Length cpgNum 116 int(10) unsigned range Number of CpGs in island gcNum 787 int(10) unsigned range Number of C and G in island perCpg 21.6 float range Percentage of island that is CpG perGc 73.2 float range Percentage of island that is C or G obsExp 0.83 float range Ratio of observed(cpgNum) to expected(numC*numG/length) CpG in island You can select specific rows directly from the public MySQL server: mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e "select chrom,chromStart,chromEnd,name from cpgIslandExt;" hg19 --Hiram qcshare wrote: > Dear Professor, > I want to download the genome CpG islands information, such as the number of > chromosome, start/end position of the CpG islands and CpG islands ID > numbers, I just found the first three items, but I can not found the > information of CpG islands ID numbers. > Could you please tell me where can I get this information? > > Thank you very much! > > Your Sincerely! > > Joshua. _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
