delete from portal_post;
delete from auth_permission;
delete from auth_user;
INSERT INTO "portal_post" VALUES(1,'JASPAR database 2018 release','We are happy to announce the seventh release of JASPAR database, as JASPAR 2018. This latest release comes with a hundreds of new/updated profiles as position frequency matrices (PFMs) and TF flexible models (TFFMs), and also several other features. 

<br><br>
Below are the highlights of this release:

<ul>
<li> Added 322 new PFMs (60 for vertebrates and 262 for plants)</li>
<li> Updated 33 PFMs were (24 for vertebrates, 8 for plants, and 1 for insects)</li>
<li> Added 316 TFFMs (95 for vertebrates, 218 for plants, and 3 for insects)</li>
<li> This release comes with clusters of similar PFMs in each taxon and each TF class per taxon</li>
<li> Comes with UCSC Genome Browser track data hub containing genome-wide binding site predictions for TF profiles in the JASPAR CORE vertebrates collection</li>
<li> Introduced a completely new web framework with an interactive and responsive user-interface</li>
<li> Introduced a RESTful API to retrieved data programmatically</li>
</ul>

<br><br>
The data are available on the <a href="/">JASPAR website</a>, via the <a href="/api">REST API</a>, and in the <a href="/downloads">downloads section</a>.','jaspar-database-seventh-release-2018','Announcement','2017-10-16 10:33:12.096697',2);
INSERT INTO "portal_post" VALUES(2,'JASPAR TFBS tracks for UCSC and Ensembl Genome Browser','Track hubs are web-accessible directories of genomic data that can be viewed on Genome Browsers, such as UCSC  Genome Browser and Ensembl Genome Browser.
<p>
In the 2018 release of JASPAR, we have performed transcription factor binding sites (TFBS) predictions on the human genome using the JASPAR CORE
vertebrate position frequency matrices (PFMs). The predicted TFBSs are publicly available through UCSC Genome Browser data hub containing tracks for the human genome assemblies
<a href="http://genome.ucsc.edu/cgi-bin/hgTracks?db=hg19&hubUrl=http://expdata.cmmt.ubc.ca/JASPAR/UCSC_tracks/hub.txt" target="_blank">hg19</a> and <a href="http://genome.ucsc.edu/cgi-bin/hgTracks?db=hg38&hubUrl=http://expdata.cmmt.ubc.ca/JASPAR/UCSC_tracks/hub.txt" target="_blank">hg38</a>.

These tracks tracks are also available through <a href="http://www.ensembl.org/Trackhub?url=http://expdata.cmmt.ubc.ca/JASPAR/UCSC_tracks/hub.txt" target="_blank">Ensembl Genome Browser</a>.
</p>
<p>
Further, JASPAR TFBS tracks are available on the <b><a href="https://www.trackhubregistry.org/search?q=jaspar" target="_blank">Track Hub Registry</a></b>, which is a centralised repository for registering and discovering publicly accessible track data hubs. These tracks can be viewed in Genome Browsers including Ensembl, UCSC and Biodalliance.</p>

<img src=''/static/img/Ensembl_JASAPR_track_1.png'' class=''img img-responsive'' width=''80%''>

<p>For more details and to download the data and code please visit <a href=''/genome-tracks/''>JASPAR Genome Browser tracks page</a></p>','jaspar-tfbs-genome-tracks','Announcement','2017-10-31 11:47:49.427117',2);
INSERT INTO "portal_post" VALUES(3,'The 8th release of JASPAR database','We are happy to announce the eighth release of JASPAR database, as JASPAR 2020. This latest release comes with a hundreds of new/updated profiles as position frequency matrices (PFMs), introducing a new community curation initiative, an open Q&A forum, and much more. 

<br><br>
Below are the highlights of this release:

<ul>
<li> Added 245 new PFMs (169 for vertebrates, 42 for plants, 17 for nematodes, 10 for insects, and 7 for fungi)</li>
<li> Updated 157 PFMs (125 for vertebrates, 28 for plants, and 3 for insects).</li>
<li> This release comes with a novel collection of unvalidated TF-binding profiles for which our curators did not find orthogonal supporting evidence in the literature.</li>
<li> Moreover, we created a Q&A forum to ease the communication between the user community and JASPAR curators. </li>
</ul>

<br><br>
The data are available on the <a href="/">JASPAR website</a>, via the <a href="/api">REST API</a>, and in the <a href="/downloads">downloads section</a>.','eighth-release-of-jaspar-database','Announcement','2019-10-12 11:15:09.152432',2);
INSERT INTO "auth_permission" VALUES(1,1,'add_logentry','Can add log entry');
INSERT INTO "auth_permission" VALUES(2,1,'change_logentry','Can change log entry');
INSERT INTO "auth_permission" VALUES(3,1,'delete_logentry','Can delete log entry');
INSERT INTO "auth_permission" VALUES(4,2,'add_group','Can add group');
INSERT INTO "auth_permission" VALUES(5,2,'change_group','Can change group');
INSERT INTO "auth_permission" VALUES(6,2,'delete_group','Can delete group');
INSERT INTO "auth_permission" VALUES(7,3,'add_permission','Can add permission');
INSERT INTO "auth_permission" VALUES(8,3,'change_permission','Can change permission');
INSERT INTO "auth_permission" VALUES(9,3,'delete_permission','Can delete permission');
INSERT INTO "auth_permission" VALUES(10,4,'add_user','Can add user');
INSERT INTO "auth_permission" VALUES(11,4,'change_user','Can change user');
INSERT INTO "auth_permission" VALUES(12,4,'delete_user','Can delete user');
INSERT INTO "auth_permission" VALUES(13,5,'add_contenttype','Can add content type');
INSERT INTO "auth_permission" VALUES(14,5,'change_contenttype','Can change content type');
INSERT INTO "auth_permission" VALUES(15,5,'delete_contenttype','Can delete content type');
INSERT INTO "auth_permission" VALUES(16,6,'add_session','Can add session');
INSERT INTO "auth_permission" VALUES(17,6,'change_session','Can change session');
INSERT INTO "auth_permission" VALUES(18,6,'delete_session','Can delete session');
INSERT INTO "auth_permission" VALUES(19,7,'add_post','Can add post');
INSERT INTO "auth_permission" VALUES(20,7,'change_post','Can change post');
INSERT INTO "auth_permission" VALUES(21,7,'delete_post','Can delete post');
INSERT INTO "auth_permission" VALUES(22,8,'add_tax','Can add tax');
INSERT INTO "auth_permission" VALUES(23,8,'change_tax','Can change tax');
INSERT INTO "auth_permission" VALUES(24,8,'delete_tax','Can delete tax');
INSERT INTO "auth_permission" VALUES(25,9,'add_matrixdata','Can add matrix data');
INSERT INTO "auth_permission" VALUES(26,9,'change_matrixdata','Can change matrix data');
INSERT INTO "auth_permission" VALUES(27,9,'delete_matrixdata','Can delete matrix data');
INSERT INTO "auth_permission" VALUES(28,10,'add_matrixspecies','Can add matrix species');
INSERT INTO "auth_permission" VALUES(29,10,'change_matrixspecies','Can change matrix species');
INSERT INTO "auth_permission" VALUES(30,10,'delete_matrixspecies','Can delete matrix species');
INSERT INTO "auth_permission" VALUES(31,11,'add_matrixannotation','Can add matrix annotation');
INSERT INTO "auth_permission" VALUES(32,11,'change_matrixannotation','Can change matrix annotation');
INSERT INTO "auth_permission" VALUES(33,11,'delete_matrixannotation','Can delete matrix annotation');
INSERT INTO "auth_permission" VALUES(34,12,'add_matrixprotein','Can add matrix protein');
INSERT INTO "auth_permission" VALUES(35,12,'change_matrixprotein','Can change matrix protein');
INSERT INTO "auth_permission" VALUES(36,12,'delete_matrixprotein','Can delete matrix protein');
INSERT INTO "auth_permission" VALUES(37,13,'add_matrix','Can add matrix');
INSERT INTO "auth_permission" VALUES(38,13,'change_matrix','Can change matrix');
INSERT INTO "auth_permission" VALUES(39,13,'delete_matrix','Can delete matrix');
INSERT INTO "auth_permission" VALUES(40,14,'add_taxext','Can add tax ext');
INSERT INTO "auth_permission" VALUES(41,14,'change_taxext','Can change tax ext');
INSERT INTO "auth_permission" VALUES(42,14,'delete_taxext','Can delete tax ext');
INSERT INTO "auth_permission" VALUES(43,15,'add_tffm','Can add tffm');
INSERT INTO "auth_permission" VALUES(44,15,'change_tffm','Can change tffm');
INSERT INTO "auth_permission" VALUES(45,15,'delete_tffm','Can delete tffm');
INSERT INTO "auth_permission" VALUES(46,16,'add_release','Can add release');
INSERT INTO "auth_permission" VALUES(47,16,'change_release','Can change release');
INSERT INTO "auth_permission" VALUES(48,16,'delete_release','Can delete release');
INSERT INTO "auth_user" VALUES(1,'pbkdf2_sha256$36000$klZiKtXsyee2$dU9ph4cGYU1ty2MOqqWo0D2xQW97RQB6U5YRYtuPJmc=','2017-10-16 10:26:54.000000',1,'admin','JASPAR','jaspar.team@gmail.com',1,1,'2017-09-24 16:20:26.000000','Admin');
INSERT INTO "auth_user" VALUES(2,'pbkdf2_sha256$36000$jgDWENbIOiue$UcwTwpNg7nGDa7+VKwwTR9RdSzGqlsmtRq5fSlVHeFk=','2019-10-12 11:07:15.811835',1,'azizk','Aziz','azez.khan@gmail.com',1,1,'2017-10-16 10:27:54.000000','Khan');
