You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Instantly share code, notes, and snippets.
Amanda Devine
amdevine
I write little tools to explore biodiversity data.
The Global Genome Biodiversity Network (GGBN) API is a service that allows users to retrieve data from the GGBN Data Portal quickly and easily. Data can be accessed via a script or a web browser. Data are output in the JavaScript Object Notation (JSON) format, a common format for sharing and accessing data from websites.
Types of data available
The GGBN API is accessed by using a web browser (or a script) to navigate to a specific URL (the endpoint) on the GGBN website:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT tablea.column1, tablea.column2, tableb.column3 AS somealias, SUM(tableb.column4)
FROM tablea
LEFT JOIN tableb
ON tablea.columnx = tableb.columnx
WHERE (tablea.column1 = 'someString') AND (tablea.column2 = someNumber)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This gist contains all classes that occur in phylum Arthropoda for each data source, and whether these classes would be classified as "terrestrial arthropods" when doing analyses.
This gist contains all classes that occur in phylum Chordata for each data source, and whether these classes would be classified as vertebrates for the purpose of analysis.