Query: Top 10 Most-Cited Publications (OpenAIRE) by Paulo Sousa

1SELECT
2  SUBSTRING(maintitle, 1, 50) AS title,
3  try_cast (
4    regexp_extract(indicators, 'citationCount.: ([0-9.]+)', 1) AS DOUBLE
5  ) AS citations,
6publicationdate,
7publisher,
8id,
9container, 
10authors[:50] as authors_snippet,
11descriptions[:100] as description_snippet,
12indicators
13FROM
14  "@openaire.graph_publications.publications"
15WHERE
16  indicators IS NOT NULL
17  AND indicators LIKE '%citationCount%'
18ORDER BY
19  try_cast (
20    regexp_extract(indicators, 'citationCount.: ([0-9.]+)', 1) AS DOUBLE
21  ) DESC NULLS LAST
22LIMIT
23  10

title	citations	publicationdate	publisher	id	container	authors_snippet	description_snippet	indicators
PROTEIN MEASUREMENT WITH THE FOLIN PHENOL REAGENT	340187	1951-11-01	Elsevier BV	doi_dedup___::6013564d557628905abf3c0f70e51675	{'name': Journal of Biological Chemistry, 'issnPrinted': 0021-9258, 'issnOnline': NULL, 'issnLinking': NULL, 'ep': 275, 'iss': NULL, 'sp': 265, 'vol': 193, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': 'O H, LOWRY', 'name': O H, 'surname'	null	{'citationImpact': {'citationCount': 340187.0, 'influence': 5.3589443e-05, 'popularity': 1.9714265e-05, 'impulse': 84.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C3, 'popularityClass': C1}, 'usageCounts': NULL}
Cleavage of Structural Proteins during the Assembl	262820	1970-08-01	Springer Science and Business Media LLC	doi_dedup___::ee253ec27e28ed6b0df7da99c853917f	{'name': Nature, 'issnPrinted': 0028-0836, 'issnOnline': 1476-4687, 'issnLinking': NULL, 'ep': 685, 'iss': NULL, 'sp': 680, 'vol': 227, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': 'Laemmli, Ulrich Karl', 'name': Ulri	['Using an improved method of gel electrophoresis, many hitherto unknown proteins have been found in	{'citationImpact': {'citationCount': 262820.0, 'influence': 3.0128942e-05, 'popularity': 1.6633692e-05, 'impulse': 403.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
A Rapid and Sensitive Method for the Quantitation	248877	1976-05-01	Elsevier BV	doi_dedup___::ec319731a12c0b83e5d4bf781693cdac	{'name': Analytical Biochemistry, 'issnPrinted': 0003-2697, 'issnOnline': NULL, 'issnLinking': NULL, 'ep': 254, 'iss': NULL, 'sp': 248, 'vol': 72, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': Marion M. Bradford, 'name': NULL, 's	['Abstract A protein determination method which involves the binding of Coomassie Brilliant Blue G	{'citationImpact': {'citationCount': 248877.0, 'influence': 1.994387e-05, 'popularity': 3.495533e-05, 'impulse': 760.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
Generalized Gradient Approximation Made Simple	165230	1996-10-28	American Physical Society (APS)	doi_dedup___::9e66d033e8035c05be96e5e1e268e2dd	{'name': Physical Review Letters, 'issnPrinted': 0031-9007, 'issnOnline': 1079-7114, 'issnLinking': NULL, 'ep': 3868, 'iss': NULL, 'sp': 3865, 'vol': 77, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': John P. Perdew, 'name': NULL, 'surna	['Generalized gradient approximations (GGA’s) for the exchange-correlation energy improve upon the l	{'citationImpact': {'citationCount': 165230.0, 'influence': 7.872996e-06, 'popularity': 6.263603e-05, 'impulse': 287.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C2, 'popularityClass': C1}, 'usageCounts': NULL}
Analysis of Relative Gene Expression Data Using Re	159700	2001-12-01	Elsevier BV	doi_dedup___::1d94c7d28dba6d3c5317dd607ff7829a	{'name': Methods, 'issnPrinted': 1046-2023, 'issnOnline': NULL, 'issnLinking': NULL, 'ep': 408, 'iss': NULL, 'sp': 402, 'vol': 25, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': Thomas D. Schmittgen, 'name': NULL,	['The two most commonly used methods to analyze data from real-time, quantitative PCR experiments ar	{'citationImpact': {'citationCount': 159700.0, 'influence': 6.175853e-06, 'popularity': 5.661756e-05, 'impulse': 498.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
Deep Residual Learning for Image Recognition	128407	2016-06-01	IEEE	doi_dedup___::94a532a2d7afe4386242b6d2a5a783ef	{'name': '2016 IEEE Conference on Computer Vision and Pattern Recognition (CVPR)', 'issnPrinted': NULL, 'issnOnline': NULL, 'issnLinking': NULL, 'ep': 778, 'iss': NULL, 'sp': 770, 'vol': NULL, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': Shaoqing Ren, 'name': NULL, 'surname	['Deeper neural networks are more difficult to train. We present a residual learning framework to ea	{'citationImpact': {'citationCount': 128407.0, 'influence': 1.2750633e-05, 'popularity': 9.2474176e-05, 'impulse': 20598.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
Using thematic analysis in psychology	125013	2006-01-01	Informa UK Limited	doi_dedup___::812fb2552b98b6b082e6495e638920c4	{'name': Qualitative Research in Psychology, 'issnPrinted': 1478-0887, 'issnOnline': 1478-0895, 'issnLinking': NULL, 'ep': 101, 'iss': NULL, 'sp': 77, 'vol': 3, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': Virginia Braun, 'name': NULL, 'surna	['Thematic analysis is a poorly demarcated, rarely acknowledged, yet widely used qualitative analyti	{'citationImpact': {'citationCount': 125013.0, 'influence': 7.658036e-06, 'popularity': 6.905882e-05, 'impulse': 384.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
Preferred Reporting Items for Systematic Reviews a	123288	2009-07-21	Public Library of Science (PLoS)	doi_dedup___::0a4205bfc259eb8ca29fb2cffe49f4ee	{'name': PLoS Medicine, 'issnPrinted': NULL, 'issnOnline': 1549-1676, 'issnLinking': NULL, 'ep': NULL, 'iss': NULL, 'sp': e1000097, 'vol': 6, 'edition': NULL, 'conferencePlace': NULL, 'conferenceDate': NULL}	[{'fullName': Moher D., 'name': '', 'surname': '',	['David Moher and colleagues introduce PRISMA, an update of the QUOROM guidelines for reporting syst	{'citationImpact': {'citationCount': 123288.0, 'influence': 6.540874e-06, 'popularity': 5.90258e-05, 'impulse': 2515.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': {'downloads': 434, 'views': 1078}}
Diagnostic and Statistical Manual of Mental Disord	101512	2013-06-11	NASW Press and Oxford University Press	doi_dedup___::a67dbeb45511a6c1bf34e139e2e6898a	null	[{'fullName': Janet B. W. Williams, 'name': Janet	['<p>The fifth edition of the <italic>Diagnostic and Statistical Manual of Mental Disorders</italic>	{'citationImpact': {'citationCount': 101512.0, 'influence': 1.0501542e-05, 'popularity': 1.2684399e-05, 'impulse': 81746.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}
Diagnostic and Statistical Manual of Mental Disord	97078	2013-05-22	American Psychiatric Association	doi_dedup___::a2abd076a0febb7bff0e282066997dc6	null	[{'fullName': null American Psychiatric Associatio	null	{'citationImpact': {'citationCount': 97078.0, 'influence': 6.076828e-06, 'popularity': 4.496645e-05, 'impulse': 14515.0, 'citationClass': C1, 'influenceClass': C1, 'impulseClass': C1, 'popularityClass': C1}, 'usageCounts': NULL}

Query Result