Detail information of $geneid/$geneid_convert
"; #annotation echo "

Functional Annotation

"; echo ""; $query=mysql_query("SELECT * FROM annotation WHERE gene = '$geneid'"); while($result1=mysql_fetch_row($query)){ echo ""; } echo "
DatabaseOrthologsE valueAnnotation
$result1[1]$result1[2]$result1[3]$result1[4]

"; ?> Location And Transcript Sequence
"; echo ""; $query=mysql_query("SELECT * FROM locus WHERE ID = '$geneid'");#SELECT * FROM locus WHERE ID = '$geneid' $result=mysql_fetch_row($query); if($result[2]==""){$result[2]="--";} if($result[1]==""){$result[1]="--";} if($result[3]==""){$result[3]="--";} if($result[4]==""){$result[4]="--";} echo ""; echo ""; echo "
ScaffoldStartEndStrand
$result[1]$result[2]$result[3]$result[4]
Transcript Sequence
"; $query = mysql_query("SELECT * from sequence WHERE (geneid='$geneid' or id='$geneid' ) and type='transcript'"); if(!$sequence=mysql_fetch_row($query)) {echo "";} else { echo ""; } echo "

"; ?> Network for $geneid"; echo ""; echo ""; echo ""; echo "
Network categoryNetworkTop300 PCC genelist
Coexpression PositiveNetworkTop300 PCC genelist
Coexpression NegativeNetworkTop300 PCC genelist
"; ?> Functional Module "; $sql="SELECT * from module_member WHERE gene = '$geneid'"; $query = mysql_query($sql,$con); while($result=mysql_fetch_row($query)){ echo ""; } echo "
Module IDFunction Annotation
$result[2]"; $sql1="SELECT * from module_annotation WHERE module='$result[2]'"; $query1 = mysql_query($sql1,$con); while($result1=mysql_fetch_row($query1)) { echo "$result1[1]
"; } echo "
"; ?>

Protein Structure

"; echo ""; $result=array(); $query=mysql_query("SELECT * FROM pfam WHERE ID = '$geneid'"); if(!$result=mysql_fetch_row($query)) { echo ""; } else { echo ""; } while($result=mysql_fetch_row($query)) { echo ""; } echo ""; echo "
Pfam accessionPfam nameAlignment startAlignment endE-value
----------
$result[3]$result[4]$result[1]$result[2]$result[5]
$result[3]$result[4]$result[1]$result[2]$result[5]
Protein Sequence
"; $query = mysql_query("SELECT * from sequence WHERE (geneid='$geneid' or id='$geneid' ) and type='protein'"); if(!$sequence=mysql_fetch_row($query)) { echo "";} else { echo ""; } echo ""; echo "

"; echo "

Gene family

"; echo ""; $result_P450=array(); $result_TF=array(); $result_PK=array(); $result_Ubs=array(); $result_CAZy=array(); $query_P450 = mysql_query("SELECT * from P450 WHERE geneid='$geneid' "); $result_P450=mysql_fetch_row($query_P450); $query_TF = mysql_query("SELECT * from TF WHERE Geneid='$geneid' "); $result_TF=mysql_fetch_row($query_TF); $query_PK = mysql_query("SELECT * from PK WHERE Geneid='$geneid' "); $result_PK=mysql_fetch_row($query_PK); $query_Ubs = mysql_query("SELECT * from Ubs WHERE Geneid='$geneid' "); $result_Ubs=mysql_fetch_row($query_Ubs); $query_CAZy = mysql_query("SELECT * from CAZy WHERE Geneid='$geneid' "); $result_CAZy=mysql_fetch_row($query_CAZy); if(!$result_P450 && !$result_TF && !$result_PK && ! $result_Ubs && ! $result_CAZy) {echo "";} else { if($result_P450){echo"";} if($result_TF){echo"";} if($result_PK){echo"";} if($result_Ubs){echo"";} if($result_CAZy){echo"";} } while($result_P450=mysql_fetch_row($query_P450)){echo"";} while($result_TF=mysql_fetch_row($query_TF)){echo"";} while($result_PK=mysql_fetch_row($query_PK)){echo"";} while($result_Ubs=mysql_fetch_row($query_Ubs)){echo"";} while($result_CAZy=mysql_fetch_row($query_CAZy)){echo"";} echo "
Gene familysubfamily
----
Cytochrome P450 Family$result_P450[0]
Transcription Factors Family$result_TF[1]
Protein Kinases Family$result_PK[0]
Ubiquitin Family$result_Ubs[0]
Carbohydrate-Active enzymes Family$result_CAZy[0]
Cytochrome P450 Family$result_P450[0]
Transcription Factors Family$result_TF[0]
Protein Kinases Family$result_PK[0]
Ubiquitin Family$result_Ubs[0]
Carbohydrate-Active enzymes Family$result_CAZy[0]
"; echo "

