#author("2020-03-30T12:08:02+09:00","","") #author("2020-03-30T12:12:30+09:00","","") *Samples table [#d426e074] RIGHT:[[日本語はこちら>#b5d2a0c3]]~ LEFT:ChemTHEATRE stores and offers the following types of Information about the registered samples.(As of February 19, 2020)~ ~ ~ |CENTER:Required |CENTER:Category |CENTER:Title |CENTER:Description |CENTER:Relationship or External Link |h |CENTER:◯ |CENTER:General info. | ProjectID | ID which ChemTHEATRE assigns to a project | [[Projects]] table | |CENTER:◯ |CENTER:General info. | SampleID | ID which ChemTHEATRE assigns to a sample | | |CENTER:◯ |CENTER:General info. | Sample Type | Kinds of sample(biotic, abiotic, etc) | Sample Type table | | |CENTER:&color(orange){Biotic}; | TaxonomyID | NCBI Taxonomy ID | http://www.ncbi.nlm.nih.gov/taxonomy | |CENTER:◯ |CENTER:General info. | Scientific Name | Biotic: Scientific name, Abiotic: Water, Sediment, Air| | |CENTER:◯ |CENTER:General info. | Common Name | | | |CENTER:◯ |CENTER:General info. | Collection Year | | | | |CENTER:General info. | Collection Month | | | | |CENTER:General info. | Collection Day | | | | |CENTER:General info. | Sampling Time (Start/End) | | | | |CENTER:General info. | Sampling Time (AM/PM) | | | | |CENTER:General info. | Sampling Duration | | | | |CENTER:General info. | Weather (Start/End) | | | | |CENTER:General info. | Temperature(℃) (Start/End) | | | |CENTER:◯ |CENTER:General info. | Collection Region | | | |CENTER:◯ |CENTER:General info. | Collection Country | | | |CENTER:◯ |CENTER:General info. | Collection Area | | | |CENTER:◯ |CENTER:General info. | Collection Latitude From | | Google Map, Google Earth | | |CENTER:General info. | Collection Latitude To | | Google Map, Google Earth | |CENTER:◯ |CENTER:General info. | Collection Longitude From | | Google Map, Google Earth | | |CENTER:General info. | Collection Longitude To | | Google Map, Google Earth | | |CENTER:General info. | MAP | Sampling spots are pointed out by inputting Latitude and Longitude | | |CENTER:◯ |CENTER:&color(orange){Biotic}; | Tissue/Organ | | | | |CENTER:&color(orange){Biotic}; | Tissue_Lipid (%) | | | | |CENTER:&color(orange){Biotic}; | Tissue_Moist (%) | | | | |CENTER:&color(orange){Biotic}; | Sex | Male, Female, or Unidentified | | |CENTER:◯ |CENTER:&color(orange){Biotic}; | Weight | | | | |CENTER:&color(orange){Biotic}; | Weight_unit | g, kg, etc. | | | |CENTER:&color(orange){Biotic}; | Length | | | | |CENTER:&color(orange){Biotic}; | Length_unit | cm, m. etc. | | | |CENTER:&color(orange){Biotic}; | Length_type | body length, fork length, height, etc. | | | |CENTER:&color(orange){Biotic}; | Growth Stage | adult, juvenile, etc. | | | |CENTER:&color(orange){Biotic}; | Age | | | | |CENTER:&color(orange){Biotic}; | Disease | | | | |CENTER:&color(blue){Water}; | Water Temperature (℃) (Start/End) | | | | |CENTER:&color(blue){Water}; | pH | | | | |CENTER:&color(blue){Water}; | DO (mg/L) | Dissolved Oxygen (DO) | | | |CENTER:&color(blue){Water}; | EC (mS/m) | Electrical Conductivity (EC) | | | |CENTER:&color(blue){Water}; | Salinity | | | | |CENTER:&color(blue){Water}; | SS (mg/L) | Suspended Solids/Substance (SS) | | |CENTER:◯ |CENTER:&color(blue){Water}; | Water Depth (m) | | | | |CENTER:&color(blue){Water}; | Transparency (m) | | | | |CENTER:&color(blue){Water}; | Water Color | | | | |CENTER:&color(red){Sediment}; | Sediment Temperature (℃) (Start/End) | | | |CENTER:◯ |CENTER:&color(red){Sediment}; | Sediment Depth (m) | | | | |CENTER:&color(red){Sediment}; | Sediment Appearance | | | | |CENTER:&color(red){Sediment}; | Sediment Color | | | | |CENTER:&color(red){Sediment}; | Sediment Surface Color | | | | |CENTER:&color(red){Sediment}; | Sediment Odor | | | | |CENTER:&color(red){Sediment}; | Sediment Impurities | | | | |CENTER:&color(red){Sediment}; | Sediment Moisture (%)(On Site/Analysis) | | | | |CENTER:&color(red){Sediment}; | Ignition Loss (%)(On Site/Analysis) | | | |CENTER:◯ |CENTER:&color(purple){Soil}; | Soil Depth (m) | | | | |CENTER:&color(green){Air}; | Wind Direction (Start/End) | | | | |CENTER:&color(green){Air}; | Wind Speed (m/s)(Start/End) | | | | |CENTER:&color(green){Air}; | Flow Rate | | | | |CENTER:&color(green){Air}; | Humidity (%) (Start/End) | | | | |CENTER:&color(green){Air}; | Amount of Collected Air (Start/End) | | | | |CENTER:&color(green){Air}; | Mean PM10 | | | | |CENTER:&color(green){Air}; | Mean Total Suspended Particles | | | |CENTER:◯*1 |CENTER:General info. | Sample Name | | | |CENTER:◯*1 |CENTER:General info. | Uniq Code | | External database (Open to the public) | |CENTER:◯*2 |CENTER:General info. | Uniq Code Type | | | | |CENTER:General info. | Remarks | | | -*1: Either of them are required. -*2: Required if the sample has an uniq code. ~ ~ ~ *Samples テーブル [#b5d2a0c3] RIGHT:[[English ver.>#d426e074]]~ LEFT:試料に関する情報は下記の通り。(2020/02/19現在)~ 追加すべき項目があれば[[こちら>info@chem-theatre.com]]まで連絡下さい。 ~ ~ |CENTER:必須 |CENTER:分類 |CENTER:タイトル |CENTER:説明文 |CENTER:リレーションシップ or 外部リンク |h |CENTER:◯ | 共通 | ProjectID | 各プロジェクトに付すシリアルナンバー | [[Projects]] テーブル | |CENTER:◯ | 共通 | SampleID | 各サンプルに付すシリアルナンバー | | |CENTER:◯ | 共通 | Sample Type | サンプルの種類(生物,非生物等) | Sample Type テーブル | | | &color(orange){生物}; | TaxonomyID | NCBI Taxonomy ID / 生物分類 | http://www.ncbi.nlm.nih.gov/taxonomy | |CENTER:◯ | 共通 | Scientific Name | 生物の場合:学名, 非生物の場合: 水, 底質, 土壌, 大気| | |CENTER:◯ | 共通 | Common Name | 一般名 | | |CENTER:◯ | 共通 | Collection Year | 試料採取年 | | | | 共通 | Collection Month | 試料採取月 | | | | 共通 | Collection Day | 試料採取日 | | | | 共通 | Sampling Time (Start/End) | サンプリング時間(開始時/終了時) | | | | 共通 | Sampling Time (AM/PM) | サンプリング時間(午前/午後) | | | | 共通 | Sampling Duration | サンプリング継続時間 | | | | 共通 | Weather (Start/End) | 天候(開始時/終了時) | | | | 共通 | Temperature(℃) (Start/End) | 温度(℃)(開始時/終了時) | | |CENTER:◯ | 共通 | Collection Region | 採取地域 | | |CENTER:◯ | 共通 | Collection Country | 採取国 | | |CENTER:◯ | 共通 | Collection Area | 採取地 | | |CENTER:◯ | 共通 | Collection Latitude From | 採取地緯度 | Google Map, Google Earth等 | | | 共通 | Collection Latitude To | 採取地緯度(範囲表示の場合) | Google Map, Google Earth等 | |CENTER:◯ | 共通 | Collection Longitude From | 採取地経度 | Google Map, Google Earth等 | | | 共通 | Collection Longitude To | 採取地経度(範囲表示の場合) | Google Map, Google Earth等 | | | 共通 | MAP | 地図(緯度経度の入力により自動で採取地点を表示) | | |CENTER:◯ | &color(orange){生物}; | Tissue/Organ | (生物)組織または臓器名 | | | | &color(orange){生物}; | Tissue_Lipid (%) | (生物) 脂質含量 (%) | | | | &color(orange){生物}; | Tissue_Moist (%) | (生物)水分含量(%) | | | | &color(orange){生物}; | Sex | (生物)性別(男性/女性/不明, オス/メス/不明) | | |CENTER:◯ | &color(orange){生物}; | Weight | (生物)重量 | | | | &color(orange){生物}; | Weight_unit | (生物)重量の単位(g, kg等) | | | | &color(orange){生物}; | Length | (生物)長さ(Length_typeで定義) | | | | &color(orange){生物}; | Length_unit | (生物)長さの単位(cm, m等) | | | | &color(orange){生物}; | Length_type | (生物)長さの種類 (体長(body length), 尾叉長(fork length), 全長(total length), 身長(height)等) | | | | &color(orange){生物}; | Growth Stage | (生物)成長段階(成人/成体(adult), 幼若者(体)/未成熟(juvenile等) | | | | &color(orange){生物}; | Age | (生物)年齢 | | | | &color(orange){生物}; | Disease | (生物)疾病等 | | | |CENTER:&color(blue){水}; | Water Temperature (℃) (Start/End) | (水)温度(℃)(開始時/終了時) | | | |CENTER:&color(blue){水}; | pH | (水)pH | | | |CENTER:&color(blue){水}; | DO (mg/L) | (水)溶存酸素量 Dissolved Oxygen (DO) | | | |CENTER:&color(blue){水}; | EC (mS/m) | (水)電気伝導率 Electrical Conductivity (EC) | | | |CENTER:&color(blue){水}; | Salinity | (水)塩分濃度 | | | |CENTER:&color(blue){水}; | SS (mg/L) | (水)浮遊物質/懸濁物質 Suspended Solids/Substance (SS) | | |CENTER:◯ |CENTER:&color(blue){水}; | Water Depth (m) | (水)水の深度 (m) | | | |CENTER:&color(blue){水}; | Transparency (m) | (水)透明度 (m) | | | |CENTER:&color(blue){水}; | Water Color | (水)水の色 | | | | &color(red){底質}; | Sediment Temperature (℃) (Start/End) | (底質)底質の温度(℃)(開始時/終了時) | | |CENTER:◯ | &color(red){底質}; | Sediment Depth (m) | (底質)底質の深度(m) | | | | &color(red){底質}; | Sediment Appearance | (底質)底質の外観 | | | | &color(red){底質}; | Sediment Color | (底質)底質の色 | | | | &color(red){底質}; | Sediment Surface Color | (底質)底質表層の色 | | | | &color(red){底質}; | Sediment Odor | (底質)底質の臭気 | | | | &color(red){底質}; | Sediment Impurities | (底質)底質中の不純物 | | | | &color(red){底質}; | Sediment Moisture (%)(On Site/Analysis) | (底質)底質の湿度(%)(採取時/測定時) | | | | &color(red){底質}; | Ignition Loss (%)(On Site/Analysis) | (底質)強熱減量(%)(採取時/測定時) | | |CENTER:◯ | &color(purple){土壌}; | Soil Depth (m) | (土壌)土壌の深度 (m) | | | | &color(green){大気}; | Wind Direction (Start/End) | (大気)風向(開始時/終了時) | | | | &color(green){大気}; | Wind Speed (m/s)(Start/End) | (大気)風速 (m/s) (開始時/終了時) | | | | &color(green){大気}; | Flow Rate | (大気)流速 | | | | &color(green){大気}; | Humidity (%) (Start/End) | (大気)湿度 (%) (開始時/終了時) | | | | &color(green){大気}; | Amount of Collected Air (Start/End) | (大気)大気採取量(開始時/終了時) | | | | &color(green){大気}; | Mean PM10 | (大気)PM10平均値 | | | | &color(green){大気}; | Mean Total Suspended Particles | (大気)総浮遊粒子 平均値 | | |CENTER:◯*1 | 共通 | Sample Name | 登録者が独自に付けた試料名 | | |CENTER:◯*1 | 共通 | Uniq Code | サンプルに付された固有ID(公開されているものに限る) | External database (Open to the public) | |CENTER:◯*1 | 共通 | Uniq Code | サンプルに付された固有ID(公開されているものに限る) | 外部データベース(公開されているもの) | |CENTER:◯*2 | 共通 | Uniq Code Type | 固有IDの種類(愛媛大学es-BANK,国立科学博物館等)| | | | 共通 | Remarks | 備考 その他試料に関する情報 | | -*1:いずれかの試料IDが必須となる。 -*2:Uniq Code を有する試料では必須となる。 ***Change log (変更履歴) [#j4fddecd] 2020/02/17 共通する項目の他に、生物、水、底質、土壌、大気に特有な項目を追加しました。~ 2016/09/28 試料採取年月日をそれぞれ別カラムにしました。~ 2016/07/08 "Age"と"Disease"を追加しました。~ 2016/07/07 テーブル情報をアップしました。~