media_variant

22 rows where media = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
985 RMS SUPER KOMBI 42 DS 1 RHZRS22_ZT ok 31824.18
988 RMS SUPER KOMBI 42 HpT 4 RHZRS22_ZH ok 31824.18
989 RMS SUPER KOMBI 42 Ø 5 RHZRS22_ZD ok 7463.12
990 RMS SUPER KOMBI 42 0500-0600 6 RHZRS22_FAGA ok 3152.83
991 RMS SUPER KOMBI 42 0600-0700 7 RHZRS22_GAHA ok 6729.45
992 RMS SUPER KOMBI 42 0700-0800 8 RHZRS22_HAIA ok 9439.87
993 RMS SUPER KOMBI 42 0800-0900 9 RHZRS22_IAJA ok 8698.25
994 RMS SUPER KOMBI 42 0900-1000 10 RHZRS22_JAKA ok 7433.73
995 RMS SUPER KOMBI 42 1000-1100 11 RHZRS22_KALA ok 6685.73
996 RMS SUPER KOMBI 42 1100-1200 12 RHZRS22_LAMA ok 6331.21
997 RMS SUPER KOMBI 42 1200-1300 13 RHZRS22_MANA ok 6293.62
998 RMS SUPER KOMBI 42 1300-1400 14 RHZRS22_NAOA ok 5970.38
999 RMS SUPER KOMBI 42 1400-1500 15 RHZRS22_OAPA ok 6027.62
1000 RMS SUPER KOMBI 42 1500-1600 16 RHZRS22_PAQA ok 6147.72
1001 RMS SUPER KOMBI 42 1600-1700 17 RHZRS22_QARA ok 6716.16
1002 RMS SUPER KOMBI 42 1700-1800 18 RHZRS22_RASA ok 6424.45
1003 RMS SUPER KOMBI 42 1800-1900 19 RHZRS22_SATA ok 5260.11
1004 RMS SUPER KOMBI 42 1900-2000 20 RHZRS22_TAUA ok 3461.23
1005 RMS SUPER KOMBI 42 2000-2100 21 RHZRS22_UAVA ok 2046.86
1006 RMS SUPER KOMBI 42 2100-2200 22 RHZRS22_VAWA ok 1348.43
1007 RMS SUPER KOMBI 42 2200-2300 23 RHZRS22_WAXA ok 1086.84
1008 RMS SUPER KOMBI 42 2300-2400 24 RHZRS22_XAYA ok 718.27

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