BetyDB

Get trait data for Willow (Salix spp.)

(salix <- betydb_search("Salix Vcmax"))
#> # A tibble: 14 x 36
#>    checked result_type    id citation_id site_id treatment_id sitename city 
#>      <int> <chr>       <int>       <int>   <int>        <int> <chr>    <chr>
#>  1       1 traits      39217         430     645         1342 ""       Saare
#>  2       1 traits      39218         430     645         1343 ""       Saare
#>  3       1 traits      39219         430     645         1344 ""       Saare
#>  4       1 traits      39220         430     645         1345 ""       Saare
#>  5       1 traits      25405          51      NA            1  <NA>    <NA> 
#>  6       1 traits      39213         430     645         1342 ""       Saare
#>  7       1 traits      39214         430     645         1343 ""       Saare
#>  8       1 traits      39215         430     645         1344 ""       Saare
#>  9       1 traits      39216         430     645         1345 ""       Saare
#> 10       1 traits      39221         430     645         1342 ""       Saare
#> 11       1 traits      39222         430     645         1343 ""       Saare
#> 12       1 traits      39223         430     645         1344 ""       Saare
#> 13       1 traits      39224         430     645         1345 ""       Saare
#> 14       1 traits      37519         381     602         1220  <NA>    <NA> 
#> # … with 28 more variables: lat <dbl>, lon <dbl>, scientificname <chr>,
#> #   commonname <chr>, genus <chr>, species_id <int>, cultivar_id <int>,
#> #   author <chr>, citation_year <int>, treatment <chr>, date <chr>, time <chr>,
#> #   raw_date <chr>, month <int>, year <int>, dateloc <chr>, trait <chr>,
#> #   trait_description <chr>, mean <dbl>, units <chr>, n <int>, statname <chr>,
#> #   stat <dbl>, notes <chr>, access_level <int>, cultivar <chr>, entity <lgl>,
#> #   method_name <lgl>
# equivalent:
# (out <- betydb_search("willow"))

Summarise data from the output data.frame

library("dplyr")
salix %>%
  group_by(scientificname, trait) %>%
  mutate(.mean = as.numeric(mean)) %>%
  summarise(mean = round(mean(.mean, na.rm = TRUE), 2),
            min = round(min(.mean, na.rm = TRUE), 2),
            max = round(max(.mean, na.rm = TRUE), 2),
            n = length(n))
#> # A tibble: 4 x 6
#> # Groups:   scientificname [4]
#>   scientificname                  trait  mean   min   max     n
#>   <chr>                           <chr> <dbl> <dbl> <dbl> <int>
#> 1 Salix                           Vcmax  65    65    65       1
#> 2 Salix dasyclados                Vcmax  46.1  34.3  56.7     4
#> 3 Salix sachalinensis × miyabeana Vcmax  79.3  79.3  79.3     1
#> 4 Salix viminalis                 Vcmax  43.0  20.0  61.3     8

NCBI sequence data

Get sequences by id

ncbi_byid(ids = "360040093")
#>                  taxon
#> 1 Eristalis transversa
#>                                                                                                                                                                                       taxonomy
#> 1 Eukaryota; Metazoa; Ecdysozoa; Arthropoda; Hexapoda; Insecta; Pterygota; Neoptera; Holometabola; Diptera; Brachycera; Muscomorpha; Syrphoidea; Syrphidae; Eristalinae; Eristalini; Eristalis
#>                                                                                                             gene_desc
#> 1 Eristalis transversa voucher CNC:Diptera:102013 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial
#>       organelle     gi_no     acc_no keyword   specimen_voucher
#> 1 mitochondrion 360040093 JN991986.1 BARCODE CNC:Diptera:102013
#>               lat_lon
#> 1 38.4623 N 79.2417 W
#>                                                       country
#> 1 USA: Virginia, Reddish Knob Lookout, 14.5km W Briery Branch
#>                                                              paper_title
#> 1 The evolution of imperfect mimicry in hover flies (Diptera: Syrphidae)
#>       journal first_author uploaded_date length
#> 1 Unpublished   Penny,H.D.   03-NOV-2012    658
#>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             sequence
#> 1 tactttatattttgtatttggaacatgagcgggtatagtaggaacttcattaagaattttaattcgagctgaattaggtcatccaggtgcattaattggtgatgatcaaatttataatgttattgtaacagctcatgcttttgttataattttttttatagtaatacctattataattggaggatttggaaattgattagtaccacttatattaggagctccagatatagcattccctcgaataaataatataagtttctgattattacctccttctttaactctattattagtaagaagtatagtagaaaatggggctggaacaggatgaacagtttatcctccattatcaagtaatattgcacatggaggagcctcagttgatttagcaattttttcacttcacttatcaggaatatcatctattttaggtgcagtaaattttattacaacagttattaatatacgatcaacaggaattacttatgatcgtatacctttatttgtttgatctgttgctattacagctttattattattattatcattaccagtactagcaggagctattacaatattattaactgatcgaaatttaaatacatcattctttgatccagcaggaggaggagaccctatcctgtaccaacacttattc

