media_variant

22 rows where media = 389

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
9313 R.SA 389 DS 1 RHHOLFM_ZT ok 733.37
9316 R.SA 389 HpT 4 RHHOLFM_ZH ok 733.37
9317 R.SA 389 Ø 5 RHHOLFM_ZD ok 124.75
9318 R.SA 389 0500-0600 6 RHHOLFM_FAGA ok 65.92
9319 R.SA 389 0600-0700 7 RHHOLFM_GAHA ok 141.58
9320 R.SA 389 0700-0800 8 RHHOLFM_HAIA ok 155.69
9321 R.SA 389 0800-0900 9 RHHOLFM_IAJA ok 139.78
9322 R.SA 389 0900-1000 10 RHHOLFM_JAKA ok 142.28
9323 R.SA 389 1000-1100 11 RHHOLFM_KALA ok 129.01
9324 R.SA 389 1100-1200 12 RHHOLFM_LAMA ok 128.11
9325 R.SA 389 1200-1300 13 RHHOLFM_MANA ok 109.73
9326 R.SA 389 1300-1400 14 RHHOLFM_NAOA ok 106.37
9327 R.SA 389 1400-1500 15 RHHOLFM_OAPA ok 112.17
9328 R.SA 389 1500-1600 16 RHHOLFM_PAQA ok 119.56
9329 R.SA 389 1600-1700 17 RHHOLFM_QARA ok 104.73
9330 R.SA 389 1700-1800 18 RHHOLFM_RASA ok 88.9
9331 R.SA 389 1800-1900 19 RHHOLFM_SATA ok 76.68
9332 R.SA 389 1900-2000 20 RHHOLFM_TAUA ok 40.5
9333 R.SA 389 2000-2100 21 RHHOLFM_UAVA ok 26.92
9334 R.SA 389 2100-2200 22 RHHOLFM_VAWA ok 8.86
9335 R.SA 389 2200-2300 23 RHHOLFM_WAXA ok 8.99
9336 R.SA 389 2300-2400 24 RHHOLFM_XAYA ok 7.1

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