missing file: outputs/gdc/Project.Vertex.json

done
select
  count(distinct i.to) as "individual",
  v.data->>'project_id' as "project_id"
  from edge i
    join edge p on (p.label = 'InProject' and p.from = i.to and i.label = 'BiosampleFor')
        join vertex v on (v.label = 'Project' and p.to = v.gid)
  group by project_id ;
 individual |               project_id
------------+-----------------------------------------
          1 | CCLE:ADRENAL_CORTEX
         33 | CCLE:AUTONOMIC_GANGLIA
         14 | CCLE:BILIARY_TRACT
          2 | CCLE:BLADDER
         78 | CCLE:BONE
         93 | CCLE:BREAST
          1 | CCLE:BUCCAL
         91 | CCLE:CENTRAL_NERVOUS_SYSTEM
         16 | CCLE:CERVIX
         30 | CCLE:ENDOMETRIUM
          4 | CCLE:ENGINEERED
          5 | CCLE:ESOPHAGUS
          2 | CCLE:FIBROBLAST
          1 | CCLE:GASTROINTESTINAL_TRACT
          5 | CCLE:HAEMATOPOIETIC_AND_LYMPHOID
        264 | CCLE:HAEMATOPOIETIC_AND_LYMPHOID_TISSUE
         17 | CCLE:HEAD_AND_NECK
         57 | CCLE:KIDNEY
         77 | CCLE:LARGE_INTESTINE
         28 | CCLE:LIVER
        270 | CCLE:LUNG
         40 | CCLE:MATCHED_NORMAL_TISSUE
         26 | CCLE:NERVOUS_SYSTEM
         33 | CCLE:OESOPHAGUS
         68 | CCLE:OVARY
         57 | CCLE:PANCREAS
          2 | CCLE:PLACENTA
         11 | CCLE:PLEURA
         10 | CCLE:PROSTATE
          2 | CCLE:SALIVARY_GLAND
        108 | CCLE:SKIN
          1 | CCLE:SMALL_INTESTINE
         69 | CCLE:SOFT_TISSUE
         45 | CCLE:STOMACH
          1 | CCLE:TESTES
          2 | CCLE:TESTIS
         19 | CCLE:THYROID
          1 | CCLE:TO_ACH-000109]H3255_LUNG
          1 | CCLE:TO_ACH-000474]NCIH292_LUNG
         45 | CCLE:UPPER_AERODIGESTIVE_TRACT
         38 | CCLE:URINARY_TRACT
          4 | CCLE:UVEA
          1 | CCLE:VULVA
      18004 | FM-AD
        988 | TARGET-AML
         13 | TARGET-CCSK
       1105 | TARGET-NBL
        369 | TARGET-OS
         75 | TARGET-RT
        652 | TARGET-WT
         92 | TCGA-ACC
        412 | TCGA-BLCA
       1098 | TCGA-BRCA
        307 | TCGA-CESC
         51 | TCGA-CHOL
        461 | TCGA-COAD
         58 | TCGA-DLBC
        185 | TCGA-ESCA
        617 | TCGA-GBM
        528 | TCGA-HNSC
        113 | TCGA-KICH
        537 | TCGA-KIRC
        291 | TCGA-KIRP
        200 | TCGA-LAML
        516 | TCGA-LGG
        377 | TCGA-LIHC
        585 | TCGA-LUAD
        504 | TCGA-LUSC
         87 | TCGA-MESO
        608 | TCGA-OV
        185 | TCGA-PAAD
        179 | TCGA-PCPG
        500 | TCGA-PRAD
        172 | TCGA-READ
        261 | TCGA-SARC
        470 | TCGA-SKCM
        443 | TCGA-STAD
        150 | TCGA-TGCT
        507 | TCGA-THCA
        124 | TCGA-THYM
        560 | TCGA-UCEC
         57 | TCGA-UCS
         80 | TCGA-UVM
        752 | gtex
(84 rows)

Time: 939.566 ms
bmeg / bmeg-etl

missing file: outputs/gdc/Project.Vertex.json #224
