media_variant

22 rows where media = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
2185 HAMBURG ZWEI 92 DS 1 RHAOKRA_ZT ok 215.29
2188 HAMBURG ZWEI 92 HpT 4 RHAOKRA_ZH ok 215.29
2189 HAMBURG ZWEI 92 Ø 5 RHAOKRA_ZD ok 30.79
2190 HAMBURG ZWEI 92 0500-0600 6 RHAOKRA_FAGA ok 22.15
2191 HAMBURG ZWEI 92 0600-0700 7 RHAOKRA_GAHA ok 27.39
2192 HAMBURG ZWEI 92 0700-0800 8 RHAOKRA_HAIA ok 38.59
2193 HAMBURG ZWEI 92 0800-0900 9 RHAOKRA_IAJA ok 29.51
2194 HAMBURG ZWEI 92 0900-1000 10 RHAOKRA_JAKA ok 30.04
2195 HAMBURG ZWEI 92 1000-1100 11 RHAOKRA_KALA ok 29.02
2196 HAMBURG ZWEI 92 1100-1200 12 RHAOKRA_LAMA ok 20.48
2197 HAMBURG ZWEI 92 1200-1300 13 RHAOKRA_MANA ok 25.2
2198 HAMBURG ZWEI 92 1300-1400 14 RHAOKRA_NAOA ok 26.65
2199 HAMBURG ZWEI 92 1400-1500 15 RHAOKRA_OAPA ok 30.34
2200 HAMBURG ZWEI 92 1500-1600 16 RHAOKRA_PAQA ok 27.36
2201 HAMBURG ZWEI 92 1600-1700 17 RHAOKRA_QARA ok 40.34
2202 HAMBURG ZWEI 92 1700-1800 18 RHAOKRA_RASA ok 38.53
2203 HAMBURG ZWEI 92 1800-1900 19 RHAOKRA_SATA ok 20.18
2204 HAMBURG ZWEI 92 1900-2000 20 RHAOKRA_TAUA ok 21.02
2205 HAMBURG ZWEI 92 2000-2100 21 RHAOKRA_UAVA ok 11.9
2206 HAMBURG ZWEI 92 2100-2200 22 RHAOKRA_VAWA ok 10.54
2207 HAMBURG ZWEI 92 2200-2300 23 RHAOKRA_WAXA ok 7.36
2208 HAMBURG ZWEI 92 2300-2400 24 RHAOKRA_XAYA ok 3.31

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