哪些期刊发表过关于水稻基因的文章，数量有多少？今天用了一个我以前没有用过的SQL查询语句来回答这个问题。
先建立一个空表，表名为：journal_refnumber_14922。这个表有两个字段：journal_name,期刊名字；ref_numbers,期刊中报道的文献数量。journal_name的定义方式和reflist_14922中的journal字段一样。然后用下面的SQL语句插入数据：
INSERT INTO journal_refnumber_14922(journal_name,ref_numbers)
SELECT journal, COUNT(DISTINCT Oryzabase_ref_id)
FROM reflist_14922
GROUP BY journal
这个select用得比较多，至于INSERT INTO这个就不太熟了，所以用百度搜索了下。总共有500种期刊报道过水稻基因。其中报道文献数量在10以上的期刊如下：
| journal_name | ref_numbers  |
|
|---|
| Ann. Phytopath. Soc. Japan | 10 |
| BMC Evol. Biol. | 10 |
| Bot. Bull. Acad. Sin. | 10 |
| Development | 10 |
| Eur. J. Biochem. | 10 |
| J. Hered. | 10 |
| Journal of Plant Biology | 10 |
| Plant Biotechnol J. | 10 |
| FEBS J. | 11 |
| Nat. Genet. | 11 |
| Plant Science | 11 |
| PLoS Genet. | 11 |
| Rice Genetics. IRRI, Manila, Philippines. | 11 |
| S. Iyama and G. Takeda (eds.), Proc. 6th Internat.... | 11 |
| BMC Plant Biol | 12 |
| EMBO J. | 12 |
| J. Fac. Agr. Hokkaido Univ. | 12 |
| RICE | 12 |
| Physiol Plant | 13 |
| DNA Res. | 14 |
| Nat Genet | 14 |
| J Integr Plant Biol | 15 |
| BMC Genomics | 16 |
| Mem. Fac. Agr. Hokkaido Univ. | 16 |
| Mol. Biol. Evol. | 16 |
| Plant Breeding | 17 |
| Rice Genetics. II. IRRI, Manila, Philippines. | 17 |
| BMC Plant Biol. | 18 |
| Mol. Biol. Rep. | 18 |
| Science | 18 |
| DNA Seq. | 20 |
| Genome | 20 |
| Phytochemistry | 21 |
| Plant Physiol. Biochem. | 22 |
| Crop Sci. | 23 |
| Mol. Cells | 23 |
| Plant Signal Behav | 23 |
| Nature | 24 |
| Phytopathology | 24 |
| Genes Genet. Syst. | 26 |
| Mol Plant | 28 |
| Planta | 28 |
| Jpn. J. Genet. | 29 |
| Mol. Genet. Genomics | 29 |
| Molecular Breeding | 29 |
| Plant Cell Environ. | 29 |
| Rice Genetics III. IRRI, Manila, Philippines. | 30 |
| Mol. Plant Microbe Interact. | 31 |
| New Phytol. | 31 |
| Biochim. Biophys. Acta | 34 |
| Genetics | 35 |
| FEBS Lett. | 37 |
| Biochem. Biophys. Res. Commun. | 38 |
| Nucleic Acids Res. | 38 |
| J. Plant Physiol. | 39 |
| Mol. Gen. Genet. | 39 |
| Biosci. Biotechnol. Biochem. | 42 |
| Molecular Genetics & Genomics (Molecular General G... | 45 |
| Plant Cell Rep. | 46 |
| Planta. | 46 |
| J. Biol. Chem. | 47 |
| PLoS ONE | 59 |
| Euphytica | 64 |
| Plant Sci. | 68 |
| J. Exp. Bot. | 69 |
| Gene | 89 |
| Proc. Natl. Acad. Sci. U.S.A. | 132 |
| Japan. J. Breed. | 163 |
| Plant Cell Physiol. | 185 |
| Plant Cell | 204 |
| Plant J. | 212 |
| Breeding Science | 258 |
| Plant Mol. Biol. | 266 |
| Theor. Appl. Genet. | 287 |
| Plant Physiol. | 348 |
| RGN | 394 |
这个表里有不少非常有名的期刊。利用这个表可以很方便的在文献数据库中把发表在特定期刊上的文章抓出来。比如Nature Genetics
SELECT DISTINCT Journal, Title, Volume, pages, YEAR
FROM `reflist_14922`
WHERE Journal = "Nat Genet"
OR journal = "Nat. Genet."
ORDER BY YEAR
结果：
| Journal | Title | Volume | pages | YEAR |
|
|---|
| Nat Genet | A 300 kilobase interval genetic map of rice including 883 expressed sequences. | 8 | 365-372. | 1994 |
| Nat Genet | Sequencing of a rice centromere uncovers active genes. | 36(2) | 138-145 | 2004 |
| Nat Genet | A rice quantitative trait locus for salt tolerance encodes a sodium transporter. | 37(10) | 1141-1146 | 2005 |
| Nat Genet | A QTL for rice grain width and weight encodes a novel RING-type E3 ubiquitin ligase | 39(5) | 623-630 | 2007 |
| Nat Genet | Control of a key transition from prostrate to erect growth in rice domestication | 40(11) | 1360-1364 | 2008 |
| Nat Genet | Control of rice grain-filling and yield by a gene with a potential signature of domestication | 40(11) | 1370-1374 | 2008 |
| Nat Genet | Deletion in a gene associated with grain size increased yields during rice domestication | 40(8) | 1023-1028 | 2008 |
| Nat Genet | Genetic control of rice plant architecture domestication | 40(11) | 1365-69 | 2008 |
| Nat Genet | Genetic control of rice plant architecture under domestication | 40(11) | 1365-1369 | 2008 |
| Nat Genet | Natural variation in Ghd7 is an important regulator of heading date and yield potential in rice | 40(6) | 761-767 | 2008 |
| Nat Genet | Natural variation at the DEP1 locus enhances grain yield in rice | 41(4) | 494-497 | 2009 |
| Nat Genet | A pair of floral regulators sets critical day length for Hd3a florigen expression in rice. | 42(7) | 635-8 | 2010 |
| Nat Genet | OsSPL14 promotes panicle branching and higher grain productivity in rice | 42(6) | 545-9 | 2010 |
| Nat Genet | Regulation of OsSPL14 by OsmiR156 defines ideal plant architecture in rice | 42(6) | 541-544 | 2010 |
| Nat. Genet. | Natural variation in GS5 plays an important role in regulating grain size and yield in rice | 43(12) | 1266-1269 | 2011 |
| Nat. Genet. | Control of grain size, shape and quality by OsSPL16 in rice. | 44(8) | 950-4 | 2012 |
| Nat. Genet. | Genome-wide association study of flowering time and grain yield traits in a worldwide collection of rice germplasm. | 44(1) | 32-9 | 2012 |
| Nat. Genet. | One gene's shattering effects. | 44(6) | 616-7 | 2012 |
| Nat. Genet. | Parallel domestication of the Shattering1 genes in cereals. | 44(6) | 720-4 | 2012 |
| Nat. Genet. | A battle between genomes in plant male fertility. | 45(5) | 472-3 | 2013 |
| Nat. Genet. | A detrimental mitochondrial-nuclear interaction causes cytoplasmic male sterility in rice. | 45(5) | 573-7 | 2013 |
| Nat. Genet. | Control of root system architecture by DEEPER ROOTING 1 increases rice yield under drought conditions. | 45(9) | 1097-102 | 2013 |
| Nat. Genet. | Loss of function of the IAA-glucose hydrolase gene TGW6 enhances rice grain weight and increases yield. | 45(6) | 707-11 | 2013 |
| Nat. Genet. | OsLG1 regulates a closed panicle trait in domesticated rice. | 45(4) | 462-5, 465e1-2 | 2013 |
| Nat. Genet. | Chalk5 encodes a vacuolar H(+)-translocating pyrophosphatase influencing grain chalkiness in rice. | 46(4) | 398-404 | 2014 |
https://wap.sciencenet.cn/blog-479743-833503.html
上一篇：
利用MySQL库分析关于水稻基因的研究（五）下一篇：
一点感想
