Question

How can I create ChipDb for Solanum lycopersicum?

0

Entering edit mode

knishida ▴ 20

@knishida-8230

Last seen 4.2 years ago

United States

Hi

I would like to create ChipDb package for Solanum lycopersicum.

It seems there is already Solanum lycopersicum OrgDb in AnntationHub.

And I have an ID mapping table for my probeIDs and ENTREZ IDs.

I think makeDBPackage creates sqlite database from such a table.

makeDBPackage needs schema for the argument, but there is no available dbschema for Solanum lycopersicum.

How can I create ChipDb for Solanum lycopersicum?

annotation • 1.0k views

ADD COMMENT • link updated 8.6 years ago by James W. MacDonald 65k • written 8.6 years ago by knishida ▴ 20

score 4 · Accepted Answer · 2015-09-10

4

Entering edit mode

James W. MacDonald 65k

@james-w-macdonald-5106

Last seen 9 hours ago

United States

You use makeChipPackage() from AnnotationForge, which will determine the correct schema (in this case the NOCHIPSCHEMA_DB) automatically.

ADD COMMENT • link 8.6 years ago James W. MacDonald 65k

0

Entering edit mode

Thanks James.

makeChipPackage()

almost works well.

But I could NOT find the way to assign multiple ENTREZ IDs for a probe ID.

It seems ChipDb has is_multiple column and the value is 1 when the probe ID has multiple ENTREZ IDs.

How can I assign multiple ENTREZ IDs for a probe ID ?

ADD REPLY • link 8.6 years ago knishida ▴ 20

1

Entering edit mode

It's as simple as you might expect. You put the probe ID in twice (on two different lines).

ProbeID_X   12345
ProbeID_X    45322

ADD REPLY • link 8.6 years ago James W. MacDonald 65k

0

Entering edit mode

Thanks again James!

It works well!.

Now I have added the is_multiple 1 column to my db.

ADD REPLY • link 8.6 years ago knishida ▴ 20