media_variant

18 rows where media = 357

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8545 MDR JUMP 357 DS 1 RHGMDRJ_ZT ok 1977.93
8548 MDR JUMP 357 HpT 4 RHGMDRJ_ZH ok 1977.93
8549 MDR JUMP 357 Ø 5 RHGMDRJ_ZD ok 293.37
8550 MDR JUMP 357 0500-0600 6 RHGMDRJ_FAGA ok 146.01
8551 MDR JUMP 357 0600-0700 7 RHGMDRJ_GAHA ok 362.16
8552 MDR JUMP 357 0700-0800 8 RHGMDRJ_HAIA ok 509.81
8553 MDR JUMP 357 0800-0900 9 RHGMDRJ_IAJA ok 377.62
8554 MDR JUMP 357 0900-1000 10 RHGMDRJ_JAKA ok 230.94
8555 MDR JUMP 357 1000-1100 11 RHGMDRJ_KALA ok 221.82
8556 MDR JUMP 357 1100-1200 12 RHGMDRJ_LAMA ok 219.48
8557 MDR JUMP 357 1200-1300 13 RHGMDRJ_MANA ok 210.58
8558 MDR JUMP 357 1300-1400 14 RHGMDRJ_NAOA ok 192.48
8559 MDR JUMP 357 1400-1500 15 RHGMDRJ_OAPA ok 238.18
8560 MDR JUMP 357 1500-1600 16 RHGMDRJ_PAQA ok 258.68
8561 MDR JUMP 357 1600-1700 17 RHGMDRJ_QARA ok 308.35
8562 MDR JUMP 357 1700-1800 18 RHGMDRJ_RASA ok 303.75
8563 MDR JUMP 357 1800-1900 19 RHGMDRJ_SATA ok 236.13
8564 MDR JUMP 357 1900-2000 20 RHGMDRJ_TAUA ok 166.68

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