2011年11月28日 星期一

[VBA] normscore functiom

## 套用在模組中
Function normscore(inde_num As Double, ref_leng As range)
X = Application.WorksheetFunction.Rank(inde_num, ref_leng, 1)
Y = Application.WorksheetFunction.Count(ref_leng) + 1
Z = Application.WorksheetFunction.NormSInv(X / Y)
normscore = Z
End Function

2011年11月23日 星期三

Genome Sizes

Table of Genome Sizes (haploid)
Base pairsGenesNotes
φX1745,38611virus of E. coli
Human mitochondrion16,56937
Epstein-Barr virus (EBV)172,28280causes mononucleosis
Nanoarchaeum equitans490,885552This parasitic member of the Archaea has the smallest genome of a true organism yet found.
nucleomorph of Guillardia theta551,264511all that remains of the nuclear genome of a red alga (a eukaryote) engulfed long ago by another eukaryote
Mycoplasma genitalium580,073485two of the smallest true organisms
Mycoplasma pneumoniae816,394680
Chlamydia trachomatis1,042,519936this bacterium causes the most common sexually-transmitted disease (STD) in the U.S.
Rickettsia prowazekii1,111,523834bacterium that causes epidemic typhus
Treponema pallidum1,138,0111,039bacterium that causes syphilis
Mimivirus1,181,4041,262A virus (of an amoeba) with a genome larger than the six cellular organisms above
Pelagibacter ubique1,308,7591,354smallest genome yet found in a free-living organism (marine α-proteobacterium)
Borrelia burgdorferi1.44 x 1061,738bacterium that causes Lyme disease [Note]
Campylobacter jejuni1,641,4811,708frequent cause of food poisoning
Helicobacter pylori1,667,8671,589chief cause of stomach ulcers (not stress and diet)
Thermoplasma acidophilum1,564,9051,509These unicellular microbes look like typical bacteria but their genes
are so different from those of either bacteria or eukaryotes that they are
classified in a third kingdom: Archaea.
Methanococcus jannaschii1,664,9701,783
Aeropyrum pernix1,669,6951,885
Methanobacterium
thermoautotrophicum
1,751,3772,008
Haemophilus influenzae1,830,1381,738bacterium that causes middle ear infections
Streptococcus pneumoniae2,160,8372,236the pneumococcus
Neisseria meningitidis2,184,4062,185Group A; causes occasional epidemics of meningitis in less developed countries.
Neisseria meningitidis2,272,3512,221Group B; the most frequent cause of meningitis in the U.S.
Encephalitozoon cuniculi2,507,5191,997(plus 69 RNA genes); a parasitic eukaryote.
Propionibacterium acnes2,560,2652,333causes acne
Listeria monocytogenes2,944,5282,9262,853 of these encode proteins; the rest RNAs
Deinococcus radiodurans3,284,1563,187on 2 chromosomes and 2 plasmids; bacterium noted for its resistance to radiation damage
Synechocystis3,573,4704,003a marine cyanobacterium ("blue-green alga")
Vibrio cholerae4,033,4603,890in 2 chromosomes; causes cholera
Mycobacterium tuberculosis4,411,5323,959causes tuberculosis
Mycobacterium leprae3,268,2031,604causes leprosy
Bacillus subtilis4,214,8144,779another bacterium
E. coli K-124,639,2214,3774,290 of these genes encode proteins; the rest RNAs
E. coli O157:H75.44 x 1065,416strain that is pathogenic for humans; has 1,346 genes not found in E. coli K-12
Agrobacterium tumefaciens4,674,0625,419Useful vector for making transgenic plants; shares many genes with Sinorhizobium meliloti
Salmonella enterica var Typhi4,809,0374,395+ 2 plasmids with 372 active genes; causes typhoid fever
Salmonella enterica var Typhimurium4,857,4324,450+ 1 plasmid with 102 active genes
Yersinia pestis4,826,1004,052on 1 chromosome + 3 plasmids; causes plague
Schizosaccharomyces pombe12,462,6374,929Fission yeast. A eukaryote with fewer genes than the four bacteria below.
Ralstonia solanacearum5,810,9225,129soil bacterium pathogenic for many plants; 1681 of its genes on a huge plasmid
Pseudomonas aeruginosa6.3 x 1065,570Increasingly common cause of opportunistic infections in humans.
Streptomyces coelicolor6,667,5077,842An actinomycete whose relatives provide us with many antibiotics
Sinorhizobium meliloti6,691,6946,204The rhizobial symbiont of alfalfa. Genome consists of one chromosome and 2 large plasmids.
Saccharomyces cerevisiae12,495,6825,770Budding yeast. A eukaryote.
Cyanidioschyzon merolae16,520,3055,331A unicellular red alga.
Plasmodium falciparum22,853,7645,268Plus 53 RNA genes. Causes the most dangerous form of malaria.
Thalassiosira pseudonana34.5 x 10611,242A diatom. Plus 144 chloroplast and 40 mitochondrial genes encoding proteins
Neurospora crassa38,639,76910,082Plus 498 RNA genes.
Naegleria gruberi41 x 10615,727This free-living unicellular organism lives as both an amoeboid and a flagellated form.
4,133 of its genes are also found in other eukaryotes suggesting that they were present in the
common ancestor of all eukaryotes. The great variety of functions encoded by these genes
also suggests that the common ancestor of all eukaryotes was itself as complex as many of the
present-day unicellular members.
Caenorhabditis elegans100,258,17121,733The first metazoan to be sequenced.
Arabidopsis thaliana115,409,949~28,000a flowering plant (angiosperm) See note.
Drosophila melanogaster122,653,977~17,000the "fruit fly"
Anopheles gambiae278,244,06313,683Mosquito vector of malaria.
Tetraodon nigroviridis (a pufferfish)3.42 x 10827,918Although Tetraodon seems to have more protein-encoding genes than we do, it has much less "junk" DNA so its total genome is about a tenth the size of ours.
Rice3.9 x 10828,236
Sea urchin8.14 x 108~23,300
Zebrafish1.2 x 10915,761
Dogs2.4 x 10919,300
Humans3.3 x 109~21,000[Link to more details.]
Mouse3.4 x 109~23,000
Amphibians109–1011?
Psilotum nudum2.5 x 1011?Note