RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

10 rows where experiment.library_selection = "cDNA", experiment.platform = "ION_TORRENT" and tissue_curation_coarse = "Surface Structure"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation 2

experiment.library_strategy 2

devstage_curation_coarse 2

devstage_curation 2

tissue_curation_coarse 1

  • Surface Structure · 10 ✖

technology 1

experiment.platform 1

  • ION_TORRENT · 10 ✖

experiment.library_source 1

experiment.library_selection 1

  • cDNA · 10 ✖

experiment.library_layout 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
95 95 DRR050167 DRX045209 DRS025834 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing ES1 and EGFP ES1 3 SAMD00044057   sample name:ES1 EGFP rod 003|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044057 DRX045209 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>105</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044057       371748120.0 3469843.0 DRR050167 0:107.14 A:107190409;C:79475572;G:83520360;T:101561779;N:0 107       107190409 79475572 83520360 101561779 0 DRX045209 DRS025834 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.81026   0.26715   0.86953   0.52321   51   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
96 96 DRR050166 DRX045208 DRS025833 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing ES1 and EGFP ES1 2 SAMD00044056   sample name:ES1 EGFP rod 002|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044056 DRX045208 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>128</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044056       425549011.0 3275261.0 DRR050166 0:129.93 A:126640704;C:86415371;G:90822163;T:121670773;N:0 129       126640704 86415371 90822163 121670773 0 DRX045208 DRS025833 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.80223   0.31429   0.85861   0.5272   57   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
97 97 DRR050165 DRX045207 DRS025832 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing ES1 and EGFP ES1 1 SAMD00044055   sample name:ES1 EGFP rod 001|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044055 DRX045207 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>147</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044055       584599765.0 3941083.0 DRR050165 0:148.33 A:164329030;C:129885620;G:136727379;T:153657736;N:0 148       164329030 129885620 136727379 153657736 0 DRX045207 DRS025832 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.83769   0.25395   0.83116   0.52784   185   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
98 98 DRR050164 DRX045206 DRS025831 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing EGFP EGFP 3 SAMD00044054   sample name:EGFP rod 003|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044054 DRX045206 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>88</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044054       343014114.0 3827762.0 DRR050164 0:89.61 A:99421434;C:73070267;G:77738821;T:92783592;N:0 89       99421434 73070267 77738821 92783592 0 DRX045206 DRS025831 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.78953   0.25529   0.87367   0.52148   24   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
99 99 DRR050163 DRX045205 DRS025830 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing EGFP EGFP 2 SAMD00044053   sample name:EGFP rod 002|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044053 DRX045205 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>137</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044053       533069427.0 3824140.0 DRR050163 0:139.40 A:152608173;C:113928273;G:120051739;T:146481242;N:0 139       152608173 113928273 120051739 146481242 0 DRX045205 DRS025830 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.80412   0.26768   0.85338   0.52255   245   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
100 100 DRR050162 DRX045204 DRS025829 DRP003043 PRJDB4416 Transcriptome analysis in ES1 expressing rods of zebrafish DRP003043 Transcriptome Analysis Transcriptome analysis using next generation sequencing system for isolated rods from zebrafish of wild type T?bingen long fin TL line. Transgenic zebrafish expressing ES1 and/or EGFP in rods were used.     Zebrafish rods expressing EGFP EGFP 1 SAMD00044052   sample name:EGFP rod 001|strain:Tubingen long fin|cell type:rod                 Ion Torrent PGM sequencing of SAMD00044052 DRX045204 1 1 1   RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent PGM <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>113</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP003043 Ion Torrent PGM sequencing of SAMD00044052       478262965.0 4224064.0 DRR050162 0:113.22 A:136348264;C:104872341;G:113114502;T:123927858;N:0 113       136348264 104872341 113114502 123927858 0 DRX045204 DRS025829 DRA004229 OSAKA_FB|Kawamura lab., Frontier Biology, Osaka univ. Osaka university 1 0.86947   0.29839   0.83317   0.51453   80   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Japan 2016-03-09 Undetermined Undetermined Fin Surface Structure
41421 41421 SRR4423115 SRX2245299 SRS1745859 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Adult MWB Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:Adult|sex:male|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: Adult male whole body 94 3 94 3 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     maleRID0094BC03smallZF.fastq fastq 697814234.0 14408051.0 maleRID0094BC03smallZF.fastq 0:48.43 A:165337411;C:177790468;G:184204311;T:170482044;N:0 48       165337411 177790468 184204311 170482044 0 SRX2245299 SRS1745859 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.70426   0.16215   0.91027   0.5459   120   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Adult Adult Trunk Surface Structure
41423 41423 SRR4423113 SRX2245297 SRS1745859 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Adult MWB Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:Adult|sex:male|tissue:whole body|BioSampleModel:Model organism or animal                 RNA Seq of Zebrafish: Adult male whole body 99 5 99 5 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific.     RNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     maleRID0099BC05LargeZF.fastq fastq 3606425618.0 40350582.0 maleRID0099BC05LargeZF.fastq 0:89.38 A:900873268;C:899774590;G:1079098037;T:726679723;N:0 89       900873268 899774590 1079098037 726679723 0 SRX2245297 SRS1745859 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.90069   0.21287   0.95726   0.72186   53   B   usable mapping rate ion_torrent ion_torrent unknown cdna_unspecified unknown bulk unknown unknown   Netherlands 2016-10-19 Adult Adult Trunk Surface Structure
41425 41425 SRR4423111 SRX2245295 SRS1745859 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Adult MWB Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:Adult|sex:male|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: Adult male whole body 88 3 88 3 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     maleRID0088BC03smallZF.fastq fastq 523776538.0 11118832.0 maleRID0088BC03smallZF.fastq 0:47.11 A:123827431;C:133478804;G:138882662;T:127587641;N:0 47       123827431 133478804 138882662 127587641 0 SRX2245295 SRS1745859 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.69556   0.16368   0.9093   0.54838   22   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Adult Adult Trunk Surface Structure
41427 41427 SRR4423109 SRX2245293 SRS1745859 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Adult MWB Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:Adult|sex:male|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: Adult male whole body 93 3 93 3 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     maleRID0093BC03smallZF.fastq fastq 692750598.0 14286031.0 maleRID0093BC03smallZF.fastq 0:48.49 A:164412063;C:176380331;G:182539801;T:169418403;N:0 48       164412063 176380331 182539801 169418403 0 SRX2245293 SRS1745859 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.70738   0.16645   0.90948   0.55306   22   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Adult Adult Trunk Surface Structure

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");;