MetaBase is a user-contributed database of biological databases, listing all the biological databases currently available on the internet. The initial release of MetaBase was derived entirely from the content of the Nucleic Acids Research (NAR) 2007 Database Issue. MetaBase is a wiki, using the MediaWiki software as well as the Semantic MediaWiki extension.
Analyzing or organizing large datasets is one of those things that has to potential to offer you with a massive headache. Fortunately, you can make your life a bit easier, at least in this respect, with the help of specialized tools for data visualization, such as Metabase.
MetaBase was developed as part of the BioWiki initiative and was entered into the first International Openfree Bioinformation Contents Competition organized by BiO.CC, the top-level biological information web site operated by Genome Research Foundation.
Currently, MetaBase contains details about nearly 1000 biological databases and over 800 ‘web services’ derived from NAR, as well as more than 50 ‘user-contributed’ databases
A trusted, freeware app for data visualization
Metabase is a legit, very much user-friendly and well-rounded piece of software that allows you to organize, analyze and filter collections of data without having to undergo complicated procedures like manually having to write queries or other database-related commands.
Before anything, you should know that this a very versatile tool as it not only works on all major operating systems out there, but it also comes with support for some of the most popular database management systems, namely MySQL, Postgres, MongoDB, SQL Server, AWS RedShift, Google BigQuery, Druid, H2 and SQLite.
Requires Java and any modern web-browser
To run Metabase you need to make sure that Java is available on your computer’s system. Once you launch the application, it should automatically connect a Metabase server which can be easily accessed via any modern web-browser by entering the following address: http://localhost:3000/.
Now start the log-in process, logging in and connecting Metabase to your database. If simply want to explore the app’s capabilities, feel free to use the available sample datasets.
Once the connection process is successful, it is only at this point that you will be greeted by the app’s web-based interface. Since we are on the subject, we should point out that this tool boasts one of the most attractive, modern and smooth-running interfaces found in this category.
Getting to the primary focus of the utility, you can rest assured that Metabase has what it takes for data analyzing and organizing data. This said, start off by ‘asking questions’ and continue by exploring the app’s numerous ways to visualize data, including maps and some beautiful pie, line and bar charts.
The Dashboard is the place where most of the work will take place. You and your team can create, organize and share results, datasets and even save visualizations for easier future access.
Intelligent data analytics
Metabase manages to tick all the right boxes by allowing users to simplify the whole process of organizing, sharing and analyzing large datasets.
Considering that it’s open source and the fact that it looks good and packs a set of very useful features, we can safely say that this one of the best alternatives for other similar tools for data visualization out there that require payment.
New added features in Metabase 0.32.5:
- Fix issues in Dashboards where Cards with long-running queries would load slowly or not at all (#9693)
- Major improvements to the way Metabase handles long-running queries to prevent reverse proxies like nginx from canceling them due to timeouts before they finish (#9817)
- Fix issue where H2 to MySQL/Postgres migration tool could fail with sizeX cannot be a null message (#9756)
- Fix issue where maps powered by custom GeoJSON files would not display on embedded Dashboards (#5338)
MetaBase Download V0.32.5 (File Size 229 MB for Windows all versions)
For MetaBase older version other than 0.32.5, click here
Other Useful info about MetaBase
Have a problem and need help? Start with our troubleshooting guide.
This is the go-to guide on asking questions and sharing answers using Metabase. You’ll learn in depth about how questions are expressed, how to chart answers, as well as how to share questions and create dashboards.
This guide is for advanced users and those who will be setting up and maintaining a Metabase installation. You’ll learn how to set the instance up, how to configure common settings, how to manage user accounts, and how to add databases. You’ll also learn how to troubleshoot common problems with both Metabase as well as underlying databases or data warehouses it uses.
This guide contains more detailed information about how to install Metabase for production use. It covers topics like SSL termination, deploying via Docker Containers vs. Jars, as well as the tradeoffs involved.
Enterprise Features Guide
Here’s where to go for help using the features included in the Enterprise Edition of Metabase.
This guide covers how to contribute back to the Metabase open source project. It includes setting up a development environment, running tests, and the contribution and product process Metabase follows.