Open In Colab

Command-line Download

This notebook demonstrates how to use pysradb from the command line to download SRA data.

[1]:
# Install pysradb if not already installed
try:
    import pysradb

    print(f"pysradb {pysradb.__version__} is already installed")
except ImportError:
    print("Installing pysradb from GitHub...")
    import sys

    !{sys.executable} -m pip install -q git+https://github.com/saketkc/pysradb
    print("pysradb installed successfully!")
pysradb 3.0.0.dev0 is already installed
/home/runner/work/pysradb/pysradb/pysradb/download.py:15: TqdmExperimentalWarning: Using `tqdm.autonotebook.tqdm` in notebook mode. Use `tqdm.tqdm` instead to force console mode (e.g. in jupyter console)
  from tqdm.autonotebook import tqdm
[2]:
# pip install -U pysradb
[3]:
!pysradb --version
pysradb 3.0.0.dev0

Get metadata for SRX (SRRs/SRS etc)

[4]:
!pysradb srx-to-srr SRX4720625
Displaying 24 columns in chunks of 5

Columns 1-5:
 experimen                                                                    
 t_accessi  run_acce  study_acc                                               
 on         ssion     ession     study_title                experiment_title  
 SRX472062  SRR78820  SRP162234  Transcriptomic profile of  GSM3396533:
 5          15                   zebrafish cardiomyocytes   wt_GFPpos_24hpf_r
                                 throughout heart           ep1; Danio rerio;
                                 development                RNA-Seq

Columns 6-10:
                                 organism_t  organism_  library_na  library_s 
 experiment_desc                 axid        name       me          trategy   
 GSM3396533:                     7955        Danio                  RNA-Seq
 wt_GFPpos_24hpf_rep1; Danio                 rerio
 rerio; RNA-Seq

Columns 11-15:
                 library_selecti  library_layou  sample_accessi               
 library_source  on               t              on              sample_title 
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805811

Columns 16-20:
                                         instrument_mode  instrument_model_de 
 biosample    bioproject    instrument   l                sc                  
 SAMN1009572  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3

Columns 21-24:
 total_spots       total_size        run_total_spots      run_total_bases     
 47867961          3470385670        47867961             7230485009

Get detailed metadata

[5]:
!pysradb srx-to-srr SRX4720625 --detailed
Displaying 57 columns in chunks of 5

Columns 1-5:
 experimen                                                                    
 t_accessi  run_acce  study_acc                                               
 on         ssion     ession     study_title                experiment_title  
 SRX472062  SRR78820  SRP162234  Transcriptomic profile of  GSM3396533:
 5          15                   zebrafish cardiomyocytes   wt_GFPpos_24hpf_r
                                 throughout heart           ep1; Danio rerio;
                                 development                RNA-Seq

Columns 6-10:
                                 organism_t  organism_  library_na  library_s 
 experiment_desc                 axid        name       me          trategy   
 GSM3396533:                     7955        Danio      -           RNA-Seq
 wt_GFPpos_24hpf_rep1; Danio                 rerio
 rerio; RNA-Seq

Columns 11-15:
                 library_selecti  library_layou  sample_accessi               
 library_source  on               t              on              sample_title 
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805811      -

Columns 16-20:
                                         instrument_mode  instrument_model_de 
 biosample    bioproject    instrument   l                sc                  
 SAMN1009572  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3

Columns 21-25:
 total_spots    total_size    run_total_spots  run_total_bases  run_alias     
 47867961       3470385670    47867961         7230485009       GSM3396533_r1

Columns 26-30:
 public_filen                                                     public_vers 
 ame           public_size  public_date   public_md5              ion         
 SRR7882015.s  1881003321   2020-06-14    8161154ca4e9cf674e3f0e  1
 ralite                     12:02:25      4af74c8455

Columns 31-35:
 public_sem  public_sup  public_srat                              aws_free_eg 
 antic_name  ertype      oolkit       aws_url                     ress        
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      15/SRR7882015.sralite.1     1

