Cloud-based Kmer Table
Overview
The Kmer Table (kmer) contains the 32-mers used in the analysis with their respective taxonomy ID.
Linking to other tables:
- to Taxonomy Table (
tax) table bytax_idcolumn
| Column name | Type | Desription |
|---|---|---|
| kmer | STRING | 32-mer |
| tax_id | INTEGER | Taxonomy ID. Link with tax_analysis and tax tables. |
Example queries for Big Query UI
SELECT kmer.kmer , tax.tax_id , tax.sci_name
FROM `nih-sra-datastore.sra_tax_analysis_tool.kmer` as kmer , `research-sra-cloud-pipeline.sratest.taxonomy` tax
WHERE kmer.tax_id = tax.tax_id and tax.sci_name = 'Severe acute respiratory syndrome-related coronavirus'
FROM `nih-sra-datastore.sra_tax_analysis_tool.kmer` as kmer , `research-sra-cloud-pipeline.sratest.taxonomy` tax
WHERE kmer.tax_id = tax.tax_id and tax.sci_name = 'Severe acute respiratory syndrome-related coronavirus'
Contact SRA
Contact SRA staff for assistance at sra@ncbi.nlm.nih.gov