GIS overlay for environmental samples from NCBI
1
1
Entering edit mode
7 weeks ago
joe ▴ 490

Hi all,

I was wondering if anyone is aware of an overlay for GIS GUI software (like ArcPro) showing where environmental samples (for NGS) were collected along with some basic metadata, like type of sequencing, library prep, etc. TIA!

NCBI environmental SRA GIS ArcPro • 311 views
ADD COMMENT
1
Entering edit mode
21 days ago
joe ▴ 490

If you setup one of the cloud-based SQL-like metadata search options, you can use the below code (for AWS-Athena) to find coordinates of samples, and then port over to whatever GIS system. Note that many samples will not have this information, or the information is only partial. There will be a bit of data-wrangling to still do after you retrieve this

https://www.ncbi.nlm.nih.gov/sra/docs/sra-bigquery/

https://www.ncbi.nlm.nih.gov/sra/docs/sra-bigquery-examples/

https://www.ncbi.nlm.nih.gov/sra/docs/sra-cloud-based-metadata-table/

SELECT
    element.k AS key,
    element.v AS value,
    *
FROM
    metadata,
    UNNEST("attributes") AS unnested(element)
WHERE
    element.k = 'lat_lon_sam_s_dpl34' AND
    REGEXP_LIKE(element.v, '[0-9]')
ADD COMMENT

Login before adding your answer.

Traffic: 1519 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6