Columns 36-40:
                                                                      ncbi_ac 
 aws_acce                                                   ncbi_fre  cess_ty 
 ss_type   public_url               ncbi_url                e_egress  pe      
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882015/SRR788  R007/882/SRR7882015/SR
           2015.sralite.1           R7882015.sralite.1

Columns 41-45:
                           gcp_free_e  gcp_access_  experiment                
 gcp_url                   gress       type         _alias      source_name   
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396533  FACS-sorted
 882015/SRR7882015.zq.1    1           identity                 embryo cells

Columns 46-50:
                     developmental                genetic         ena_fastq_h 
 tissue              stage           gfp status   background      ttp         
 FACS-sorted embryo  24 hpf          GFP          wild type       -
 cells                               positive

Columns 51-55:
 ena_fastq_http  ena_fastq_http  ena_fastq_f  ena_fastq_ftp_                  
 _1              _2              tp           1               ena_fastq_ftp_2 
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /005/SRR788201  /005/SRR788201               788/005/SRR788  /005/SRR7882015
 5/SRR7882015_1  5/SRR7882015_2               2015/SRR788201  /SRR7882015_2.f
 .fastq.gz       .fastq.gz                    5_1.fastq.gz    astq.gz

Columns 56-57:
 study_geo_accession                experiment_geo_accession                  
 GSE120236                          GSM3396533

Download all runs for a particular experiment

[6]:
print("pysradb srx-to-srr SRX4720625 --detailed | pysradb download")
pysradb srx-to-srr SRX4720625 --detailed | pysradb download

Get metadata for entire project

[7]:
!pysradb metadata SRP162234 --detailed
Displaying 57 columns in chunks of 5

Columns 1-5:
                                                 experime                     
 run_acce  study_ac                              nt_acces                     
 ssion     cession   study_title                 sion      experiment_title   
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396532:
 14        4         zebrafish cardiomyocytes    24        wt_GFPneg_24hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396533:
 15        4         zebrafish cardiomyocytes    25        wt_GFPpos_24hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396534:
 16        4         zebrafish cardiomyocytes    26        wt_GFPpos_24hpf_re
                     throughout heart                      p2; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396535:
 17        4         zebrafish cardiomyocytes    27        wt_GFPneg_48hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396536:
 18        4         zebrafish cardiomyocytes    28        wt_GFPpos_48hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396537:
 19        4         zebrafish cardiomyocytes    29        wt_GFPpos_48hpf_re
                     throughout heart                      p2; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396538:
 20        4         zebrafish cardiomyocytes    30        wt_GFPneg_72hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396539:
 21        4         zebrafish cardiomyocytes    31        wt_GFPpos_72hpf_re
                     throughout heart                      p1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396540:
 22        4         zebrafish cardiomyocytes    32        wt_GFPpos_72hpf_re
                     throughout heart                      p2; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396541:
 23        4         zebrafish cardiomyocytes    33        gata5_GFPneg_72hpf
                     throughout heart                      _rep1; Danio
                     development                           rerio; RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396542:
 24        4         zebrafish cardiomyocytes    34        gata5_GFPpos_72hpf
                     throughout heart                      _rep1; Danio
                     development                           rerio; RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396543:
 25        4         zebrafish cardiomyocytes    35        gata5_GFPpos_72hpf
                     throughout heart                      _rep2; Danio
                     development                           rerio; RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396544:
 26        4         zebrafish cardiomyocytes    36        tbx5_GFPneg_72hpf_
                     throughout heart                      rep1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396545:
 27        4         zebrafish cardiomyocytes    37        tbx5_GFPpos_72hpf_
                     throughout heart                      rep1; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396546:
 28        4         zebrafish cardiomyocytes    38        tbx5_GFPpos_72hpf_
                     throughout heart                      rep2; Danio rerio;
                     development                           RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396547:
 29        4         zebrafish cardiomyocytes    39        hand2_GFPneg_72hpf
                     throughout heart                      _rep1; Danio
                     development                           rerio; RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396548:
 30        4         zebrafish cardiomyocytes    40        hand2_GFPpos_72hpf
                     throughout heart                      _rep1; Danio
                     development                           rerio; RNA-Seq
 SRR78820  SRP16223  Transcriptomic profile of   SRX47206  GSM3396549:
 31        4         zebrafish cardiomyocytes    41        hand2_GFPpos_72hpf
                     throughout heart                      _rep2; Danio
                     development                           rerio; RNA-Seq

