Source: https://github.com/markziemann/GeneNameErrors2020

View the reports: http://ziemann-lab.net/public/gene_name_errors/

Intro

Gene name errors result when data are imported improperly into MS Excel and other spreadsheet programs (Zeeberg et al, 2004). Certain gene names like MARCH3, SEPT2 and DEC1 are converted into date format. These errors are surprisingly common in supplementary data files in the field of genomics (Ziemann et al, 2016). This could be considered a small error because it only affects a small number of genes, however it is symptomtic of poor data processing methods. The purpose of this script is to identify gene name errors present in supplementary files of PubMed Central articles in the previous month.

library("jsonlite")
library("xml2")
library("reutils")
library("readxl")

Get PMC IDs

Here I will be getting PubMed Central IDs for the previous month.

Start with figuring out the date to search PubMed Central.

DATE="2022/5"

Let’s see how many PMC IDs we have in the past month.

QUERY ='((genom*[Abstract]))'

ESEARCH_RES <- esearch(term=QUERY, db = "pmc", rettype = "uilist", retmode = "xml", retstart = 0, 
  retmax = 5000000, usehistory = TRUE, webenv = NULL, querykey = NULL, sort = NULL, field = NULL, 
  datetype = NULL, reldate = NULL, mindate = DATE, maxdate = DATE)

pmc <- efetch(ESEARCH_RES,retmode="text",rettype="uilist",outfile="pmcids.txt")
## Retrieving UIDs 1 to 500
## Retrieving UIDs 501 to 1000
## Retrieving UIDs 1001 to 1500
## Retrieving UIDs 1501 to 2000
## Retrieving UIDs 2001 to 2500
## Retrieving UIDs 2501 to 3000
## Retrieving UIDs 3001 to 3500
pmc <- read.table(pmc)
pmc <- paste("PMC",pmc$V1,sep="")
NUM_ARTICLES=length(pmc)
NUM_ARTICLES
## [1] 3148
writeLines(pmc,con="pmc.txt")

Run the screen

Now run the bash script. As PMC has changed and restricts scraping journal articles, it is best to use the dedicated utility called pygetpapers for the download.

Note that false positives can occur (~1.5%) and these results have not been verified by a human.

Here are some definitions:

system("./gene_names.sh pmc.txt")
results <- readLines("results.txt")

XLS <- results[grep("XLS",results,ignore.case=TRUE)]
NUM_XLS = length(XLS)
NUM_XLS
## [1] 5458
NUM_XLS_ARTICLES = length(unique(sapply(strsplit(XLS," "),"[[",1)))
NUM_XLS_ARTICLES
## [1] 931
GENELISTS <- XLS[lapply(strsplit(XLS," "),length)>2]
#GENELISTS

NUM_GENELISTS <- length(unique(sapply(strsplit(GENELISTS," "),"[[",2)))
NUM_GENELISTS
## [1] 777
NUM_GENELIST_ARTICLES <- length(unique(sapply(strsplit(GENELISTS," "),"[[",1)))
NUM_GENELIST_ARTICLES
## [1] 354
ERROR_GENELISTS <- XLS[lapply(strsplit(XLS," "),length)>3]
#ERROR_GENELISTS

NUM_ERROR_GENELISTS = length(ERROR_GENELISTS)
NUM_ERROR_GENELISTS
## [1] 273
GENELIST_ERROR_ARTICLES <- unique(sapply(strsplit(ERROR_GENELISTS," "),"[[",1))
GENELIST_ERROR_ARTICLES
##  [1] "PMC9150314" "PMC9149313" "PMC9146729" "PMC9144384" "PMC9144309"
##  [6] "PMC9141370" "PMC9139936" "PMC9137560" "PMC9104707" "PMC9133720"
## [11] "PMC9106303" "PMC9130556" "PMC9128528" "PMC9128383" "PMC9122603"
## [16] "PMC9124206" "PMC9121553" "PMC9120926" "PMC9113978" "PMC9118152"
## [21] "PMC9117226" "PMC9150894" "PMC9150289" "PMC9104698" "PMC9135276"
## [26] "PMC9135160" "PMC9133343" "PMC9130323" "PMC9128527" "PMC9123275"
## [31] "PMC9122532" "PMC9122980" "PMC9122918" "PMC9121576" "PMC9119800"
## [36] "PMC9118622" "PMC9116208" "PMC9113246" "PMC9110779" "PMC9108397"
## [41] "PMC9108107" "PMC9067402" "PMC9114146" "PMC9110415" "PMC9107348"
## [46] "PMC9106650" "PMC9102361" "PMC9095680" "PMC9091224" "PMC9090837"
## [51] "PMC9089922" "PMC9082922" "PMC9103663" "PMC9080204" "PMC9076534"
## [56] "PMC9068765" "PMC9069606" "PMC9105114" "PMC9061740" "PMC9054707"
## [61] "PMC9098994" "PMC9092402" "PMC9054804" "PMC9097904" "PMC9106336"
## [66] "PMC9081883" "PMC9101002" "PMC9074814" "PMC9073418" "PMC9068942"
## [71] "PMC9065345" "PMC9059228" "PMC9062782" "PMC9062235" "PMC9074372"
## [76] "PMC9099420" "PMC9062783" "PMC9071389" "PMC9085672" "PMC9060359"
## [81] "PMC9062482" "PMC9075957" "PMC9089222" "PMC9095494" "PMC9073733"
## [86] "PMC7612684" "PMC9039713" "PMC9046921"
NUM_ERROR_GENELIST_ARTICLES <- length(GENELIST_ERROR_ARTICLES) 
NUM_ERROR_GENELIST_ARTICLES
## [1] 88
ERROR_PROPORTION = NUM_ERROR_GENELIST_ARTICLES / NUM_GENELIST_ARTICLES
ERROR_PROPORTION
## [1] 0.2485876

Look at the errors detected

Here you can have a look at all the gene lists detected in the past month, as well as those with errors. The dates are obvious errors, these are commonly dates in September, March, December and October. The five-digit numbers represent dates as they are encoded in the Excel internal format. The five digit number is the number of days since 1900. If you were to take these numbers and put them into Excel and format the cells as dates, then these will also mostly map to dates in September, March, December and October.

#GENELISTS

