SlideShare a Scribd company logo
1 of 33
Download to read offline
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Step by step tutorial:
ModestR tools to work with GBIF and ITIS
taxonomy databases
What do you need for this tutorial:
1. ModestR 6.5 or higher
2. Internet connection
3. About 20 minutes
ModestR software can be freely downloaded from http://www.ipez.es/ModestR
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
We’ll describe 3 tools provided by ModestR to work
with taxonomic data. (1) ModestR can use GBIF or (2)
ITIS taxonomic database to explore and export
taxonomic data.
(3) It can also use GBIF to check and complete
taxonomic data from a list of species.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
1. Explore GBIF taxonomy database
and export data.
Optionally, import those data to
DataManager
One feature provided by ModestR is a simple GBIF Backbone Taxonomy explorer.
This feature is included in the DataManager application. Therefore, to test it, we’ll start by running ModestR DataManager.
If you already have created a ModestR database, you can open it. Otherwise, just go to the File >> New Taxonomy database
menu option and create a new database called “MymodestRDatabase”. This is just because some DataManager menus are
enabled only if a ModestR database is opened.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Now we’ll explore the GBIF Backbone Taxonomy (from now on GBIFBT). A selection of this database that mainly includes
accepted taxa is distributed with ModestR (later we’ll explain how to download new updates of this database from GBIF
and import them to ModestR).
Go to menu Import >> Import Taxonomy >> From GBIF Backbone Taxonomy. Then wait for a moment while data are
loaded…. (this is a large database!).
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
A browser integrated in DataManager will appear, allowing you to explore GBIFBT. You can eventually export data to a CSV
file (easily read by worksheets such as Excel), or use the search tool to find specific taxons.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
In the left panel, two
tabs allow to go to
export feature, and to
search tool
In this panel, a
tree allows you to
easily explore
GBIFBT database.
To use the search tool, select the Search tool tab. You can write the first letters (at least 3 letters are required) of a taxon to
search for it in the database. Take into account that this can require some time.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Select the Search tool tab.
Then write the first letters (at
least 3 letters are required) of a
taxon to search and click on
“Update results”
Result will appear on this list.
Clicking on any of the results, it
will be highlighted in the left
tree (this can require some
time)
To limit a search and make it
faster, you can first uncheck
the kingdoms you want to
exclude from the search.
Once found the taxa you are interested in, you may export them to a CSV file. To do that, just check the wanted taxa in the
left tree. You can check any rank (classes, families….). Then select the levels to be exported on the right panel and click the
“Export to file” button. Or you can directly import them to the current database clicking on “Add to database“.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Select the Export options tab.
Check on the left tree the taxa
that contain the species to be
exported.
Select the levels to be exported.
By default, class, order, family,
genus and species are selected. If
you don’t include a level, the
information for this level for each
species will not be included in the
exported result.
You can eventually want to directly
import selected taxonomic data to the
current ModestR database. But this
option will only be enabled if
exclusively class, order, family, genus
and species are exported, because
they are the ranks supported by
ModestR.
The exported file, opened with a worksheet application, will look like this:
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
The selected levels
are included in the
exportation
If you optionally choose to directly
import taxa to the current database,
they will appear in the taxonomic tree
of Datamanager.
As explained before, ModestR includes a selection of the GBIFBT database that mainly includes accepted taxa. This
database is regularly updated, so you may eventually want to download the last version from GBIF and import it to
ModestR. To do that you can go to menu Import >> Import Taxonomy >> From GBIF Backbone Taxonomy, then click on the
button “Taxonomy website”. This will open a web browser and go to GBIF Backbone Taxonomy site.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
In this page, search for a link to the page where you can download GBIF Backbone Taxonomy site.
When this tutorial was done, this link was http://rs.gbif.org/datasets/backbone/
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Then locate and download the file “backbone-current-simple.txt.gz”. It is a large file so this may require some time.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
The next step is to uncompress the file “backbone-current-simple.txt.gz”. You will obtain a file named “backbone-
simple.txt” that can have a size of more than 2 Gb.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Now go back to DataManager, where we have left the GBIF taxonomy browser opened. Then click on the button “Import
new version” and, in the dialog that will appear, select the file “backbone-simple.txt” you have downloaded and
uncompressed previously.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
The importation process will start. This can take several minutes, as the GBIFBT contains several millions of species.
If all goes well, the new database will be imported and stored into ModestR and shown in the GBIFBT browser.
The date of the last imported file is shown at the bottom of the GBIFBT browser.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
2. Explore ITIS taxonomy database and
export data.
Optionally, import those data to
DataManager
One feature provided by ModestR is a simple ITIS database explorer. ITIS is and Integrated Taxonomic Information System,
online at http://www.itis.gov/ . But to use those data, you should first download them, following those steps:
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
2. In the left side menu, select
Get ITIS Data >> Full Database
Download >> Database Files
1. Go to http://www.itis.gov/
the web site of the Integrated
Taxonomic Information System
4. Uncompressed the downloaded
file, you’ll obtain a file named
“ITIS.sqlite”
5. Now you can explore and import
taxonomic data from the ITIS
database using ModestR
DataManager.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
3. Download the Full ITIS Data Set (SQLite) --
itisSqlite.zip to a folder of your computer
ModestR can help users to explore taxonomic data and to check or complete it. Those features are gathered in the
DataManager application. Therefore, to test them, we’ll start by running ModestR DataManager. If you already have
created a ModestR database, you can open it. Otherwise, just go to the File >> New Taxonomy database menu option and
create a new database called “MymodestRDatabase”. This is just because some DataManager menus are enabled only if a
ModestR database is opened.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Now we’ll explore the ITIS taxonomic database we have previously downloaded. Go to menu Import >> Import Taxonomy
>> From ITIS database >> ITIS database browser tool. A dialog box will be shown, where you should select the previously
uncompressed file “ITIS.sqlite”. Then wait for a moment while data are loaded…. (this is a large database!).
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
A browser integrated in DataManager will appear, allowing you to explore ITIS database. You can eventually export data to
a CSV file (easily read by worksheets such as Excel), or use the search tool to find specific taxons.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
In the left panel, two
tabs allow to go to
export feature, and to
search tool
In this panel, a
tree allows you to
easily explore ITIS
database.
To use the search tool, select the Search tool tab. You can write the first letters (at least 3 letters are required) of a taxon to
search for it in the database. Take into account that this can require some time (occasionally a long time…). You can make it
faster by firstly unchecking the kingdoms you want to exclude from the search.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Select the Search tool tab.
Then write the first letters (at
least 3 letters are required) of a
taxon to search
Result will appear on this list.
Clicking on any of the results, it
will be highlighted in the left
tree (this can require some
time)
To limit search and make it
faster, you can first uncheck
the kingdoms you want to
exclude from the search.
Once found the taxons you are interested in, you may want to export the corresponding data to a CSV file. To do that, just
check the wanted taxons in the left tree. You can check any rank (classes, families….). Then select the levels to be exported
on the right panel and click the Export button.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Select the Export options tab.
Check on the left tree the
taxons that contain the species
to be exported.
Select the levels to be exported.
By default, class, order, family,
genus and species are selected. If
you don’t include a level, the
information for this level for each
species will not be included in the
exported result.
You can eventually want to directly
reimport exported taxonomic data to
the current ModestR database. But
this option will only be enabled if
exclusively class, order, family, genus
and species are exported, because
they are the ranks supported by
ModestR.
The exported file, opened with a worksheet application, will look like this:
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
The selected levels
are included in the
exportation
3. Using GBIF to check and complete
taxonomic data from a list of species.
Now we’ll see another feature provided by ModestR to work with taxonomic data. That is a tool that can complete
taxonomic data from a list of species (only species are currently supported), and check them to detect synonyms or
probably inappropriate names. This feature uses GBIF online database. To use this tool, the first step is to create a CSV file
with the list of species to be checked. This can be done in a worksheet, then saved as CSV file, or even in a simple text
editor such as Notepad, and saved with the “CSV” extension.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Worksheet saved as CSV file
Now go to menu Import >> Import Taxonomy >> GBIF taxonomy search tool. A dialog box will be shown, where you should
select the previously created CSV file with the list of species.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
In the next dialog box, select if the file contains a header (in this case first line it will be skipped), and the field separator
(this only be used when using files with more than one column). Most of the times, default options will be OK and you just
have to click the Accept button.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
The a dialog box will allow you to select the target file where result will be saved. Once accepted, the checking process will
start. You need to be connected to Internet because this tool uses GBIF web services to retrieve taxonomic data.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
1. Class, order, family, genus, species, for each original species of the input file.
2. Accepted: indicates using a 1 (=yes) or a 0 (=no) if the original species is a species flagged as accepted by GBIF.
3. OriginalName: is the original species name of the input file (that can be different from the name returned by GBIF, in case of
synonyms or corrections)
4. Corrected: indicates if yes (=1) or a no (=0) GBIF returned a correction for the original species name.
5. Confidence: when a correction has been suggested, this indicates its % confidence according to GBIF
6. IsSynonym: indicates if yes (=1) or a no (=0) GBIF considered that the original species name was a synonym of the returned species
name.
7. Observations: other observations, if any. They can indicate that this species may not be considered as the most appropriate by GBIF.
If eventually a species was not found in GBIF, it is also indicated here.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
Once finished, the exported file will contain several columns with different information
The results returned by this tool are not intended to be absolutely authoritative, thus it is very recommended to carefully
review them. But this can be a useful tool to help checking species names and to easily obtain for the higher ranks.
The returned file, once reviewed, can be directly imported by DataManager to add those species to a ModestR database.
See the tutorial How to create a ModestR database for more information.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
It was the
Step by step tutorial:
ModestR tools to work with taxonomic data
Thank you for your interest.
MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/º
You can find this one and other tutorials in
http://www.ipez.es/ModestR
By the ModestR team
Colaborators:
Estefanía Isaza Toro