Columns 6-10:
                                  organism_  organism_  library_na  library_s 
 experiment_desc                  taxid      name       me          trategy   
 GSM3396532:                      7955       Danio      -           RNA-Seq
 wt_GFPneg_24hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396533:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_24hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396534:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_24hpf_rep2; Danio                 rerio
 rerio; RNA-Seq
 GSM3396535:                      7955       Danio      -           RNA-Seq
 wt_GFPneg_48hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396536:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_48hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396537:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_48hpf_rep2; Danio                 rerio
 rerio; RNA-Seq
 GSM3396538:                      7955       Danio      -           RNA-Seq
 wt_GFPneg_72hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396539:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_72hpf_rep1; Danio                 rerio
 rerio; RNA-Seq
 GSM3396540:                      7955       Danio      -           RNA-Seq
 wt_GFPpos_72hpf_rep2; Danio                 rerio
 rerio; RNA-Seq
 GSM3396541:                      7955       Danio      -           RNA-Seq
 gata5_GFPneg_72hpf_rep1; Danio              rerio
 rerio; RNA-Seq
 GSM3396542:                      7955       Danio      -           RNA-Seq
 gata5_GFPpos_72hpf_rep1; Danio              rerio
 rerio; RNA-Seq
 GSM3396543:                      7955       Danio      -           RNA-Seq
 gata5_GFPpos_72hpf_rep2; Danio              rerio
 rerio; RNA-Seq
 GSM3396544:                      7955       Danio      -           RNA-Seq
 tbx5_GFPneg_72hpf_rep1; Danio               rerio
 rerio; RNA-Seq
 GSM3396545:                      7955       Danio      -           RNA-Seq
 tbx5_GFPpos_72hpf_rep1; Danio               rerio
 rerio; RNA-Seq
 GSM3396546:                      7955       Danio      -           RNA-Seq
 tbx5_GFPpos_72hpf_rep2; Danio               rerio
 rerio; RNA-Seq
 GSM3396547:                      7955       Danio      -           RNA-Seq
 hand2_GFPneg_72hpf_rep1; Danio              rerio
 rerio; RNA-Seq
 GSM3396548:                      7955       Danio      -           RNA-Seq
 hand2_GFPpos_72hpf_rep1; Danio              rerio
 rerio; RNA-Seq
 GSM3396549:                      7955       Danio      -           RNA-Seq
 hand2_GFPpos_72hpf_rep2; Danio              rerio
 rerio; RNA-Seq

Columns 11-15:
                 library_selecti  library_layou  sample_accessi               
 library_source  on               t              on              sample_title 
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805810      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805811      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805812      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805813      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805814      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805815      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805816      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805817      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805818      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805819      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805820      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805821      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805822      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805823      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805824      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805825      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805826      -
 TRANSCRIPTOMIC  cDNA             PAIRED         SRS3805827      -

Columns 16-20:
                                         instrument_mode  instrument_model_de 
 biosample    bioproject    instrument   l                sc                  
 SAMN1009572  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 4
 SAMN1009572  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3
 SAMN1009580  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3
 SAMN1009580  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 1
 SAMN1009582  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3
 SAMN1009582  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 2
 SAMN1009582  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 1
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 9
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 7
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 1
 SAMN1009580  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 9
 SAMN1009580  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 7
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 6
 SAMN1009587  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 9
 SAMN1009587  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 8
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 4
 SAMN1009581  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 3
 SAMN1009580  PRJNA492280   NextSeq 500  NextSeq 500      ILLUMINA
 5