Get sequences searching by taxonomic name

out <- ncbi_searcher(taxa = "Umbra limi", seqrange = "1:2000")
#> using sleep: 0
#> ══  1 queries  ═══════════════
#> ✔  Found:  Umbra+limi
#> ══  Results  ═════════════════
#> 
#> ● Total: 1 
#> ● Found: 1 
#> ● Not Found: 0
head(out)
#>        taxon length
#> 1 Umbra limi    298
#> 2 Umbra limi    761
#> 3 Umbra limi    765
#> 4 Umbra limi    764
#> 5 Umbra limi    743
#> 6 Umbra limi    758
#>                                                                                                gene_desc
#> 1 Umbra limi voucher Umbra_limi_GLF16S large subunit ribosomal RNA gene, partial sequence; mitochondrial
#> 2                                        Umbra limi voucher NXG2012264 rhodopsin (Rho) gene, partial cds
#> 3                                         Umbra limi voucher NXG201250 rhodopsin (Rho) gene, partial cds
#> 4                                        Umbra limi voucher NXG2012183 rhodopsin (Rho) gene, partial cds
#> 5                                         Umbra limi voucher NXG201252 rhodopsin (Rho) gene, partial cds
#> 6                                        Umbra limi voucher NXG2012231 rhodopsin (Rho) gene, partial cds
#>     acc_no      gi_no
#> 1 MT549086 1847697133
#> 2 KX146134 1049488959
#> 3 KX146015 1049488721
#> 4 KX145969 1049488629
#> 5 KX145777 1049488245
#> 6 KX145759 1049488209

EOL’s traitbank trait data

traitbank(query = "MATCH (n:Trait) RETURN n LIMIT 1;")
#> $columns
#> [1] "n"
#> 
#> $data
#> $data[[1]]
#>   metadata.id metadata.labels    data.eol_pk data.object_page_id
#> 1    22529388           Trait R20-PK20910350            46581789
#>                                                    data.resource_pk
#> 1 ReverseOf_globi:assoc:7296029-FBC:FB:SpecCode:4755-ATE-EOL_V2:281
#>   data.scientific_name
#> 1              Plantae
#>                                                                                                                                                                                                                                                             data.source
#> 1 Froese, R. and D. Pauly. Editors. 2019. FishBase. World Wide Web electronic publication. www.fishbase.org, version (08/2019). Accessed at <https://github.com/globalbioticinteractions/fishbase/archive/6ebceaacea18c6ff6c247182f9af8ad6fc05cc82.zip> on 25 May 2020.

Birdlife International

Habitat data

birdlife_habitat(22721692)
#>         id Habitat (level 1)                  Habitat (level 2) Importance
#> 1 22721692            Forest           Subtropical/Tropical Dry      major
#> 2 22721692            Forest Subtropical/Tropical Moist Montane      major
#> 3 22721692            Forest                          Temperate   suitable
#> 4 22721692         Shrubland Subtropical/Tropical High Altitude   suitable
#>     Occurrence
#> 1     breeding
#> 2 non-breeding
#> 3     breeding
#> 4     breeding

Threats data

