media_variant

22 rows where media = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
49 Private Sender 3 DS 1 RHZPR14_ZT ok 35524.94
52 Private Sender 3 HpT 4 RHZPR14_ZH ok 35524.94
53 Private Sender 3 Ø 5 RHZPR14_ZD ok 8629.77
54 Private Sender 3 0500-0600 6 RHZPR14_FAGA ok 3494.37
55 Private Sender 3 0600-0700 7 RHZPR14_GAHA ok 7572.14
56 Private Sender 3 0700-0800 8 RHZPR14_HAIA ok 10745.68
57 Private Sender 3 0800-0900 9 RHZPR14_IAJA ok 9936.93
58 Private Sender 3 0900-1000 10 RHZPR14_JAKA ok 8610.98
59 Private Sender 3 1000-1100 11 RHZPR14_KALA ok 7695.25
60 Private Sender 3 1100-1200 12 RHZPR14_LAMA ok 7240.69
61 Private Sender 3 1200-1300 13 RHZPR14_MANA ok 7224.72
62 Private Sender 3 1300-1400 14 RHZPR14_NAOA ok 6876.67
63 Private Sender 3 1400-1500 15 RHZPR14_OAPA ok 6863.03
64 Private Sender 3 1500-1600 16 RHZPR14_PAQA ok 7040.56
65 Private Sender 3 1600-1700 17 RHZPR14_QARA ok 7754.79
66 Private Sender 3 1700-1800 18 RHZPR14_RASA ok 7422.73
67 Private Sender 3 1800-1900 19 RHZPR14_SATA ok 6181.63
68 Private Sender 3 1900-2000 20 RHZPR14_TAUA ok 4173.2
69 Private Sender 3 2000-2100 21 RHZPR14_UAVA ok 2452.81
70 Private Sender 3 2100-2200 22 RHZPR14_VAWA ok 1594.37
71 Private Sender 3 2200-2300 23 RHZPR14_WAXA ok 1415.73
72 Private Sender 3 2300-2400 24 RHZPR14_XAYA ok 910.59

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