In-Geol Choi

From CSBLwiki

Revision as of 16:04, 29 July 2008 (view source) Csbl (Talk | contribs) (→GAD) ← Older edit		Revision as of 17:35, 29 July 2008 (view source) Csbl (Talk | contribs) (→UMLS) Newer edit →
Line 3:		Line 3:
	===UMLS===		===UMLS===
	*MRHIER,MRCONSO,MRXNW_ENG,MRRELM		*MRHIER,MRCONSO,MRXNW_ENG,MRRELM
		+	*install.packages("DBI")
		+	install.packages("RMySQL")
		+	library("RMySQL")
		+	library(DBI)
		+	library("RMySQL")
		+
		+	drv=dbDriver("MySQL")
		+	con = dbConnect(drv,username="",password="",dbname="umls")
		+	rs = dbSendQuery(con,statement=paste("select CUI,GROUP_CONCAT(SDUI separator \',\') from MRCONSO","WHERE SAB="OMIM"))
		+	data = fetch(rs,n=-1)
		+	data
		+
	===GAD===		===GAD===
	*한성: 네 Data의 summary이다.		*한성: 네 Data의 summary이다.

---

Revision as of 17:35, 29 July 2008

Contents 1 Introduction 2 인간질병네트워크 2.1 UMLS 2.2 GAD 3 Misc.

Introduction

인간질병네트워크

UMLS

• MRHIER,MRCONSO,MRXNW_ENG,MRRELM
• install.packages("DBI")

install.packages("RMySQL") library("RMySQL") library(DBI) library("RMySQL")

drv=dbDriver("MySQL") con = dbConnect(drv,username="",password="",dbname="umls") rs = dbSendQuery(con,statement=paste("select CUI,GROUP_CONCAT(SDUI separator \',\') from MRCONSO","WHERE SAB="OMIM")) data = fetch(rs,n=-1) data

GAD

• 한성: 네 Data의 summary이다.
  • 총 6723 record중에 중복된것을 제거하면 6696인데 이전 데이터보다 늘어난것 같다 (이전데이터는 8088->6144). 왜인지?
  • 19 Dis. Class, 2859 Dis. types, 1316 Dis. genes
  • Hs.##### 의 Description 정보를 다오. 일례로 두번째로 많은 링크를 가지고 있는 Hs.370955는 사용되지 않는 식별자이다

No. of Links in Dis. Genes

No. of Links in Dis. Types

No. of Dis. Classes

Misc.

Paul W. K. Rothemund manipulated molecules of DNA to create smiley faces that are one one-thousandth the width of a human hair.	DNA origami
Huge dust storms can be easily seen from space like this dust from China blowing across Korea and Japan in April 2002.	Dust in the Wind