ERROR_GENELISTS
##   [1] "PMC9150314 PMC_DL/PMC9150314/supplementaryfiles/12883_2022_2724_MOESM8_ESM.xlsx Hsapiens 14 44531 44256 44257 44256 44265 44266 44257 44258 44259 44260 44261 44262 44263 44264"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##   [2] "PMC9149313 PMC_DL/PMC9149313/supplementaryfiles/Table_7.xlsx Hsapiens 28 43525 43800 43525 43709 43714 43526 43533 43530 43718 43526 43535 43717 43531 43711 43719 43528 43715 43722 43712 43723 43534 43529 43532 43710 43716 43527 43713 43720"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##   [3] "PMC9146729 zip/Supplemental_Tables_1-9.xlsx Athaliana 40 44807 44807 44807 44805 44807 44807 44807 44807 44807 44807 44807 44807 44807 44805 44805 44807 44807 44805 44807 44805 44805 44805 44805 44807 44807 44807 44807 44807 44807 44805 44807 44805 44807 44807 44807 44807 44807 44807 44807 44807"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##   [4] "PMC9144384 zip/Supplementary_Table_S3-The_unique_PCV3_Cap-123-or_PCV4_Cap_binding_cellular_proteins-206-.xlsx Hsapiens 1 44811"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
##   [5] "PMC9144309 zip/Table_S6.xlsx Hsapiens 23 44077 44088 44085 44075 43891 43891 43899 44078 44079 43896 43892 43900 43892 43898 43893 44083 44082 44080 44081 44076 44089 43897 43895"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
##   [6] "PMC9144309 zip/Table_S3.xlsx Hsapiens 19 44079 44166 44087 43899 44088 43901 44088 43893 44166 43893 43892 43891 44166 43893 44085 43891 44166 43896 43891"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
##   [7] "PMC9144309 zip/Table_S4.xlsx Hsapiens 3 42796 42802 43070"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##   [8] "PMC9144309 zip/Table_S5.xlsx Hsapiens 22 44085 43891 44089 44081 44076 44080 43892 43891 44078 44088 44083 43892 43893 43895 44077 43898 44075 43897 43899 44082 43896 44079"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##   [9] "PMC9141370 zip/Table_S1.candidate_peptides_1.xlsx Hsapiens 19 44896 44813 44816 44808 44630 44813 44818 44808 44818 44808 44808 44815 44808 44815 44815 44815 44808 44630 44818"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [10] "PMC9141370 zip/Table_S2.candidate_peptides_2.xlsx Hsapiens 40 44808 44808 44808 44818 44808 44808 44808 44818 44808 44808 44818 44818 44808 44808 44818 44818 44808 44808 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44818 44815 44815 44815 44815 44815 44818"                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [11] "PMC9139936 zip/Supplementary_Table_S3-Cancers-1693895-.xlsx Hsapiens 3 39326 36951 38961"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##  [12] "PMC9137560 zip/Supplemental_Tables_Final/Morgan_Table_S4.xlsx Hsapiens 4 40057 40057 41883 41883"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [13] "PMC9104707 PMC_DL/PMC9104707/supplementaryfiles/supp_gr.275811.121_Supplemental_Table_S6.xlsx Hsapiens 1 44266"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
##  [14] "PMC9104707 PMC_DL/PMC9104707/supplementaryfiles/supp_gr.275811.121_Supplemental_Table_S12.xlsx Hsapiens 36 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170 43170"                                                                                                                                                                                                                                                                                                                                                                                                                                                        
##  [15] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table2.XLSX Rnorvegicus 4 44448 44258 44443 44256"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [16] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table2.XLSX Mmusculus 8 44448 44442 44450 44258 44443 44444 44256 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [17] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table3.XLSX Mmusculus 3 44445 44256 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [18] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table1.XLSX Rnorvegicus 5 44263 44447 44256 44258 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [19] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table1.XLSX Mmusculus 9 44256 44259 44450 44445 44263 44447 44258 44261 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [20] "PMC9133720 PMC_DL/PMC9133720/supplementaryfiles/Table4.XLSX Rnorvegicus 8 44444 44442 44443 44256 44257 44446 44448 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [21] "PMC9106303 zip/sciadv.abm6638_table_s4.xlsx Hsapiens 27 43161 43435 43170 43349 43165 43354 43162 43352 43345 43358 43357 43168 43344 43160 43160 43164 43163 43346 43167 43169 43161 43166 43355 43347 43348 43351 43353"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [22] "PMC9106303 zip/sciadv.abm6638_table_s4.xlsx Hsapiens 27 43528 43525 43714 43720 43718 43709 43530 43526 43716 43535 43532 43533 43722 43529 43800 43711 43723 43531 43710 43525 43713 43526 43712 43717 43719 43527 43534"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [23] "PMC9106303 zip/sciadv.abm6638_table_s4.xlsx Hsapiens 27 44077 44078 43900 44083 44088 43895 43899 44084 44085 43894 43891 44080 43898 44166 44079 44082 43897 43892 43896 43892 43901 44076 43893 43891 44089 44086 44075"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [24] "PMC9106303 zip/sciadv.abm6638_table_s4.xlsx Hsapiens 27 43723 43718 43800 43530 43525 43531 43716 43711 43528 43719 43714 43527 43526 43710 43722 43717 43533 43709 43720 43535 43525 43529 43713 43532 43712 43534 43526"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [25] "PMC9106303 zip/sciadv.abm6638_table_s4.xlsx Hsapiens 27 43895 44078 44077 44085 44082 44076 44088 43891 44083 43899 43891 44084 43901 43893 43897 44086 43900 43892 43898 44166 43894 44079 43896 44080 44075 44089 43892"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [26] "PMC9130556 PMC_DL/PMC9130556/supplementaryfiles/Table_1.xlsx Hsapiens 20 44258 44441 44450 44262 44442 44263 44260 44445 44446 44444 44447 44259 44257 44265 44449 44261 44440 44256 44448 44264"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [27] "PMC9128528 PMC_DL/PMC9128528/supplementaryfiles/Table_1.xlsx Hsapiens 1 44813"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [28] "PMC9128383 PMC_DL/PMC9128383/supplementaryfiles/Table_4.xlsx Hsapiens 1 44266"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [29] "PMC9128383 PMC_DL/PMC9128383/supplementaryfiles/Table_3.xlsx Hsapiens 16 44262 44261 44258 44263 44260 44257 44531 44263 44256 44257 44262 44261 44258 44531 44263 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##  [30] "PMC9122603 zip/Table_S2._DE_genes_FOSL1,_FOSL2,_Double_KD.xlsx Hsapiens 1 37681"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [31] "PMC9122603 zip/Table_S2._DE_genes_FOSL1,_FOSL2,_Double_KD.xlsx Hsapiens 1 39508"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [32] "PMC9122603 zip/Table_S2._DE_genes_FOSL1,_FOSL2,_Double_KD.xlsx Hsapiens 2 37681 39508"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [33] "PMC9122603 zip/Table_S6._BATF_ChIP_peaks_shared_with_FOSL.xlsx Hsapiens 3 40787 40057 38961"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
##  [34] "PMC9122603 zip/Table_S5._BATF_DE_genes,_ChIP_peaks,_direct_targets_and_motif_analysis.xlsx Hsapiens 31 38595 36038 39325 38595 37315 36038 38595 38776 36219 35764 38776 37680 39325 36219 38230 39325 36219 36219 37864 38595 35764 38595 38046 36219 36585 36585 37499 38595 36585 37315 38595"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [35] "PMC9122603 zip/Table_S5._BATF_DE_genes,_ChIP_peaks,_direct_targets_and_motif_analysis.xlsx Hsapiens 7 37500 39142 37681 37681 40057 38777 38047"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [36] "PMC9122603 zip/Table_S4._FOSL1_FOSL2_ChIP,_shared_direct_targets,_motif_analysis.xlsx Hsapiens 8 38595 39325 38595 36038 38595 37499 37499 38595"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [37] "PMC9122603 zip/Table_S4._FOSL1_FOSL2_ChIP,_shared_direct_targets,_motif_analysis.xlsx Hsapiens 1 37500"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
##  [38] "PMC9122603 zip/Table_S4._FOSL1_FOSL2_ChIP,_shared_direct_targets,_motif_analysis.xlsx Hsapiens 41 38046 36038 38595 36585 38595 37680 38595 39325 38595 37499 35764 38595 39325 36219 36950 36585 35764 38776 38595 38595 38595 38595 36219 38776 37499 36585 37499 38595 36585 38595 38595 37864 35764 38595 36585 37864 36585 38595 40786 37680 36403"                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [39] "PMC9122603 zip/Table_S4._FOSL1_FOSL2_ChIP,_shared_direct_targets,_motif_analysis.xlsx Hsapiens 9 37500 38412 40057 37135 38047 38961 39873 39142 37865"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
##  [40] "PMC9122603 zip/Table_S4._FOSL1_FOSL2_ChIP,_shared_direct_targets,_motif_analysis.xlsx Hsapiens 6 40787 37500 40057 40057 38961 38961"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [41] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 5 44629 44622 44624 44628 44810"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##  [42] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 1 44624"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [43] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 6 44628 44810 44811 44629 44624 44622"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
##  [44] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 2 44448 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
##  [45] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 3 44448 44448 44449"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [46] "PMC9124206 PMC_DL/PMC9124206/supplementaryfiles/41419_2022_4940_MOESM6_ESM.xlsx Hsapiens 1 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [47] "PMC9121553 PMC_DL/PMC9121553/supplementaryfiles/12993_2022_191_MOESM2_ESM.xlsx Hsapiens 3 44166 43900 43892"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
##  [48] "PMC9121553 PMC_DL/PMC9121553/supplementaryfiles/12993_2022_191_MOESM1_ESM.xlsx Hsapiens 3 43900 43892 44166"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
##  [49] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_1.XLSX Hsapiens 2 44629 44819"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
##  [50] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_1.XLSX Hsapiens 2 44622 44625"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
##  [51] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_1.XLSX Hsapiens 1 44621"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [52] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 12 44626 44806 44815 44815 44806 44815 44806 44625 44815 44815 44806 44815"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [53] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 12 44806 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815 44815"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [54] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 2 44814 44621"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
##  [55] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 29 44806 44811 44806 44810 44806 44810 44806 44810 44806 44810 44815 44806 44810 44806 44810 44811 44811 44811 44811 44811 44811 44811 44811 44811 44811 44811 44811 44811 44806"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
##  [56] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 14 44626 44624 44625 44625 44625 44624 44625 44625 44626 44626 44626 44626 44626 44626"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [57] "PMC9120926 PMC_DL/PMC9120926/supplementaryfiles/Table_8.XLSX Hsapiens 19 44815 44806 44818 44815 44806 44818 44815 44806 44813 44818 44815 44806 44813 44818 44815 44806 44815 44806 44818"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
##  [58] "PMC9113978 zip/ZR-43-367-Supplementary_Tables.xlsx Athaliana 1 2-Oct"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [59] "PMC9118152 PMC_DL/PMC9118152/supplementaryfiles/mmc5.xlsx Hsapiens 4 44621 44815 44621 44623"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [60] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM20_ESM.xlsx Dmelanogaster 1 43070"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [61] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM10_ESM.xlsx Mmusculus 24 42433 42615 42438 42621 42617 42439 42622 42440 42435 42616 42625 42618 42431 42432 42434 42436 42628 42624 42627 42437 42614 42430 42620 42619"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
##  [62] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM8_ESM.xlsx Hsapiens 20 44807 44814 44812 44816 44809 44813 44808 44811 44631 44626 44622 44810 44815 44628 44625 44624 44627 44806 44623 44621"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [63] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM8_ESM.xlsx Drerio 15 44451 44449 44256 44442 44260 44445 44454 44441 44261 44266 44257 44264 44262 44259 44263"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [64] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM8_ESM.xlsx Dmelanogaster 5 44444 44441 44531 44443 44440"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
##  [65] "PMC9117226 PMC_DL/PMC9117226/supplementaryfiles/41467_2022_30192_MOESM8_ESM.xlsx Celegans 10 44259 44440 44287 44470 44261 44257 44256 44471 44348 44260"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##  [66] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp1.xlsx Hsapiens 6 44454 44445 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [67] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp1.xlsx Hsapiens 5 44454 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [68] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp1.xlsx Hsapiens 6 44454 44445 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [69] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp1.xlsx Hsapiens 6 44454 44445 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [70] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp1.xlsx Hsapiens 6 44454 44445 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [71] "PMC9150894 PMC_DL/PMC9150894/supplementaryfiles/elife-76804-supp2.xlsx Hsapiens 6 44454 44445 44450 44446 44441 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [72] "PMC9150289 PMC_DL/PMC9150289/supplementaryfiles/12885_2022_9627_MOESM3_ESM.xlsx Hsapiens 28 44896 44818 44621 44630 44631 44622 44623 44624 44625 44626 44627 44628 44629 44621 44622 44819 44805 44814 44815 44816 44806 44807 44808 44809 44810 44811 44812 44813"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
##  [73] "PMC9150289 PMC_DL/PMC9150289/supplementaryfiles/12885_2022_9627_MOESM3_ESM.xlsx Hsapiens 25 44819 44814 44627 44624 44806 44815 44621 44626 44631 44623 44812 44811 44818 44896 44628 44625 44629 44816 44805 44808 44630 44813 44622 44809 44807"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [74] "PMC9104698 PMC_DL/PMC9104698/supplementaryfiles/supp_gr.276286.121_Supplemental_Tables_.xlsx Scerevisiae 1 44835"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [75] "PMC9135276 PMC_DL/PMC9135276/supplementaryfiles/pone.0267882.s008.xlsx Hsapiens 15 43070 42795 42795 42805 42799 42800 42801 42802 42993 42988 42990 42980 42985 42986 42987"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [76] "PMC9135160 PMC_DL/PMC9135160/supplementaryfiles/Table1.XLSX Hsapiens 1 44256"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [77] "PMC9133343 PMC_DL/PMC9133343/supplementaryfiles/Table_2.xlsx Hsapiens 2 44628 44629"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
##  [78] "PMC9130323 PMC_DL/PMC9130323/supplementaryfiles/41467_2022_30512_MOESM4_ESM.xlsx Hsapiens 1 44263"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [79] "PMC9128527 PMC_DL/PMC9128527/supplementaryfiles/Table_2.xlsx Hsapiens 5 38596 37135 37135 38412 36951"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [80] "PMC9123275 PMC_DL/PMC9123275/supplementaryfiles/mmc1.xlsx Hsapiens 112 44454 44261 44448 44448 44442 44440 44450 44444 44449 44256 44444 44257 44440 44451 44443 44262 44453 44444 44441 44448 44261 44257 44443 44451 44445 44440 44266 44264 44440 44256 44262 44257 44256 44257 44444 44258 44261 44258 44264 44256 44260 44443 44446 44256 44256 44442 44449 44450 44261 44451 44445 44265 44260 44450 44446 44263 44447 44451 44448 44449 44259 44265 44449 44257 44454 44453 44447 44454 44258 44264 44265 44531 44447 44441 44257 44442 44256 44441 44264 44446 44450 44445 44260 44445 44454 44266 44531 44263 44266 44263 44256 44447 44453 44263 44259 44258 44442 44262 44443 44262 44531 44257 44259 44260 44265 44266 44531 44259 44453 44257 44446 44441"                    
##  [81] "PMC9123275 PMC_DL/PMC9123275/supplementaryfiles/mmc2.xlsx Hsapiens 28 44449 44454 44261 44448 44443 44262 44256 44442 44260 44263 44265 44259 44453 44258 44447 44441 44264 44446 44256 44257 44531 44266 44450 44445 44257 44451 44440 44444"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
##  [82] "PMC9122532 zip/Supplementary_data.xls Hsapiens 12 44627 44624 44621 44626 44631 44623 44896 44628 44625 44629 44630 44622"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [83] "PMC9122532 zip/Supplementary_data.xls Hsapiens 12 2021/03/01 2021/03/02 2021/03/03 2021/03/04 2021/03/05 2021/03/06 2021/03/07 2021/03/08 2021/03/09 2021/03/10 2021/03/11 2021/12/01"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
##  [84] "PMC9122532 zip/Supplementary_data.xls Hsapiens 12 44256 44259 44264 44263 44257 44262 44260 44258 44531 44261 44266 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
##  [85] "PMC9122980 PMC_DL/PMC9122980/supplementaryfiles/41467_2022_30177_MOESM4_ESM.xls Athaliana 1 38231"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [86] "PMC9122918 PMC_DL/PMC9122918/supplementaryfiles/41467_2022_30513_MOESM4_ESM.xlsx Scerevisiae 1 44105"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [87] "PMC9121576 zip/Additional_data_file_1_a.xlsx Hsapiens 22 43345 43166 43164 43350 43348 43353 43168 43344 43167 43161 43355 43162 43352 37316 43160 43169 43160 43165 43346 43354 43357 43163"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [88] "PMC9119800 PMC_DL/PMC9119800/supplementaryfiles/12035_2022_2860_MOESM4_ESM.xlsx Mmusculus 1 43349"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [89] "PMC9119800 PMC_DL/PMC9119800/supplementaryfiles/12035_2022_2860_MOESM7_ESM.xlsx Mmusculus 2 44621 44813"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [90] "PMC9119800 PMC_DL/PMC9119800/supplementaryfiles/12035_2022_2860_MOESM7_ESM.xlsx Mmusculus 2 44628 44625"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
##  [91] "PMC9118622 PMC_DL/PMC9118622/supplementaryfiles/13046_2022_2384_MOESM2_ESM.xlsx Hsapiens 1 37469"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
##  [92] "PMC9116208 zip/Supplementary_Tables-20220210.xlsx Hsapiens 2 44263 44262"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
##  [93] "PMC9113246 zip/Supplementary_file_4.xlsx Scerevisiae 2 44105 43975"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
##  [94] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 4 44440 44263 44262 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
##  [95] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 14 44263 44261 44256 44442 44262 44445 44265 44449 44447 44258 44450 44264 44446 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
##  [96] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 7 44256 44265 44262 44447 44448 44258 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
##  [97] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 18 44261 44257 44264 44258 44263 44260 44450 44449 44454 44448 44443 44440 44266 44262 44265 44256 44446 44442"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
##  [98] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 13 44263 44261 44256 44262 44264 44259 44449 44442 44443 44454 44260 44444 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
##  [99] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44449 44445 44450 44454 44261 44443 44446 44441 44258 44264 44442"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [100] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 23 44454 44257 44259 44266 44447 44445 44256 44260 44442 44446 44263 44450 44448 44261 44262 44449 44444 44453 44440 44441 44258 44531 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [101] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 7 44454 44260 44453 44263 44265 44448 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [102] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44265 44263 44454 44448 44449 44261 44447 44450 44259 44257 44256"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [103] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44265 44454 44259 44441 44260 44444 44445 44443 44446 44453 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [104] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44445 44262 44450 44259 44261 44448 44263 44446 44451 44256 44454"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [105] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 8 44263 44261 44262 44259 44265 44256 44258 44264"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [106] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 10 44265 44450 44256 44443 44454 44263 44447 44453 44262 44258"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [107] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44256 44450 44441 44445 44440 44262 44446 44265 44263 44449 44266"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [108] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 10 44447 44441 44448 44260 44454 44449 44445 44257 44259 44262"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [109] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 17 44448 44264 44257 44265 44262 44451 44450 44449 44263 44261 44266 44258 44441 44256 44442 44260 44440"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [110] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 8 44454 44257 44448 44444 44441 44443 44259 44446"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [111] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 13 44260 44263 44261 44450 44262 44445 44440 44264 44257 44441 44446 44447 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [112] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44454 44263 44259 44449 44442 44441 44446 44448 44265 44262 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [113] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 10 44263 44256 44454 44261 44447 44444 44448 44445 44450 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [114] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 6 44441 44263 44265 44260 44451 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
## [115] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 20 44450 44447 44261 44264 44263 44448 44256 44266 44443 44449 44257 44262 44454 44260 44258 44446 44445 44444 44451 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [116] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 15 44442 44451 44256 44448 44264 44265 44257 44260 44440 44450 44258 44443 44444 44261 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [117] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 18 44264 44440 44445 44256 44449 44448 44447 44441 44263 44261 44450 44257 44258 44443 44265 44453 44454 44531"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [118] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 13 44265 44263 44442 44454 44264 44257 44260 44447 44450 44451 44259 44261 44444"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [119] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 6 44446 44444 44443 44264 44265 44442"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
## [120] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 11 44454 44449 44256 44265 44448 44260 44446 44441 44262 44258 44450"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [121] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 12 44256 44263 44454 44265 44264 44448 44262 44444 44259 44449 44260 44440"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [122] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 17 44454 44448 44260 44444 44447 44449 44262 44441 44446 44259 44263 44440 44264 44443 44257 44442 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [123] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 7 44263 44262 44445 44261 44446 44449 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [124] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 3 44262 44263 44449"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [125] "PMC9110779 PMC_DL/PMC9110779/supplementaryfiles/Table_2.xlsx Hsapiens 14 44265 44454 44531 44258 44263 44257 44261 44450 44440 44447 44444 44445 44448 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [126] "PMC9108397 PMC_DL/PMC9108397/supplementaryfiles/ijmsv19p0779s2.xlsx Mmusculus 1 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
## [127] "PMC9108107 PMC_DL/PMC9108107/supplementaryfiles/18_2022_4316_MOESM2_ESM.xlsx Hsapiens 112 39326 39326 39326 39326 37135 37135 37135 37135 37500 37500 37500 37500 38596 38596 38596 38596 38231 38231 38231 38231 42248 42248 42248 42248 38777 38777 38777 38777 40057 40057 40057 40057 38961 38961 38961 38961 39692 39692 39692 39692 37226 37226 37226 37226 37316 37316 37316 37316 38412 38412 38412 38412 37316 37316 37316 37316 36951 36951 36951 36951 40787 40787 40787 40787 37865 37865 37865 37865 38047 38047 38047 38047 36951 36951 36951 36951 39142 39142 39142 39142 39873 39873 39873 39873 37681 37681 37681 37681 41153 41153 41153 41153 40422 40422 40422 40422 40238 40238 40238 40238 39508 39508 39508 39508 41883 41883 41883 41883 40603 40603 40603 40603" 
## [128] "PMC9108107 PMC_DL/PMC9108107/supplementaryfiles/18_2022_4316_MOESM2_ESM.xlsx Hsapiens 26 36951 40603 41883 37500 40787 39873 38961 40238 40422 38231 38047 39142 37681 39508 40057 37226 37865 39692 37316 37135 38412 41153 42248 38596 38777 39326"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [129] "PMC9067402 PMC_DL/PMC9067402/supplementaryfiles/supp_gad.349282.121_Supplementary_Table8.xlsx Mmusculus 27 38596 36951 37316 36951 40238 40603 37316 37681 38047 38412 38777 39142 39508 39873 40787 42248 37135 40422 41153 41883 37500 37865 38231 38961 39326 39692 40057"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [130] "PMC9114146 PMC_DL/PMC9114146/supplementaryfiles/41598_2022_12185_MOESM2_ESM.xlsx Hsapiens 1 44258"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [131] "PMC9110415 PMC_DL/PMC9110415/supplementaryfiles/41467_2022_30045_MOESM3_ESM.xlsx Scerevisiae 1 43975"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [132] "PMC9110415 PMC_DL/PMC9110415/supplementaryfiles/41467_2022_30045_MOESM3_ESM.xlsx Scerevisiae 1 44105"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [133] "PMC9107348 PMC_DL/PMC9107348/supplementaryfiles/12032_2022_1665_MOESM3_ESM.xls Hsapiens 26 43892 44077 44078 43892 44081 44080 43897 44085 43899 44086 43894 43891 43896 44088 44082 43898 44076 43900 43893 44075 43901 44083 44079 43891 44084 43895"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [134] "PMC9106650 PMC_DL/PMC9106650/supplementaryfiles/41467_2022_30342_MOESM8_ESM.xlsx Hsapiens 21 43715 43709 43710 43713 43712 43530 43717 43714 43716 43529 43526 43719 43711 43525 43531 43718 43722 43891 42073 42072 42074"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [135] "PMC9106650 PMC_DL/PMC9106650/supplementaryfiles/41467_2022_30342_MOESM5_ESM.xlsx Hsapiens 20 43715 43709 43710 43713 43712 43530 43717 43714 43716 43529 43719 43711 43525 43531 43718 43722 43891 42073 42072 42074"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [136] "PMC9106650 PMC_DL/PMC9106650/supplementaryfiles/41467_2022_30342_MOESM7_ESM.xlsx Hsapiens 21 43715 43709 43710 43713 43712 43530 43717 43714 43716 43529 43526 43719 43711 43525 43531 43718 43722 43891 42073 42072 42074"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [137] "PMC9106650 PMC_DL/PMC9106650/supplementaryfiles/41467_2022_30342_MOESM6_ESM.xlsx Hsapiens 21 43715 43709 43710 43713 43712 43530 43717 43714 43716 43529 43526 43719 43711 43525 43531 43718 43722 43891 42073 42072 42074"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [138] "PMC9102361 PMC_DL/PMC9102361/supplementaryfiles/12915_2022_1300_MOESM2_ESM.xlsx Dmelanogaster 2 38231 37135"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
## [139] "PMC9102361 PMC_DL/PMC9102361/supplementaryfiles/12915_2022_1300_MOESM2_ESM.xlsx Dmelanogaster 4 38231 38596 37135 37500"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [140] "PMC9095680 PMC_DL/PMC9095680/supplementaryfiles/41467_2022_30184_MOESM4_ESM.xlsx Hsapiens 1 41153"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [141] "PMC9095680 PMC_DL/PMC9095680/supplementaryfiles/41467_2022_30184_MOESM4_ESM.xlsx Hsapiens 1 41153"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [142] "PMC9091224 PMC_DL/PMC9091224/supplementaryfiles/41467_2022_30050_MOESM12_ESM.xlsx Hsapiens 12 36951 38047 42248 41883 37865 37226 40238 39142 39508 37135 40787 40057"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
## [143] "PMC9091224 PMC_DL/PMC9091224/supplementaryfiles/41467_2022_30050_MOESM15_ESM.xlsx Hsapiens 1 38231"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [144] "PMC9091224 PMC_DL/PMC9091224/supplementaryfiles/41467_2022_30050_MOESM6_ESM.xlsx Hsapiens 9 37316 37865 37316 41153 38777 41883 37681 40057 40422"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [145] "PMC9090837 PMC_DL/PMC9090837/supplementaryfiles/41467_2022_30207_MOESM7_ESM.xlsx Hsapiens 1 44814"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [146] "PMC9090837 PMC_DL/PMC9090837/supplementaryfiles/41467_2022_30207_MOESM7_ESM.xlsx Hsapiens 3 44814 44813 44622"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
## [147] "PMC9090837 PMC_DL/PMC9090837/supplementaryfiles/41467_2022_30207_MOESM7_ESM.xlsx Hsapiens 3 44814 44815 44812"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
## [148] "PMC9090837 PMC_DL/PMC9090837/supplementaryfiles/41467_2022_30207_MOESM4_ESM.xlsx Hsapiens 1 44076"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [149] "PMC9089922 PMC_DL/PMC9089922/supplementaryfiles/pone.0267180.s007.xlsx Ggallus 20 44261 44446 44446 44449 44257 44450 44442 44454 44445 44262 44260 44263 44441 44447 44451 44444 44448 44448 44443 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [150] "PMC9082922 PMC_DL/PMC9082922/supplementaryfiles/13062_2022_324_MOESM2_ESM.xlsx Hsapiens 5 36892 37104 38200 37469 37834"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [151] "PMC9103663 zip/cancers-1608714-supplementary.xlsx Hsapiens 1 44409"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [152] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM14_ESM.xlsx Hsapiens 21 44089 43894 44082 44085 43893 44079 43898 44077 43896 44084 44081 44083 43892 43891 44078 44076 44080 44075 43895 43897 43899"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [153] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM14_ESM.xlsx Hsapiens 20 44089 43895 44077 43898 44082 44083 44081 43891 44084 44080 43899 43892 44085 43896 44079 44075 44076 43897 43893 44078"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [154] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM14_ESM.xlsx Hsapiens 20 43895 43898 44080 44077 44081 44083 43893 44089 43891 43899 44084 44075 43892 43897 44085 44076 44079 44078 44082 43896"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [155] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM16_ESM.xlsx Hsapiens 21 44078 43894 44089 43892 44079 43899 44084 43895 43893 44083 44081 44085 43897 44075 43896 44077 43891 44080 43898 44082 44076"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [156] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM16_ESM.xlsx Hsapiens 21 43894 44089 43899 43893 44081 43892 44082 44078 43896 44084 44083 43895 43891 43898 44075 44076 44085 44080 44079 44077 43897"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [157] "PMC9080204 PMC_DL/PMC9080204/supplementaryfiles/40478_2022_1372_MOESM16_ESM.xlsx Hsapiens 22 44079 44078 43896 44082 43901 44084 43892 44075 43897 43895 44081 44085 43898 44076 44083 43899 44077 43891 43893 44080 44089 43894"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [158] "PMC9076534 PMC_DL/PMC9076534/supplementaryfiles/41593_2022_1061_MOESM3_ESM.xlsx Hsapiens 61 2022-03-04 2022-03-05 2022-03-01 2022-09-06 2022-09-11 2022-03-02 2022-03-06 2022-03-11 2022-09-10 2022-03-11 2022-03-01 2022-03-05 2022-09-11 2022-03-04 2022-09-07 2022-03-04 2022-03-03 2022-03-11 2022-09-11 2022-03-07 2022-09-06 2022-09-02 2022-09-03 2022-03-01 2022-03-11 2022-03-04 2022-03-03 2022-03-09 2022-09-05 2022-09-03 2022-09-07 2022-03-04 2022-03-08 2022-03-07 2022-03-01 2022-09-11 2022-03-01 2022-09-10 2022-03-05 2022-09-14 2022-09-02 2022-03-11 2022-09-08 2022-09-03 2022-09-07 2022-09-05 2022-09-10 2022-03-11 2022-03-04 2022-03-08 2022-03-07 2022-09-03 2022-03-05 2022-03-06 2022-03-01 2022-09-10 2022-09-11 2022-03-01 2022-09-09 2022-03-05 2022-09-02"
## [159] "PMC9068765 PMC_DL/PMC9068765/supplementaryfiles/41467_2022_29960_MOESM9_ESM.xlsx Hsapiens 3 40787 40422 40422"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
## [160] "PMC9069606 PMC_DL/PMC9069606/supplementaryfiles/sj-xlsx-6-mpx-10.1177_17448069221097760.xlsx Mmusculus 1 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [161] "PMC9069606 PMC_DL/PMC9069606/supplementaryfiles/sj-xlsx-6-mpx-10.1177_17448069221097760.xlsx Mmusculus 1 44263"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [162] "PMC9069606 PMC_DL/PMC9069606/supplementaryfiles/sj-xlsx-6-mpx-10.1177_17448069221097760.xlsx Mmusculus 2 44444 44263"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [163] "PMC9069606 PMC_DL/PMC9069606/supplementaryfiles/sj-xlsx-7-mpx-10.1177_17448069221097760.xlsx Mmusculus 1 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [164] "PMC9069606 PMC_DL/PMC9069606/supplementaryfiles/sj-xlsx-5-mpx-10.1177_17448069221097760.xlsx Hsapiens 1 2022/03/01"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [165] "PMC9105114 zip/Suplementary_tables.xlsx Hsapiens 5 40057 37500 40787 39326 39692"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [166] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 2 37316 40057"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [167] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 1 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [168] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 2 40787 37135"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [169] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 3 37316 39692 38596"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [170] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 2 38596 41883"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [171] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 3 40057 37316 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [172] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 2 39692 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [173] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 1 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [174] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 2 39692 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [175] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 1 39692"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [176] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 1 37316"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [177] "PMC9061740 PMC_DL/PMC9061740/supplementaryfiles/41398_2022_1936_MOESM2_ESM.xlsx Hsapiens 1 38596"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [178] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 2 43892 43891"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [179] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 9 43891 44085 43898 43892 44081 44080 44076 44083 43892"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [180] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 10 44084 43900 43896 44080 43896 44083 44085 44083 44076 44081"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [181] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 4 41521 41521 41334 41334"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [182] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 9 41521 41519 41334 41334 41521 41523 41341 41341 41335"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [183] "PMC9054707 PMC_DL/PMC9054707/supplementaryfiles/mmc3.xlsx Hsapiens 2 38961 38961"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [184] "PMC9098994 PMC_DL/PMC9098994/supplementaryfiles/Table_1.xlsx Hsapiens 4 39873 39326 39142 38777"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
## [185] "PMC9092402 PMC_DL/PMC9092402/supplementaryfiles/advancesADV2021006410-suppl2.xlsx Hsapiens 2 42985 42985"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
## [186] "PMC9092402 PMC_DL/PMC9092402/supplementaryfiles/advancesADV2021006410-suppl2.xlsx Hsapiens 1 42980"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [187] "PMC9054804 PMC_DL/PMC9054804/supplementaryfiles/41598_2022_11089_MOESM2_ESM.xlsx Hsapiens 15 44626 44627 44813 44806 44811 44814 44815 44819 44622 44626 44812 44812 44814 44627 44819"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [188] "PMC9054804 PMC_DL/PMC9054804/supplementaryfiles/41598_2022_11089_MOESM2_ESM.xlsx Hsapiens 8 44819 44627 44814 44812 44812 44626 44625 44622"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
## [189] "PMC9097904 PMC_DL/PMC9097904/supplementaryfiles/Table_6.xls Hsapiens 24 2019/09/02 2019/09/08 2019/09/07 2019/09/09 2019/03/03 2019/12/01 2019/09/06 2019/03/02 2019/03/10 2019/09/11 2019/03/11 2019/09/04 2019/03/09 2019/09/05 2019/03/05 2019/03/02 2019/09/10 2019/03/04 2019/03/07 2019/09/12 2019/03/01 2019/09/03 2019/03/06 2019/03/01"                                                                                                                                                                                                                                                                                                                                                                                                                                           
## [190] "PMC9106336 PMC_DL/PMC9106336/supplementaryfiles/elife-76539-supp6.xlsx Mmusculus 25 40057 39692 39326 38231 36951 38596 38412 40787 42248 39508 37865 38047 39873 37316 40422 38961 37500 38777 40603 39142 37681 37135 41153 41883 40238"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [191] "PMC9106336 PMC_DL/PMC9106336/supplementaryfiles/elife-76539-supp6.xlsx Mmusculus 25 40057 39692 36951 40603 40422 38596 38231 40787 39142 39508 39326 40238 38412 37500 39873 37865 37316 38777 37681 38047 42248 38961 37135 41153 41883"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [192] "PMC9106336 PMC_DL/PMC9106336/supplementaryfiles/elife-76539-supp4.xlsx Mmusculus 25 38231 38412 40057 39326 38596 36951 40422 39692 40787 42248 38047 39508 37316 38777 38961 40603 40238 37681 37500 39873 37865 39142 37135 41153 41883"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [193] "PMC9081883 zip/Supplementary_Table_S12.xlsx Athaliana 2 44805 44807"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
## [194] "PMC9101002 zip/Table_S1_Identification_of_total_circular_RNAs-circRNAs-.xlsx Ggallus 18 44261 44449 44262 44441 44449 44445 44449 44449 44262 44262 44261 44263 44449 44262 44262 44441 44261 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
## [195] "PMC9074814 PMC_DL/PMC9074814/supplementaryfiles/Table_5.xls Hsapiens 1 2021/03/06"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [196] "PMC9074814 PMC_DL/PMC9074814/supplementaryfiles/Table_5.xls Ggallus 1 2021/03/06"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [197] "PMC9074814 PMC_DL/PMC9074814/supplementaryfiles/Table_5.xls Hsapiens 2 2021/03/01 2021/03/02"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [198] "PMC9074814 PMC_DL/PMC9074814/supplementaryfiles/Table_5.xls Hsapiens 1 2021/03/02"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [199] "PMC9073418 PMC_DL/PMC9073418/supplementaryfiles/Supplementary_Data12.xlsx Hsapiens 1 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [200] "PMC9068942 zip/Supplementary_Table_3.XLSX Hsapiens 2 37865 40787"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [201] "PMC9065345 PMC_DL/PMC9065345/supplementaryfiles/Table_3.xlsx Hsapiens 1 44621"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
## [202] "PMC9065345 PMC_DL/PMC9065345/supplementaryfiles/Table_2.xlsx Hsapiens 2 44623 44621"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
## [203] "PMC9065345 PMC_DL/PMC9065345/supplementaryfiles/Table_1.xlsx Hsapiens 3 44621 44623 44651"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [204] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-9.xlsx Mmusculus 1 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [205] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-7.xlsx Mmusculus 1 44440"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [206] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-7.xlsx Mmusculus 1 44446"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [207] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 2 44256 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [208] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44256"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [209] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 3 44448 44440 44446"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [210] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 3 44440 44445 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [211] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44450"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [212] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 3 44440 44445 44446"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [213] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [214] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44442"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [215] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44262"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [216] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 2 44260 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [217] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44448"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [218] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44450"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [219] "PMC9059228 PMC_DL/PMC9059228/supplementaryfiles/NIHMS1799981-supplement-5.xlsx Mmusculus 1 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [220] "PMC9062782 PMC_DL/PMC9062782/supplementaryfiles/Table_3.XLSX Ggallus 5 44262 44262 44263 44261 44258"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [221] "PMC9062235 PMC_DL/PMC9062235/supplementaryfiles/Table_2.XLSX Athaliana 29 37104 39873 37500 38200 37316 39356 39356 38930 38930 38930 39873 37895 38261 36951 37895 38261 36951 37681 37895 38261 36951 39661 39661 39661 38930 38930 39661 37712 37712"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [222] "PMC9074372 PMC_DL/PMC9074372/supplementaryfiles/NIHMS1798348-supplement-2.xlsx Scerevisiae 2 24-May 1-Oct"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [223] "PMC9099420 PMC_DL/PMC9099420/supplementaryfiles/NIHMS1798525-supplement-Table_S3.xlsx Mmusculus 1 2020-09-07"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [224] "PMC9099420 PMC_DL/PMC9099420/supplementaryfiles/NIHMS1798525-supplement-Table_S1.xlsx Mmusculus 2 2020-03-05 2020-03-07"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [225] "PMC9062783 zip/Supplementary_tables/Table_S6a-S6b/Table_S6b_all_target_gene.xls.annotate.xls Hsapiens 13 44448 44265 44441 44446 44447 44263 44444 44445 44450 44259 44440 44257 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
## [226] "PMC9071389 zip/Supplementary_Tables_1_to_5_v4.xlsx Dmelanogaster 5 37226 37135 37500 38596 38231"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [227] "PMC9085672 PMC_DL/PMC9085672/supplementaryfiles/10552_2022_1574_MOESM4_ESM.xlsx Hsapiens 8 44257 44265 44261 44454 44440 44453 44443 44444"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [228] "PMC9085672 PMC_DL/PMC9085672/supplementaryfiles/10552_2022_1574_MOESM4_ESM.xlsx Hsapiens 3 44257 44261 44446"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
## [229] "PMC9085672 PMC_DL/PMC9085672/supplementaryfiles/10552_2022_1574_MOESM4_ESM.xlsx Hsapiens 1 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [230] "PMC9085672 PMC_DL/PMC9085672/supplementaryfiles/10552_2022_1574_MOESM4_ESM.xlsx Hsapiens 1 44265"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [231] "PMC9060359 PMC_DL/PMC9060359/supplementaryfiles/pgen.1009638.s008.xlsx Hsapiens 3 37226 10-decarbamoylmitomycin C"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [232] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 11 44444 44444 44444 44261 44261 44445 44441 44441 44446 44446 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [233] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 24 44263 44261 44261 44261 44257 44257 44450 44450 44441 44441 44441 44441 44441 44441 44449 44449 44258 44262 44262 44262 44262 44262 44262 44262"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
## [234] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 10 44440 44444 44444 44261 44446 44442 44443 44443 44443 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
## [235] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 7 44261 44256 44256 44441 44441 44449 44449"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
## [236] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Ggallus 13 44448 44444 44444 44444 44261 44261 44261 44445 44441 44441 44446 44446 44447"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
## [237] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 23 44261 44261 44261 44450 44450 44445 44441 44441 44441 44441 44441 44441 44449 44449 44449 44258 44262 44262 44262 44262 44262 44262 44262"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
## [238] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 8 44444 44444 44261 44446 44442 44443 44443 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [239] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc5.xlsx Hsapiens 12 44440 44261 44256 44256 44441 44441 44441 44441 44449 44449 44443 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
## [240] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc4.xlsx Hsapiens 27 44441 44443 44258 44257 44262 44266 44450 44448 44257 44447 44449 44445 44263 44265 44451 44531 44264 44260 44440 44261 44442 44256 44256 44259 44446 44444 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [241] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc4.xlsx Hsapiens 27 44441 44443 44258 44257 44262 44266 44450 44448 44257 44447 44449 44445 44263 44265 44451 44531 44264 44260 44440 44261 44442 44256 44256 44259 44446 44444 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [242] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc4.xlsx Hsapiens 27 44441 44443 44258 44257 44262 44266 44450 44448 44257 44447 44449 44445 44263 44265 44451 44531 44264 44260 44440 44261 44442 44256 44256 44259 44446 44444 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [243] "PMC9062482 PMC_DL/PMC9062482/supplementaryfiles/mmc4.xlsx Hsapiens 27 44441 44443 44258 44257 44262 44266 44450 44448 44257 44447 44449 44445 44263 44265 44451 44531 44264 44260 44440 44261 44442 44256 44256 44259 44446 44444 44453"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [244] "PMC9075957 PMC_DL/PMC9075957/supplementaryfiles/elife-72989-supp3.xlsx Mmusculus 22 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891 43891"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [245] "PMC9075957 PMC_DL/PMC9075957/supplementaryfiles/elife-72989-supp7.xlsx Mmusculus 1 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
## [246] "PMC9075957 PMC_DL/PMC9075957/supplementaryfiles/elife-72989-supp7.xlsx Mmusculus 1 44440"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
## [247] "PMC9075957 PMC_DL/PMC9075957/supplementaryfiles/elife-72989-supp7.xlsx Rnorvegicus 1 44443"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [248] "PMC9089222 PMC_DL/PMC9089222/supplementaryfiles/CAM4-11-2020-s007.xlsx Hsapiens 1 44259"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [249] "PMC9089222 PMC_DL/PMC9089222/supplementaryfiles/CAM4-11-2020-s014.xlsx Hsapiens 1 44454"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
## [250] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44447 44449 44444 44263 44443 44446 44259 44265 44442 44264 44266 44256 44257 44440 44257 44256 44450 44448 44441 44260 44445 44262 44451 44258 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [251] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44447 44449 44444 44263 44443 44446 44259 44265 44442 44264 44266 44256 44257 44440 44257 44256 44450 44448 44441 44260 44445 44262 44451 44258 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [252] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44447 44443 44449 44264 44446 44263 44444 44442 44256 44441 44259 44262 44265 44257 44451 44256 44260 44440 44445 44261 44266 44258 44257 44448 44450"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [253] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44447 44443 44449 44264 44446 44263 44444 44442 44256 44441 44259 44262 44265 44257 44451 44256 44260 44440 44445 44261 44266 44258 44257 44448 44450"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [254] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44447 44444 44265 44266 44450 44449 44263 44445 44448 44259 44257 44442 44443 44446 44257 44256 44256 44451 44260 44258 44264 44440 44441 44262 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [255] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM5_ESM.xls Hsapiens 25 44265 44266 44257 44264 44440 44444 44449 44447 44256 44259 44442 44445 44263 44256 44258 44441 44446 44260 44443 44448 44262 44450 44451 44257 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [256] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM3_ESM.xls Hsapiens 23 44257 44441 44454 44443 44264 44260 44447 44259 44446 44258 44263 44453 44256 44442 44256 44444 44448 44445 44261 44450 44449 44262 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [257] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM3_ESM.xls Hsapiens 23 44257 44441 44454 44443 44264 44260 44447 44259 44446 44258 44263 44453 44256 44442 44256 44444 44448 44445 44261 44450 44449 44262 44257"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [258] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM3_ESM.xls Hsapiens 23 44257 44449 44263 44447 44441 44264 44448 44442 44453 44262 44256 44445 44446 44260 44259 44258 44443 44444 44450 44257 44261 44256 44454"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [259] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM3_ESM.xls Hsapiens 23 44264 44257 44441 44443 44449 44454 44446 44259 44258 44257 44260 44442 44447 44256 44453 44445 44444 44261 44256 44450 44262 44448 44263"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [260] "PMC9095494 PMC_DL/PMC9095494/supplementaryfiles/41380_2021_1416_MOESM3_ESM.xls Ggallus 23 44257 44443 44263 44441 44447 44261 44257 44259 44264 44453 44446 44442 44444 44449 44258 44448 44260 44450 44256 44454 44256 44262 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
## [261] "PMC9073733 PMC_DL/PMC9073733/supplementaryfiles/mmc3.xlsx Hsapiens 29 44444 44265 44263 44257 44258 44448 44451 44443 44450 44446 44440 44447 44453 44257 44440 44256 44449 44264 44531 44441 44266 44261 44262 44256 44445 44259 44260 44442 44454"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
## [262] "PMC9073733 PMC_DL/PMC9073733/supplementaryfiles/mmc3.xlsx Hsapiens 22 44442 44443 44256 44258 44450 44445 44444 44259 44260 44263 44257 44447 44256 44446 44257 44449 44454 44448 44441 44262 44264 44261"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [263] "PMC9073733 PMC_DL/PMC9073733/supplementaryfiles/mmc3.xlsx Hsapiens 22 44443 44263 44444 44258 44257 44256 44264 44447 44256 44442 44445 44446 44454 44262 44259 44450 44441 44261 44260 44448 44257 44449"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [264] "PMC9073733 PMC_DL/PMC9073733/supplementaryfiles/mmc3.xlsx Hsapiens 22 44442 44444 44443 44258 44256 44256 44263 44257 44447 44264 44261 44448 44449 44450 44259 44446 44260 44262 44257 44454 44441 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [265] "PMC9073733 PMC_DL/PMC9073733/supplementaryfiles/mmc3.xlsx Hsapiens 22 44444 44258 44443 44256 44264 44257 44445 44442 44256 44257 44448 44262 44450 44263 44259 44446 44261 44447 44260 44449 44454 44441"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## [266] "PMC7612684 PMC_DL/PMC7612684/supplementaryfiles/EMS137572-supplement-Supplementary_Tables_3a___3z.xls Hsapiens 1 SOX2-OCT4-NANOG"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
## [267] "PMC7612684 PMC_DL/PMC7612684/supplementaryfiles/EMS137572-supplement-Supplementary_Tables_3a___3z.xls Hsapiens 2 SOX2-OCT4 SOX2-OCT4-NANOG"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [268] "PMC7612684 PMC_DL/PMC7612684/supplementaryfiles/EMS137572-supplement-Supplementary_Tables_3a___3z.xls Hsapiens 13 Analysis Ready Molecules for My Projects->GWAS_depr_cogn_metaanalysis->2nd analysis Nov 2020 - 2020-11-28 10:39 AM"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [269] "PMC9039713 PMC_DL/PMC9039713/supplementaryfiles/JCTH-10-273-s005.xlsx Hsapiens 6 43892 43901 44089 44084 44085 44076"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [270] "PMC9046921 PMC_DL/PMC9046921/supplementaryfiles/EVA-15-603-s011.xlsx Ggallus 2 44256 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [271] "PMC9046921 PMC_DL/PMC9046921/supplementaryfiles/EVA-15-603-s011.xlsx Ggallus 1 44256"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
## [272] "PMC9046921 PMC_DL/PMC9046921/supplementaryfiles/EVA-15-603-s011.xlsx Ggallus 2 44256 44445"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
## [273] "PMC9046921 PMC_DL/PMC9046921/supplementaryfiles/EVA-15-603-s011.xlsx Ggallus 1 44256"

