media_variant

22 rows where media = 144

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
3433 RMS SÜDWEST KOMBI 144 DS 1 RHCRM14_ZT ok 16745.02
3436 RMS SÜDWEST KOMBI 144 HpT 4 RHCRM14_ZH ok 16745.02
3437 RMS SÜDWEST KOMBI 144 Ø 5 RHCRM14_ZD ok 3489.66
3438 RMS SÜDWEST KOMBI 144 0500-0600 6 RHCRM14_FAGA ok 1255.2
3439 RMS SÜDWEST KOMBI 144 0600-0700 7 RHCRM14_GAHA ok 2999.94
3440 RMS SÜDWEST KOMBI 144 0700-0800 8 RHCRM14_HAIA ok 4445.67
3441 RMS SÜDWEST KOMBI 144 0800-0900 9 RHCRM14_IAJA ok 3901.37
3442 RMS SÜDWEST KOMBI 144 0900-1000 10 RHCRM14_JAKA ok 3324.43
3443 RMS SÜDWEST KOMBI 144 1000-1100 11 RHCRM14_KALA ok 3043.83
3444 RMS SÜDWEST KOMBI 144 1100-1200 12 RHCRM14_LAMA ok 2895.66
3445 RMS SÜDWEST KOMBI 144 1200-1300 13 RHCRM14_MANA ok 2971.2
3446 RMS SÜDWEST KOMBI 144 1300-1400 14 RHCRM14_NAOA ok 2889.13
3447 RMS SÜDWEST KOMBI 144 1400-1500 15 RHCRM14_OAPA ok 2846.91
3448 RMS SÜDWEST KOMBI 144 1500-1600 16 RHCRM14_PAQA ok 2901.01
3449 RMS SÜDWEST KOMBI 144 1600-1700 17 RHCRM14_QARA ok 3310.64
3450 RMS SÜDWEST KOMBI 144 1700-1800 18 RHCRM14_RASA ok 3310.17
3451 RMS SÜDWEST KOMBI 144 1800-1900 19 RHCRM14_SATA ok 2630.09
3452 RMS SÜDWEST KOMBI 144 1900-2000 20 RHCRM14_TAUA ok 1718.93
3453 RMS SÜDWEST KOMBI 144 2000-2100 21 RHCRM14_UAVA ok 1068.46
3454 RMS SÜDWEST KOMBI 144 2100-2200 22 RHCRM14_VAWA ok 731.25
3455 RMS SÜDWEST KOMBI 144 2200-2300 23 RHCRM14_WAXA ok 535.7
3456 RMS SÜDWEST KOMBI 144 2300-2400 24 RHCRM14_XAYA ok 368.54

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