run_metadata
4 rows where experiment.library_selection = "cDNA", experiment.library_strategy = "RIP-Seq" and technology = "unknown"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71624 | 71624 | SRR21849078 | SRX17837652 | SRS15359804 | SRP401744 | PRJNA888821 | The RNA binding protein CSDE1 promotes hematopoietic stem and progenitor cell generation via translational control of Wnt signaling | PRJNA888821 | Other | We identified RBP as an important post transcriptional regulator of HSPC generation and elucidated the underlying molecular mechanisms. The study also provides helpful insights into designing novel strategies for HSPC generation in vitro. | 33 hpf Zebrafish Bulk RIP seq.Flag hCsde1 2 | Zebrafish 33 hpf.Bulk RIP seq.Flag hCsde1 2 | breed:Zebrafish|age:33 hpf|dev stage:HSPC generation|sex:pooled male and female|tissue:whole embryos|treatment:8|BioSampleModel:Model organism or animal | 33 hpf Zebrafish Bulk RIP seq.Flag hCsde1 2 | Flag hCsde1 2 | Flag hCsde1 2 | RIP Seq | RIP-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP401744 | Flag-hCsde1-2_1.fq.gz Flag-hCsde1-2_2.fq.gz | fastq fastq | 7253178600.0 | 24177262.0 | Flag hCsde1 2 1.fq.gz | 0:150 1:150 | A:1490001899;C:2113749179;G:2152941566;T:1496406491;N:79465 | 150 | 150 | 1490001899 | 2113749179 | 2152941566 | 1496406491 | 79465 | SRX17837652 | SRS15359804 | SRA1516844 | Institute of Hematology & Blood Diseases Hospital|State Key Laboratory of Experimental Hematology | Institute of Hematology & Blood Diseases Hospital | 2 | 0.9907 | 0.98973 | 0.51575 | 0.5119 | 0.9459 | 0.94631 | 0.80609 | 0.80353 | 150 | 150 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2022-10-09 | Pharyngula | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||
| 71625 | 71625 | SRR21849079 | SRX17837651 | SRS15359803 | SRP401744 | PRJNA888821 | The RNA binding protein CSDE1 promotes hematopoietic stem and progenitor cell generation via translational control of Wnt signaling | PRJNA888821 | Other | We identified RBP as an important post transcriptional regulator of HSPC generation and elucidated the underlying molecular mechanisms. The study also provides helpful insights into designing novel strategies for HSPC generation in vitro. | 33 hpf Zebrafish Bulk RIP seq.Flag hCsde1 1 | Zebrafish 33 hpf.Bulk RIP seq.Flag hCsde1 1 | breed:Zebrafish|age:33 hpf|dev stage:HSPC generation|sex:pooled male and female|tissue:whole embryos|treatment:7|BioSampleModel:Model organism or animal | 33 hpf Zebrafish Bulk RIP seq.Flag hCsde1 1 | Flag hCsde1 1 | Flag hCsde1 1 | RIP Seq | RIP-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP401744 | Flag-hCsde1-1_1.fq.gz Flag-hCsde1-1_2.fq.gz | fastq fastq | 5032252500.0 | 16774175.0 | Flag hCsde1 1 1.fq.gz | 0:150 1:150 | A:1150344713;C:1135461821;G:1687878347;T:1058543429;N:24190 | 150 | 150 | 1150344713 | 1135461821 | 1687878347 | 1058543429 | 24190 | SRX17837651 | SRS15359803 | SRA1516844 | Institute of Hematology & Blood Diseases Hospital|State Key Laboratory of Experimental Hematology | Institute of Hematology & Blood Diseases Hospital | 2 | 0.22813 | 0.23161 | 0.06226 | 0.06317 | 0.92801 | 0.92719 | 0.73744 | 0.71685 | 150 | 150 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2022-10-09 | Pharyngula | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||
| 71626 | 71626 | SRR21849080 | SRX17837650 | SRS15359801 | SRP401744 | PRJNA888821 | The RNA binding protein CSDE1 promotes hematopoietic stem and progenitor cell generation via translational control of Wnt signaling | PRJNA888821 | Other | We identified RBP as an important post transcriptional regulator of HSPC generation and elucidated the underlying molecular mechanisms. The study also provides helpful insights into designing novel strategies for HSPC generation in vitro. | 33 hpf Zebrafish Bulk RIP seq.Control2 | Zebrafish 33 hpf.Bulk RIP seq.Control2 | breed:Zebrafish|age:33 hpf|dev stage:HSPC generation|sex:pooled male and female|tissue:whole embryos|treatment:6|BioSampleModel:Model organism or animal | 33 hpf Zebrafish Bulk RIP seq.Control2 | Control2 | Control2 | RIP Seq | RIP-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP401744 | Control2_1.fq.gz Control2_2.fq.gz | fastq fastq | 7884108600.0 | 26280362.0 | Control2 1.fq.gz | 0:150 1:150 | A:1586894082;C:2334065454;G:2372509011;T:1590552802;N:87251 | 150 | 150 | 1586894082 | 2334065454 | 2372509011 | 1590552802 | 87251 | SRX17837650 | SRS15359801 | SRA1516844 | Institute of Hematology & Blood Diseases Hospital|State Key Laboratory of Experimental Hematology | Institute of Hematology & Blood Diseases Hospital | 2 | 0.98745 | 0.98691 | 0.48401 | 0.48011 | 0.94095 | 0.94113 | 0.74796 | 0.74138 | 150 | 150 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2022-10-09 | Pharyngula | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||
| 71627 | 71627 | SRR21849081 | SRX17837649 | SRS15359800 | SRP401744 | PRJNA888821 | The RNA binding protein CSDE1 promotes hematopoietic stem and progenitor cell generation via translational control of Wnt signaling | PRJNA888821 | Other | We identified RBP as an important post transcriptional regulator of HSPC generation and elucidated the underlying molecular mechanisms. The study also provides helpful insights into designing novel strategies for HSPC generation in vitro. | 33 hpf Zebrafish Bulk RIP seq.Control1 | Zebrafish 33 hpf.Bulk RIP seq.Control1 | breed:Zebrafish|age:33 hpf|dev stage:HSPC generation|sex:pooled male and female|tissue:whole embryos|treatment:5|BioSampleModel:Model organism or animal | 33 hpf Zebrafish Bulk RIP seq.Control1 | Control1 | Control1 | RIP Seq | RIP-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP401744 | Control1_1.fq.gz Control1_2.fq.gz | fastq fastq | 6838591200.0 | 22795304.0 | Control1 1.fq.gz | 0:150 1:150 | A:1483754703;C:1578056923;G:2412990846;T:1363739708;N:49020 | 150 | 150 | 1483754703 | 1578056923 | 2412990846 | 1363739708 | 49020 | SRX17837649 | SRS15359800 | SRA1516844 | Institute of Hematology & Blood Diseases Hospital|State Key Laboratory of Experimental Hematology | Institute of Hematology & Blood Diseases Hospital | 2 | 0.34381 | 0.34082 | 0.09181 | 0.09135 | 0.95144 | 0.95148 | 0.81928 | 0.81462 | 150 | 150 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2022-10-09 | Pharyngula | Embryo | Whole Organism | All anatomical structures |
Advanced export
JSON shape: default, array, newline-delimited
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");;