Data illustrating join operations

A set of tibbles contain information about genes and their protein products used to illustrate join operations.

Usage

data("jdf")

Source

These data are based on feature varaibles from the hyperLOPIT2015 data available in the pRolocdata package. The script to generate, join.R, is available in the scipts package directory.

Examples

data(jdf)
library("dplyr")
#> 
#> Attaching package: ‘dplyr’
#> The following object is masked from ‘package:Biobase’:
#> 
#>     combine
#> The following objects are masked from ‘package:GenomicRanges’:
#> 
#>     intersect, setdiff, union
#> The following object is masked from ‘package:GenomeInfoDb’:
#> 
#>     intersect
#> The following objects are masked from ‘package:IRanges’:
#> 
#>     collapse, desc, intersect, setdiff, slice, union
#> The following objects are masked from ‘package:S4Vectors’:
#> 
#>     first, intersect, rename, setdiff, setequal, union
#> The following objects are masked from ‘package:BiocGenerics’:
#> 
#>     combine, intersect, setdiff, union
#> The following object is masked from ‘package:matrixStats’:
#> 
#>     count
#> The following objects are masked from ‘package:stats’:
#> 
#>     filter, lag
#> The following objects are masked from ‘package:base’:
#> 
#>     intersect, setdiff, setequal, union
dplyr::full_join(jdf1, jdf2)
#> Joining with `by = join_by(uniprot)`
#> # A tibble: 25 × 6
#>    uniprot  organelle                       entry gene_name description organism
#>    <chr>    <chr>                           <chr> <chr>     <chr>       <chr>   
#>  1 P26039   Actin cytoskeleton              TLN1… Tln1      Talin-1     Mmus    
#>  2 Q99PL5   Endoplasmic reticulum/Golgi ap… RRBP… Rrbp1     Ribosome-b… Mmus    
#>  3 Q6PB66   Mitochondrion                   LPPR… Lrpprc    Leucine-ri… Mmus    
#>  4 P11276   Extracellular matrix            FINC… Fn1       Fibronectin Mmus    
#>  5 Q6PR54   Nucleus - Chromatin             RIF1… Rif1      Telomere-a… Mmus    
#>  6 Q05793   Extracellular matrix            PGBM… Hspg2     Basement m… Mmus    
#>  7 P19096   Cytosol                         FAS_… Fasn      Fatty acid… Mmus    
#>  8 Q9JKF1   Plasma membrane                 IQGA… Iqgap1    Ras GTPase… Mmus    
#>  9 Q9QZQ1-2 Plasma membrane                 AFAD… Mllt4     Isoform 1 … Mmus    
#> 10 Q6NS46   Nucleus - Non-chromatin         RRP5… Pdcd11    Protein RR… Mmus    
#> # ℹ 15 more rows
dplyr::left_join(jdf6, jdf7)
#> Joining with `by = join_by(uniprot)`
#> Warning: Detected an unexpected many-to-many relationship between `x` and `y`.
#> ℹ Row 2 of `x` matches multiple rows in `y`.
#> ℹ Row 1 of `y` matches multiple rows in `x`.
#> ℹ If a many-to-many relationship is expected, set `relationship =
#>   "many-to-many"` to silence this warning.
#> # A tibble: 7 × 9
#>   uniprot organelle     entry isoform gene_name description organism isoform_num
#>   <chr>   <chr>         <chr>   <dbl> <chr>     <chr>       <chr>          <dbl>
#> 1 P26039  Actin cytosk… TLN1…       1 NA        NA          NA                NA
#> 2 Q99PL5  Endoplasmic … RRBP…       1 Rrbp1     Ribosome-b… Mmus               1
#> 3 Q99PL5  Endoplasmic … RRBP…       1 Rrbp1     Ribosome-b… Mmus               2
#> 4 Q99PL5  Golgi appara… RRBP…       2 Rrbp1     Ribosome-b… Mmus               1
#> 5 Q99PL5  Golgi appara… RRBP…       2 Rrbp1     Ribosome-b… Mmus               2
#> 6 Q6PB66  Mitochondrion LPPR…       1 NA        NA          NA                NA
#> 7 P11276  Extracellula… FINC…       1 NA        NA          NA                NA
#> # ℹ 1 more variable: measure <dbl>