UCAlist.php from eXtensible Genome Data Broker at Krugle

Show UCAlist.php syntax highlighted


<?php
if(empty($SITEDEF_H)){require('SITEDEF.php');}
if(empty($PARAM_H)){require('getPARAM.php');}
require('SSI_GDBprep.php');
virtual("${CGIPATH}SSI_GDBgui.pl/TWO_COLUMN_HEADER/" . $SSI_QUERYSTRING);
?>

<!--
<STYLE TYPE="text/css">
p { font-family: Verdana,Arial,sans-serif;
    font-size: 10pt;
}
h3 { 
 padding:1px 5px; margin:2px;
 border:1px solid maroon; background:#336666;
 color:#FFFFFF; font:bold 100% stencil,cursive;
}
</STYLE>
-->

<div align="left">

<h2 align="center"><font color="#000000"><big>Accepted Community Annotations</big></font></h2>

<P style="margin-right:32px; text-align:left;">
The UCA system facilitates annotation creation and submission by individual users for 
incorporation into AtGDB and almost immediate dissemination via the web. Thus, the UCA
system allows the community to contribute directly to the annotation integrity and
accuracy of the <I>Arabiodopsis</I> genome.  In particular, the annotations are accessible
to all <I>Arabidopsis</I> database providers, which should allow quick convergence and
elimination of obvious errors.
</P>

<script language="JavaScript1.2">
var browser_type = navigator.appName;
if (browser_type == "Netscape" || browser_type == "Mozilla"){
  displayshow = "table-row";
}else{
  displayshow = "block";
}

function showAnnotations(usr,lrow,cnt){
  for(x=lrow;x<cnt;x++){
    document.getElementById("row_" + x).style.display = displayshow;
  }
  document.getElementById('URH_' + usr).style.display = displayshow;
  document.getElementById('URS_' + usr).style.display = 'none';
}

function hideAnnotations(usr,lrow,cnt){
  for(x=lrow;x<cnt;x++){
    document.getElementById('row_' + x).style.display = 'none';
  }
  document.getElementById('URH_' + usr).style.display = 'none';
  document.getElementById('URS_' + usr).style.display = displayshow;
}
</script>

<TABLE ID='UCAlist' border=1>
<TR><TH COLSPAN=2>Contributor</TH><TH>UCA Identifier</TH><TH>Chromosome (Region)</TH></TR>
<?php
// Query ATGDB database for user_gene_annotation
$dbh = mysql_connect($DB_HOST,$DB_USER,$DB_PASSWORD);
$AnnDB = end($DBver);
mysql_select_db($AnnDB["DB"]);

$sth = mysql_query("SELECT a.USERid, u.fullname, a.geneId, a.chr, a.l_pos, a.r_pos, a.uid FROM users as u, user_gene_annotation as a WHERE (u.USERid = a.USERid)&&(a.status='ACCEPTED') ORDER BY USERid,chr,l_pos");

$x=$y=0;
$Cuser = '';
$UCArows = '';
while( $row = mysql_fetch_row($sth)){
  if($Cuser == ''){
    $Cuser = $row[0];
    $Cuser_FN = $row[1];
  }

  if($row[0] != $Cuser){
    echo "<TR ID='URS_$Cuser' CLASS='UserRow'><TD>$Cuser</TD><TD>$Cuser_FN ($z)</TD><TD COLSPAN=2><A HREF='javascript:showAnnotations(\"$Cuser\",$x,$y);'>Show annotations</A></TD></TR>\n";
    echo "<TR ID='URH_$Cuser' CLASS='UserRow' STYLE='display:none;'><TD>$Cuser</TD><TD>$Cuser_FN</TD><TD COLSPAN=2><A HREF='javascript:hideAnnotations(\"$Cuser\",$x,$y);'>Hide annotations</A></TD></TR>\n";
    echo $UCArows;
    $Cuser    = $row[0];
    $Cuser_FN = $row[1];
    $UCArows  = '';
    $x=$y;
    $z=0;
  }

  $UCArows .=  "<TR ID='row_$y' STYLE='display:none;'><TD></TD><TD></TD><TD><A TARGET='_blank' HREF='${CGIPATH}getRecord.pl?resid=3&chrUID=$row[6]'>$row[2]</A></TD><TD><A TARGET='_blank' HREF='${CGIPATH}getRegion.pl?chr=$row[3]&l_pos=$row[4]&r_pos=$row[5]'>$row[3] ($row[4] - $row[5])</A></TD></TR>\n";
  $y++;$z++;
}
echo "<TR ID='URS_$Cuser' CLASS='UserRow'><TD>$Cuser</TD><TD>$Cuser_FN ($z)</TD><TD COLSPAN=2><A HREF='javascript:showAnnotations(\"$Cuser\",$x,$y);'>Show annotations</A></TD></TR>\n";
echo "<TR ID='URH_$Cuser' CLASS='UserRow' STYLE='display:none;'><TD>$Cuser</TD><TD>$Cuser_FN</TD><TD COLSPAN=2><A HREF='javascript:hideAnnotations(\"$Cuser\",$x,$y);'>Hide annotations</A></TD></TR>\n";
echo $UCArows;
?>

</TABLE>

</div>

<?php
require('SSI_GDBprep.php');
virtual("${CGIPATH}SSI_GDBgui.pl/STANDARD_FOOTER/" . $SSI_QUERYSTRING);
?>

See more files for this project here

eXtensible Genome Data Broker

The xGDB project provides scientists with an online portal for the integration of diverse sources of genomic data. Portals allow researchers to effectively target a specific scientific question by customizing their interactions with available data.

Project homepage: http://sourceforge.net/projects/xgdb
Programming language(s): JavaScript,Perl,PHP
License: other

  Showcase/
    03nov01/
      CDNA.png
      EST.png
      GBK.png
      UCA.png
      description.html
      ruler.png
    04mar11/
      CDNA.png
      EST.png
      GBK.png
      UCA.png
      description.html
      ruler.png
    GeneModelMerge/
      CDNA.png
      EST.png
      GBK.png
      UCA.png
      index.php
      ruler.png
    GeneModelSplit/
      CDNA.png
      EST.png
      GBK.png
      UCA.png
      index.php
      ruler.png
  gaeval/
    examples/
      altspl.png
      amb3.png
      amb5.png
      att.png
      cov0.png
      cov1.png
      cov2.png
      cov3.png
      cov4.png
      fission.png
      fussion.png
      ovext.png
      unext.png
    GLquery.css
    GLquery.js
    cps.php
    fig1.png
    fig2.png
    figa.png
    gaeval_lists.php
    index.php
  ATchr2.aln
  ATchr3.aln
  ATchr5.aln
  UCAlist.php
  index.php
  vector.php