In depth look at the errors

Let’s investigate the errors in more detail.

# By species
SPECIES <- sapply(strsplit(ERROR_GENELISTS," "),"[[",3)
table(SPECIES)
## SPECIES
##     Athaliana      Celegans Dmelanogaster        Drerio       Ggallus 
##             5             1             5             1            10 
##      Hsapiens     Mmusculus   Rnorvegicus   Scerevisiae 
##           204            37             4             6
par(mar=c(5,12,4,2))
barplot(table(SPECIES),horiz=TRUE,las=1)

par(mar=c(5,5,4,2))

# Number of affected Excel files per paper
DIST <- table(sapply(strsplit(ERROR_GENELISTS," "),"[[",1))
DIST
## 
## PMC7612684 PMC9039713 PMC9046921 PMC9054707 PMC9054804 PMC9059228 PMC9060359 
##          3          1          4          6          2         16          1 
## PMC9061740 PMC9062235 PMC9062482 PMC9062782 PMC9062783 PMC9065345 PMC9067402 
##         12          1         12          1          1          3          1 
## PMC9068765 PMC9068942 PMC9069606 PMC9071389 PMC9073418 PMC9073733 PMC9074372 
##          1          1          5          1          1          5          1 
## PMC9074814 PMC9075957 PMC9076534 PMC9080204 PMC9081883 PMC9082922 PMC9085672 
##          4          4          1          6          1          1          4 
## PMC9089222 PMC9089922 PMC9090837 PMC9091224 PMC9092402 PMC9095494 PMC9095680 
##          2          1          4          3          2         11          2 
## PMC9097904 PMC9098994 PMC9099420 PMC9101002 PMC9102361 PMC9103663 PMC9104698 
##          1          1          2          1          2          1          1 
## PMC9104707 PMC9105114 PMC9106303 PMC9106336 PMC9106650 PMC9107348 PMC9108107 
##          2          1          5          3          4          1          2 
## PMC9108397 PMC9110415 PMC9110779 PMC9113246 PMC9113978 PMC9114146 PMC9116208 
##          1          2         32          1          1          1          1 
## PMC9117226 PMC9118152 PMC9118622 PMC9119800 PMC9120926 PMC9121553 PMC9121576 
##          6          1          1          3          9          2          1 
## PMC9122532 PMC9122603 PMC9122918 PMC9122980 PMC9123275 PMC9124206 PMC9128383 
##          3         11          1          1          2          6          2 
## PMC9128527 PMC9128528 PMC9130323 PMC9130556 PMC9133343 PMC9133720 PMC9135160 
##          1          1          1          1          1          6          1 
## PMC9135276 PMC9137560 PMC9139936 PMC9141370 PMC9144309 PMC9144384 PMC9146729 
##          1          1          1          2          4          1          1 
## PMC9149313 PMC9150289 PMC9150314 PMC9150894 
##          1          2          1          6
summary(as.numeric(DIST))
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   1.000   1.000   1.000   3.102   4.000  32.000
hist(DIST,main="Number of affected Excel files per paper")

