{"id":"https://openalex.org/W3216428676","doi":"https://doi.org/10.1002/bmb.21596","title":"A simple spreadsheet\u2010based method for relative quantification using quantitative real\u2010time PCR","display_name":"A simple spreadsheet\u2010based method for relative quantification using quantitative real\u2010time PCR","publication_year":2021,"publication_date":"2021-12-02","ids":{"openalex":"https://openalex.org/W3216428676","doi":"https://doi.org/10.1002/bmb.21596","mag":"3216428676","pmid":"https://pubmed.ncbi.nlm.nih.gov/34854201"},"language":"en","primary_location":{"id":"doi:10.1002/bmb.21596","doi":"https://doi.org/10.1002/bmb.21596","is_oa":false,"landing_page_url":"https://doi.org/10.1002/bmb.21596","pdf_url":null,"source":{"id":"https://openalex.org/S105183386","display_name":"Biochemistry and Molecular Biology Education","issn_l":"1470-8175","issn":["1470-8175","1539-3429"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","doyens","erih-plus","jufo-1","ki-jl-1","medline","norway-1","poland-40","russia-white-list-3"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Biochemistry and Molecular Biology Education","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref","pubmed"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5062819728","display_name":"Hien Fuh Ng","orcid":"https://orcid.org/0000-0001-7228-096X","observed_orcids":["https://orcid.org/0000-0001-7228-096X"]},"institutions":[{"id":"https://openalex.org/I4405256456","display_name":"Universiti Tunku Abdul Rahman Sungai Long Campus","ror":"https://ror.org/046b54093","country_code":"MY","type":"education","lineage":["https://openalex.org/I4405256456","https://openalex.org/I931681460"]},{"id":"https://openalex.org/I931681460","display_name":"Universiti Tunku Abdul Rahman","ror":"https://ror.org/050pq4m56","country_code":"MY","type":"education","lineage":["https://openalex.org/I931681460"]}],"countries":["MY"],"is_corresponding":false,"raw_author_name":"Hien Fuh Ng","raw_affiliation_strings":["Centre for Research on Communicable Diseases, Faculty of Medicine and Health Sciences Universiti Tunku Abdul Rahman  Kajang Selangor Malaysia"],"raw_orcid":"https://orcid.org/0000-0001-7228-096X","affiliations":[{"raw_affiliation_string":"Centre for Research on Communicable Diseases, Faculty of Medicine and Health Sciences Universiti Tunku Abdul Rahman  Kajang Selangor Malaysia","institution_ids":["https://openalex.org/I4405256456","https://openalex.org/I931681460"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011864259","display_name":"Yun Fong Ngeow","orcid":"https://orcid.org/0000-0002-1011-762X","observed_orcids":["https://orcid.org/0000-0002-1011-762X"]},"institutions":[{"id":"https://openalex.org/I4405256456","display_name":"Universiti Tunku Abdul Rahman Sungai Long Campus","ror":"https://ror.org/046b54093","country_code":"MY","type":"education","lineage":["https://openalex.org/I4405256456","https://openalex.org/I931681460"]},{"id":"https://openalex.org/I931681460","display_name":"Universiti Tunku Abdul Rahman","ror":"https://ror.org/050pq4m56","country_code":"MY","type":"education","lineage":["https://openalex.org/I931681460"]}],"countries":["MY"],"is_corresponding":false,"raw_author_name":"Yun Fong Ngeow","raw_affiliation_strings":["Centre for Research on Communicable Diseases, Faculty of Medicine and Health Sciences Universiti Tunku Abdul Rahman  Kajang Selangor Malaysia"],"raw_orcid":"https://orcid.org/0000-0002-1011-762X","affiliations":[{"raw_affiliation_string":"Centre for Research on Communicable Diseases, Faculty of Medicine and Health Sciences Universiti Tunku Abdul Rahman  Kajang Selangor Malaysia","institution_ids":["https://openalex.org/I4405256456","https://openalex.org/I931681460"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":3000,"currency":"USD","value_usd":3000},"apc_paid":null,"fwci":0.5593,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.56183664,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":99},"biblio":{"volume":"50","issue":"1","first_page":"99","last_page":"103"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11970","display_name":"Molecular Biology Techniques and Applications","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T11970","display_name":"Molecular Biology Techniques and Applications","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10885","display_name":"Gene expression and cancer classification","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T13937","display_name":"Genetics, Bioinformatics, and Biomedical Research","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/relative-quantification","display_name":"relative quantification","score":0.9760000109672546},{"id":"https://openalex.org/keywords/quantitative-real-time-pcr","display_name":"quantitative real-time PCR","score":0.9539999961853027},{"id":"https://openalex.org/keywords/spreadsheet-based-calculation","display_name":"spreadsheet-based calculation","score":0.7229999899864197},{"id":"https://openalex.org/keywords/gene-expression-normalization","display_name":"gene expression normalization","score":0.8669999837875366},{"id":"https://openalex.org/keywords/reference-genes","display_name":"reference genes","score":0.8349999785423279},{"id":"https://openalex.org/keywords/pcr-efficiency","display_name":"PCR efficiency","score":0.8840000033378601},{"id":"https://openalex.org/keywords/statistical-analysis-of-gene-expression","display_name":"statistical analysis of gene expression","score":0.5630000233650208},{"id":"https://openalex.org/keywords/bioinformatics-education","display_name":"bioinformatics education","score":0.47999998927116394}],"concepts":[{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.7811971306800842},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.687333881855011},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.6167668104171753},{"id":"https://openalex.org/C90559484","wikidata":"https://www.wikidata.org/wiki/Q778379","display_name":"Expression (computer science)","level":2,"score":0.4525519907474518},{"id":"https://openalex.org/C95986675","wikidata":"https://www.wikidata.org/wiki/Q185168","display_name":"Quantitative analysis (chemistry)","level":2,"score":0.44933977723121643},{"id":"https://openalex.org/C2986587452","wikidata":"https://www.wikidata.org/wiki/Q938438","display_name":"Statistical analysis","level":2,"score":0.44186514616012573},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43851327896118164},{"id":"https://openalex.org/C2779148672","wikidata":"https://www.wikidata.org/wiki/Q25326537","display_name":"Reference genes","level":4,"score":0.427916556596756},{"id":"https://openalex.org/C48023723","wikidata":"https://www.wikidata.org/wiki/Q856198","display_name":"Real-time polymerase chain reaction","level":3,"score":0.35752853751182556},{"id":"https://openalex.org/C70721500","wikidata":"https://www.wikidata.org/wiki/Q177005","display_name":"Computational biology","level":1,"score":0.35393157601356506},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.23686257004737854},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.22265753149986267},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.188651442527771},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17729505896568298},{"id":"https://openalex.org/C54355233","wikidata":"https://www.wikidata.org/wiki/Q7162","display_name":"Genetics","level":1,"score":0.1264902651309967},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.09425866603851318},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.08898481726646423},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08059605956077576},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012107","descriptor_name":"Research Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D020869","descriptor_name":"Gene Expression Profiling","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D060888","descriptor_name":"Real-Time Polymerase Chain Reaction","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.1002/bmb.21596","doi":"https://doi.org/10.1002/bmb.21596","is_oa":false,"landing_page_url":"https://doi.org/10.1002/bmb.21596","pdf_url":null,"source":{"id":"https://openalex.org/S105183386","display_name":"Biochemistry and Molecular Biology Education","issn_l":"1470-8175","issn":["1470-8175","1539-3429"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","doyens","erih-plus","jufo-1","ki-jl-1","medline","norway-1","poland-40","russia-white-list-3"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Biochemistry and Molecular Biology Education","raw_type":"journal-article"},{"id":"pmid:34854201","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/34854201","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Biochemistry and molecular biology education : a bimonthly publication of the International Union of Biochemistry and Molecular Biology","raw_type":"Journal Article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1577577364","https://openalex.org/W2099249565","https://openalex.org/W2099824652","https://openalex.org/W2105423509","https://openalex.org/W2107277218","https://openalex.org/W2108244474","https://openalex.org/W2111427334","https://openalex.org/W2136212493","https://openalex.org/W2954836300","https://openalex.org/W2989225633"],"related_works":["https://openalex.org/W7154951266","https://openalex.org/W4286218944","https://openalex.org/W2099249565","https://openalex.org/W2403455606","https://openalex.org/W7096280655","https://openalex.org/W2329707261","https://openalex.org/W2138581811","https://openalex.org/W4382725711","https://openalex.org/W4413117363","https://openalex.org/W2115513841"],"abstract_inverted_index":{"Abstract":[0],"Relative":[1,135],"quantification":[2],"is":[3],"a":[4,94,141,168],"popular":[5,142],"analysis":[6,26,85,106],"in":[7,93,176],"gene":[8,81],"expression":[9],"studies":[10],"using":[11,20],"quantitative":[12],"real\u2010time":[13],"PCR":[14],"(qPCR).":[15],"However,":[16],"the":[17,21,47,56,88,91,100,105,109,130,134,177],"calculation":[18,76,153],"steps":[19,154],"major":[22],"algorithms":[23],"for":[24,39,144,171],"this":[25,31],"are":[27,46],"rather":[28],"complicated.":[29],"In":[30],"study,":[32],"we":[33],"developed":[34],"an":[35],"easy\u2010to\u2010use":[36],"spreadsheet\u2010based":[37],"method":[38,67],"relative":[40,145],"quantification.":[41,146],"The":[42,124],"inputs":[43],"from":[44,62],"end\u2010users":[45,101],"efficiencies":[48],"of":[49,59,77,80,179],"both":[50],"target":[51],"and":[52,55,64,83,155,174],"reference":[53,74],"genes":[54,61],"Cq":[57],"values":[58],"those":[60],"cases":[63],"controls.":[65],"This":[66],"performed":[68],"normalization":[69],"(with":[70],"one":[71],"or":[72,162],"more":[73],"genes),":[75],"fold":[78],"change":[79],"expression,":[82],"statistical":[84],"to":[86,102,164],"analyze":[87],"difference":[89],"between":[90],"groups":[92],"step\u2010by\u2010step":[95],"manner,":[96],"which":[97,150],"would":[98,166],"allow":[99],"understand":[103],"how":[104],"arrived":[107],"at":[108],"conclusion.":[110],"Four":[111],"previously":[112],"published":[113],"data":[114],"sets":[115],"with":[116,129],"different":[117],"experimental":[118],"designs":[119],"were":[120,127],"used":[121],"as":[122],"examples.":[123],"calculated":[125],"results":[126,131],"concordant":[128],"computed":[132],"by":[133],"Expression":[136],"Software":[137],"Tool":[138],"(REST)":[139],"2009,":[140],"tool":[143,170],"Altogether,":[147],"our":[148],"method,":[149],"offers":[151],"easy\u2010to\u2010understand":[152],"does":[156],"not":[157],"require":[158],"specialized":[159],"instruments,":[160],"software,":[161],"expertise":[163],"operate,":[165],"be":[167],"useful":[169],"students,":[172],"educators,":[173],"scientists":[175],"field":[178],"molecular":[180],"biology.":[181]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2021-12-06T00:00:00"}