media_variant

22 rows where media = 243

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
5809 Regenbogen Zwei 243 DS 1 RHDREB2_ZT ok 409.62
5812 Regenbogen Zwei 243 HpT 4 RHDREB2_ZH ok 409.62
5813 Regenbogen Zwei 243 Ø 5 RHDREB2_ZD ok 67.21
5814 Regenbogen Zwei 243 0500-0600 6 RHDREB2_FAGA ok 20.81
5815 Regenbogen Zwei 243 0600-0700 7 RHDREB2_GAHA ok 70.79
5816 Regenbogen Zwei 243 0700-0800 8 RHDREB2_HAIA ok 87.38
5817 Regenbogen Zwei 243 0800-0900 9 RHDREB2_IAJA ok 78.93
5818 Regenbogen Zwei 243 0900-1000 10 RHDREB2_JAKA ok 57.75
5819 Regenbogen Zwei 243 1000-1100 11 RHDREB2_KALA ok 48.95
5820 Regenbogen Zwei 243 1100-1200 12 RHDREB2_LAMA ok 56.98
5821 Regenbogen Zwei 243 1200-1300 13 RHDREB2_MANA ok 54.55
5822 Regenbogen Zwei 243 1300-1400 14 RHDREB2_NAOA ok 44.79
5823 Regenbogen Zwei 243 1400-1500 15 RHDREB2_OAPA ok 73.75
5824 Regenbogen Zwei 243 1500-1600 16 RHDREB2_PAQA ok 76.18
5825 Regenbogen Zwei 243 1600-1700 17 RHDREB2_QARA ok 81.79
5826 Regenbogen Zwei 243 1700-1800 18 RHDREB2_RASA ok 60.57
5827 Regenbogen Zwei 243 1800-1900 19 RHDREB2_SATA ok 37.02
5828 Regenbogen Zwei 243 1900-2000 20 RHDREB2_TAUA ok 17.47
5829 Regenbogen Zwei 243 2000-2100 21 RHDREB2_UAVA ok 8.37
5830 Regenbogen Zwei 243 2100-2200 22 RHDREB2_VAWA ok 6.85
5831 Regenbogen Zwei 243 2200-2300 23 RHDREB2_WAXA ok 2.81
5832 Regenbogen Zwei 243 2300-2400 24 RHDREB2_XAYA ok 2.38

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