How to Access Data

TERRA-REF data can be accessed through many different interfaces: Globus, Clowder, BETYdb, CyVerse, and CoGe. Raw data is transfered to the primary compute pipeline using Globus Online. Data is ingested into Clowder to support exploratory analysis. The Clowder extractor system is used to transform the data and create derived data products, which are either available via Clowder or published to specialized services, such as BETYdb.
Resource
Use
Web User Interface
API*
clients
Sensor Data
Globus
Browse directories; transfer large sensor files
globus.org #TERRAREF endpoint
R, Python
Clowder
Browse and Download small Sensor Data
terraref.org/clowder
Python
Trait Data
BETYdb
Trait and Agronomic Metadata
terraref.org/bety
R traits package, Python: terrautils; SQL: Postgres in Docker
traitvis
View available trait data
terraref.org/traitvis
NA
NA
Genomics Data
CyVerse
Download Genomics data
terraref.org/cyverse-genomics
yes
CoGe
Download, process, visualize Genomics data
terraref.org/coge
Other
Tutorials
R and Python scripts for accessing data
terraref.org/tutorials
NA
Advanced Search
Search across sensor and trait data
search.terraref.org (under development)
yes

We have developed tutorials to provide users with both 'quick start' vignettes and more detailed introductions to TERRA REF datasets. Tutorials for accessing trait data, sensor data, and genomics data are organized by directory ("traits", "sensors", and "genomics").
The tutorials assume familiarity with or willingness to learn Python and / or R, and provide the greatest flexibility and access to available data.
These can be found at terraref.org/tutorials.

Raw data is transferred to the primary TERRA-REF file system at the National Center for Computing Applications at the University of Illinois.
Public domain data is available for Globus transfer via the ncsa#terra-public. Non-public (but available with permission) data are at the #Terraref endpoint
Use Globus Online when you want to transfer data from the TERRA-REF system for local analysis.
See also Globus Getting Started

The Globus Connect service provides high-performance, secure, file transfer and synchronization between endpoints. It also allows you to securely share your data with other Globus users.
To access data via Globus, you must first have a Globus account and endpoint.
  1. 1.
    Sign up for Globus at globus.org
  2. 2.
    Download and install Globus Connect Personal or Server.
  3. 3.
    Log into Globus https://www.globus.org
  4. 4.
    Add an endpoint for the destination (e.g. your local computer) https://www.globus.org/app/endpoints/create-gcp
  5. 5.
    Go to the 'transfer files' page: https://www.globus.org/app/transfer
  6. 6.
    Select source
    • Endpoint: #Terraref
    • Path: Navigate to the subdirectory that you want.
    • Select (click) a folder
    • Select (highlight) files that you want to download at destination
    • Select the endpoint that you set up above of your local computer or server
    • Select the destination folder (e.g. /~/Downloads/)
  7. 7.
    Click 'go'
  8. 8.
    Files will be transfered to your computer
Requesting Access to unpublished data in TERRA-REF BETYdb:
To request access to unpublished data, send your Globus id to David LeBauer ([email protected]) with 'TERRAREF Globus Access Request' in the subject.
  1. 1.
    fill out the terraref.org/beta user form
  2. 2.
    email [email protected] with your globusid to request access.

BETYdb is used to manage and distribute agricultural and ecological data. It contains phenotype and agronomic data including plot locations and other geolocations of interest (e.g. fields, rows, plants).
BETYdb contains the derived trait data with plot locations and other information associated with agronomic experimental design.

The easiest way to access data is to use the R traits package. This is documented in the tutorials.
Requesting Access to unpublished data in TERRA-REF BETYdb:
  1. 1.
    fill out the terraref.org/beta user form
  2. 2.
    create an account at the TERRA-REF BETYdb: terraref.org/bety (not betydb.org)
  3. 3.
    email [email protected] for your account to be approved.

The fastest and most comprehensive way to access the database using SQL and other database interfaces (such as the R package dplyr interface described below, or GIS programs described in . You can run an instance of the database using docker, as described below
This is how you can access the TERRA REF trait database. It requires that you install the Docker software on your computer.
The easiest way to get the entire database, including metadata. Assuming you are familiar with the Postgres and / or the R dbplyr library documentation. See the TERRA REF Tutorials terraref.org/tutorials, the BETYdb Data Access guide for additional examples.
#git clone https://github.com/terraref/data-paper
cd data-paper/code/betydb_docker
docker-compose up -d postgres
docker-compose run --rm bety initialize
docker-compose run --rm bety sync

psql -d bety -U bety -W bety

library(dplyr)
bety_src <- src_postgres(dbname = "bety",
password = 'bety',
host = 'localhost',
user = 'bety',
port = 5433)

Interested researchers can access BETYdb directly from GIS software such as ESRI ArcMap and QGIS. In some cases direct access can simplify the use of spatial data in BETYdb. See the Appendix Accessing BETYdb with GIS Software for more information.

Clowder is an active data repository designed to enable collaboration around a set of shared datasets. TERRAREF uses Clowder to organize, annotate, and process data generated by phenotyping platforms. Datafiles are available via the Clowder web interface or API.
Clowder is the used to organize, annotate, and process raw data generated by the field scanner and other phenotyping platforms. It also stores information about sensors. Learn more about Clowder software from https://clowderframework.org

Data is organized into spaces, collections, and datasets, collections.
  • Spaces contain collections and datasets. TERRA-REF uses one space for each of the phenotyping platforms.
  • Collections consist of one or more datasets. TERRA-REF collections are organized by acquisition date and sensor. Users can also create their own collections.
  • Datasets consist of one or more files with associated metadata collected by one sensor at one time point. Users can annotate, download, and use these sensor datasets.
Requesting Access to unpublished data in Clowder:
  1. 1.
    fill out the terraref.org/beta user form
  2. 2.
    create an account at the TERRA-REF Clowder site
  3. 3.
    email [email protected] for your account to be approved.

CyVerse is a National Science Foundation funded cyberinfrastructure that aims to democratize access to supercomputing capabilities.
TERRA-REF genomics data is accessible on the CyVerse Data Store and Discovery Environment. Accessing data through the CyVerse Discovery Environment requires signing up for a free CyVerse account. The Discovery Environment gives users access to software and computing resources, so this method has the advantage that TERRA-REF data can be utilized directly without the need to copy the data elsewhere.
Genomics data can be browsed and downloaded from the CyVerse data store at http://datacommons.cyverse.org/browse/iplant/home/shared/terraref
You can also find these in the CyVerse discovery environment in the TERRA-REF Community Data folder: /iplant/home/shared/terraref.

CoGe is a platform for performing Comparative Genomics research. It provides an open-ended network of interconnected tools to manage, analyze, and visualize next-gen data.
CoGe contains genomic information and sequence data. You can find the TERRA REF Genomics data on CoGe in this notebook: https://genomevolution.org/coge/NotebookView.pl?nid=2137
Last modified 1yr ago
Export as PDF
Copy link
On this page
Overview
Tutorials (Recommended!)
Globus: Browse and Transfer Files
BETYdb: Trait Data and Agronomic Metadata
Accessing data in R
Using SQL and PostGIS with Docker (Advanced Users)
Clowder: Sensor Data and Metadata Browser
CyVerse: Genomics Data
CoGe: Genomics Data