run_metadata
1 row where experiment.library_layout = "SINGLE", technology = "10x" and tissue_curation_coarse = "Surface Structure"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76372 | 76372 | SRR24954201 | SRX20712237 | SRS18004425 | SRP444513 | PRJNA981358 | Danio rerio Genome sequencing and assembly | PRJNA981358 | Whole Genome Sequencing | To explore the source of Csf1a and Csf1b in embryonic zebrafish we carried out a single cell RNA sequencing scRNA seq. We collected the trunks from 28 hpf embryos and performed 10X Genomics scRNA seq. | This sample contained cells isolated from trunks of 40 zebrafish embryos at 28hpf. | Cells isolated from trunks of wildtype danio rerio at 28hpf | WT 1 | strain:ABSR|dev stage:28 hpf date:2019 11 18|geo loc name:China: Guangzhou|sex:not determined|tissue:Trunk|BioSampleModel:Model organism or animal | scRNA seq of 28hpfWT trunk | 28hpfWT 1 | 28hpfWT 1 | Cellular suspensions were loaded on a 10X Genomics GemCode Single cell instrument that generates single cell Gel Bead In EMlusion GEMs. Libraries were generated and sequenced from the cDNAs with Chromium Next GEM Single Cell 3 Reagent Kits v3.1. Upon dissolution of the Gel Bead in a GEM primers containing i an Illumina R1 sequence read 1 sequencing primer ii a 16nt 10x Barcode iii a 10nt Unique Molecular Identifier UMI and iv a poly dT primer sequence were released and mixed with cell lysate and Master Mix. Barcoded full length cDNAs were then reverse transcribed from poly adenylated mRNA. Silane magnetic beads were used to remove leftover biochemical reagents and primers from the post GEM reaction mixture. Full length barcoded cDNAs were then amplified by PCR to generate sufficient mass for library construction. R1 were added to the molecules during GEM incubation. P5 P7 a sample index and R2 were added during library construction via End Repair A tailing Adaptor Ligation and PCR. The final libraries contained the P5 and P7 primers used in Illumina bridge amplification. | RNA-Seq | TRANSCRIPTOMIC SINGLE CELL | cDNA | SINGLE | ILLUMINA | Illumina NovaSeq 6000 | SRP444513 | J1911072-ATGCTCCG_BKDL192544560-1a-AK949_2.fq.gz J1911072-CACTCGGA_BKDL192544560-1a-AK946_1.fq.gz J1911072-CACTCGGA_BKDL192544560-1a-AK946_2.fq.gz J1911072-GCTGAATT_BKDL192544560-1a-AK947_1.fq.gz J1911072-GCTGAATT_BKDL192544560-1a-AK947_2.fq.gz J1911072-TGAAGTAC_BKDL192544560-1a-AK948_1.fq.gz J1911072-TGAAGTAC_BKDL192544560-1a-AK948_2.fq.gz J1911072-ATGCTCCG_BKDL192544560-1a-AK949_1.fq.gz | fastq fastq fastq fastq fastq fastq fastq fastq | 144260432400.0 | 480868108.0 | J1911072 ATGCTCCG BKDL192544560 1a AK949 1.fq.gz | 0:150 1:150 | A:57113710706;C:25903289244;G:24836065109;T:36405707402;N:1659939 | 150 | 150 | 57113710706 | 25903289244 | 24836065109 | 36405707402 | 1659939 | SRX20712237 | SRS18004425 | SRA1657728 | South China University of Technology|School of Medicine | South China University of Technology | 2 | 0.0 | 0.92449 | 0.0 | 0.12055 | 1.0 | 0.77806 | 0.51028 | 150 | 150 | T | B | mate1 technical by mapping diff | illumina | novaseq_era | full_length | cdna_unspecified | unknown | sc | single_cell_droplet | 10x | China | 2023-06-17 | Pharyngula | Embryo | Trunk | Surface Structure |
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");;