#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 テーブル情報をアップしました。~

トップ   編集 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS