media_variant

17 rows where media = 175

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4177 SWR1 Kombi BW/RP 175 DS 1 RHCSW11_ZT ok 3910.34
4180 SWR1 Kombi BW/RP 175 HpT 4 RHCSW11_ZH ok 3910.34
4181 SWR1 Kombi BW/RP 175 Ø 5 RHCSW11_ZD ok 759.01
4183 SWR1 Kombi BW/RP 175 0600-0700 7 RHCSW11_GAHA ok 635.76
4184 SWR1 Kombi BW/RP 175 0700-0800 8 RHCSW11_HAIA ok 991.58
4185 SWR1 Kombi BW/RP 175 0800-0900 9 RHCSW11_IAJA ok 962.85
4186 SWR1 Kombi BW/RP 175 0900-1000 10 RHCSW11_JAKA ok 885.55
4187 SWR1 Kombi BW/RP 175 1000-1100 11 RHCSW11_KALA ok 736.45
4188 SWR1 Kombi BW/RP 175 1100-1200 12 RHCSW11_LAMA ok 742.58
4189 SWR1 Kombi BW/RP 175 1200-1300 13 RHCSW11_MANA ok 787.67
4190 SWR1 Kombi BW/RP 175 1300-1400 14 RHCSW11_NAOA ok 644.42
4191 SWR1 Kombi BW/RP 175 1400-1500 15 RHCSW11_OAPA ok 636.34
4192 SWR1 Kombi BW/RP 175 1500-1600 16 RHCSW11_PAQA ok 594.55
4193 SWR1 Kombi BW/RP 175 1600-1700 17 RHCSW11_QARA ok 654.81
4194 SWR1 Kombi BW/RP 175 1700-1800 18 RHCSW11_RASA ok 644.25
4195 SWR1 Kombi BW/RP 175 1800-1900 19 RHCSW11_SATA ok 532.17
4196 SWR1 Kombi BW/RP 175 1900-2000 20 RHCSW11_TAUA ok 332.97

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