media_variant

22 rows where media = 367

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
8785 89.0 RTL 367 DS 1 RHGP890_ZT ok 579.31
8788 89.0 RTL 367 HpT 4 RHGP890_ZH ok 579.31
8789 89.0 RTL 367 Ø 5 RHGP890_ZD ok 83.59
8790 89.0 RTL 367 0500-0600 6 RHGP890_FAGA ok 33.06
8791 89.0 RTL 367 0600-0700 7 RHGP890_GAHA ok 75.79
8792 89.0 RTL 367 0700-0800 8 RHGP890_HAIA ok 91.37
8793 89.0 RTL 367 0800-0900 9 RHGP890_IAJA ok 104.6
8794 89.0 RTL 367 0900-1000 10 RHGP890_JAKA ok 89.24
8795 89.0 RTL 367 1000-1100 11 RHGP890_KALA ok 68.69
8796 89.0 RTL 367 1100-1200 12 RHGP890_LAMA ok 72.98
8797 89.0 RTL 367 1200-1300 13 RHGP890_MANA ok 63.46
8798 89.0 RTL 367 1300-1400 14 RHGP890_NAOA ok 68.45
8799 89.0 RTL 367 1400-1500 15 RHGP890_OAPA ok 67.93
8800 89.0 RTL 367 1500-1600 16 RHGP890_PAQA ok 104.53
8801 89.0 RTL 367 1600-1700 17 RHGP890_QARA ok 88.04
8802 89.0 RTL 367 1700-1800 18 RHGP890_RASA ok 72.97
8803 89.0 RTL 367 1800-1900 19 RHGP890_SATA ok 57.04
8804 89.0 RTL 367 1900-2000 20 RHGP890_TAUA ok 26.06
8805 89.0 RTL 367 2000-2100 21 RHGP890_UAVA ok 27.58
8806 89.0 RTL 367 2100-2200 22 RHGP890_VAWA ok 9.37
8807 89.0 RTL 367 2200-2300 23 RHGP890_WAXA ok 11.11
8808 89.0 RTL 367 2300-2400 24 RHGP890_XAYA ok 11.46

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