Skip to content

Commit 0bf676c

Browse files
novapythnovapyth
committed
Create Load_Genome_Annotation.sql
1 parent 51b1ee2 commit 0bf676c

1 file changed

Lines changed: 7 additions & 0 deletions

File tree

‎Load_Genome_Annotation.sql‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
-- Load local infile "~/Scopulariopsis/Genome_Annotation.csv" INTO TABLE Genome_Annotation
2+
LOAD DATA LOCAL INFILE "~/Scopulariopsis/RNAseq.csv" INTO TABLE scopulariopsis.Genome_Annotation
3+
FIELDS TERMINATED BY ','
4+
LINES TERMINATED BY '\n'
5+
IGNORE 1 LINES
6+
(Gene_ID, Gene_Annotation, Expression_values, Gene_length, Unique_gene_reads, Total_gene_read, RPKM);
7+
Protein_Sequence_Length, mean_Similarity, NO_GOs, GOs, Enzyme_Codes

0 commit comments

Comments
 (0)