https://sql.quacking.cloud/
https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering

一个duckdb-wasm sql在线工具

https://doc.linkurious.com/ogma/latest/
b0ba59e2-a901-4d11-a489-1c019f9957ef-image.png

71794678-875a-4f70-85b7-af01aa4c8691-image.png

配置文件的优先级
Selector priority

When mixing generic process configuration and selectors the following priority rules are applied (from lower to higher):

Process generic configuration.

Process specific directive defined in the workflow script.

withLabel selector definition.

withName selector definition.

https://edwards.flinders.edu.au/fastq-dump/
https://notarocketscientist.xyz/posts/2022-07-26-getting-index-reads-from-sra/

docker run -it -p 139:139 -p 445:445 -v /home/genostack/share:/mount -d dperson/samba -u "samba;samba" -s "shared;/mount;yes;no;no;all;none"
docker exec -it 容器ID /bin/bash
smbpasswd -a samba 命令添加用户，并设置密码为samba

https://developer.nvidia.com/blog/search-posts/?q=parabricks&faceted_search_industry_str=Healthcare+%26+Life+Sciences
一些应用案例

We constructed the front-end framework with Vue.js (version 2.6.14) and built the backend using Django (version 2.2) and Python (version 3.7.4). STOmicsDB used PostgreSQL (version 9.6) to store the metadata of publications, and datasets. We used Elasticsearch (version 7.16.2) as the search engine in the resource center of STOmicsDB. We employed MongoDB (version 4.2) and Cirrocumulus to manage and visualize curated datasets. We used Redis (v5.0.4) as the cache to store and manage the data in memory. For task queue management, we applied RabbitMQ (v3.8.13). Nginx (v1.20.1) was used as the reverse proxy server. Currently, STOmicsDB supports the following browsers: Google Chrome (v80.0 and above), Opera (v62.0 and above), Safari (v12.0 and above) and Firefox (v80.0 and above).

https://github.com/lilab-bcb/cirrocumulus

ADD (Additive Model):

这代表加性模型的测试结果，通常是基因型数据的主要分析方法。
在加性模型中，假设一个等位基因的效应（对表型的影响）是加性的，即不考虑基因间的相互作用。
在输出中，ADD 行表示单个等位基因变化对表型的影响，即每增加一个特定等位基因，表型（比如疾病风险）如何变化。
COVAR1 (Covariate):

这表示单独考虑协变量（例如，年龄、性别）对表型的影响的结果。
COVAR1 测试的目的是估计协变量本身对表型的影响，而不是基因型。
这有助于理解和控制这些非遗传因素对研究结果的潜在影响。
ADDxCOVAR1 (Interaction between Additive Genetic Effect and Covariate):

这代表基因型（加性效应）和协变量之间交互作用的测试结果。
该测试旨在评估特定的基因型和协变量（如性别、年龄等）之间是否存在交互作用，这种交互作用是否影响了表型。
例如，某个基因变体对疾病风险的影响可能在不同年龄或性别的人群中有所不同。
在解释这些结果时，重要的是要考虑到你的特定研究目标和上下文。ADD 结果通常是最关注的，因为它直接关系到基因型与表型之间的关联。COVAR1 和 ADDxCOVAR1 的结果有助于理解和解释这些基因型-表型关联可能受哪些其他因素的影响。

清理磁盘的分区表

sudo gdisk /dev/sdb
GPT fdisk (gdisk) version 0.8.10

Partition table scan:
MBR: protective
BSD: not present
APM: not present
GPT: present

Found valid GPT with protective MBR; using GPT.

Command (? for help): x

Expert command (? for help): z
About to wipe out GPT on /dev/sdb. Proceed? (Y/N): Y
GPT data structures destroyed! You may now partition the disk using fdisk or
other utilities.
Blank out MBR? (Y/N): Y