Columns 21-25:
 total_spots    total_size    run_total_spots  run_total_bases  run_alias     
 21439471       1549237734    21439471         3235130828       GSM3396532_r1
 47867961       3470385670    47867961         7230485009       GSM3396533_r1
 45108524       3347127540    45108524         6811055984       GSM3396534_r1
 25172776       1597637090    25172776         3804459726       GSM3396535_r1
 68478641       4227037694    68478641         10362706101      GSM3396536_r1
 72822775       4519247080    72822775         11019279496      GSM3396537_r1
 17619161       1288448692    17619161         2643010914       GSM3396538_r1
 62587832       4050860463    62587832         9407123202       GSM3396539_r1
 67147971       4345146386    67147971         10142882964      GSM3396540_r1
 27837896       1720418790    27837896         4201863748       GSM3396541_r1
 56555130       3467480388    56555130         8562517609       GSM3396542_r1
 60833762       3735673536    60833762         9212176075       GSM3396543_r1
 49187957       3190641550    49187957         7431177314       GSM3396544_r1
 96090300       6245453636    96090300         14525399561      GSM3396545_r1
 62838564       4072100836    62838564         9494332347       GSM3396546_r1
 30761676       2091196312    30761676         4675774752       GSM3396547_r1
 66234287       4470573268    66234287         10067611624      GSM3396548_r1
 80003290       5496499311    80003290         12160500080      GSM3396549_r1

Columns 26-30:
 public_filen                                                     public_vers 
 ame           public_size  public_date   public_md5              ion         
 SRR7882014.s  843819674    2020-06-14    c037ccca37bf4d6abc5813  1
 ralite                     02:49:28      cc3b31d2f0
 SRR7882015.s  1881003321   2020-06-14    8161154ca4e9cf674e3f0e  1
 ralite                     12:02:25      4af74c8455
 SRR7882016.s  1780836154   2020-06-22    2b5e272ac8b85fb07e8984  1
 ralite                     13:49:36      2b6fa1e7ff
 SRR7882017.s  991847394    2020-06-14    26b25df3ca97659b77d69f  1
 ralite                     11:47:21      b9a2514f07
 SRR7882018.s  2687036341   2020-06-20    076044f1f92cd47d55c8a8  1
 ralite                     12:03:19      9e6860e005
 SRR7882019.s  2861783098   2020-06-22    0906b937e8b613468a5cdc  1
 ralite                     13:58:14      522532bc7e
 SRR7882020.s  693263779    2020-06-24    8c1d6436606b28b95450cb  1
 ralite                     02:36:29      538ea2f066
 SRR7882021.s  2460093865   2020-06-20    527dc540e148a7288012b1  1
 ralite                     12:01:27      88ed11541c
 SRR7882022.s  2649120145   2020-06-22    9d3fcc2b555af694643af3  1
 ralite                     14:03:06      5393bd9d1d
 SRR7882023.s  1092395868   2020-06-14    db7d0a7737eb616301bd7f  1
 ralite                     11:46:37      544c57f455
 SRR7882024.s  2216823671   2020-06-21    cd4c4270d817343d2f81b3  1
 ralite                     14:15:12      ff711fb7e4
 SRR7882025.s  2384360834   2020-06-24    d179a5c3889518879eaaec  1
 ralite                     02:53:43      1914404090
 SRR7882026.s  1940747812   2020-06-21    7f896dfee5c74c558c9d95  1
 ralite                     14:07:10      cbaa047ca2
 SRR7882027.s  3777195699   2021-06-15    111d6ca4fb00189697d543  1
 ralite                     02:20:27      d0ca744c3a
 SRR7882028.s  2472733302   2020-06-24    8e8f270cee4fc7a9c5f450  1
 ralite                     02:54:40      a34930de4f
 SRR7882029.s  1179822118   2020-06-20    5a7f09aa682cdee98a6767  1
 ralite                     11:39:34      3aaf2d205a
 SRR7882030.s  2532332515   2020-06-22    40e79360fa3d4ea481b829  1
 ralite                     13:51:55      28909b68b1
 SRR7882031.s  3062201982   2020-06-22    9942effecf10d150ad5653  1
 ralite                     13:56:01      39bf207f81