birdlife_threats(22721692)
#>          id                                                  threat1
#> 1  22721692                                Agriculture & aquaculture
#> 2  22721692                                Agriculture & aquaculture
#> 3  22721692                                  Biological resource use
#> 4  22721692                          Climate change & severe weather
#> 5  22721692                          Climate change & severe weather
#> 6  22721692                          Climate change & severe weather
#> 7  22721692 Invasive and other problematic species, genes & diseases
#> 8  22721692 Invasive and other problematic species, genes & diseases
#> 9  22721692 Invasive and other problematic species, genes & diseases
#> 10 22721692 Invasive and other problematic species, genes & diseases
#> 11 22721692 Invasive and other problematic species, genes & diseases
#> 12 22721692 Invasive and other problematic species, genes & diseases
#> 13 22721692                             Natural system modifications
#> 14 22721692                             Natural system modifications
#> 15 22721692                     Residential & commercial development
#> 16 22721692                       Transportation & service corridors
#>                                                                                   threat2
#> 1                             Annual & perennial non-timber crops - Agro-industry farming
#> 2                              Annual & perennial non-timber crops - Small-holder farming
#> 3  Logging & wood harvesting - Unintentional effects: (subsistence/small scale) [harvest]
#> 4                                                                                Droughts
#> 5                                                           Habitat shifting & alteration
#> 6                                                                       Storms & flooding
#> 7                                 Invasive non-native/alien species/diseases - Sus scrofa
#> 8                        Invasive non-native/alien species/diseases - Unspecified species
#> 9                            Problematic native species/diseases - Dendroctonus frontalis
#> 10                           Problematic native species/diseases - Odocoileus virginianus
#> 11                              Problematic native species/diseases - Unspecified species
#> 12                    Problematic species/disease of unknown origin - Unspecified species
#> 13                                     Fire & fire suppression - Trend Unknown/Unrecorded
#> 14                                                          Other ecosystem modifications
#> 15                                                                  Housing & urban areas
#> 16                                                                      Roads & railroads
#>                                                                 stresses
#> 1                     Ecosystem degradation, Ecosystem conversion, Other
#> 2                     Ecosystem degradation, Ecosystem conversion, Other
#> 3                                                  Ecosystem degradation
#> 4                                                  Ecosystem degradation
#> 5                            Ecosystem degradation, Ecosystem conversion
#> 6                                                  Ecosystem degradation
#> 7                            Ecosystem degradation, Ecosystem conversion
#> 8                                                      Species mortality
#> 9                                                  Ecosystem degradation
#> 10                                                 Ecosystem degradation
#> 11                   Ecosystem degradation, Reduced reproductive success
#> 12                                                     Species mortality
#> 13                           Ecosystem degradation, Ecosystem conversion
#> 14                           Ecosystem degradation, Ecosystem conversion
#> 15 Ecosystem degradation, Ecosystem conversion, Species mortality, Other
#> 16                                                     Species mortality
#>                                                      timing
#> 1                                 Agriculture & aquaculture
#> 2                                 Agriculture & aquaculture
#> 3                                   Biological resource use
#> 4                           Climate change & severe weather
#> 5                           Climate change & severe weather
#> 6                           Climate change & severe weather
#> 7  Invasive and other problematic species, genes & diseases
#> 8  Invasive and other problematic species, genes & diseases
#> 9  Invasive and other problematic species, genes & diseases
#> 10 Invasive and other problematic species, genes & diseases
#> 11 Invasive and other problematic species, genes & diseases
#> 12 Invasive and other problematic species, genes & diseases
#> 13                             Natural system modifications
#> 14                             Natural system modifications
#> 15                     Residential & commercial development
#> 16                       Transportation & service corridors
#>                                                                                     scope
#> 1                             Annual & perennial non-timber crops - Agro-industry farming
#> 2                              Annual & perennial non-timber crops - Small-holder farming
#> 3  Logging & wood harvesting - Unintentional effects: (subsistence/small scale) [harvest]
#> 4                                                                                Droughts
#> 5                                                           Habitat shifting & alteration
#> 6                                                                       Storms & flooding
#> 7                                 Invasive non-native/alien species/diseases - Sus scrofa
#> 8                        Invasive non-native/alien species/diseases - Unspecified species
#> 9                            Problematic native species/diseases - Dendroctonus frontalis
#> 10                           Problematic native species/diseases - Odocoileus virginianus
#> 11                              Problematic native species/diseases - Unspecified species
#> 12                    Problematic species/disease of unknown origin - Unspecified species
#> 13                                     Fire & fire suppression - Trend Unknown/Unrecorded
#> 14                                                          Other ecosystem modifications
#> 15                                                                  Housing & urban areas
#> 16                                                                      Roads & railroads
#>    severity  impact
#> 1   Ongoing Ongoing
#> 2   Ongoing Ongoing
#> 3   Ongoing Ongoing
#> 4   Ongoing Ongoing
#> 5    Future  Future
#> 6   Ongoing Ongoing
#> 7   Ongoing Ongoing
#> 8   Ongoing Ongoing
#> 9   Ongoing Ongoing
#> 10  Ongoing Ongoing
#> 11  Ongoing Ongoing
#> 12  Ongoing Ongoing
#> 13  Ongoing Ongoing
#> 14   Future  Future
#> 15  Ongoing Ongoing
#> 16  Ongoing Ongoing