"; echo "

KEGG pathway

"; echo ""; $result=array();$pathway=array();$map=array();$n=0; $query=mysql_query("SELECT * from KEGG WHERE genes='$geneid' "); if(!$result=mysql_fetch_row($query)) { echo ""; echo "
KO Enzyme pathway mapID
--------
"; } else { $ko=$result[2];$en=$result[3];$enid=$result[5];$pathway[$n]=$result[0];$map[$n]=$result[6];$n++; // echo "$result[2]$result[3]$result[5]$result[0]$result[8]"; while($result=mysql_fetch_row($query)) { $pathway[$n]=$result[0];$map[$n]=$result[6];$n++; //echo "$result[2]$result[3]$result[5]$result[0]$result[8]"; } echo "$ko$en"; $ec=explode(":",$enid); echo" $pathway[0] $map[0]"; for($i=1;$i<$n;$i++){echo "$pathway[$i]$map[$i]";} echo ""; } echo "

"; echo "

Gene Ontology

"; $result=array(); $query=mysql_query("SELECT * FROM GO WHERE ID = '$geneid'"); echo ""; while($result=mysql_fetch_row($query)){ echo ""; } echo "
GO term OntologyName
$result[1]$result[2]$result[3]
"; echo "

Expression pattern

"; $sql="SELECT * from FPKM WHERE gene_id='$geneid'"; $query = mysql_query($sql,$con); $result=array(); $result=mysql_fetch_row($query); for($i=0;$i

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $Gastro=($result[28]+$result[29]+$result[30])/3; $Gastro=number_format($Gastro,2); echo ""; $Juven=($result[31]+$result[32]+$result[33])/3; $Juven=number_format($Juven, 2); echo ""; $MotherG=($result[34]+$result[35]+$result[36])/3; $MotherG=number_format($MotherG,2); echo ""; $MotherJ=($result[37]+$result[38]+$result[39])/3; $MotherJ=number_format($MotherJ,2); echo ""; echo "
SRPSampleDescriptionFPKM
SRP064423SRR2545914vegetative propagation corms$result[2]
SRR2545915Juvenile tuber$result[1]
SRP108465SRR5643513five period of Gastrodia elata$result[3]
SRR5643514five period of Gastrodia elata$result[4]
SRR5643515five period of Gastrodia elata$result[5]
SRR5643524five period of Gastrodia elata$result[6]
SRR5643525five period of Gastrodia elata$result[7]
SRR5643528five period of Gastrodia elata$result[8]
SRR5643658five period of Gastrodia elata$result[9]
SRR5643659five period of Gastrodia elata$result[10]
SRR5643660five period of Gastrodia elata$result[11]
SRR5643661five period of Gastrodia elata$result[12]
SRR5643662five period of Gastrodia elata$result[13]
SRR5643663five period of Gastrodia elata$result[14]
SRR5643664five period of Gastrodia elata$result[15]
SRP118053SRR6049654Rhizomagastrodiae_C368-T07_good_1$result[16]
SRR6049655Rhizomagastrodiae_C368-T10_good_1$result[17]
SRR6049656Rhizomagastrodiae_C368-T07_good_1$result[18]
SRR6049657Rhizomagastrodiae_C368-T07_good_1$result[19]
SRR6049658Rhizomagastrodiae_C368-T04_good_1$result[20]
SRR6049659Rhizomagastrodiae_C368-T04_good_1$result[21]
SRR6049660Rhizomagastrodiae_C368-T01_good_1$result[22]
SRR6049661Rhizomagastrodiae_C368-T04_good_1$result[23]
SRR6049662Rhizomagastrodiae_C368-T01_good_1$result[24]
SRR6049663Rhizomagastrodiae_C368-T01_good_1$result[25]
SRR6049664Rhizomagastrodiae_C368-T10_good_1$result[26]
SRR6049665Rhizomagastrodiae_C368-T10_good_1$result[27]
SRP279888GastroGastrodia elata tuber $Gastro
JuvenJuvenile tuber$Juven
Mother_GastroMother tuber of Gastrodia elata $MotherG
Mother_JuvenMother tuber of Juvenile $MotherJ
"; ?>

"; } ?>