metadata: run_metadata: 1 row where experiment.library_layout = "PAIRED", experiment.library_selection = "RT-PCR" and experiment.library

1 row where experiment.library_layout = "PAIRED", experiment.library_selection = "RT-PCR" and experiment.library_source = "TRANSCRIPTOMIC SINGLE CELL"

descending

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
58872	58872	SRR11510448	SRX8082500	SRS6450585	SRP255712	PRJNA623798	Single cell lineage tracing on endogenous scarring sites scLOESS	PRJNA623798	Other	Lineage recording of zebrafish embryogenesis reveals early cell fate commitment			The developmental history of a whole zebrafish organism were recording by LOESS Lineage tracing Of Endogenous Scarring Sites technique. And both cell lineage histories and cell molecular profile were reconstructed by single cell RNA Seq profiling with the help of single cell sequencing methods and self developed analysis strategies.	Single Cell RNA Seq of a whole organism of zebrafish larva	SC		strain:AB line\|age:7dpf\|dev stage:larvae\|sex:not applicable\|tissue:Whole organism\|collection date:2018 07 26\|BioSampleModel:Model organism or animal									Single Cell RNA Seq of a whole organism of zebrafish larva	SC L3	SC L3	Zebrafish embryo at one cell stage were micro injected with gRNA pool and Cas9 mRNA mixture and growth at standard condiction ttwo xxxdpf. Then a single larva were lysis into single cell suspension and the RNA profile were obtained by 10x Genomics Chromium Single Cell three prime Reagent Kits v2 Chemistry.			RNA-Seq	TRANSCRIPTOMIC SINGLE CELL	RT-PCR	PAIRED	ILLUMINA	HiSeq X Ten		SRP255712			SC-I1_S1_L001_R1_001.fastq.gz SC-I1_S1_L001_R2_001.fastq.gz SC-I1_S1_L002_R1_001.fastq.gz SC-I1_S1_L002_R2_001.fastq.gz SC-I1_S1_L003_R1_001.fastq.gz SC-I1_S1_L003_R2_001.fastq.gz SC-I2_S1_L001_R1_001.fastq.gz SC-I2_S1_L001_R2_001.fastq.gz SC-I2_S1_L002_R1_001.fastq.gz SC-I2_S1_L002_R2_001.fastq.gz SC-I2_S1_L003_R1_001.fastq.gz SC-I2_S1_L003_R2_001.fastq.gz SC-I3_S1_L001_R1_001.fastq.gz SC-I3_S1_L001_R2_001.fastq.gz SC-I3_S1_L002_R1_001.fastq.gz SC-I3_S1_L002_R2_001.fastq.gz SC-I3_S1_L003_R1_001.fastq.gz SC-I3_S1_L003_R2_001.fastq.gz SC-I4_S1_L001_R1_001.fastq.gz SC-I4_S1_L001_R2_001.fastq.gz SC-I4_S1_L002_R1_001.fastq.gz SC-I4_S1_L002_R2_001.fastq.gz SC-I4_S1_L003_R1_001.fastq.gz SC-I4_S1_L003_R2_001.fastq.gz	fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq fastq	86925323584.0	493893884.0	SC I1 S1 L001 R1 001.fastq.gz	0:26 1:150	A:24075189135;C:19816237204;G:21200277502;T:21828035227;N:5584516	26	150			24075189135	19816237204	21200277502	21828035227	5584516	SRX8082500	SRS6450585	SRA1063827	Sun Yat- sen University\|Life Sicence School	Sun Yat- sen University	2	0.00528	0.77254	0.00115	0.06529	0.98729	0.8158	0.41854	0.50141	26	150	T	B	sc-like readlen	illumina	hiseq_era	unknown	other	unknown	sc	single_cell_droplet	10x		China	2020-04-11	Larval	Larval	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");;