media_variant

22 rows where media = 390

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
9337 ANTENNE THÜRINGEN 390 DS 1 RHHANTT_ZT ok 963.85
9340 ANTENNE THÜRINGEN 390 HpT 4 RHHANTT_ZH ok 963.85
9341 ANTENNE THÜRINGEN 390 Ø 5 RHHANTT_ZD ok 151.87
9342 ANTENNE THÜRINGEN 390 0500-0600 6 RHHANTT_FAGA ok 66.86
9343 ANTENNE THÜRINGEN 390 0600-0700 7 RHHANTT_GAHA ok 135.37
9344 ANTENNE THÜRINGEN 390 0700-0800 8 RHHANTT_HAIA ok 209.16
9345 ANTENNE THÜRINGEN 390 0800-0900 9 RHHANTT_IAJA ok 200.12
9346 ANTENNE THÜRINGEN 390 0900-1000 10 RHHANTT_JAKA ok 172.83
9347 ANTENNE THÜRINGEN 390 1000-1100 11 RHHANTT_KALA ok 140.51
9348 ANTENNE THÜRINGEN 390 1100-1200 12 RHHANTT_LAMA ok 136.15
9349 ANTENNE THÜRINGEN 390 1200-1300 13 RHHANTT_MANA ok 126.36
9350 ANTENNE THÜRINGEN 390 1300-1400 14 RHHANTT_NAOA ok 128.17
9351 ANTENNE THÜRINGEN 390 1400-1500 15 RHHANTT_OAPA ok 119.41
9352 ANTENNE THÜRINGEN 390 1500-1600 16 RHHANTT_PAQA ok 130.23
9353 ANTENNE THÜRINGEN 390 1600-1700 17 RHHANTT_QARA ok 146.32
9354 ANTENNE THÜRINGEN 390 1700-1800 18 RHHANTT_RASA ok 128.69
9355 ANTENNE THÜRINGEN 390 1800-1900 19 RHHANTT_SATA ok 124.73
9356 ANTENNE THÜRINGEN 390 1900-2000 20 RHHANTT_TAUA ok 76.81
9357 ANTENNE THÜRINGEN 390 2000-2100 21 RHHANTT_UAVA ok 31.05
9358 ANTENNE THÜRINGEN 390 2100-2200 22 RHHANTT_VAWA ok 24.52
9359 ANTENNE THÜRINGEN 390 2200-2300 23 RHHANTT_WAXA ok 28.34
9360 ANTENNE THÜRINGEN 390 2300-2400 24 RHHANTT_XAYA ok 12.02

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 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);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);