To get a list of the 55 loci in human that are on b36 but we elected not to map over to b37 do the following query.
webuser@mousehole [t1dbase_curate_4_14_3]> select l.locus_id,locus_type_name,locus_name,locus_desc,chromosome,locus_start,locus_end from locus l inner join locus_location ll on l.locus_id=ll.locus_id inner join locus_type lt on lt.locus_type_id=l.locus_type_id where l.record_status_id='N' and ll.record_status_id='N' and build_id=6 and l.locus_id not in (select locus_id from locus_location where build_id=11) order by l.locus_type_id, ll.chromosome_id, locus_start;
By keeping them as N (normal) regions in the curate db, the scripts to create the GFF for gbrowse will use them and create links using the locus_id. However, the site cannot create a locus page as there is no positional info on the current build.
Decision reserved for discussion.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
To get a list of the 55 loci in human that are on b36 but we elected not to map over to b37 do the following query.
webuser@mousehole [t1dbase_curate_4_14_3]> select l.locus_id,locus_type_name,locus_name,locus_desc,chromosome,locus_start,locus_end from locus l inner join locus_location ll on l.locus_id=ll.locus_id inner join locus_type lt on lt.locus_type_id=l.locus_type_id where l.record_status_id='N' and ll.record_status_id='N' and build_id=6 and l.locus_id not in (select locus_id from locus_location where build_id=11) order by l.locus_type_id, ll.chromosome_id, locus_start;
By keeping them as N (normal) regions in the curate db, the scripts to create the GFF for gbrowse will use them and create links using the locus_id. However, the site cannot create a locus page as there is no positional info on the current build.
Decision reserved for discussion.