media_variant

22 rows where media = 192

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
4585 RPR Kombi 192 DS 1 RHCRPKB_ZT ok 1984.35
4588 RPR Kombi 192 HpT 4 RHCRPKB_ZH ok 1984.35
4589 RPR Kombi 192 Ø 5 RHCRPKB_ZD ok 317.02
4590 RPR Kombi 192 0500-0600 6 RHCRPKB_FAGA ok 68.75
4591 RPR Kombi 192 0600-0700 7 RHCRPKB_GAHA ok 260.3
4592 RPR Kombi 192 0700-0800 8 RHCRPKB_HAIA ok 481.9
4593 RPR Kombi 192 0800-0900 9 RHCRPKB_IAJA ok 432.52
4594 RPR Kombi 192 0900-1000 10 RHCRPKB_JAKA ok 347.45
4595 RPR Kombi 192 1000-1100 11 RHCRPKB_KALA ok 303.51
4596 RPR Kombi 192 1100-1200 12 RHCRPKB_LAMA ok 253.19
4597 RPR Kombi 192 1200-1300 13 RHCRPKB_MANA ok 272.38
4598 RPR Kombi 192 1300-1400 14 RHCRPKB_NAOA ok 224.76
4599 RPR Kombi 192 1400-1500 15 RHCRPKB_OAPA ok 218.21
4600 RPR Kombi 192 1500-1600 16 RHCRPKB_PAQA ok 243.78
4601 RPR Kombi 192 1600-1700 17 RHCRPKB_QARA ok 319.81
4602 RPR Kombi 192 1700-1800 18 RHCRPKB_RASA ok 303.45
4603 RPR Kombi 192 1800-1900 19 RHCRPKB_SATA ok 200.67
4604 RPR Kombi 192 1900-2000 20 RHCRPKB_TAUA ok 129.61
4605 RPR Kombi 192 2000-2100 21 RHCRPKB_UAVA ok 86.06
4606 RPR Kombi 192 2100-2200 22 RHCRPKB_VAWA ok 43.84
4607 RPR Kombi 192 2200-2300 23 RHCRPKB_WAXA ok 37.93
4608 RPR Kombi 192 2300-2400 24 RHCRPKB_XAYA ok 19.72

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