RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_selection = "Oligo-dT" and tissue_curation_coarse = "Endocrine System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Endocrine System · 6 ✖

tissue_curation 1

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • Oligo-dT · 6 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

Link rowid ▼ run.accession experiment.accession sample.accession study.accession bioproject study.title study.alias study.type study.abstract study.attributes study.PMIDs sample.description sample.title sample.alias sample.centername sample.attributes GEOsample.title GEOsample.dataprocessing GEOsample.source GEOsample.treatmentprotocol GEOsample.extractprotocol GEOsample.growthprotocol GEOsample.characteristics GEOsample.accession experiment.title experiment.alias experiment.library_name experiment.design_description experiment.library_construction_protocol experiment.attributes experiment.library_strategy experiment.library_source experiment.library_selection experiment.library_layout experiment.platform experiment.instrument_model experiment.spot_descriptor experiment.study_ref run.title run.attributes run.filename run.semantic_name run.total_bases run.total_spots run.alias run.read_lengths run.base_counts run.r1_length run.r2_length run.r3_length run.r4_length run.Acount run.Ccount run.Gcount run.Tcount run.Ncount run.experiment run.pool_member submission.accession submission.srasource submission.bioprojectsource seqdetective.n_mates seqdetective.mapping_rate.mate1 seqdetective.mapping_rate.mate2 seqdetective.nofeature_rate.mate1 seqdetective.nofeature_rate.mate2 seqdetective.sparsity.mate1 seqdetective.sparsity.mate2 seqdetective.pos_strand_rate.mate1 seqdetective.pos_strand_rate.mate2 seqdetective.readlen.mate1 seqdetective.readlen.mate2 seqdetective.judgement.mate1 seqdetective.judgement.mate2 seqdetective.judgement.reason platform_family instrument_generation read_bias selection_class prep_kit sc_or_bulk tech_class technology tech_variant submission.bioprojectsource.country earliest_date devstage_curation devstage_curation_coarse tissue_curation tissue_curation_coarse
321 321 ERR977589 ERX1054572 ERS805778 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Delta cells R3 SAMEA3498629 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498629|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:34|cell type:Pancreatic Delta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgsst2:GFP|lab host:ZDDM|sample name:34                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:489 14 Delta R3 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 NGS14-B176_SSTcells-03122013_CAGATC_L001_R1_001.fastq.gz NGS14-B176_SSTcells-03122013_CAGATC_L001_R2_001.fastq.gz fastq fastq 17691597128.0 87582164.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:489 14 0:101 1:101 A:4843643109;C:3683816237;G:3736882877;T:5332210638;N:95044267 101 101     4843643109 3683816237 3736882877 5332210638 95044267 ERX1054572 ERS805778 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.92685 0.84146 0.10249 0.11723 0.76532 0.78309 0.39721 0.43714 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System
330 330 ERR977580 ERX1054563 ERS805769 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Beta cells R3 SAMEA3498620 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498620|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:25|cell type:Pancreatic Beta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgins:GFP|lab host:ZDDM|sample name:25                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:487 5 Beta R3 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 NGS14-B174_Betacells-03122013_GCCAAT_L002_R1_001.fastq.gz NGS14-B174_Betacells-03122013_GCCAAT_L002_R2_001.fastq.gz fastq fastq 17625660086.0 87255743.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:487 5 0:101 1:101 A:4840276660;C:3724973884;G:3755195525;T:5214977933;N:90236084 101 101     4840276660 3724973884 3755195525 5214977933 90236084 ERX1054563 ERS805769 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.90631 0.8718 0.11791 0.11942 0.76203 0.77638 0.53654 0.49457 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System
331 331 ERR977579 ERX1054562 ERS805768 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Beta cells R2 2 SAMEA3498619 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498619|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:24|cell type:Pancreatic Beta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgins:GFP|lab host:ZDDM|sample name:24                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:487 4 Beta R2 2 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 BetaCell2_A026_ATGTCA_L004_R1_001.fastq.gz BetaCell2_A026_ATGTCA_L004_R2_001.fastq.gz fastq fastq 8532015198.0 42237699.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:487 4 0:101 1:101 A:2314776471;C:1823939144;G:1839244845;T:2552984556;N:1070182 101 101     2314776471 1823939144 1839244845 2552984556 1070182 ERX1054562 ERS805768 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.69844 0.57999 0.09124 0.07501 0.80876 0.82964 0.56023 0.5159 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System
332 332 ERR977578 ERX1054561 ERS805767 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Beta cells R2 1 SAMEA3498618 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498618|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:23|cell type:Pancreatic Beta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgins:GFP|lab host:ZDDM|sample name:23                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:487 3 Beta R2 1 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 BetaCell_ATGTCA_L005_R1_001.fastq.gz BetaCell_ATGTCA_L005_R2_001.fastq.gz fastq fastq 3250611068.0 16092134.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:487 3 0:101 1:101 A:854826460;C:691024995;G:695294721;T:954934438;N:54530454 101 101     854826460 691024995 695294721 954934438 54530454 ERX1054561 ERS805767 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.67496 0.53873 0.08771 0.06606 0.80969 0.83433 0.56231 0.51717 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System
333 333 ERR977577 ERX1054560 ERS805766 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Beta cells R1 2 SAMEA3498617 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498617|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:22|cell type:Pancreatic Beta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgins:GFP|lab host:ZDDM|sample name:22                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:487 2 Beta R1 2 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 BetaCell1_A003_GTCCGC_L004_R1_001.fastq.gz BetaCell1_A003_GTCCGC_L004_R2_001.fastq.gz fastq fastq 3765102038.0 18639119.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:487 2 0:101 1:101 A:1050226787;C:789381360;G:801049952;T:1123973291;N:470648 101 101     1050226787 789381360 801049952 1123973291 470648 ERX1054560 ERS805766 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.90456 0.86125 0.12934 0.13194 0.77721 0.79109 0.56708 0.53213 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System
334 334 ERR977576 ERX1054559 ERS805765 ERP011346 PRJEB10140 RNAseq from the pancreatic acinar alpha beta and delta cells from zebrafish ena-STUDY-GIGA-R, University of Liege-05-08-2015-10:47:24:447-55 Other We took advantage of zebrafish transgenic tools to isolate by FACS the major pancreatic cell types and obtain pure preparations of endocrine a ß and d cells as well as exocrine acinar and ductal cells. ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2017 01 31   Beta cells from adults purified by FACS Beta cells R1 1 SAMEA3498616 GIGA-R, University of Liege ENA first public:2017 01 31|ENA last update:2015 08 05|External Id:SAMEA3498616|INSDC center alias:GIGA R University of Liege|INSDC center name:GIGA R University of Liege|INSDC first public:2017 01 31T17:01:11Z|INSDC last update:2015 08 05T16:56:59Z|INSDC status:public|Submitter Id:21|cell type:Pancreatic Beta cells|collected by:Estefania Tarifeño Saldivia|common name:zebrafish|dev stage:Adult|isolate:Tgins:GFP|lab host:ZDDM|sample name:21                 Illumina HiSeq 2000 paired end sequencing ena EXPERIMENT GIGA R University of Liege 05 08 2015 16:56:42:486 1 Beta R1 1 1 Truseq DNA Sample prep   RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina HiSeq 2000   ERP011346 Illumina HiSeq 2000 paired end sequencing ENA FIRST PUBLIC:2017 01 31|ENA LAST UPDATE:2018 11 16 BetaCells_30000_GTCCGC_L008_R1_001.fastq.gz BetaCells_30000_GTCCGC_L008_R2_001.fastq.gz fastq fastq 10597717092.0 52463946.0 ena RUN GIGA R University of Liege 05 08 2015 16:56:42:486 1 0:101 1:101 A:2951812422;C:2213949786;G:2252957090;T:3178649938;N:347856 101 101     2951812422 2213949786 2252957090 3178649938 347856 ERX1054559 ERS805765 ERA463595 GIGA-R, University of Liege|European Nucleotide Archive GIGA-R, University of Liege 2 0.90302 0.84857 0.12843 0.12749 0.77745 0.79157 0.56129 0.52011 101 101 B B biological fallback assumption illumina hiseq_era unknown poly_a trueseq bulk unknown unknown   Belgium 2015-08-05 Adult Adult Pancreas Endocrine System

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE run_metadata("run.accession" VARCHAR, "experiment.accession" VARCHAR, "sample.accession" VARCHAR, "study.accession" VARCHAR, bioproject VARCHAR, "study.title" VARCHAR, "study.alias" VARCHAR, "study.type" VARCHAR, "study.abstract" VARCHAR, "study.attributes" VARCHAR, "study.PMIDs" VARCHAR, "sample.description" VARCHAR, "sample.title" VARCHAR, "sample.alias" VARCHAR, "sample.centername" VARCHAR, "sample.attributes" VARCHAR, "GEOsample.title" VARCHAR, "GEOsample.dataprocessing" VARCHAR, "GEOsample.source" VARCHAR, "GEOsample.treatmentprotocol" VARCHAR, "GEOsample.extractprotocol" VARCHAR, "GEOsample.growthprotocol" VARCHAR, "GEOsample.characteristics" VARCHAR, "GEOsample.accession" VARCHAR, "experiment.title" VARCHAR, "experiment.alias" VARCHAR, "experiment.library_name" VARCHAR, "experiment.design_description" VARCHAR, "experiment.library_construction_protocol" VARCHAR, "experiment.attributes" VARCHAR, "experiment.library_strategy" VARCHAR, "experiment.library_source" VARCHAR, "experiment.library_selection" VARCHAR, "experiment.library_layout" VARCHAR, "experiment.platform" VARCHAR, "experiment.instrument_model" VARCHAR, "experiment.spot_descriptor" VARCHAR, "experiment.study_ref" VARCHAR, "run.title" VARCHAR, "run.attributes" VARCHAR, "run.filename" VARCHAR, "run.semantic_name" VARCHAR, "run.total_bases" DOUBLE, "run.total_spots" DOUBLE, "run.alias" VARCHAR, "run.read_lengths" VARCHAR, "run.base_counts" VARCHAR, "run.r1_length" BIGINT, "run.r2_length" BIGINT, "run.r3_length" BIGINT, "run.r4_length" BIGINT, "run.Acount" BIGINT, "run.Ccount" BIGINT, "run.Gcount" BIGINT, "run.Tcount" BIGINT, "run.Ncount" BIGINT, "run.experiment" VARCHAR, "run.pool_member" VARCHAR, "submission.accession" VARCHAR, "submission.srasource" VARCHAR, "submission.bioprojectsource" VARCHAR, "seqdetective.n_mates" BIGINT, "seqdetective.mapping_rate.mate1" DOUBLE, "seqdetective.mapping_rate.mate2" DOUBLE, "seqdetective.nofeature_rate.mate1" DOUBLE, "seqdetective.nofeature_rate.mate2" DOUBLE, "seqdetective.sparsity.mate1" DOUBLE, "seqdetective.sparsity.mate2" DOUBLE, "seqdetective.pos_strand_rate.mate1" DOUBLE, "seqdetective.pos_strand_rate.mate2" DOUBLE, "seqdetective.readlen.mate1" BIGINT, "seqdetective.readlen.mate2" BIGINT, "seqdetective.judgement.mate1" VARCHAR, "seqdetective.judgement.mate2" VARCHAR, "seqdetective.judgement.reason" VARCHAR, platform_family VARCHAR, instrument_generation VARCHAR, read_bias VARCHAR, selection_class VARCHAR, prep_kit VARCHAR, sc_or_bulk VARCHAR, tech_class VARCHAR, technology VARCHAR, tech_variant VARCHAR, "submission.bioprojectsource.country" VARCHAR, earliest_date DATE, devstage_curation VARCHAR, devstage_curation_coarse VARCHAR, tissue_curation VARCHAR, tissue_curation_coarse VARCHAR);;
CREATE INDEX idx_run_bioproject ON run_metadata(bioproject);;
CREATE INDEX idx_run_run_accession ON run_metadata("run.accession");;