Guest User

Untitled

a guest
Nov 15th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. <rebase>
  2. <Organism>
  3. <Name>Aminomonas paucivorans</Name>
  4. <Enzyme>M1.Apa12260I</Enzyme>
  5. <Motif>GGAGNNNNNGGC</Motif>
  6. <Enzyme>M2.Apa12260I</Enzyme>
  7. <Motif>GGAGNNNNNGGC</Motif>
  8. </Organism>
  9. <Organism>
  10. <Name>Bacillus cellulosilyticus</Name>
  11. <Enzyme>M1.BceNI</Enzyme>
  12. <Motif>CCCNNNNNCTC</Motif>
  13. <Enzyme>M2.BceNI</Enzyme>
  14. <Motif>CCCNNNNNCTC</Motif>
  15. </Organism>
  16. </rebase>
  17.  
  18. name,enzyme
  19. Aminomonas paucivorans,M1.Apa12260I
  20. Aminomonas paucivorans,M2.Apa12260I
  21. Bacillus cellulosilyticus,M1.BceNI
  22. Bacillus cellulosilyticus,M2.BceNI
  23.  
  24. name,motif
  25. Aminomonas paucivorans,GGAGNNNNNGGC
  26. Aminomonas paucivorans,GGAGNNNNNGGC
  27. Bacillus cellulosilyticus,CCCNNNNNCTC
  28. Bacillus cellulosilyticus,CCCNNNNNCTC
  29.  
  30. USING PERIODIC COMMIT
  31. LOAD CSV WITH HEADERS FROM "file1.csv" AS csvLine
  32. MATCH (o:Organism { name: csvLine.name}),(e:Enzyme { name: csvLine.enzyme})
  33. CREATE (o)-[:has_enzyme]->(e) //or maybe CREATE UNIQUE?
  34.  
  35. USING PERIODIC COMMIT
  36. LOAD CSV WITH HEADERS FROM "file2.csv" AS csvLine
  37. MATCH (o:Organism { name: csvLine.name}),(m:Motif { name: csvLine.motif})
  38. CREATE (o)-[:has_motif]->(m) //or maybe CREATE UNIQUE?
Add Comment
Please, Sign In to add comment