# PMC Articles with the most errors
DIST_DF <- as.data.frame(DIST)
DIST_DF <- DIST_DF[order(-DIST_DF$Freq),,drop=FALSE]
head(DIST_DF,20)
##          Var1 Freq
## 52 PMC9110779   32
## 6  PMC9059228   16
## 8  PMC9061740   12
## 10 PMC9062482   12
## 34 PMC9095494   11
## 65 PMC9122603   11
## 61 PMC9120926    9
## 4  PMC9054707    6
## 25 PMC9080204    6
## 57 PMC9117226    6
## 69 PMC9124206    6
## 76 PMC9133720    6
## 88 PMC9150894    6
## 17 PMC9069606    5
## 20 PMC9073733    5
## 45 PMC9106303    5
## 3  PMC9046921    4
## 22 PMC9074814    4
## 23 PMC9075957    4
## 28 PMC9085672    4
MOST_ERR_FILES = as.character(DIST_DF[1,1])
MOST_ERR_FILES
## [1] "PMC9110779"
# Number of errors per paper
NERR <- as.numeric(sapply(strsplit(ERROR_GENELISTS," "),"[[",4))
names(NERR) <- sapply(strsplit(ERROR_GENELISTS," "),"[[",1)
NERR <-tapply(NERR, names(NERR), sum)
NERR
## PMC7612684 PMC9039713 PMC9046921 PMC9054707 PMC9054804 PMC9059228 PMC9060359 
##         16          6          6         36         23         24          3 
## PMC9061740 PMC9062235 PMC9062482 PMC9062782 PMC9062783 PMC9065345 PMC9067402 
##         21         29        216          5         13          6         27 
## PMC9068765 PMC9068942 PMC9069606 PMC9071389 PMC9073418 PMC9073733 PMC9074372 
##          3          2          6          5          1        117          2 
## PMC9074814 PMC9075957 PMC9076534 PMC9080204 PMC9081883 PMC9082922 PMC9085672 
##          5         25         61        125          2          5         13 
## PMC9089222 PMC9089922 PMC9090837 PMC9091224 PMC9092402 PMC9095494 PMC9095680 
##          2         20          8         22          3        265          2 
## PMC9097904 PMC9098994 PMC9099420 PMC9101002 PMC9102361 PMC9103663 PMC9104698 
##         24          4          3         18          6          1          1 
## PMC9104707 PMC9105114 PMC9106303 PMC9106336 PMC9106650 PMC9107348 PMC9108107 
##         37          5        135         75         83         26        138 
## PMC9108397 PMC9110415 PMC9110779 PMC9113246 PMC9113978 PMC9114146 PMC9116208 
##          1          2        370          2          1          1          2 
## PMC9117226 PMC9118152 PMC9118622 PMC9119800 PMC9120926 PMC9121553 PMC9121576 
##         75          4          1          5         93          6         22 
## PMC9122532 PMC9122603 PMC9122918 PMC9122980 PMC9123275 PMC9124206 PMC9128383 
##         36        110          1          1        140         18         17 
## PMC9128527 PMC9128528 PMC9130323 PMC9130556 PMC9133343 PMC9133720 PMC9135160 
##          5          1          1         20          2         37          1 
## PMC9135276 PMC9137560 PMC9139936 PMC9141370 PMC9144309 PMC9144384 PMC9146729 
##         15          4          3         59         67          1         40 
## PMC9149313 PMC9150289 PMC9150314 PMC9150894 
##         28         53         14         35
hist(NERR,main="number of errors per PMC article")

