Skip to content
AWS for Query.Farm

aws.omics.list_read_sets

Example SQL Queries

SELECT * FROM
aws.omics.list_read_sets
WHERE
"sequence_store_id" = 'VALUE';

Description

Retrieves a list of read sets.

Table Definition

Column NameColumn Data Type
sequence_store_id Required Input Column

The read set's sequence store ID.

VARCHAR
filter Input Column

A filter to apply to the list.

STRUCT(
    "name" VARCHAR,
    "status" VARCHAR,
    "reference_arn" VARCHAR,
    "created_after" TIMESTAMP_S,
    "created_before" TIMESTAMP_S,
    "sample_id" VARCHAR,
    "subject_id" VARCHAR,
    "generated_from" VARCHAR,
    "creation_type" VARCHAR
)
Show child fields
filter.created_after

The filter's start date.

filter.created_before

The filter's end date.

filter.creation_type

The creation type of the read set.

filter.generated_from

Where the source originated.

filter.name

A name to filter on.

filter.reference_arn

A genome reference ARN to filter on.

filter.sample_id

The read set source's sample ID.

filter.status

A status to filter on.

filter.subject_id

The read set source's subject ID.

_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
arn

The read set's ARN.

VARCHAR
creation_time

When the read set was created.

TIMESTAMP_S
creation_type

The creation type of the read set. 

VARCHAR
description

The read set's description.

VARCHAR
etag

The entity tag (ETag) is a hash of the object representing its semantic content.

STRUCT(
    "algorithm" VARCHAR,
    "source1" VARCHAR,
    "source2" VARCHAR
)
Show child fields
etag.algorithm

The algorithm used to calculate the read set’s ETag(s).

etag.source1

The ETag hash calculated on Source1 of the read set.

etag.source2

The ETag hash calculated on Source2 of the read set.

file_type

The read set's file type.

VARCHAR
id

The read set's ID.

VARCHAR
name

The read set's name.

VARCHAR
reference_arn

The read set's genome reference ARN.

VARCHAR
sample_id

The read set's sample ID.

VARCHAR
sequence_information

Details about a sequence.

STRUCT(
    "total_read_count" BIGINT,
    "total_base_count" BIGINT,
    "generated_from" VARCHAR,
    "alignment" VARCHAR
)
Show child fields
sequence_information.alignment

The sequence's alignment setting.

sequence_information.generated_from

Where the sequence originated.

sequence_information.total_base_count

The sequence's total base count.

sequence_information.total_read_count

The sequence's total read count.

status

The read set's status.

VARCHAR
status_message

The status for a read set. It provides more detail as to why the read set has a status. 

VARCHAR
subject_id

The read set's subject ID.

VARCHAR