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 N29c93f4e144748b4af1bcf299c5d7695
    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 N03ca53f715ff46ed8642c6edcfa969ab
    21 N3f9a3ee9b881471597569bc6905aeac6
    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 N38ef05f57eaa471f9635b923b189e40f
    26 N86060f8c0a864410a5613436fd4cffac
    27 N9ded757e091246c7be43a47d389212f5
    28 Na1d95f38bdb2454696be9e406da09cda
    29 Nfac7e4e21361431188d4efa8f3cb261c
    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 Naa48cfa232ea4ebfaf3048ddc913679b
    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 N03ca53f715ff46ed8642c6edcfa969ab schema:volumeNumber 2
    40 rdf:type schema:PublicationVolume
    41 N2435f099e06a4ac7b3374bfcc5666e76 rdf:first sg:person.0726772160.17
    42 rdf:rest rdf:nil
    43 N29c93f4e144748b4af1bcf299c5d7695 rdf:first sg:person.01007446576.93
    44 rdf:rest Nc9793758790c4faa9aef59f4513e3a66
    45 N38ef05f57eaa471f9635b923b189e40f schema:name readcube_id
    46 schema:value 743530ed623582474da07e93924cd9041c91cf31ec5e827c4e6e13a2d1386063
    47 rdf:type schema:PropertyValue
    48 N3f9a3ee9b881471597569bc6905aeac6 schema:issueNumber 1
    49 rdf:type schema:PublicationIssue
    50 N86060f8c0a864410a5613436fd4cffac schema:name nlm_unique_id
    51 schema:value 101462768
    52 rdf:type schema:PropertyValue
    53 N9ded757e091246c7be43a47d389212f5 schema:name dimensions_id
    54 schema:value pub.1024392375
    55 rdf:type schema:PropertyValue
    56 Na1d95f38bdb2454696be9e406da09cda schema:name pubmed_id
    57 schema:value 19852806
    58 rdf:type schema:PropertyValue
    59 Naa48cfa232ea4ebfaf3048ddc913679b schema:name Springer Nature - SN SciGraph project
    60 rdf:type schema:Organization
    61 Nc9793758790c4faa9aef59f4513e3a66 rdf:first sg:person.01031455532.19
    62 rdf:rest Nd1428e900cb141f0b06cdddd6fed7a3e
    63 Nd1428e900cb141f0b06cdddd6fed7a3e rdf:first sg:person.0705271026.69
    64 rdf:rest N2435f099e06a4ac7b3374bfcc5666e76
    65 Nfac7e4e21361431188d4efa8f3cb261c schema:name doi
    66 schema:value 10.1186/1756-0500-2-214
    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)


    ...