NERR_DF <- as.data.frame(NERR)
NERR_DF <- NERR_DF[order(-NERR_DF$NERR),,drop=FALSE]
head(NERR_DF,20)
##            NERR
## PMC9110779  370
## PMC9095494  265
## PMC9062482  216
## PMC9123275  140
## PMC9108107  138
## PMC9106303  135
## PMC9080204  125
## PMC9073733  117
## PMC9122603  110
## PMC9120926   93
## PMC9106650   83
## PMC9106336   75
## PMC9117226   75
## PMC9144309   67
## PMC9076534   61
## PMC9141370   59
## PMC9150289   53
## PMC9146729   40
## PMC9104707   37
## PMC9133720   37
MOST_ERR = rownames(NERR_DF)[1]
MOST_ERR
## [1] "PMC9110779"

Journals affected

GENELIST_ERROR_ARTICLES <- gsub("PMC","",GENELIST_ERROR_ARTICLES)

### JSON PARSING is more reliable than XML
ARTICLES <- esummary( GENELIST_ERROR_ARTICLES , db="pmc" , retmode = "json"  )
ARTICLE_DATA <- reutils::content(ARTICLES,as= "parsed")
ARTICLE_DATA <- ARTICLE_DATA$result
ARTICLE_DATA <- ARTICLE_DATA[2:length(ARTICLE_DATA)]
JOURNALS <- unlist(lapply(ARTICLE_DATA,function(x) {x$fulljournalname} ))
JOURNALS_TABLE <- table(JOURNALS)
JOURNALS_TABLE <- JOURNALS_TABLE[order(-JOURNALS_TABLE)]

