I'm a bioinformatician with some Perl programming skills. However other members in my lab didn't know much about bioinformatics. Sometimes they need to search for some specific gene IDs and obtain their sequences, structures (GFF) and GO annations. As the organisms are non-model species, public servers such as Ensembl or Phytozome are not sufficient. I want to do a web interface with simple data search function and using SQL database as backends. I tried building local InterMine server but it was too complex. Any other good open source tools?
All the data had been stored on local server, in FASTA, GFF, or tab delimited files. They could be dumped into databases. We want to implement data search frontends like the "key word search" and "gene page" of Phytozome or Metazome.
See if genoverse fits your needs. It doesn't need any database back-end and can work with many file formats. Otherwise, you could turn tab-delimited files into SQLite tables and write simple cgi scripts to access the data.