RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

8 rows where experiment.library_layout = "PAIRED", technology = "unknown" and tissue_curation = "Pituitary Gland"

✎ View and edit SQL

This data as json, CSV (advanced)

experiment.library_selection 2

tissue_curation_coarse 1

tissue_curation 1

  • Pituitary Gland · 8 ✖

technology 1

  • unknown · 8 ✖

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_layout 1

  • PAIRED · 8 ✖

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
33348 33348 SRR30085223 SRX25558689 SRS22210797 SRP523634 PRJNA1142970 rna sequncing of POMC miR 7a zebrafish PRJNA1142970 Other           Pomc WT   strain:Wild type|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:5 mpf date:2017 03|geo loc name:Taiwan|sex:pooled male and female|tissue:Pituitary gland|BioSampleModel:Model organism or animal                 RNA Seq of pomc neuron:wild type zebrafish Pomc WT Pomc WT RNA was extracted from pooled zebrafish pomc neron     RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA Illumina HiScanSQ   SRP523634     Pomc_WT_1.fq Pomc_WT_2.fq fastq fastq 7525490700.0 25084969.0 Pomc WT 1.fq 0:150 1:150 A:2000028813;C:1750437540;G:1771219215;T:2003249941;N:555191 150 150     2000028813 1750437540 1771219215 2003249941 555191 SRX25558689 SRS22210797 SRA1937807 National Yang Ming Chiao Tung University|Institute of Biopharmaceutical Sciences National Yang Ming Chiao Tung University                       B B biological fallback assumption illumina early_illumina unknown cdna_unspecified unknown bulk unknown unknown   Taiwan 2024-08-01 Adult Adult Pituitary Gland Endocrine System
33349 33349 SRR30085224 SRX25558688 SRS22210796 SRP523634 PRJNA1142970 rna sequncing of POMC miR 7a zebrafish PRJNA1142970 Other           Pomc 7a   strain:Pomc miR7a|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:5 mpf date:2017 03|geo loc name:Taiwan|sex:pooled male and female|tissue:Pituitary gland|BioSampleModel:Model organism or animal                 RNA Seq of pomc neuron:micorRNA 7a overexpressed zebrafish Pomc 7a Pomc 7a RNA was extracted from pooled zebrafish pomc neron     RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA Illumina HiScanSQ   SRP523634     Pomc_7a_1.fq Pomc_7a_2.fq fastq fastq 9785072700.0 32616909.0 Pomc 7a 1.fq 0:150 1:150 A:2643936280;C:2244968340;G:2260302975;T:2635083506;N:781599 150 150     2643936280 2244968340 2260302975 2635083506 781599 SRX25558688 SRS22210796 SRA1937807 National Yang Ming Chiao Tung University|Institute of Biopharmaceutical Sciences National Yang Ming Chiao Tung University                       B B biological fallback assumption illumina early_illumina unknown cdna_unspecified unknown bulk unknown unknown   Taiwan 2024-08-01 Adult Adult Pituitary Gland Endocrine System
55229 55229 SRR10199493 SRX6919651 SRS5450537 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         Chr23PG replicate 1   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:15 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary CHR23 PG1 CHR23 PG1 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     Chr23-PG1_combined_R1.fastq.gz Chr23-PG1_combined_R2.fastq.gz fastq fastq 6654002100.0 22180007.0 Chr23 PG1 combined R1.fastq.gz 0:150 1:150 A:1819739632;C:1499478529;G:1515944103;T:1818620794;N:219042 150 150     1819739632 1499478529 1515944103 1818620794 219042 SRX6919651 SRS5450537 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.92113 0.92255 0.09207 0.09331 0.71573 0.7205 0.52726 0.58205 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland Endocrine System
55241 55241 SRR10199505 SRX6919639 SRS5450525 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         WTPG replicate 3   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:20 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary WT PG3 WT PG3 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     WT-PG3_combined_R1.fastq.gz WT-PG3_combined_R2.fastq.gz fastq fastq 6751713000.0 22505710.0 WT PG3 combined R1.fastq.gz 0:150 1:150 A:1869416559;C:1496572806;G:1514851553;T:1870652394;N:219688 150 150     1869416559 1496572806 1514851553 1870652394 219688 SRX6919639 SRS5450525 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.92953 0.93151 0.09098 0.09156 0.73074 0.73699 0.66993 0.67339 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland Endocrine System
55242 55242 SRR10199506 SRX6919638 SRS5450524 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         WTPG replicate 2   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:19 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary WT PG2 WT PG2 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     WT-PG2_combined_R1.fastq.gz WT-PG2_combined_R2.fastq.gz fastq fastq 6370809600.0 21236032.0 WT PG2 combined R1.fastq.gz 0:150 1:150 A:1787150048;C:1388750804;G:1405374191;T:1789322231;N:212326 150 150     1787150048 1388750804 1405374191 1789322231 212326 SRX6919638 SRS5450524 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.9274 0.92797 0.09768 0.09788 0.7288 0.73387 0.6714 0.67474 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland Endocrine System
55243 55243 SRR10199507 SRX6919637 SRS5450523 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         WTPG replicate 1   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:18 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary WT PG1 WT PG1 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     WT-PG1_combined_R1.fastq.gz WT-PG1_combined_R2.fastq.gz fastq fastq 7088374200.0 23627914.0 WT PG1 combined R1.fastq.gz 0:150 1:150 A:1976454953;C:1556957648;G:1576097593;T:1978627198;N:236808 150 150     1976454953 1556957648 1576097593 1978627198 236808 SRX6919637 SRS5450523 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.92813 0.92862 0.09435 0.09468 0.73072 0.73732 0.67177 0.67649 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland Endocrine System
55244 55244 SRR10199508 SRX6919636 SRS5450522 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         Chr23PG replicate 3   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:17 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary CHR23 PG3 CHR23 PG3 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     Chr23-PG3_combined_R1.fastq.gz Chr23-PG3_combined_R2.fastq.gz fastq fastq 6306831900.0 21022773.0 Chr23 PG3 combined R1.fastq.gz 0:150 1:150 A:1761625771;C:1384630771;G:1399189529;T:1761175818;N:210011 150 150     1761625771 1384630771 1399189529 1761175818 210011 SRX6919636 SRS5450522 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.91822 0.91897 0.09779 0.09773 0.71676 0.72198 0.59874 0.52969 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland Endocrine System
55245 55245 SRR10199509 SRX6919635 SRS5450521 SRP223604 PRJNA574807 comparative transcriptome between wildtype and chr23 KO zebrafish. PRJNA574807 Other the comparative transcriptome between wildtype and chr23 KO zebrafish were analyzed to uncover the cause of the failure of the oocyte maturation and ovulation in chr23 KO.         Chr23PG replicate 2   strain:AB line|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:16 month|dev stage:sex mature|sex:female|tissue:pituitaty|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: adult female pituitary CHR23 PG2 CHR23 PG2 the libraries were constructed and sequenced on Illumina HiSeq using paired end protocol by GENEWIZ Biotechnology Co. LTD     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED ILLUMINA HiSeq X Ten   SRP223604     Chr23-PG2_combined_R1.fastq.gz Chr23-PG2_combined_R2.fastq.gz fastq fastq 6790899600.0 22636332.0 Chr23 PG2 combined R1.fastq.gz 0:150 1:150 A:1842525837;C:1545697169;G:1560457672;T:1841998398;N:220524 150 150     1842525837 1545697169 1560457672 1841998398 220524 SRX6919635 SRS5450521 SRA969652 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.92407 0.92584 0.0916 0.09113 0.71644 0.72141 0.5239 0.59097 150 150 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2019-09-29 Adult Adult Pituitary Gland 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");;