length(JOURNALS_TABLE)
## [1] 54
par(mar=c(5,25,4,2))
barplot(head(JOURNALS_TABLE,10), horiz=TRUE, las=1, 
  xlab="Articles with gene name errors in supp files",
  main="Top journals this month")

Journal of the month winner

Congrats to our Journal of the Month winner!

JOURNAL_WINNER <- names(head(JOURNALS_TABLE,1))
JOURNAL_WINNER
## [1] "Nature Communications"

Paper of the month winners

There are two categories:

Sometimes, one paper can win both categories. Congrats to our winners.

Paper with most files affected

MOST_ERR_FILES <- gsub("PMC","",MOST_ERR_FILES)
ARTICLES <- esummary( MOST_ERR_FILES , db="pmc" , retmode = "json"  )
ARTICLE_DATA <- reutils::content(ARTICLES,as= "parsed")
ARTICLE_DATA <- ARTICLE_DATA[2]
ARTICLE_DATA
## $result
## $result$uids
## [1] "9110779"
## 
## $result$`9110779`
## $result$`9110779`$uid
## [1] "9110779"
## 
## $result$`9110779`$pubdate
## [1] "2022 May 3"
## 
## $result$`9110779`$epubdate
## [1] "2022 May 3"
## 
## $result$`9110779`$printpubdate
## [1] ""
## 
## $result$`9110779`$source
## [1] "Front Immunol"
## 
## $result$`9110779`$authors
##      name authtype
## 1    Tu Z   Author
## 2  Peng J   Author
## 3  Long X   Author
## 4    Li J   Author
## 5    Wu L   Author
## 6 Huang K   Author
## 7   Zhu X   Author
## 
## $result$`9110779`$title
## [1] "Sperm Autoantigenic Protein 17 Predicts the Prognosis and the Immunotherapy Response of Cancers: A Pan-Cancer Analysis"
## 
## $result$`9110779`$volume
## [1] "13"
## 
## $result$`9110779`$issue
## [1] ""
## 
## $result$`9110779`$pages
## [1] "844736"
## 
## $result$`9110779`$articleids
##   idtype                     value
## 1   pmid                  35592314
## 2    doi 10.3389/fimmu.2022.844736
## 3  pmcid                PMC9110779
## 
## $result$`9110779`$fulljournalname
## [1] "Frontiers in Immunology"
## 
## $result$`9110779`$sortdate
## [1] "2022/05/03 00:00"
## 
## $result$`9110779`$pmclivedate
## [1] "2022/05/18"

