Difference between revisions of "Movie"
From WormBaseWiki
Jump to navigationJump to search| Line 31: | Line 31: | ||
* Remark -> "mov_remark" text | * Remark -> "mov_remark" text | ||
* Curator -> "mov_curator" | * Curator -> "mov_curator" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==.ace dumper== | ==.ace dumper== | ||
Revision as of 19:10, 17 October 2012
Movie Curation
In October 2012 we have decided to generate a movie OA. There were 514 movies in acedb, all pertaining the RNAi class. We are going to generate the movie OA and import those objects. Files on tazendra /home/acedb/draciti/Movies
Movie Data Model
////////////////////////////////////////////////////////////////////////////////////
?Movie Description ?Text
Name UNIQUE Text
Pick_me_to_call Text Text
RNAi ?RNAi XREF Movie
Variation ?Variation XREF Movie
Expr_pattern ?Expr_pattern XREF Movie
Remark ?Text #Evidence
///////////////////////////////////////////////////////////////////////////////////
OA
- Pgdbid -- no table -- postgres database ID, generates automatically upon entry.
- WBMovie -> "mov_name" Generates automatically upon entry. WBMovie0000000001
- Source -> "mov_source" text
- Description -> "mov_description" bigtext
- RNAi -> "mov_rnai" Text
There are 500 objects we currently have for movie/rnai are not in rnai OA but are stored in citace minus so we cannot import them as multiontology.
- Expression pattern -> "mov_exprpattern" multiontology on expression patterns as in Picture OA
- Variation -> "mov_variation" multiontology on variations like in phenotype OA tab1
- Remark -> "mov_remark" text
- Curator -> "mov_curator"
.ace dumper
module /home/postgres/work/citace_upload/movie/get_movie_ace.pm
script /home/postgres/work/citace_upload/movie/use_movie_package.pl
Populating RNAi-Movie data
/home/postgres/work/pgpopulation/mov_movie/20121012_newOa/populate_movies_20121012.pl done in sandbox.