More Related Content

What's hot

1. How to create a database (Version ModestR v6.5 or higher)
1. How to create a database (Version ModestR v6.5 or higher)1. How to create a database (Version ModestR v6.5 or higher)
1. How to create a database (Version ModestR v6.5 or higher)modestrsoftware
 
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher)
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher) 5.- Doing a map in MRMapping (Version ModestR v5.3 or higher)
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher) modestrsoftware
 
19. Calculating 3D species distribution in marine habitats with ModestR (Ver...
19.  Calculating 3D species distribution in marine habitats with ModestR (Ver...19.  Calculating 3D species distribution in marine habitats with ModestR (Ver...
19. Calculating 3D species distribution in marine habitats with ModestR (Ver...modestrsoftware
 
21.- Creating virtual species and calculating simple ensemble models with R ...
21.-  Creating virtual species and calculating simple ensemble models with R ...21.-  Creating virtual species and calculating simple ensemble models with R ...
21.- Creating virtual species and calculating simple ensemble models with R ...modestrsoftware
 
20. Calculating most probable distribution of a species with Niche of Occurr...
20.  Calculating most probable distribution of a species with Niche of Occurr...20.  Calculating most probable distribution of a species with Niche of Occurr...
20. Calculating most probable distribution of a species with Niche of Occurr...modestrsoftware
 
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)modestrsoftware
 
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)modestrsoftware
 
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)modestrsoftware
 
11.- Calculating species distribution for different periods with ModestR (Ve...
11.-  Calculating species distribution for different periods with ModestR (Ve...11.-  Calculating species distribution for different periods with ModestR (Ve...
11.- Calculating species distribution for different periods with ModestR (Ve...modestrsoftware
 
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...4.- How to use data cleaning, EOO estimation and environmental of occurrence ...
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...modestrsoftware
 
16. Importing different climatic change scenarios from WorldClim to ModestR ...
16.  Importing different climatic change scenarios from WorldClim to ModestR ...16.  Importing different climatic change scenarios from WorldClim to ModestR ...
16. Importing different climatic change scenarios from WorldClim to ModestR ...modestrsoftware
 
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...modestrsoftware
 

What's hot (12)

1. How to create a database (Version ModestR v6.5 or higher)
1. How to create a database (Version ModestR v6.5 or higher)1. How to create a database (Version ModestR v6.5 or higher)
1. How to create a database (Version ModestR v6.5 or higher)
 
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher)
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher) 5.- Doing a map in MRMapping (Version ModestR v5.3 or higher)
5.- Doing a map in MRMapping (Version ModestR v5.3 or higher)
 
19. Calculating 3D species distribution in marine habitats with ModestR (Ver...
19.  Calculating 3D species distribution in marine habitats with ModestR (Ver...19.  Calculating 3D species distribution in marine habitats with ModestR (Ver...
19. Calculating 3D species distribution in marine habitats with ModestR (Ver...
 
21.- Creating virtual species and calculating simple ensemble models with R ...
21.-  Creating virtual species and calculating simple ensemble models with R ...21.-  Creating virtual species and calculating simple ensemble models with R ...
21.- Creating virtual species and calculating simple ensemble models with R ...
 
20. Calculating most probable distribution of a species with Niche of Occurr...
20.  Calculating most probable distribution of a species with Niche of Occurr...20.  Calculating most probable distribution of a species with Niche of Occurr...
20. Calculating most probable distribution of a species with Niche of Occurr...
 
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)
22.- Using Maxent in ModestR (Version ModestR 6.0 or higher)
 
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)
14.- Adding WorldClim data to ModestR (Version ModestR 5.3 or higher)
 
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)
25. Phylogenetics trees with ModestRr and bold (Version ModestR 6.5 or higher)
 
11.- Calculating species distribution for different periods with ModestR (Ve...
11.-  Calculating species distribution for different periods with ModestR (Ve...11.-  Calculating species distribution for different periods with ModestR (Ve...
11.- Calculating species distribution for different periods with ModestR (Ve...
 
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...4.- How to use data cleaning, EOO estimation and environmental of occurrence ...
4.- How to use data cleaning, EOO estimation and environmental of occurrence ...
 
16. Importing different climatic change scenarios from WorldClim to ModestR ...
16.  Importing different climatic change scenarios from WorldClim to ModestR ...16.  Importing different climatic change scenarios from WorldClim to ModestR ...
16. Importing different climatic change scenarios from WorldClim to ModestR ...
 
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...
12.- Recommendations for marine environments and Economic Exclusive Zones (Ve...
 

Similar to 7.- ModestR tools for taxonomy (Version ModestR v6.5 or higher)

Sas UTR How To Create Your UTRs Sep2009
Sas UTR How To Create Your UTRs Sep2009Sas UTR How To Create Your UTRs Sep2009
Sas UTR How To Create Your UTRs Sep2009praack
 
Tableau Basic Questions
Tableau Basic QuestionsTableau Basic Questions
Tableau Basic QuestionsSooraj Vinodan
 
Phpmyadmin administer mysql
Phpmyadmin administer mysqlPhpmyadmin administer mysql
Phpmyadmin administer mysqlMohd yasin Karim
 
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)Cheer Chain Enterprise Co., Ltd.
 
Overview of the DSD editor in the new CountrySTAT platform
Overview of the DSD editor in the new CountrySTAT platformOverview of the DSD editor in the new CountrySTAT platform
Overview of the DSD editor in the new CountrySTAT platformFAO
 
" Overview of the DSD and DATA editor in the new CountrySTAT platform "
" Overview of the DSD and DATA editor  in the new CountrySTAT platform  "" Overview of the DSD and DATA editor  in the new CountrySTAT platform  "
" Overview of the DSD and DATA editor in the new CountrySTAT platform "FAO
 
Access_lab_manual06.pdf
Access_lab_manual06.pdfAccess_lab_manual06.pdf
Access_lab_manual06.pdfAditya Kumar
 
MicrosoftAccessHandout.doc
MicrosoftAccessHandout.docMicrosoftAccessHandout.doc
MicrosoftAccessHandout.docCom2K22Class
 
TYPO3 6.2. What's new
TYPO3 6.2. What's newTYPO3 6.2. What's new
TYPO3 6.2. What's newRafal Brzeski
 
Database as information system
Database as information systemDatabase as information system
Database as information systemKAZEMBETVOnline
 
AdRotator and AdRepeater Control in Asp.Net for Msc CS
AdRotator and AdRepeater Control in Asp.Net for Msc CSAdRotator and AdRepeater Control in Asp.Net for Msc CS
AdRotator and AdRepeater Control in Asp.Net for Msc CSThanveen
 
Chapter 06-software-using thetaxonomytool
Chapter 06-software-using thetaxonomytoolChapter 06-software-using thetaxonomytool
Chapter 06-software-using thetaxonomytooljps619
 
Manual InnerSoft STATS
Manual InnerSoft STATSManual InnerSoft STATS
Manual InnerSoft STATSInnerSoft
 

Similar to 7.- ModestR tools for taxonomy (Version ModestR v6.5 or higher) (20)

Sas UTR How To Create Your UTRs Sep2009
Sas UTR How To Create Your UTRs Sep2009Sas UTR How To Create Your UTRs Sep2009
Sas UTR How To Create Your UTRs Sep2009
 
Tableau Basic Questions
Tableau Basic QuestionsTableau Basic Questions
Tableau Basic Questions
 
Remedy Presentation
Remedy PresentationRemedy Presentation
Remedy Presentation
 
Phpmyadmin administer mysql
Phpmyadmin administer mysqlPhpmyadmin administer mysql
Phpmyadmin administer mysql
 
Understanding Microsoft Access
Understanding Microsoft AccessUnderstanding Microsoft Access
Understanding Microsoft Access
 
Ms Access
Ms AccessMs Access
Ms Access
 
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)
Maxqda 2020 質性分析及混合研究理論應用軟體完整使用手冊(英文版)
 
Create Components in TomatoCMS
Create Components in TomatoCMSCreate Components in TomatoCMS
Create Components in TomatoCMS
 
Overview of the DSD editor in the new CountrySTAT platform
Overview of the DSD editor in the new CountrySTAT platformOverview of the DSD editor in the new CountrySTAT platform
Overview of the DSD editor in the new CountrySTAT platform
 
" Overview of the DSD and DATA editor in the new CountrySTAT platform "
" Overview of the DSD and DATA editor  in the new CountrySTAT platform  "" Overview of the DSD and DATA editor  in the new CountrySTAT platform  "
" Overview of the DSD and DATA editor in the new CountrySTAT platform "
 
Access_lab_manual06.pdf
Access_lab_manual06.pdfAccess_lab_manual06.pdf
Access_lab_manual06.pdf
 
MicrosoftAccessHandout.doc
MicrosoftAccessHandout.docMicrosoftAccessHandout.doc
MicrosoftAccessHandout.doc
 
TYPO3 6.2. What's new
TYPO3 6.2. What's newTYPO3 6.2. What's new
TYPO3 6.2. What's new
 
Database as information system
Database as information systemDatabase as information system
Database as information system
 
AdRotator and AdRepeater Control in Asp.Net for Msc CS
AdRotator and AdRepeater Control in Asp.Net for Msc CSAdRotator and AdRepeater Control in Asp.Net for Msc CS
AdRotator and AdRepeater Control in Asp.Net for Msc CS
 
001.general
001.general001.general
001.general
 
SAP data archiving
SAP data archivingSAP data archiving
SAP data archiving
 
Naval PPT.pptx
Naval PPT.pptxNaval PPT.pptx
Naval PPT.pptx
 
Chapter 06-software-using thetaxonomytool
Chapter 06-software-using thetaxonomytoolChapter 06-software-using thetaxonomytool
Chapter 06-software-using thetaxonomytool
 
Manual InnerSoft STATS
Manual InnerSoft STATSManual InnerSoft STATS
Manual InnerSoft STATS
 

Recently uploaded

Save the Environment - Environ Craft
Save the Environment -     Environ CraftSave the Environment -     Environ Craft
Save the Environment - Environ Craftenvironcraft
 
4th Earthquake Drill Narraative Report.docx
4th Earthquake Drill Narraative Report.docx4th Earthquake Drill Narraative Report.docx
4th Earthquake Drill Narraative Report.docxJeneroseBaldoza
 
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...Amil baba
 
Exploring the snake evolution (wild's gravity).pdf
Exploring the snake evolution (wild's gravity).pdfExploring the snake evolution (wild's gravity).pdf
Exploring the snake evolution (wild's gravity).pdfdrsk203
 
Ecosystem and their types ||Environmental Science||.pdf
Ecosystem and their types ||Environmental Science||.pdfEcosystem and their types ||Environmental Science||.pdf
Ecosystem and their types ||Environmental Science||.pdfMUKUL GAUR
 
How do TOPCon Solar Cells/Solar Panel Work?
How do TOPCon Solar Cells/Solar Panel Work?How do TOPCon Solar Cells/Solar Panel Work?
How do TOPCon Solar Cells/Solar Panel Work?Bluebird Solar Pvt. Ltd.
 
Third OECD-DOE Workshop Photo slide show.pdf
Third OECD-DOE Workshop Photo slide show.pdfThird OECD-DOE Workshop Photo slide show.pdf
Third OECD-DOE Workshop Photo slide show.pdfOECD Environment
 
Incentive Scheme for Smallholders
Incentive Scheme for Smallholders Incentive Scheme for Smallholders
Incentive Scheme for Smallholders CIFOR-ICRAF
 
PBL Endangered and Vulnerable Species- Presentation.pptx
PBL Endangered and Vulnerable Species- Presentation.pptxPBL Endangered and Vulnerable Species- Presentation.pptx
PBL Endangered and Vulnerable Species- Presentation.pptxjabernethy
 
Capacity Building in oil palm trade and sustainability
Capacity Building in oil palm trade and sustainabilityCapacity Building in oil palm trade and sustainability
Capacity Building in oil palm trade and sustainabilityCIFOR-ICRAF
 
"Solid waste Fill Site Analysis: Proximities & Parameters"
"Solid waste Fill Site Analysis: Proximities & Parameters""Solid waste Fill Site Analysis: Proximities & Parameters"
"Solid waste Fill Site Analysis: Proximities & Parameters"KeerthireddyNussi
 
Item 7. Discussion on PWB 2023-24 work related to adaptation
Item 7. Discussion on PWB 2023-24 work related to adaptationItem 7. Discussion on PWB 2023-24 work related to adaptation
Item 7. Discussion on PWB 2023-24 work related to adaptationOECD Environment
 
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26Item 3. Developing EPOC’s PWB related to mitigation for 2025-26
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26OECD Environment
 
Pathways to sustainable trade and system dynamic simulation
Pathways to sustainable trade and system dynamic simulationPathways to sustainable trade and system dynamic simulation
Pathways to sustainable trade and system dynamic simulationCIFOR-ICRAF
 
Monitoring songbirds' online market
Monitoring songbirds' online market Monitoring songbirds' online market
Monitoring songbirds' online market CIFOR-ICRAF
 
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docx
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docxNarrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docx
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docxJeneroseBaldoza
 
Supporting Farmer Transition to Produce Deforestation-Free Coffee
Supporting Farmer Transition to Produce Deforestation-Free CoffeeSupporting Farmer Transition to Produce Deforestation-Free Coffee
Supporting Farmer Transition to Produce Deforestation-Free CoffeeCIFOR-ICRAF
 
Item 8. Developing EPOC's PWB related to adaptation
Item 8. Developing EPOC's PWB related to adaptationItem 8. Developing EPOC's PWB related to adaptation
Item 8. Developing EPOC's PWB related to adaptationOECD Environment
 
PPT TLE 7 and 8 Q3 AGRI CROP QUIZ 2.pptx
PPT TLE 7 and 8  Q3 AGRI CROP QUIZ 2.pptxPPT TLE 7 and 8  Q3 AGRI CROP QUIZ 2.pptx
PPT TLE 7 and 8 Q3 AGRI CROP QUIZ 2.pptxCrislynBaados
 
EC-funded Projects and CAPs Webinar slides
EC-funded Projects and CAPs Webinar slidesEC-funded Projects and CAPs Webinar slides
EC-funded Projects and CAPs Webinar slidesweADAPT
 

Recently uploaded (20)

Save the Environment - Environ Craft
Save the Environment -     Environ CraftSave the Environment -     Environ Craft
Save the Environment - Environ Craft
 
4th Earthquake Drill Narraative Report.docx
4th Earthquake Drill Narraative Report.docx4th Earthquake Drill Narraative Report.docx
4th Earthquake Drill Narraative Report.docx
 
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...
Best-NO1 Best Black Magic Specialist Near Me Spiritual Healer Powerful Love S...
 
Exploring the snake evolution (wild's gravity).pdf
Exploring the snake evolution (wild's gravity).pdfExploring the snake evolution (wild's gravity).pdf
Exploring the snake evolution (wild's gravity).pdf
 
Ecosystem and their types ||Environmental Science||.pdf
Ecosystem and their types ||Environmental Science||.pdfEcosystem and their types ||Environmental Science||.pdf
Ecosystem and their types ||Environmental Science||.pdf
 
How do TOPCon Solar Cells/Solar Panel Work?
How do TOPCon Solar Cells/Solar Panel Work?How do TOPCon Solar Cells/Solar Panel Work?
How do TOPCon Solar Cells/Solar Panel Work?
 
Third OECD-DOE Workshop Photo slide show.pdf
Third OECD-DOE Workshop Photo slide show.pdfThird OECD-DOE Workshop Photo slide show.pdf
Third OECD-DOE Workshop Photo slide show.pdf
 
Incentive Scheme for Smallholders
Incentive Scheme for Smallholders Incentive Scheme for Smallholders
Incentive Scheme for Smallholders
 
PBL Endangered and Vulnerable Species- Presentation.pptx
PBL Endangered and Vulnerable Species- Presentation.pptxPBL Endangered and Vulnerable Species- Presentation.pptx
PBL Endangered and Vulnerable Species- Presentation.pptx
 
Capacity Building in oil palm trade and sustainability
Capacity Building in oil palm trade and sustainabilityCapacity Building in oil palm trade and sustainability
Capacity Building in oil palm trade and sustainability
 
"Solid waste Fill Site Analysis: Proximities & Parameters"
"Solid waste Fill Site Analysis: Proximities & Parameters""Solid waste Fill Site Analysis: Proximities & Parameters"
"Solid waste Fill Site Analysis: Proximities & Parameters"
 
Item 7. Discussion on PWB 2023-24 work related to adaptation
Item 7. Discussion on PWB 2023-24 work related to adaptationItem 7. Discussion on PWB 2023-24 work related to adaptation
Item 7. Discussion on PWB 2023-24 work related to adaptation
 
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26Item 3. Developing EPOC’s PWB related to mitigation for 2025-26
Item 3. Developing EPOC’s PWB related to mitigation for 2025-26
 
Pathways to sustainable trade and system dynamic simulation
Pathways to sustainable trade and system dynamic simulationPathways to sustainable trade and system dynamic simulation
Pathways to sustainable trade and system dynamic simulation
 
Monitoring songbirds' online market
Monitoring songbirds' online market Monitoring songbirds' online market
Monitoring songbirds' online market
 
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docx
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docxNarrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docx
Narrative Report on 3rd NNational Simultaneous Earthquake Drill2023.docx
 
Supporting Farmer Transition to Produce Deforestation-Free Coffee
Supporting Farmer Transition to Produce Deforestation-Free CoffeeSupporting Farmer Transition to Produce Deforestation-Free Coffee
Supporting Farmer Transition to Produce Deforestation-Free Coffee
 
Item 8. Developing EPOC's PWB related to adaptation
Item 8. Developing EPOC's PWB related to adaptationItem 8. Developing EPOC's PWB related to adaptation
Item 8. Developing EPOC's PWB related to adaptation
 
PPT TLE 7 and 8 Q3 AGRI CROP QUIZ 2.pptx
PPT TLE 7 and 8  Q3 AGRI CROP QUIZ 2.pptxPPT TLE 7 and 8  Q3 AGRI CROP QUIZ 2.pptx
PPT TLE 7 and 8 Q3 AGRI CROP QUIZ 2.pptx
 
EC-funded Projects and CAPs Webinar slides
EC-funded Projects and CAPs Webinar slidesEC-funded Projects and CAPs Webinar slides
EC-funded Projects and CAPs Webinar slides
 

7.- ModestR tools for taxonomy (Version ModestR v6.5 or higher)

  • 1. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Step by step tutorial: ModestR tools to work with GBIF and ITIS taxonomy databases
  • 2. What do you need for this tutorial: 1. ModestR 6.5 or higher 2. Internet connection 3. About 20 minutes ModestR software can be freely downloaded from http://www.ipez.es/ModestR MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 3. We’ll describe 3 tools provided by ModestR to work with taxonomic data. (1) ModestR can use GBIF or (2) ITIS taxonomic database to explore and export taxonomic data. (3) It can also use GBIF to check and complete taxonomic data from a list of species. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 4. 1. Explore GBIF taxonomy database and export data. Optionally, import those data to DataManager
  • 5. One feature provided by ModestR is a simple GBIF Backbone Taxonomy explorer. This feature is included in the DataManager application. Therefore, to test it, we’ll start by running ModestR DataManager. If you already have created a ModestR database, you can open it. Otherwise, just go to the File >> New Taxonomy database menu option and create a new database called “MymodestRDatabase”. This is just because some DataManager menus are enabled only if a ModestR database is opened. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 6. Now we’ll explore the GBIF Backbone Taxonomy (from now on GBIFBT). A selection of this database that mainly includes accepted taxa is distributed with ModestR (later we’ll explain how to download new updates of this database from GBIF and import them to ModestR). Go to menu Import >> Import Taxonomy >> From GBIF Backbone Taxonomy. Then wait for a moment while data are loaded…. (this is a large database!). MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 7. A browser integrated in DataManager will appear, allowing you to explore GBIFBT. You can eventually export data to a CSV file (easily read by worksheets such as Excel), or use the search tool to find specific taxons. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ In the left panel, two tabs allow to go to export feature, and to search tool In this panel, a tree allows you to easily explore GBIFBT database.
  • 8. To use the search tool, select the Search tool tab. You can write the first letters (at least 3 letters are required) of a taxon to search for it in the database. Take into account that this can require some time. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Select the Search tool tab. Then write the first letters (at least 3 letters are required) of a taxon to search and click on “Update results” Result will appear on this list. Clicking on any of the results, it will be highlighted in the left tree (this can require some time) To limit a search and make it faster, you can first uncheck the kingdoms you want to exclude from the search.
  • 9. Once found the taxa you are interested in, you may export them to a CSV file. To do that, just check the wanted taxa in the left tree. You can check any rank (classes, families….). Then select the levels to be exported on the right panel and click the “Export to file” button. Or you can directly import them to the current database clicking on “Add to database“. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Select the Export options tab. Check on the left tree the taxa that contain the species to be exported. Select the levels to be exported. By default, class, order, family, genus and species are selected. If you don’t include a level, the information for this level for each species will not be included in the exported result. You can eventually want to directly import selected taxonomic data to the current ModestR database. But this option will only be enabled if exclusively class, order, family, genus and species are exported, because they are the ranks supported by ModestR.
  • 10. The exported file, opened with a worksheet application, will look like this: MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ The selected levels are included in the exportation If you optionally choose to directly import taxa to the current database, they will appear in the taxonomic tree of Datamanager.
  • 11. As explained before, ModestR includes a selection of the GBIFBT database that mainly includes accepted taxa. This database is regularly updated, so you may eventually want to download the last version from GBIF and import it to ModestR. To do that you can go to menu Import >> Import Taxonomy >> From GBIF Backbone Taxonomy, then click on the button “Taxonomy website”. This will open a web browser and go to GBIF Backbone Taxonomy site. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 12. In this page, search for a link to the page where you can download GBIF Backbone Taxonomy site. When this tutorial was done, this link was http://rs.gbif.org/datasets/backbone/ MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 13. Then locate and download the file “backbone-current-simple.txt.gz”. It is a large file so this may require some time. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 14. The next step is to uncompress the file “backbone-current-simple.txt.gz”. You will obtain a file named “backbone- simple.txt” that can have a size of more than 2 Gb. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 15. Now go back to DataManager, where we have left the GBIF taxonomy browser opened. Then click on the button “Import new version” and, in the dialog that will appear, select the file “backbone-simple.txt” you have downloaded and uncompressed previously. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 16. The importation process will start. This can take several minutes, as the GBIFBT contains several millions of species. If all goes well, the new database will be imported and stored into ModestR and shown in the GBIFBT browser. The date of the last imported file is shown at the bottom of the GBIFBT browser. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 17. 2. Explore ITIS taxonomy database and export data. Optionally, import those data to DataManager
  • 18. One feature provided by ModestR is a simple ITIS database explorer. ITIS is and Integrated Taxonomic Information System, online at http://www.itis.gov/ . But to use those data, you should first download them, following those steps: MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ 2. In the left side menu, select Get ITIS Data >> Full Database Download >> Database Files 1. Go to http://www.itis.gov/ the web site of the Integrated Taxonomic Information System
  • 19. 4. Uncompressed the downloaded file, you’ll obtain a file named “ITIS.sqlite” 5. Now you can explore and import taxonomic data from the ITIS database using ModestR DataManager. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ 3. Download the Full ITIS Data Set (SQLite) -- itisSqlite.zip to a folder of your computer
  • 20. ModestR can help users to explore taxonomic data and to check or complete it. Those features are gathered in the DataManager application. Therefore, to test them, we’ll start by running ModestR DataManager. If you already have created a ModestR database, you can open it. Otherwise, just go to the File >> New Taxonomy database menu option and create a new database called “MymodestRDatabase”. This is just because some DataManager menus are enabled only if a ModestR database is opened. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 21. Now we’ll explore the ITIS taxonomic database we have previously downloaded. Go to menu Import >> Import Taxonomy >> From ITIS database >> ITIS database browser tool. A dialog box will be shown, where you should select the previously uncompressed file “ITIS.sqlite”. Then wait for a moment while data are loaded…. (this is a large database!). MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 22. A browser integrated in DataManager will appear, allowing you to explore ITIS database. You can eventually export data to a CSV file (easily read by worksheets such as Excel), or use the search tool to find specific taxons. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ In the left panel, two tabs allow to go to export feature, and to search tool In this panel, a tree allows you to easily explore ITIS database.
  • 23. To use the search tool, select the Search tool tab. You can write the first letters (at least 3 letters are required) of a taxon to search for it in the database. Take into account that this can require some time (occasionally a long time…). You can make it faster by firstly unchecking the kingdoms you want to exclude from the search. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Select the Search tool tab. Then write the first letters (at least 3 letters are required) of a taxon to search Result will appear on this list. Clicking on any of the results, it will be highlighted in the left tree (this can require some time) To limit search and make it faster, you can first uncheck the kingdoms you want to exclude from the search.
  • 24. Once found the taxons you are interested in, you may want to export the corresponding data to a CSV file. To do that, just check the wanted taxons in the left tree. You can check any rank (classes, families….). Then select the levels to be exported on the right panel and click the Export button. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Select the Export options tab. Check on the left tree the taxons that contain the species to be exported. Select the levels to be exported. By default, class, order, family, genus and species are selected. If you don’t include a level, the information for this level for each species will not be included in the exported result. You can eventually want to directly reimport exported taxonomic data to the current ModestR database. But this option will only be enabled if exclusively class, order, family, genus and species are exported, because they are the ranks supported by ModestR.
  • 25. The exported file, opened with a worksheet application, will look like this: MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ The selected levels are included in the exportation
  • 26. 3. Using GBIF to check and complete taxonomic data from a list of species.
  • 27. Now we’ll see another feature provided by ModestR to work with taxonomic data. That is a tool that can complete taxonomic data from a list of species (only species are currently supported), and check them to detect synonyms or probably inappropriate names. This feature uses GBIF online database. To use this tool, the first step is to create a CSV file with the list of species to be checked. This can be done in a worksheet, then saved as CSV file, or even in a simple text editor such as Notepad, and saved with the “CSV” extension. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Worksheet saved as CSV file
  • 28. Now go to menu Import >> Import Taxonomy >> GBIF taxonomy search tool. A dialog box will be shown, where you should select the previously created CSV file with the list of species. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 29. In the next dialog box, select if the file contains a header (in this case first line it will be skipped), and the field separator (this only be used when using files with more than one column). Most of the times, default options will be OK and you just have to click the Accept button. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 30. The a dialog box will allow you to select the target file where result will be saved. Once accepted, the checking process will start. You need to be connected to Internet because this tool uses GBIF web services to retrieve taxonomic data. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 31. 1. Class, order, family, genus, species, for each original species of the input file. 2. Accepted: indicates using a 1 (=yes) or a 0 (=no) if the original species is a species flagged as accepted by GBIF. 3. OriginalName: is the original species name of the input file (that can be different from the name returned by GBIF, in case of synonyms or corrections) 4. Corrected: indicates if yes (=1) or a no (=0) GBIF returned a correction for the original species name. 5. Confidence: when a correction has been suggested, this indicates its % confidence according to GBIF 6. IsSynonym: indicates if yes (=1) or a no (=0) GBIF considered that the original species name was a synonym of the returned species name. 7. Observations: other observations, if any. They can indicate that this species may not be considered as the most appropriate by GBIF. If eventually a species was not found in GBIF, it is also indicated here. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/ Once finished, the exported file will contain several columns with different information
  • 32. The results returned by this tool are not intended to be absolutely authoritative, thus it is very recommended to carefully review them. But this can be a useful tool to help checking species names and to easily obtain for the higher ranks. The returned file, once reviewed, can be directly imported by DataManager to add those species to a ModestR database. See the tutorial How to create a ModestR database for more information. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/
  • 33. It was the Step by step tutorial: ModestR tools to work with taxonomic data Thank you for your interest. MODESTR QUICK TUTORIALS HTTP://WWW.IPEZ.ES/MODESTR/º You can find this one and other tutorials in http://www.ipez.es/ModestR By the ModestR team Colaborators: Estefanía Isaza Toro