Columns 31-35:
 public_sem  public_sup  public_srat                              aws_free_eg 
 antic_name  ertype      oolkit       aws_url                     ress        
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      14/SRR7882014.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      15/SRR7882015.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      16/SRR7882016.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      17/SRR7882017.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-4/SRR78820  s3.us-east-
             ETL                      18/SRR7882018.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      19/SRR7882019.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-5/SRR78820  s3.us-east-
             ETL                      20/SRR7882020.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-4/SRR78820  s3.us-east-
             ETL                      21/SRR7882021.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      22/SRR7882022.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      23/SRR7882023.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-9/SRR78820  s3.us-east-
             ETL                      24/SRR7882024.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      25/SRR7882025.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      26/SRR7882026.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-9/SRR78820  s3.us-east-
             ETL                      27/SRR7882027.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      28/SRR7882028.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-4/SRR78820  s3.us-east-
             ETL                      29/SRR7882029.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-8/SRR78820  s3.us-east-
             ETL                      30/SRR7882030.sralite.1     1
 SRA Lite    Primary     1            s3://sra-pub-zq-5/SRR78820  s3.us-east-
             ETL                      31/SRR7882031.sralite.1     1

Columns 36-40:
                                                                      ncbi_ac 
 aws_acce                                                   ncbi_fre  cess_ty 
 ss_type   public_url               ncbi_url                e_egress  pe      
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882014/SRR788  R007/882/SRR7882014/SR
           2014.sralite.1           R7882014.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882015/SRR788  R007/882/SRR7882015/SR
           2015.sralite.1           R7882015.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882016/SRR788  R007/882/SRR7882016/SR
           2016.sralite.1           R7882016.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os9/sra-pub-zq-922/SRR0  /sos9/sra-pub-zq-922/S
           07/882/SRR7882017.srali  RR007/882/SRR7882017.s
           te.1                     ralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882018/SRR788  R007/882/SRR7882018/SR
           2018.sralite.1           R7882018.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882019/SRR788  R007/882/SRR7882019/SR
           2019.sralite.1           R7882019.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-14/SRR00  /sos5/sra-pub-zq-14/SR
           7/882/SRR7882020.sralit  R007/882/SRR7882020.sr
           e.1                      alite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882021/SRR788  R007/882/SRR7882021/SR
           2021.sralite.1           R7882021.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882022/SRR788  R007/882/SRR7882022/SR
           2022.sralite.1           R7882022.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os9/sra-pub-zq-922/SRR0  /sos9/sra-pub-zq-922/S
           07/882/SRR7882023.srali  RR007/882/SRR7882023.s
           te.1                     ralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882024/SRR788  R007/882/SRR7882024/SR
           2024.sralite.1           R7882024.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882025/SRR788  R007/882/SRR7882025/SR
           2025.sralite.1           R7882025.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882026/SRR788  R007/882/SRR7882026/SR
           2026.sralite.1           R7882026.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882027/SRR788  R007/882/SRR7882027/SR
           2027.sralite.1           R7882027.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882028/SRR788  R007/882/SRR7882028/SR
           2028.sralite.1           R7882028.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882029/SRR788  R007/882/SRR7882029/SR
           2029.sralite.1           R7882029.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882030/SRR788  R007/882/SRR7882030/SR
           2030.sralite.1           R7882030.sralite.1
 aws       https://sra-downloadb.b  https://sra-downloadb.  worldwid  anonymo
 identity  e-md.ncbi.nlm.nih.gov/s  be-md.ncbi.nlm.nih.gov  e         us
           os5/sra-pub-zq-11/SRR00  /sos5/sra-pub-zq-11/SR
           7/882/SRR7882031/SRR788  R007/882/SRR7882031/SR
           2031.sralite.1           R7882031.sralite.1

