media_variant

22 rows where media = 402

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
9625 ANTENNE THÜRINGEN 402 DS 1 RHHANTT_ZT ok 910.04
9628 ANTENNE THÜRINGEN 402 HpT 4 RHHANTT_ZH ok 910.04
9629 ANTENNE THÜRINGEN 402 Ø 5 RHHANTT_ZD ok 146.31
9630 ANTENNE THÜRINGEN 402 0500-0600 6 RHHANTT_FAGA ok 58.42
9631 ANTENNE THÜRINGEN 402 0600-0700 7 RHHANTT_GAHA ok 140.08
9632 ANTENNE THÜRINGEN 402 0700-0800 8 RHHANTT_HAIA ok 201.01
9633 ANTENNE THÜRINGEN 402 0800-0900 9 RHHANTT_IAJA ok 191.39
9634 ANTENNE THÜRINGEN 402 0900-1000 10 RHHANTT_JAKA ok 177.14
9635 ANTENNE THÜRINGEN 402 1000-1100 11 RHHANTT_KALA ok 126.7
9636 ANTENNE THÜRINGEN 402 1100-1200 12 RHHANTT_LAMA ok 121.67
9637 ANTENNE THÜRINGEN 402 1200-1300 13 RHHANTT_MANA ok 121.78
9638 ANTENNE THÜRINGEN 402 1300-1400 14 RHHANTT_NAOA ok 112.7
9639 ANTENNE THÜRINGEN 402 1400-1500 15 RHHANTT_OAPA ok 127.65
9640 ANTENNE THÜRINGEN 402 1500-1600 16 RHHANTT_PAQA ok 126.51
9641 ANTENNE THÜRINGEN 402 1600-1700 17 RHHANTT_QARA ok 140.08
9642 ANTENNE THÜRINGEN 402 1700-1800 18 RHHANTT_RASA ok 127.49
9643 ANTENNE THÜRINGEN 402 1800-1900 19 RHHANTT_SATA ok 104.34
9644 ANTENNE THÜRINGEN 402 1900-2000 20 RHHANTT_TAUA ok 84.94
9645 ANTENNE THÜRINGEN 402 2000-2100 21 RHHANTT_UAVA ok 41.65
9646 ANTENNE THÜRINGEN 402 2100-2200 22 RHHANTT_VAWA ok 34.6
9647 ANTENNE THÜRINGEN 402 2200-2300 23 RHHANTT_WAXA ok 39.51
9648 ANTENNE THÜRINGEN 402 2300-2400 24 RHHANTT_XAYA ok 22.95

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