For animated textures, we use an MP4 video file. It allows getting a significantly higher frame rate with a relatively small size of the file. You can also use the .png sequence for some effects.
You specify a duration of animation during the exporting geometry to FBX format. You can export several takes of animation in one file for example by game exporter in Maya or 3Ds Max.