mysql.user(host, user, password, select_priv, insert_priv, update_priv)
VALUES (‘localhost’, ‘wangyu’, PASSWORD(‘xxxxxx’), ‘Y’, ‘Y’, ‘Y’);
UPDATE table SET columnA = ‘Fred’ WHERE columnB = ‘Wilson’
GRANT privileges ON databasename.tablename TO ‘username’@’host’
SELECT (sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024 FROM information_schema.TABLES where TABLE_SCHEMA=’servicer’;
select * from table
UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
select field from table where field like “pattern”;
1. F1 Arabidopsis
2. Rationale of unzip
3. rationale of falcon
Arabidopsis thaliana is a small flowering plant of mustard family, brassicaceae (Cruciferae). It is distributed throughout the world and was first reported in the sixteenth century by Johannes Thal. It has been used for over fifty years to study plant mutations and for classical genetic analysis. It is now being used as a model organism to study different aspects of plant biology.
A. thaliana is a diploid plant with 2n = 10 chromosomes. It became the first plant genome to be fully sequenced based on the fact that it has a (1) small genome of ~120 Mb with a simple structure having few repeated sequences (2) short generation time of six weeks from seed germination to seed set, and (3) produces large number of seeds. The sequencing was done by an international collaboration collectively termed the Arabidopsis Genome Initiative (AGI). Though of no economic importance, it is an invaluable resource to agriculturally important crops, particularly to members of the same family, which includes canola, an important source of vegetable oil. EST/mRNA alignments to the Genome are available for ftp download. They are in the Splign format.
Sweeps can be categorized in three main categories.
- The “classic selective sweep” or “hard selective sweep” is expected to occur when beneficial mutations are rare, but once a beneficial mutation has occurred it increases in frequency rapidly, thereby drastically reducing genetic variation in the population.
- A so-called “soft sweep from standing genetic variation” occurs when a previously neutral mutation that was present in a population becomes beneficial because of an environmental change. Such a mutation may be present on several genomic backgrounds so that when it rapidly increases in frequency, it doesn’t erase all genetic variation in the population.
- Finally, a “multiple origin soft sweep” occurs when mutations are common (for example in a large population) so that the same or similar beneficial mutations occurs on different genomic backgrounds such that no single genomic background can hitchhike to high frequency.
- genetic hitchhiking: 遗传搭车
- singleton: SNP’s shared by more than one individual indicate levels of relatedness, while SNP’s found only within one individual, referred to as “singletons”, indicate uniqueness.