metadata: run_metadata: 12 rows where devstage_curation = "Hatching" and tissue_curation

12 rows where devstage_curation = "Hatching" and tissue_curation_coarse = "Liver and Biliary System"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	sample.alias	sample.attributes	experiment.title	experiment.alias	experiment.library_name	experiment.design_description	experiment.library_strategy	experiment.library_source	experiment.library_selection	experiment.library_layout	experiment.platform	experiment.instrument_model	experiment.study_ref	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.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	submission.bioprojectsource.country	earliest_date	devstage_curation	devstage_curation_coarse	tissue_curation	tissue_curation_coarse
70306	70306	SRR19661766	SRX15711496	SRS13405891	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h2 S8 L001 R1	strain:not collected\|isolate:9\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	9	60h2 S8 L001 R1	60h2 S8 L001 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h2_S8_L001_R1_001.fastq.gz 60h2_S8_L001_R2_001.fastq.gz	fastq fastq	988020461.0	4273934.0	60h2 S8 L001 R1 001.fastq.gz	0:115.36 1:115.82	A:264286562;C:230326008;G:231614619;T:260866155;N:927117	115	115	264286562	230326008	231614619	260866155	927117	SRX15711496	SRS13405891	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94418	0.94354	0.04632	0.04674	0.82063	0.82199	0.49098	0.49175	79	79	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70313	70313	SRR19661773	SRX15711489	SRS13405884	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h1 S7 L004 R1	strain:not collected\|isolate:7\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	7	60h1 S7 L004 R1	60h1 S7 L004 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h1_S7_L004_R1_001.fastq.gz 60h1_S7_L004_R2_001.fastq.gz	fastq fastq	859059787.0	3783762.0	60h1 S7 L004 R1 001.fastq.gz	0:113.26 1:113.78	A:228878542;C:201258003;G:202624816;T:225356012;N:942414	113	113	228878542	201258003	202624816	225356012	942414	SRX15711489	SRS13405884	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.93549	0.93547	0.04114	0.04156	0.83976	0.84258	0.51763	0.50606	151	151	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70324	70324	SRR19661784	SRX15711478	SRS13405873	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h1 S7 L003 R1	strain:not collected\|isolate:5\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	5	60h1 S7 L003 R1	60h1 S7 L003 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h1_S7_L003_R1_001.fastq.gz 60h1_S7_L003_R2_001.fastq.gz	fastq fastq	861950674.0	3784961.0	60h1 S7 L003 R1 001.fastq.gz	0:113.44 1:114.29	A:229059608;C:201979412;G:204483606;T:225306157;N:1121891	113	114	229059608	201979412	204483606	225306157	1121891	SRX15711478	SRS13405873	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.93591	0.93506	0.04081	0.04127	0.83966	0.84287	0.5149	0.51471	84	84	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70333	70333	SRR19661793	SRX15711469	SRS13405864	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h3 S9 L004 R1	strain:not collected\|isolate:23\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	23	60h3 S9 L004 R1	60h3 S9 L004 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h3_S9_L004_R1_001.fastq.gz 60h3_S9_L004_R2_001.fastq.gz	fastq fastq	1069762288.0	4677877.0	60h3 S9 L004 R1 001.fastq.gz	0:114.07 1:114.61	A:286765598;C:249053001;G:250729965;T:282118693;N:1095031	114	114	286765598	249053001	250729965	282118693	1095031	SRX15711469	SRS13405864	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94728	0.94711	0.05297	0.05422	0.8241	0.82789	0.48666	0.46516	103	103	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70334	70334	SRR19661794	SRX15711468	SRS13405863	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h3 S9 L003 R1	strain:not collected\|isolate:21\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	21	60h3 S9 L003 R1	60h3 S9 L003 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h3_S9_L003_R1_001.fastq.gz 60h3_S9_L003_R2_001.fastq.gz	fastq fastq	1075584819.0	4688707.0	60h3 S9 L003 R1 001.fastq.gz	0:114.26 1:115.14	A:287532279;C:250477581;G:253661779;T:282618621;N:1294559	114	115	287532279	250477581	253661779	282618621	1294559	SRX15711468	SRS13405863	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94671	0.94632	0.05164	0.05273	0.82428	0.82915	0.48857	0.49523	140	140	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70335	70335	SRR19661795	SRX15711467	SRS13405862	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h1 S7 L002 R1	strain:not collected\|isolate:3\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	3	60h1 S7 L002 R1	60h1 S7 L002 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h1_S7_L002_R1_001.fastq.gz 60h1_S7_L002_R2_001.fastq.gz	fastq fastq	861878746.0	3787766.0	60h1 S7 L002 R1 001.fastq.gz	0:113.54 1:114.01	A:228906675;C:202479789;G:203764253;T:225956042;N:771987	113	114	228906675	202479789	203764253	225956042	771987	SRX15711467	SRS13405862	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.93509	0.93555	0.0402	0.04089	0.83899	0.8411	0.51834	0.51745	101	101	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70336	70336	SRR19661796	SRX15711466	SRS13405861	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h3 S9 L002 R1	strain:not collected\|isolate:19\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	19	60h3 S9 L002 R1	60h3 S9 L002 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h3_S9_L002_R1_001.fastq.gz 60h3_S9_L002_R2_001.fastq.gz	fastq fastq	1074021192.0	4687833.0	60h3 S9 L002 R1 001.fastq.gz	0:114.32 1:114.79	A:286968360;C:250769179;G:252395676;T:283023861;N:864116	114	114	286968360	250769179	252395676	283023861	864116	SRX15711466	SRS13405861	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94808	0.94832	0.05209	0.05256	0.82438	0.82651	0.49332	0.49331	141	141	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70337	70337	SRR19661797	SRX15711465	SRS13405860	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h3 S9 L001 R1	strain:not collected\|isolate:17\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	17	60h3 S9 L001 R1	60h3 S9 L001 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h3_S9_L001_R1_001.fastq.gz 60h3_S9_L001_R2_001.fastq.gz	fastq fastq	1119531285.0	4890160.0	60h3 S9 L001 R1 001.fastq.gz	0:114.22 1:114.71	A:299225983;C:261253222;G:262858023;T:295162128;N:1031929	114	114	299225983	261253222	262858023	295162128	1031929	SRX15711465	SRS13405860	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94835	0.94781	0.05256	0.0531	0.82412	0.82706	0.49397	0.49498	151	151	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70338	70338	SRR19661798	SRX15711464	SRS13405859	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h2 S8 L004 R1	strain:not collected\|isolate:15\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	15	60h2 S8 L004 R1	60h2 S8 L004 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h2_S8_L004_R1_001.fastq.gz 60h2_S8_L004_R2_001.fastq.gz	fastq fastq	948410773.0	4105044.0	60h2 S8 L004 R1 001.fastq.gz	0:115.26 1:115.77	A:254458117;C:220561299;G:221934286;T:250478553;N:978518	115	115	254458117	220561299	221934286	250478553	978518	SRX15711464	SRS13405859	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94293	0.9431	0.04627	0.0468	0.82256	0.82582	0.48311	0.48501	150	151	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70339	70339	SRR19661799	SRX15711463	SRS13405858	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h2 S8 L003 R1	strain:not collected\|isolate:13\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	13	60h2 S8 L003 R1	60h2 S8 L003 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h2_S8_L003_R1_001.fastq.gz 60h2_S8_L003_R2_001.fastq.gz	fastq fastq	950927809.0	4105298.0	60h2 S8 L003 R1 001.fastq.gz	0:115.41 1:116.23	A:254408486;C:221307652;G:223835820;T:250222170;N:1153681	115	116	254408486	221307652	223835820	250222170	1153681	SRX15711463	SRS13405858	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94289	0.94218	0.04567	0.04626	0.82045	0.82467	0.48517	0.45898	151	150	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70340	70340	SRR19661800	SRX15711462	SRS13405857	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h2 S8 L002 R1	strain:not collected\|isolate:11\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	11	60h2 S8 L002 R1	60h2 S8 L002 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h2_S8_L002_R1_001.fastq.gz 60h2_S8_L002_R2_001.fastq.gz	fastq fastq	949750170.0	4104267.0	60h2 S8 L002 R1 001.fastq.gz	0:115.47 1:115.93	A:253884726;C:221598118;G:222883814;T:250602054;N:781458	115	115	253884726	221598118	222883814	250602054	781458	SRX15711462	SRS13405857	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.94397	0.94426	0.04597	0.04611	0.82081	0.82347	0.4871	0.48423	151	150	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System
70341	70341	SRR19661801	SRX15711461	SRS13405856	SRP381845	PRJNA849172	Danio rerio Raw sequence reads	PRJNA849172	Other	Liver is an essential organ with multiple biological functions including metabolism detoxification digestion and homeostasis in vertebrates. Zebrafish Danio rerio is an excellent genetic model system to study both processes of liver development and liver regeneration while the molecular mechanism of zebrafish early liver development remain unclear. In this study we performed comparative transcriptome analysis of liver cells which were sorting by flow cytometry in different time points i.e. 60 hpf 72 hpf or 96 hpf.	60h1 S7 L001 R1	strain:not collected\|isolate:1\|age:not collected\|dev stage:hatching\|sex:not determined\|tissue:liver\|BioSampleModel:Model organism or animal	1	60h1 S7 L001 R1	60h1 S7 L001 R1	sorting	RNA-Seq	TRANSCRIPTOMIC	Oligo-dT	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	SRP381845	60h1_S7_L001_R1_001.fastq.gz 60h1_S7_L001_R2_001.fastq.gz	fastq fastq	895999939.0	3942722.0	60h1 S7 L001 R1 001.fastq.gz	0:113.40 1:113.86	A:238123332;C:210325235;G:211633693;T:235024070;N:893609	113	113	238123332	210325235	211633693	235024070	893609	SRX15711461	SRS13405856	SRA1437609	Institute of Hydrobiology, Chinese Academy of Sciences\|Center for Molecular and Cellular Biology of Aquat	Institute of Hydrobiology, Chinese Academy of Sciences	2	0.93559	0.93545	0.04116	0.04187	0.83877	0.8408	0.51256	0.51537	100	100	B	B	biological fallback assumption	illumina	early_illumina	unknown	poly_a	unknown	bulk	unknown	unknown	China	2022-06-15	Hatching	Embryo	Liver	Liver and Biliary System

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