media_variant

17 rows where media = 182

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4345 SWR1/4 Kombi BW/RP 182 DS 1 RHCARB1_ZT ok 5287.54
4348 SWR1/4 Kombi BW/RP 182 HpT 4 RHCARB1_ZH ok 5287.54
4349 SWR1/4 Kombi BW/RP 182 Ø 5 RHCARB1_ZD ok 1201.43
4351 SWR1/4 Kombi BW/RP 182 0600-0700 7 RHCARB1_GAHA ok 833.42
4352 SWR1/4 Kombi BW/RP 182 0700-0800 8 RHCARB1_HAIA ok 1419.26
4353 SWR1/4 Kombi BW/RP 182 0800-0900 9 RHCARB1_IAJA ok 1565.06
4354 SWR1/4 Kombi BW/RP 182 0900-1000 10 RHCARB1_JAKA ok 1410.45
4355 SWR1/4 Kombi BW/RP 182 1000-1100 11 RHCARB1_KALA ok 1321.28
4356 SWR1/4 Kombi BW/RP 182 1100-1200 12 RHCARB1_LAMA ok 1262.27
4357 SWR1/4 Kombi BW/RP 182 1200-1300 13 RHCARB1_MANA ok 1235.33
4358 SWR1/4 Kombi BW/RP 182 1300-1400 14 RHCARB1_NAOA ok 1055.41
4359 SWR1/4 Kombi BW/RP 182 1400-1500 15 RHCARB1_OAPA ok 975.05
4360 SWR1/4 Kombi BW/RP 182 1500-1600 16 RHCARB1_PAQA ok 899.25
4361 SWR1/4 Kombi BW/RP 182 1600-1700 17 RHCARB1_QARA ok 943.04
4362 SWR1/4 Kombi BW/RP 182 1700-1800 18 RHCARB1_RASA ok 985.3
4363 SWR1/4 Kombi BW/RP 182 1800-1900 19 RHCARB1_SATA ok 767.19
4364 SWR1/4 Kombi BW/RP 182 1900-2000 20 RHCARB1_TAUA ok 540.84

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);