Detail information of $geneid/$geneid_convert";
#annotation
echo "
"; ?> Location And Transcript Sequence"; echo "
"; ?> Network for $geneid";
echo "
";
?>
Functional Module
";
?>
";
$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 "
";
echo "
"; echo "
";
}
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 "
";
echo "";
echo "";
echo "
";
?>
";
}
?>
Functional Annotation
"; echo "Database | Orthologs | E value | Annotation |
---|---|---|---|
$result1[1] | $result1[2] | $result1[3] | $result1[4] |
"; ?> Location And Transcript Sequence"; echo "
Scaffold | Start | End | Strand |
---|---|---|---|
$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
Network category | Network | Top300 PCC genelist | "; echo "
---|---|---|
Coexpression Positive | Network | Top300 PCC genelist |
Coexpression Negative | Network | Top300 PCC genelist |
Module ID | Function 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 "Pfam accession | Pfam name | Alignment start | Alignment end | E-value |
---|---|---|---|---|
-- | -- | -- | -- | -- |
$result[3] | $result[4] | $result[1] | $result[2] | $result[5] |
$result[3] | $result[4] | $result[1] | $result[2] | $result[5] |
Protein Sequence |
"; echo "
Gene family
"; echo "Gene family | subfamily |
---|---|
-- | -- |
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 "
KEGG pathway
"; echo "KO | Enzyme | pathway | mapID |
---|---|---|---|
-- | -- | -- | -- |
"; echo "
Gene Ontology
"; $result=array(); $query=mysql_query("SELECT * FROM GO WHERE ID = '$geneid'"); echo "GO term | Ontology | Name |
---|---|---|
$result[1] | $result[2] | $result[3] |
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;$iSRP | Sample | Description | FPKM |
---|---|---|---|
SRP064423 | SRR2545914 | vegetative propagation corms | $result[2] |
SRR2545915 | Juvenile tuber | $result[1] | |
SRP108465 | SRR5643513 | five period of Gastrodia elata | $result[3] |
SRR5643514 | five period of Gastrodia elata | $result[4] | |
SRR5643515 | five period of Gastrodia elata | $result[5] | |
SRR5643524 | five period of Gastrodia elata | $result[6] | |
SRR5643525 | five period of Gastrodia elata | $result[7] | |
SRR5643528 | five period of Gastrodia elata | $result[8] | |
SRR5643658 | five period of Gastrodia elata | $result[9] | |
SRR5643659 | five period of Gastrodia elata | $result[10] | |
SRR5643660 | five period of Gastrodia elata | $result[11] | |
SRR5643661 | five period of Gastrodia elata | $result[12] | |
SRR5643662 | five period of Gastrodia elata | $result[13] | |
SRR5643663 | five period of Gastrodia elata | $result[14] | |
SRR5643664 | five period of Gastrodia elata | $result[15] | |
SRP118053 | SRR6049654 | Rhizomagastrodiae_C368-T07_good_1 | $result[16] |
SRR6049655 | Rhizomagastrodiae_C368-T10_good_1 | $result[17] | |
SRR6049656 | Rhizomagastrodiae_C368-T07_good_1 | $result[18] | |
SRR6049657 | Rhizomagastrodiae_C368-T07_good_1 | $result[19] | |
SRR6049658 | Rhizomagastrodiae_C368-T04_good_1 | $result[20] | |
SRR6049659 | Rhizomagastrodiae_C368-T04_good_1 | $result[21] | |
SRR6049660 | Rhizomagastrodiae_C368-T01_good_1 | $result[22] | |
SRR6049661 | Rhizomagastrodiae_C368-T04_good_1 | $result[23] | |
SRR6049662 | Rhizomagastrodiae_C368-T01_good_1 | $result[24] | |
SRR6049663 | Rhizomagastrodiae_C368-T01_good_1 | $result[25] | |
SRR6049664 | Rhizomagastrodiae_C368-T10_good_1 | $result[26] | |
SRR6049665 | Rhizomagastrodiae_C368-T10_good_1 | $result[27] | |
SRP279888 | Gastro | Gastrodia elata tuber | $Gastro |
Juven | Juvenile tuber | $Juven | |
Mother_Gastro | Mother tuber of Gastrodia elata | $MotherG | |
Mother_Juven | Mother tuber of Juvenile | $MotherJ |