Paper with most date conversions

MOST_ERR <- gsub("PMC","",MOST_ERR)
ARTICLE_DATA <- esummary(MOST_ERR,db = "pmc" , retmode = "json" )
ARTICLE_DATA <- reutils::content(ARTICLE_DATA,as= "parsed")
ARTICLE_DATA
## $header
## $header$type
## [1] "esummary"
## 
## $header$version
## [1] "0.3"
## 
## 
## $result
## $result$uids
## [1] "9110779"
## 
## $result$`9110779`
## $result$`9110779`$uid
## [1] "9110779"
## 
## $result$`9110779`$pubdate
## [1] "2022 May 3"
## 
## $result$`9110779`$epubdate
## [1] "2022 May 3"
## 
## $result$`9110779`$printpubdate
## [1] ""
## 
## $result$`9110779`$source
## [1] "Front Immunol"
## 
## $result$`9110779`$authors
##      name authtype
## 1    Tu Z   Author
## 2  Peng J   Author
## 3  Long X   Author
## 4    Li J   Author
## 5    Wu L   Author
## 6 Huang K   Author
## 7   Zhu X   Author
## 
## $result$`9110779`$title
## [1] "Sperm Autoantigenic Protein 17 Predicts the Prognosis and the Immunotherapy Response of Cancers: A Pan-Cancer Analysis"
## 
## $result$`9110779`$volume
## [1] "13"
## 
## $result$`9110779`$issue
## [1] ""
## 
## $result$`9110779`$pages
## [1] "844736"
## 
## $result$`9110779`$articleids
##   idtype                     value
## 1   pmid                  35592314
## 2    doi 10.3389/fimmu.2022.844736
## 3  pmcid                PMC9110779
## 
## $result$`9110779`$fulljournalname
## [1] "Frontiers in Immunology"
## 
## $result$`9110779`$sortdate
## [1] "2022/05/03 00:00"
## 
## $result$`9110779`$pmclivedate
## [1] "2022/05/18"