Columns 41-45:
                           gcp_free_e  gcp_access_  experiment                
 gcp_url                   gress       type         _alias      source_name   
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396532  FACS-sorted
 882014/SRR7882014.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396533  FACS-sorted
 882015/SRR7882015.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396534  FACS-sorted
 882016/SRR7882016.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396535  FACS-sorted
 882017/SRR7882017.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396536  FACS-sorted
 882018/SRR7882018.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396537  FACS-sorted
 882019/SRR7882019.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-105/SRR7  gs.us-east  gcp          GSM3396538  FACS-sorted
 882020/SRR7882020.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396539  FACS-sorted
 882021/SRR7882021.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396540  FACS-sorted
 882022/SRR7882022.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396541  FACS-sorted
 882023/SRR7882023.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396542  FACS-sorted
 882024/SRR7882024.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396543  FACS-sorted
 882025/SRR7882025.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396544  FACS-sorted
 882026/SRR7882026.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-105/SRR7  gs.us-east  gcp          GSM3396545  FACS-sorted
 882027/SRR7882027.noqual  1           identity                 embryo cells
 .1
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396546  FACS-sorted
 882028/SRR7882028.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396547  FACS-sorted
 882029/SRR7882029.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-107/SRR7  gs.us-east  gcp          GSM3396548  FACS-sorted
 882030/SRR7882030.zq.1    1           identity                 embryo cells
 gs://sra-pub-zq-105/SRR7  gs.us-east  gcp          GSM3396549  FACS-sorted
 882031/SRR7882031.zq.1    1           identity                 embryo cells

Columns 46-50:
                     developmental                genetic         ena_fastq_h 
 tissue              stage           gfp status   background      ttp         
 FACS-sorted embryo  24 hpf          GFP          wild type       -
 cells                               negative
 FACS-sorted embryo  24 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  24 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  48 hpf          GFP          wild type       -
 cells                               negative
 FACS-sorted embryo  48 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  48 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          wild type       -
 cells                               negative
 FACS-sorted embryo  72 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          wild type       -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          gata5           -
 cells                               negative
 FACS-sorted embryo  72 hpf          GFP          gata5           -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          gata5           -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          tbx5            -
 cells                               negative
 FACS-sorted embryo  72 hpf          GFP          tbx5            -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          tbx5            -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          hand2           -
 cells                               negative
 FACS-sorted embryo  72 hpf          GFP          hand2           -
 cells                               positive
 FACS-sorted embryo  72 hpf          GFP          hand2           -
 cells                               positive

