Skip to content
AWS for Query.Farm

aws.omics.get_read_set_metadata

Example SQL Queries

SELECT * FROM
aws.omics.get_read_set_metadata
WHERE
"id" = 'VALUE'
AND "sequence_store_id" = 'VALUE';

Description

Gets details about a read set.

Table Definition

Column NameColumn Data Type
id Required Input Column

The read set's ID.

VARCHAR
sequence_store_id Required Input Column

The read set's sequence store ID.

VARCHAR
_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 meant to represent 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
files

The read set's files.

STRUCT(
    "source1" STRUCT(
        "total_parts" BIGINT,
        "part_size" BIGINT,
        "content_length" BIGINT,
        "s3_access" STRUCT(
            "s3_uri" VARCHAR
        )
    ),
    "source2" STRUCT(
        "total_parts" BIGINT,
        "part_size" BIGINT,
        "content_length" BIGINT,
        "s3_access" STRUCT(
            "s3_uri" VARCHAR
        )
    ),
    "index" STRUCT(
        "total_parts" BIGINT,
        "part_size" BIGINT,
        "content_length" BIGINT,
        "s3_access" STRUCT(
            "s3_uri" VARCHAR
        )
    )
)
Show child fields
files.index

The files' index.

Show child fields
files.index.content_length

The file's content length.

files.index.part_size

The file's part size.

files.index.s3_access

The S3 URI metadata of a sequence store.

Show child fields
files.index.s3_access.s3_uri

The S3 URI for each read set file.

files.index.total_parts

The file's total parts.

files.source1

The location of the first file in Amazon S3.

Show child fields
files.source1.content_length

The file's content length.

files.source1.part_size

The file's part size.

files.source1.s3_access

The S3 URI metadata of a sequence store.

Show child fields
files.source1.s3_access.s3_uri

The S3 URI for each read set file.

files.source1.total_parts

The file's total parts.

files.source2

The location of the second file in Amazon S3.

Show child fields
files.source2.content_length

The file's content length.

files.source2.part_size

The file's part size.

files.source2.s3_access

The S3 URI metadata of a sequence store.

Show child fields
files.source2.s3_access.s3_uri

The S3 URI for each read set file.

files.source2.total_parts

The file's total parts.

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

The read set's sequence information.

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 message 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