media_variant

22 rows where media = 353

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8449 RMS OST KOMBI PLUS 353 DS 1 RHGRMP2_ZT ok 7652.33
8452 RMS OST KOMBI PLUS 353 HpT 4 RHGRMP2_ZH ok 7652.33
8453 RMS OST KOMBI PLUS 353 Ø 5 RHGRMP2_ZD ok 1715.63
8454 RMS OST KOMBI PLUS 353 0500-0600 6 RHGRMP2_FAGA ok 924.52
8455 RMS OST KOMBI PLUS 353 0600-0700 7 RHGRMP2_GAHA ok 1630.61
8456 RMS OST KOMBI PLUS 353 0700-0800 8 RHGRMP2_HAIA ok 2229.71
8457 RMS OST KOMBI PLUS 353 0800-0900 9 RHGRMP2_IAJA ok 2068.89
8458 RMS OST KOMBI PLUS 353 0900-1000 10 RHGRMP2_JAKA ok 1897.51
8459 RMS OST KOMBI PLUS 353 1000-1100 11 RHGRMP2_KALA ok 1610.22
8460 RMS OST KOMBI PLUS 353 1100-1200 12 RHGRMP2_LAMA ok 1506.89
8461 RMS OST KOMBI PLUS 353 1200-1300 13 RHGRMP2_MANA ok 1425.85
8462 RMS OST KOMBI PLUS 353 1300-1400 14 RHGRMP2_NAOA ok 1312.59
8463 RMS OST KOMBI PLUS 353 1400-1500 15 RHGRMP2_OAPA ok 1403.56
8464 RMS OST KOMBI PLUS 353 1500-1600 16 RHGRMP2_PAQA ok 1473.86
8465 RMS OST KOMBI PLUS 353 1600-1700 17 RHGRMP2_QARA ok 1504.05
8466 RMS OST KOMBI PLUS 353 1700-1800 18 RHGRMP2_RASA ok 1381.85
8467 RMS OST KOMBI PLUS 353 1800-1900 19 RHGRMP2_SATA ok 1158.05
8468 RMS OST KOMBI PLUS 353 1900-2000 20 RHGRMP2_TAUA ok 734.56
8469 RMS OST KOMBI PLUS 353 2000-2100 21 RHGRMP2_UAVA ok 421.66
8470 RMS OST KOMBI PLUS 353 2100-2200 22 RHGRMP2_VAWA ok 267.41
8471 RMS OST KOMBI PLUS 353 2200-2300 23 RHGRMP2_WAXA ok 252
8472 RMS OST KOMBI PLUS 353 2300-2400 24 RHGRMP2_XAYA ok 159.98

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