Skip to content

Instantly share code, notes, and snippets.

@renzok

renzok/00141-tara-satge-table-and-data-import-patch.sql

Created October 23, 2015 06:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save renzok/32840a8340017f99111f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save renzok/32840a8340017f99111f to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. renzok created this gist Oct 23, 2015.
    3 changes: 3 additions & 0 deletions 00141-tara-satge-table-and-data-import-patch.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    COPY tara_samples (sample_name, ena_read_no, pangaea_id, publication, type_of_study, seq_method, date_verb, latitude_verb, longitude_verb, depth_verb, feature_verb) FROM STDIN WITH (FORMAT csv, HEADER, DELIMITER E'\t', NULL '', FORCE_NOT_NULL(type_of_study,seq_method) );
    sample_name ena_read_no pangaea_id publication type_of_study seq_method date_verb latitude_verb longitude_verb depth_verb feature_verb
    TARA_004_DCM_0.22-1.6 ERR598950|ERR599095 TARA_X000000368 sunagawa