media_variant

17 rows where media = 166

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
3961 SR-Kombi 166 DS 1 RHCSAKB_ZT ok 1135.24
3964 SR-Kombi 166 HpT 4 RHCSAKB_ZH ok 1135.24
3965 SR-Kombi 166 Ø 5 RHCSAKB_ZD ok 250.43
3967 SR-Kombi 166 0600-0700 7 RHCSAKB_GAHA ok 243.14
3968 SR-Kombi 166 0700-0800 8 RHCSAKB_HAIA ok 348.72
3969 SR-Kombi 166 0800-0900 9 RHCSAKB_IAJA ok 349.28
3970 SR-Kombi 166 0900-1000 10 RHCSAKB_JAKA ok 284.49
3971 SR-Kombi 166 1000-1100 11 RHCSAKB_KALA ok 225.15
3972 SR-Kombi 166 1100-1200 12 RHCSAKB_LAMA ok 190.07
3973 SR-Kombi 166 1200-1300 13 RHCSAKB_MANA ok 230.88
3974 SR-Kombi 166 1300-1400 14 RHCSAKB_NAOA ok 200.78
3975 SR-Kombi 166 1400-1500 15 RHCSAKB_OAPA ok 195.21
3976 SR-Kombi 166 1500-1600 16 RHCSAKB_PAQA ok 200.08
3977 SR-Kombi 166 1600-1700 17 RHCSAKB_QARA ok 226.05
3978 SR-Kombi 166 1700-1800 18 RHCSAKB_RASA ok 214.84
3979 SR-Kombi 166 1800-1900 19 RHCSAKB_SATA ok 183.07
3980 SR-Kombi 166 1900-2000 20 RHCSAKB_TAUA ok 101.95

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 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);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);