SNP_tools: A compact tool package for analysis and conversion of genotype data for MS-Excel View Full Text


Ontology type: schema:ScholarlyArticle      Open Access: True


Article Info

DATE

2009-12

AUTHORS

Bowang Chen, Stefan Wilkening, Marion Drechsel, Kari Hemminki

ABSTRACT

BACKGROUND: Single nucleotide polymorphism (SNP) genotyping is a major activity in biomedical research. Scientists prefer to have a facile access to the results which may require conversions between data formats. First hand SNP data is often entered in or saved in the MS-Excel format, but this software lacks genetic and epidemiological related functions. A general tool to do basic genetic and epidemiological analysis and data conversion for MS-Excel is needed. FINDINGS: The SNP_tools package is prepared as an add-in for MS-Excel. The code is written in Visual Basic for Application, embedded in the Microsoft Office package. This add-in is an easy to use tool for users with basic computer knowledge (and requirements for basic statistical analysis). CONCLUSION: Our implementation for Microsoft Excel 2000-2007 in Microsoft Windows 2000, XP, Vista and Windows 7 beta can handle files in different formats and converts them into other formats. It is a free software. More... »

PAGES

214

References to SciGraph publications

  • 2008. HapMap in ENCYCLOPEDIA OF GENETICS, GENOMICS, PROTEOMICS AND INFORMATICS
  • 2002-01. Merlin—rapid analysis of dense genetic maps using sparse gene flow trees in NATURE GENETICS
  • Identifiers

    URI

    http://scigraph.springernature.com/pub.10.1186/1756-0500-2-214

    DOI

    http://dx.doi.org/10.1186/1756-0500-2-214

    DIMENSIONS

    https://app.dimensions.ai/details/publication/pub.1024392375

    PUBMED

    https://www.ncbi.nlm.nih.gov/pubmed/19852806


    Indexing Status Check whether this publication has been indexed by Scopus and Web Of Science using the SN Indexing Status Tool
    Incoming Citations Browse incoming citations for this publication using opencitations.net

    JSON-LD is the canonical representation for SciGraph data.

    TIP: You can open this SciGraph record using an external JSON-LD service: JSON-LD Playground Google SDTT

    [
      {
        "@context": "https://springernature.github.io/scigraph/jsonld/sgcontext.json", 
        "about": [
          {
            "id": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/0803", 
            "inDefinedTermSet": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/", 
            "name": "Computer Software", 
            "type": "DefinedTerm"
          }, 
          {
            "id": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/08", 
            "inDefinedTermSet": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/", 
            "name": "Information and Computing Sciences", 
            "type": "DefinedTerm"
          }
        ], 
        "author": [
          {
            "affiliation": {
              "alternateName": "German Cancer Research Center", 
              "id": "https://www.grid.ac/institutes/grid.7497.d", 
              "name": [
                "Department of Molecular Genetic Epidemiology, German Cancer Research Center (DKFZ), 69120, Heidelberg, Germany"
              ], 
              "type": "Organization"
            }, 
            "familyName": "Chen", 
            "givenName": "Bowang", 
            "id": "sg:person.01007446576.93", 
            "sameAs": [
              "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01007446576.93"
            ], 
            "type": "Person"
          }, 
          {
            "affiliation": {
              "alternateName": "European Molecular Biology Laboratory", 
              "id": "https://www.grid.ac/institutes/grid.4709.a", 
              "name": [
                "European Molecular Biology Laboratory (EMBL), 69117, Heidelberg, Germany"
              ], 
              "type": "Organization"
            }, 
            "familyName": "Wilkening", 
            "givenName": "Stefan", 
            "id": "sg:person.01031455532.19", 
            "sameAs": [
              "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01031455532.19"
            ], 
            "type": "Person"
          }, 
          {
            "affiliation": {
              "alternateName": "German Cancer Research Center", 
              "id": "https://www.grid.ac/institutes/grid.7497.d", 
              "name": [
                "Department of Molecular Genetic Epidemiology, German Cancer Research Center (DKFZ), 69120, Heidelberg, Germany"
              ], 
              "type": "Organization"
            }, 
            "familyName": "Drechsel", 
            "givenName": "Marion", 
            "id": "sg:person.0705271026.69", 
            "sameAs": [
              "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.0705271026.69"
            ], 
            "type": "Person"
          }, 
          {
            "affiliation": {
              "alternateName": "Karolinska Institute", 
              "id": "https://www.grid.ac/institutes/grid.4714.6", 
              "name": [
                "Department of Molecular Genetic Epidemiology, German Cancer Research Center (DKFZ), 69120, Heidelberg, Germany", 
                "Center for Family and Community Medicine, Karolinska Institute, SE-14183, Huddinge, Sweden"
              ], 
              "type": "Organization"
            }, 
            "familyName": "Hemminki", 
            "givenName": "Kari", 
            "id": "sg:person.0726772160.17", 
            "sameAs": [
              "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.0726772160.17"
            ], 
            "type": "Person"
          }
        ], 
        "citation": [
          {
            "id": "https://doi.org/10.1093/bioinformatics/btl574", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1001638919"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1093/bioinformatics/bth457", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1008081196"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1136/jcp.48.7.691-a", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1012875528"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1086/519795", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1019061180"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1093/bioinformatics/btm025", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1034750111"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "sg:pub.10.1038/ng786", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1041343500", 
              "https://doi.org/10.1038/ng786"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "sg:pub.10.1038/ng786", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1041343500", 
              "https://doi.org/10.1038/ng786"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "sg:pub.10.1007/978-1-4020-6754-9_7342", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1046821934", 
              "https://doi.org/10.1007/978-1-4020-6754-9_7342"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1016/s0097-8493(05)00034-8", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1050992779"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1086/428594", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1058715738"
            ], 
            "type": "CreativeWork"
          }, 
          {
            "id": "https://doi.org/10.1086/502802", 
            "sameAs": [
              "https://app.dimensions.ai/details/publication/pub.1058783626"
            ], 
            "type": "CreativeWork"
          }
        ], 
        "datePublished": "2009-12", 
        "datePublishedReg": "2009-12-01", 
        "description": "BACKGROUND: Single nucleotide polymorphism (SNP) genotyping is a major activity in biomedical research. Scientists prefer to have a facile access to the results which may require conversions between data formats. First hand SNP data is often entered in or saved in the MS-Excel format, but this software lacks genetic and epidemiological related functions. A general tool to do basic genetic and epidemiological analysis and data conversion for MS-Excel is needed.\nFINDINGS: The SNP_tools package is prepared as an add-in for MS-Excel. The code is written in Visual Basic for Application, embedded in the Microsoft Office package. This add-in is an easy to use tool for users with basic computer knowledge (and requirements for basic statistical analysis).\nCONCLUSION: Our implementation for Microsoft Excel 2000-2007 in Microsoft Windows 2000, XP, Vista and Windows 7 beta can handle files in different formats and converts them into other formats. It is a free software.", 
        "genre": "research_article", 
        "id": "sg:pub.10.1186/1756-0500-2-214", 
        "inLanguage": [
          "en"
        ], 
        "isAccessibleForFree": true, 
        "isPartOf": [
          {
            "id": "sg:journal.1039457", 
            "issn": [
              "1756-0500"
            ], 
            "name": "BMC Research Notes", 
            "type": "Periodical"
          }, 
          {
            "issueNumber": "1", 
            "type": "PublicationIssue"
          }, 
          {
            "type": "PublicationVolume", 
            "volumeNumber": "2"
          }
        ], 
        "name": "SNP_tools: A compact tool package for analysis and conversion of genotype data for MS-Excel", 
        "pagination": "214", 
        "productId": [
          {
            "name": "readcube_id", 
            "type": "PropertyValue", 
            "value": [
              "743530ed623582474da07e93924cd9041c91cf31ec5e827c4e6e13a2d1386063"
            ]
          }, 
          {
            "name": "pubmed_id", 
            "type": "PropertyValue", 
            "value": [
              "19852806"
            ]
          }, 
          {
            "name": "nlm_unique_id", 
            "type": "PropertyValue", 
            "value": [
              "101462768"
            ]
          }, 
          {
            "name": "doi", 
            "type": "PropertyValue", 
            "value": [
              "10.1186/1756-0500-2-214"
            ]
          }, 
          {
            "name": "dimensions_id", 
            "type": "PropertyValue", 
            "value": [
              "pub.1024392375"
            ]
          }
        ], 
        "sameAs": [
          "https://doi.org/10.1186/1756-0500-2-214", 
          "https://app.dimensions.ai/details/publication/pub.1024392375"
        ], 
        "sdDataset": "articles", 
        "sdDatePublished": "2019-04-10T20:47", 
        "sdLicense": "https://scigraph.springernature.com/explorer/license/", 
        "sdPublisher": {
          "name": "Springer Nature - SN SciGraph project", 
          "type": "Organization"
        }, 
        "sdSource": "s3://com-uberresearch-data-dimensions-target-20181106-alternative/cleanup/v134/2549eaecd7973599484d7c17b260dba0a4ecb94b/merge/v9/a6c9fde33151104705d4d7ff012ea9563521a3ce/jats-lookup/v90/0000000001_0000000264/records_8684_00000512.jsonl", 
        "type": "ScholarlyArticle", 
        "url": "http://link.springer.com/10.1186%2F1756-0500-2-214"
      }
    ]
     

    Download the RDF metadata as:  json-ld nt turtle xml License info

    HOW TO GET THIS DATA PROGRAMMATICALLY:

    JSON-LD is a popular format for linked data which is fully compatible with JSON.

    curl -H 'Accept: application/ld+json' 'https://scigraph.springernature.com/pub.10.1186/1756-0500-2-214'

    N-Triples is a line-based linked data format ideal for batch operations.

    curl -H 'Accept: application/n-triples' 'https://scigraph.springernature.com/pub.10.1186/1756-0500-2-214'

    Turtle is a human-readable linked data format.

    curl -H 'Accept: text/turtle' 'https://scigraph.springernature.com/pub.10.1186/1756-0500-2-214'

    RDF/XML is a standard XML format for linked data.

    curl -H 'Accept: application/rdf+xml' 'https://scigraph.springernature.com/pub.10.1186/1756-0500-2-214'


     

    This table displays all metadata directly associated to this object as RDF triples.

    128 TRIPLES      21 PREDICATES      39 URIs      21 LITERALS      9 BLANK NODES

    Subject Predicate Object
    1 sg:pub.10.1186/1756-0500-2-214 schema:about anzsrc-for:08
    2 anzsrc-for:0803
    3 schema:author N80c21a7130684dd080de90d07f50227d
    4 schema:citation sg:pub.10.1007/978-1-4020-6754-9_7342
    5 sg:pub.10.1038/ng786
    6 https://doi.org/10.1016/s0097-8493(05)00034-8
    7 https://doi.org/10.1086/428594
    8 https://doi.org/10.1086/502802
    9 https://doi.org/10.1086/519795
    10 https://doi.org/10.1093/bioinformatics/bth457
    11 https://doi.org/10.1093/bioinformatics/btl574
    12 https://doi.org/10.1093/bioinformatics/btm025
    13 https://doi.org/10.1136/jcp.48.7.691-a
    14 schema:datePublished 2009-12
    15 schema:datePublishedReg 2009-12-01
    16 schema:description BACKGROUND: Single nucleotide polymorphism (SNP) genotyping is a major activity in biomedical research. Scientists prefer to have a facile access to the results which may require conversions between data formats. First hand SNP data is often entered in or saved in the MS-Excel format, but this software lacks genetic and epidemiological related functions. A general tool to do basic genetic and epidemiological analysis and data conversion for MS-Excel is needed. FINDINGS: The SNP_tools package is prepared as an add-in for MS-Excel. The code is written in Visual Basic for Application, embedded in the Microsoft Office package. This add-in is an easy to use tool for users with basic computer knowledge (and requirements for basic statistical analysis). CONCLUSION: Our implementation for Microsoft Excel 2000-2007 in Microsoft Windows 2000, XP, Vista and Windows 7 beta can handle files in different formats and converts them into other formats. It is a free software.
    17 schema:genre research_article
    18 schema:inLanguage en
    19 schema:isAccessibleForFree true
    20 schema:isPartOf N730b7687c89043a4a916dfd40ff524fa
    21 Nd40e89e42ea645a99296a22840e2d15e
    22 sg:journal.1039457
    23 schema:name SNP_tools: A compact tool package for analysis and conversion of genotype data for MS-Excel
    24 schema:pagination 214
    25 schema:productId N66251792afa84afeb3be2437852b7aa9
    26 N7556230d4dce42e9a284dd62184e6a14
    27 Nb012c57d6f924d1296e7e6a09687bd4c
    28 Nc5d3db6b261c4bb1892f6e3b96963313
    29 Ne67defb721964e25b604e4e2c99d0c4b
    30 schema:sameAs https://app.dimensions.ai/details/publication/pub.1024392375
    31 https://doi.org/10.1186/1756-0500-2-214
    32 schema:sdDatePublished 2019-04-10T20:47
    33 schema:sdLicense https://scigraph.springernature.com/explorer/license/
    34 schema:sdPublisher N2c7fc4b404dc4a7d8e04f2068a146a92
    35 schema:url http://link.springer.com/10.1186%2F1756-0500-2-214
    36 sgo:license sg:explorer/license/
    37 sgo:sdDataset articles
    38 rdf:type schema:ScholarlyArticle
    39 N2c7fc4b404dc4a7d8e04f2068a146a92 schema:name Springer Nature - SN SciGraph project
    40 rdf:type schema:Organization
    41 N5a229d61aa5644d3ab5fad2a5e8b7de7 rdf:first sg:person.0705271026.69
    42 rdf:rest N687cb7065651459f8779f5941ed88b67
    43 N66251792afa84afeb3be2437852b7aa9 schema:name readcube_id
    44 schema:value 743530ed623582474da07e93924cd9041c91cf31ec5e827c4e6e13a2d1386063
    45 rdf:type schema:PropertyValue
    46 N687cb7065651459f8779f5941ed88b67 rdf:first sg:person.0726772160.17
    47 rdf:rest rdf:nil
    48 N730b7687c89043a4a916dfd40ff524fa schema:issueNumber 1
    49 rdf:type schema:PublicationIssue
    50 N7556230d4dce42e9a284dd62184e6a14 schema:name doi
    51 schema:value 10.1186/1756-0500-2-214
    52 rdf:type schema:PropertyValue
    53 N80c21a7130684dd080de90d07f50227d rdf:first sg:person.01007446576.93
    54 rdf:rest Ncf2e90d692bd4cbcb8df02f90a88838c
    55 Nb012c57d6f924d1296e7e6a09687bd4c schema:name pubmed_id
    56 schema:value 19852806
    57 rdf:type schema:PropertyValue
    58 Nc5d3db6b261c4bb1892f6e3b96963313 schema:name nlm_unique_id
    59 schema:value 101462768
    60 rdf:type schema:PropertyValue
    61 Ncf2e90d692bd4cbcb8df02f90a88838c rdf:first sg:person.01031455532.19
    62 rdf:rest N5a229d61aa5644d3ab5fad2a5e8b7de7
    63 Nd40e89e42ea645a99296a22840e2d15e schema:volumeNumber 2
    64 rdf:type schema:PublicationVolume
    65 Ne67defb721964e25b604e4e2c99d0c4b schema:name dimensions_id
    66 schema:value pub.1024392375
    67 rdf:type schema:PropertyValue
    68 anzsrc-for:08 schema:inDefinedTermSet anzsrc-for:
    69 schema:name Information and Computing Sciences
    70 rdf:type schema:DefinedTerm
    71 anzsrc-for:0803 schema:inDefinedTermSet anzsrc-for:
    72 schema:name Computer Software
    73 rdf:type schema:DefinedTerm
    74 sg:journal.1039457 schema:issn 1756-0500
    75 schema:name BMC Research Notes
    76 rdf:type schema:Periodical
    77 sg:person.01007446576.93 schema:affiliation https://www.grid.ac/institutes/grid.7497.d
    78 schema:familyName Chen
    79 schema:givenName Bowang
    80 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01007446576.93
    81 rdf:type schema:Person
    82 sg:person.01031455532.19 schema:affiliation https://www.grid.ac/institutes/grid.4709.a
    83 schema:familyName Wilkening
    84 schema:givenName Stefan
    85 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01031455532.19
    86 rdf:type schema:Person
    87 sg:person.0705271026.69 schema:affiliation https://www.grid.ac/institutes/grid.7497.d
    88 schema:familyName Drechsel
    89 schema:givenName Marion
    90 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.0705271026.69
    91 rdf:type schema:Person
    92 sg:person.0726772160.17 schema:affiliation https://www.grid.ac/institutes/grid.4714.6
    93 schema:familyName Hemminki
    94 schema:givenName Kari
    95 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.0726772160.17
    96 rdf:type schema:Person
    97 sg:pub.10.1007/978-1-4020-6754-9_7342 schema:sameAs https://app.dimensions.ai/details/publication/pub.1046821934
    98 https://doi.org/10.1007/978-1-4020-6754-9_7342
    99 rdf:type schema:CreativeWork
    100 sg:pub.10.1038/ng786 schema:sameAs https://app.dimensions.ai/details/publication/pub.1041343500
    101 https://doi.org/10.1038/ng786
    102 rdf:type schema:CreativeWork
    103 https://doi.org/10.1016/s0097-8493(05)00034-8 schema:sameAs https://app.dimensions.ai/details/publication/pub.1050992779
    104 rdf:type schema:CreativeWork
    105 https://doi.org/10.1086/428594 schema:sameAs https://app.dimensions.ai/details/publication/pub.1058715738
    106 rdf:type schema:CreativeWork
    107 https://doi.org/10.1086/502802 schema:sameAs https://app.dimensions.ai/details/publication/pub.1058783626
    108 rdf:type schema:CreativeWork
    109 https://doi.org/10.1086/519795 schema:sameAs https://app.dimensions.ai/details/publication/pub.1019061180
    110 rdf:type schema:CreativeWork
    111 https://doi.org/10.1093/bioinformatics/bth457 schema:sameAs https://app.dimensions.ai/details/publication/pub.1008081196
    112 rdf:type schema:CreativeWork
    113 https://doi.org/10.1093/bioinformatics/btl574 schema:sameAs https://app.dimensions.ai/details/publication/pub.1001638919
    114 rdf:type schema:CreativeWork
    115 https://doi.org/10.1093/bioinformatics/btm025 schema:sameAs https://app.dimensions.ai/details/publication/pub.1034750111
    116 rdf:type schema:CreativeWork
    117 https://doi.org/10.1136/jcp.48.7.691-a schema:sameAs https://app.dimensions.ai/details/publication/pub.1012875528
    118 rdf:type schema:CreativeWork
    119 https://www.grid.ac/institutes/grid.4709.a schema:alternateName European Molecular Biology Laboratory
    120 schema:name European Molecular Biology Laboratory (EMBL), 69117, Heidelberg, Germany
    121 rdf:type schema:Organization
    122 https://www.grid.ac/institutes/grid.4714.6 schema:alternateName Karolinska Institute
    123 schema:name Center for Family and Community Medicine, Karolinska Institute, SE-14183, Huddinge, Sweden
    124 Department of Molecular Genetic Epidemiology, German Cancer Research Center (DKFZ), 69120, Heidelberg, Germany
    125 rdf:type schema:Organization
    126 https://www.grid.ac/institutes/grid.7497.d schema:alternateName German Cancer Research Center
    127 schema:name Department of Molecular Genetic Epidemiology, German Cancer Research Center (DKFZ), 69120, Heidelberg, Germany
    128 rdf:type schema:Organization
     




    Preview window. Press ESC to close (or click here)


    ...