Columns 51-55:
 ena_fastq_http  ena_fastq_http  ena_fastq_f  ena_fastq_ftp_                  
 _1              _2              tp           1               ena_fastq_ftp_2 
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /004/SRR788201  /004/SRR788201               788/004/SRR788  /004/SRR7882014
 4/SRR7882014_1  4/SRR7882014_2               2014/SRR788201  /SRR7882014_2.f
 .fastq.gz       .fastq.gz                    4_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /005/SRR788201  /005/SRR788201               788/005/SRR788  /005/SRR7882015
 5/SRR7882015_1  5/SRR7882015_2               2015/SRR788201  /SRR7882015_2.f
 .fastq.gz       .fastq.gz                    5_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /006/SRR788201  /006/SRR788201               788/006/SRR788  /006/SRR7882016
 6/SRR7882016_1  6/SRR7882016_2               2016/SRR788201  /SRR7882016_2.f
 .fastq.gz       .fastq.gz                    6_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /007/SRR788201  /007/SRR788201               788/007/SRR788  /007/SRR7882017
 7/SRR7882017_1  7/SRR7882017_2               2017/SRR788201  /SRR7882017_2.f
 .fastq.gz       .fastq.gz                    7_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /008/SRR788201  /008/SRR788201               788/008/SRR788  /008/SRR7882018
 8/SRR7882018_1  8/SRR7882018_2               2018/SRR788201  /SRR7882018_2.f
 .fastq.gz       .fastq.gz                    8_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /009/SRR788201  /009/SRR788201               788/009/SRR788  /009/SRR7882019
 9/SRR7882019_1  9/SRR7882019_2               2019/SRR788201  /SRR7882019_2.f
 .fastq.gz       .fastq.gz                    9_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /000/SRR788202  /000/SRR788202               788/000/SRR788  /000/SRR7882020
 0/SRR7882020_1  0/SRR7882020_2               2020/SRR788202  /SRR7882020_2.f
 .fastq.gz       .fastq.gz                    0_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /001/SRR788202  /001/SRR788202               788/001/SRR788  /001/SRR7882021
 1/SRR7882021_1  1/SRR7882021_2               2021/SRR788202  /SRR7882021_2.f
 .fastq.gz       .fastq.gz                    1_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /002/SRR788202  /002/SRR788202               788/002/SRR788  /002/SRR7882022
 2/SRR7882022_1  2/SRR7882022_2               2022/SRR788202  /SRR7882022_2.f
 .fastq.gz       .fastq.gz                    2_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /003/SRR788202  /003/SRR788202               788/003/SRR788  /003/SRR7882023
 3/SRR7882023_1  3/SRR7882023_2               2023/SRR788202  /SRR7882023_2.f
 .fastq.gz       .fastq.gz                    3_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /004/SRR788202  /004/SRR788202               788/004/SRR788  /004/SRR7882024
 4/SRR7882024_1  4/SRR7882024_2               2024/SRR788202  /SRR7882024_2.f
 .fastq.gz       .fastq.gz                    4_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /005/SRR788202  /005/SRR788202               788/005/SRR788  /005/SRR7882025
 5/SRR7882025_1  5/SRR7882025_2               2025/SRR788202  /SRR7882025_2.f
 .fastq.gz       .fastq.gz                    5_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /006/SRR788202  /006/SRR788202               788/006/SRR788  /006/SRR7882026
 6/SRR7882026_1  6/SRR7882026_2               2026/SRR788202  /SRR7882026_2.f
 .fastq.gz       .fastq.gz                    6_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /007/SRR788202  /007/SRR788202               788/007/SRR788  /007/SRR7882027
 7/SRR7882027_1  7/SRR7882027_2               2027/SRR788202  /SRR7882027_2.f
 .fastq.gz       .fastq.gz                    7_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /008/SRR788202  /008/SRR788202               788/008/SRR788  /008/SRR7882028
 8/SRR7882028_1  8/SRR7882028_2               2028/SRR788202  /SRR7882028_2.f
 .fastq.gz       .fastq.gz                    8_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /009/SRR788202  /009/SRR788202               788/009/SRR788  /009/SRR7882029
 9/SRR7882029_1  9/SRR7882029_2               2029/SRR788202  /SRR7882029_2.f
 .fastq.gz       .fastq.gz                    9_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /000/SRR788203  /000/SRR788203               788/000/SRR788  /000/SRR7882030
 0/SRR7882030_1  0/SRR7882030_2               2030/SRR788203  /SRR7882030_2.f
 .fastq.gz       .fastq.gz                    0_1.fastq.gz    astq.gz
 http://ftp.sra  http://ftp.sra  -            era-fasp@fasp.  era-fasp@fasp.s
 .ebi.ac.uk/vol  .ebi.ac.uk/vol               sra.ebi.ac.uk:  ra.ebi.ac.uk:vo
 1/fastq/SRR788  1/fastq/SRR788               vol1/fastq/SRR  l1/fastq/SRR788
 /001/SRR788203  /001/SRR788203               788/001/SRR788  /001/SRR7882031
 1/SRR7882031_1  1/SRR7882031_2               2031/SRR788203  /SRR7882031_2.f
 .fastq.gz       .fastq.gz                    1_1.fastq.gz    astq.gz

Columns 56-57:
 study_geo_accession                experiment_geo_accession                  
 GSE120236                          GSM3396532
 GSE120236                          GSM3396533
 GSE120236                          GSM3396534
 GSE120236                          GSM3396535
 GSE120236                          GSM3396536
 GSE120236                          GSM3396537
 GSE120236                          GSM3396538
 GSE120236                          GSM3396539
 GSE120236                          GSM3396540
 GSE120236                          GSM3396541
 GSE120236                          GSM3396542
 GSE120236                          GSM3396543
 GSE120236                          GSM3396544
 GSE120236                          GSM3396545
 GSE120236                          GSM3396546
 GSE120236                          GSM3396547
 GSE120236                          GSM3396548
 GSE120236                          GSM3396549

Download an entire project!

[8]:
print("pysradb download -p SRP162234")
pysradb download -p SRP162234