Trend info

TODO: To plot the trend over the past 6 months.

References

  1. Zeeberg, B.R., Riss, J., Kane, D.W. et al. Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics. BMC Bioinformatics 5, 80 (2004). https://doi.org/10.1186/1471-2105-5-80

  2. Ziemann, M., Eren, Y. & El-Osta, A. Gene name errors are widespread in the scientific literature. Genome Biol 17, 177 (2016). https://doi.org/10.1186/s13059-016-1044-7

SessionInfo

sessionInfo()
## R version 4.2.0 (2022-04-22)
## Platform: x86_64-pc-linux-gnu (64-bit)
## Running under: Ubuntu 20.04.4 LTS
## 
## Matrix products: default
## BLAS:   /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.9.0
## LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.9.0
## 
## locale:
##  [1] LC_CTYPE=en_AU.UTF-8       LC_NUMERIC=C              
##  [3] LC_TIME=en_AU.UTF-8        LC_COLLATE=en_AU.UTF-8    
##  [5] LC_MONETARY=en_AU.UTF-8    LC_MESSAGES=en_AU.UTF-8   
##  [7] LC_PAPER=en_AU.UTF-8       LC_NAME=C                 
##  [9] LC_ADDRESS=C               LC_TELEPHONE=C            
## [11] LC_MEASUREMENT=en_AU.UTF-8 LC_IDENTIFICATION=C       
## 
## attached base packages:
## [1] stats     graphics  grDevices utils     datasets  methods   base     
## 
## other attached packages:
## [1] readxl_1.4.0   reutils_0.2.3  xml2_1.3.3     jsonlite_1.8.0
## 
## loaded via a namespace (and not attached):
##  [1] knitr_1.39       magrittr_2.0.3   R6_2.5.1         rlang_1.0.2     
##  [5] fastmap_1.1.0    stringr_1.4.0    highr_0.9        tools_4.2.0     
##  [9] xfun_0.31        cli_3.3.0        jquerylib_0.1.4  htmltools_0.5.2 
## [13] yaml_2.3.5       digest_0.6.29    assertthat_0.2.1 sass_0.4.1      
## [17] bitops_1.0-7     RCurl_1.98-1.7   evaluate_0.15    rmarkdown_2.14  
## [21] stringi_1.7.6    compiler_4.2.0   bslib_0.3.1      cellranger_1.1.0
## [25] XML_3.99-0.10