media_variant

22 rows where media = 258

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
6169 ROCK ANTENNE 258 DS 1 RHEROC2_ZT ok 1833.44
6172 ROCK ANTENNE 258 HpT 4 RHEROC2_ZH ok 1833.44
6173 ROCK ANTENNE 258 Ø 5 RHEROC2_ZD ok 275.79
6174 ROCK ANTENNE 258 0500-0600 6 RHEROC2_FAGA ok 89.89
6175 ROCK ANTENNE 258 0600-0700 7 RHEROC2_GAHA ok 182.08
6176 ROCK ANTENNE 258 0700-0800 8 RHEROC2_HAIA ok 283.27
6177 ROCK ANTENNE 258 0800-0900 9 RHEROC2_IAJA ok 305.79
6178 ROCK ANTENNE 258 0900-1000 10 RHEROC2_JAKA ok 292.47
6179 ROCK ANTENNE 258 1000-1100 11 RHEROC2_KALA ok 287.85
6180 ROCK ANTENNE 258 1100-1200 12 RHEROC2_LAMA ok 260.74
6181 ROCK ANTENNE 258 1200-1300 13 RHEROC2_MANA ok 266.28
6182 ROCK ANTENNE 258 1300-1400 14 RHEROC2_NAOA ok 266.12
6183 ROCK ANTENNE 258 1400-1500 15 RHEROC2_OAPA ok 240.18
6184 ROCK ANTENNE 258 1500-1600 16 RHEROC2_PAQA ok 261.22
6185 ROCK ANTENNE 258 1600-1700 17 RHEROC2_QARA ok 279.88
6186 ROCK ANTENNE 258 1700-1800 18 RHEROC2_RASA ok 258.7
6187 ROCK ANTENNE 258 1800-1900 19 RHEROC2_SATA ok 203.86
6188 ROCK ANTENNE 258 1900-2000 20 RHEROC2_TAUA ok 146.97
6189 ROCK ANTENNE 258 2000-2100 21 RHEROC2_UAVA ok 120.48
6190 ROCK ANTENNE 258 2100-2200 22 RHEROC2_VAWA ok 81.78
6191 ROCK ANTENNE 258 2200-2300 23 RHEROC2_WAXA ok 69.47
6192 ROCK ANTENNE 258 2300-2400 24 RHEROC2_XAYA ok 42.18

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