Dynamic database

The data structure in BioloMICS is fully flexible. Users can create their own views on a given table or set of tables.
Links between tables are directly visible from the main interface of the software and several tables can be accessed and modified from the same view.
Data can be displayed as and edited in spreadsheets, hierarchical trees and form views.
The history of changes tool keeps track of all the changes ever made in the database and allows to reverse any changes or redo them in one click.

Structure

BioloMICS is a relational database which means that its structure is based on different tables linked to each other. The number and the type of tables are fully flexible and you are able to add a new one at any moment.

Each table contains fields. Thirty-nine different field types are integrated to manage the data in specified ways, for example some fields are used to store DNA or protein sequences while other fields are used for dates or geographic data.

A record contains data in the fields of a given table. Unlimited number of records can be added to a table and data can be added in no time.

Tracking

Any change made in the database on table, field or record level is recorded and can be viewed at any time by the administrator of the database. Previously made changes can be reversed in one click.

A search panel is available to find changes based on any condition such as user who made the change, date of modification or field that contains the new value. Also the undo is recorded which allows you to redo the change later if needed.

Views

Views are used to display data in a given way. Because not everyone wants or is supposed to see everything, one can decide which field to show. Table views can be shared between peoplend there are two types of views: tree view and form view.
Fields can be grouped to get a better structure and to see data in an easier way. An unlimited number of table views can be created for each table of any given database.

Searching

Searching databases in an easy way without the need to build complex SQL queries is possible using the basic and advanced queries options as well as the Google-like search.
Search a specific value or simply everything that has a link to a specific record. Use the search function to get the results you are looking for.

Search for one or more questions at the time. Wildcards can also be used to make the request more general. Search queries can be saved and reused later.
Even extremely complex queries involving several linked tables that would require deep knowledge of SQL commands are easy.

Import

Large amounts of data can be imported into BioloMICS using the importation tool. Various ways are possible, for example the software allows importing sequences using Fasta format, while other types
of data can be imported as tab-delimited or from a csv file.

Export

BioloMICS has the possibility to export your data from the database to different formats. Sequences can be exported to Fasta and saved locally.
Other export formats are integrated too, such as PDF, Word, HTML, Excel, CSV, XML, Images and more. As well as exporting data to StrainInfo format.
Create your own export templates for invoicing, catalogs, labels and more.

Report

Reporting templates can be created and exports can be saved in many formats (such as Word, PDF and Excel). This allows you to export different data in a previously created template.

The reporting tool can also be used for printing labels to be used on tubes or plates in the laboratory. Any shape of label can be used and any information, for example barcode strips, can be placed on it.

More Shortcuts

Documents & Regulations

Cookies are small text files that contain a string of characters and uniquely identifies a browser. They are sent to a computer by website operators or third parties. Most browsers are initially set up to accept cookies, since this is required by most website owners in order to access their sites. You may be, however, able to change your browser settings to cause your browser to refuse cookies in general, block third party cookies or to indicate when a cookie is being sent.
If you would like to know more about cookies and how they work, please visit www.allaboutcookies.org.
We use cookies in a very limited number of scenarios that are all present to help the users to have an easier experience. List of cookies present on a website managed by BioloMICS:
1. Table-columns-strains_2: contains the list of columns that must be displayed (when changed by the end-user) when searching Strains_2 table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
2. Queries-layout-strains_2: contains the list of queries that have been done by the end-user when searching Strains_2 table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
3. Table-columns- strains_3: contains the list of columns that must be displayed (when changed by the end-user) when searching strains_3 table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
4. Queries-layout- strains_3: contains the list of queries that have been done by the end-user when searching strains_3 table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
5. Table-columns-Open%20collection: contains the list of columns that must be displayed (when changed by the end-user) when searching 20collection table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
6. Queries-layout- 20collection: contains the list of queries that have been done by the end-user when searching 20collection table views (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
7. List-display: keeps the end-user preference in terms of display format (either results in grid or results looking like a Google format) (this is there to keep the preferences of the end-users; It will not be present if the end-user has not changed this option).
8. SearchState: this keeps the information about the last query and the page number where the end-user was the last time he/she did a query.
9. ASP.NET_SessionId: this is an automatic cookie that keeps the unique session ID number to be used on the server side. This is deleted when session is finished/expired.
10. last-query-layout-Open%20collection and similar, contain the last query done by the end-user on the Open%20collection table view. This is used when first reloading the page. It is replaced each time there is a query done.
11. _utma, _utmb, _utmc, _utmd, etc are Google analytics cookies to analyze web traffic (see https://helpful.knobs-dials.com/index.php/Utma,_utmb,_utmz_cookies).
Cookies mentioned in the last point are Google analytics cookies that are IP anonymized which means that we cannot trace single users. See below for more information.
No other cookies than the ones mentioned above are used on our websites.
Google cookies and technologies
Google Analytics: These cookies allow us to see information on user website activities including, but not limited to page views, source and time spent on a website. The information is depersonalized and is displayed as numbers, meaning it cannot be traced back to individuals. This will help to protect your privacy. Using Google Analytics, we can see what content is popular on our websites.
You can prevent the information generated by the Google cookie about your use of our Sites from being collected and processed by Google in the future by downloading and installing Google Analytics Opt-out Browser Add-on for your current web browser. This Add-on is available at http://tools.google.com/dlpage/gaoptout.