in reply to Re^4: MCE: How to access variables globally
in thread MCE: How to access variables globally
You can hardly blink fast enough before this code finishes. I would estimate that this code will take about 15*10 seconds or 150 seconds to create 15M line table. Ok, 2 1/2 minutes for table creation. Run this with your 15M line data set and see how long it does takes on your machine.
15M rows is "not big" as these things go. Reads are going to be much faster than writes. I could perhaps make the table creation run 2x as fast, but to what point? I think the real question is what processing of the data do you want once the table is created? I still don't understand that part.
Forget about MCE stuff for the time being. I have a 4 core machine. With a very compute bound job, I can use 4 cores and get the job done maybe 3.8x faster. At this point, focus on the order of magnitude improvements and getting something at a small scale to produce the result you want.
use strict; use warnings; use DBI; $|=1; # STARTS A NEW biohisham db from scratch.. my $dbfilename = "biohisham.sqlite"; if (-e $dbfilename) { unlink $dbfilename or die "delete of existing $dbfilename failed $!"; } my %attr = ( RaiseError => 1); #auto die with error printout my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfilename","","",\%attr) or die "Couldn't connect to database $dbfilename: " . DBI->errstr; create_table($dbh); populate_table($dbh); ### I don't understand what goes next ???? exit(0); sub populate_table { my $dbh = shift; my $insert = $dbh->prepare ("INSERT INTO bioham ( Time , TH , ErrorTH , H , HD0 , State1 , Proba1 , ErrorProba1 , State2 , Proba2 , ErrorProba2 , State3A , State3B , Proba3 , ErrorProba3 ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) + "); <DATA>; #throw away first line - bad column headings $dbh->begin_work; ########## START TRANSACTION ########### while (defined (my $line = <DATA>)) { next if ($line =~ /^\s*$/); #skip blank lines chomp $line; ## print "$line\n"; #for debugging.... my ($Time , $TH , $ErrorTH , $H , $HD0 , $State1 , $Proba1 , $ErrorProba1 , $State2 , $Proba2 , $ErrorProba2 , $State3A , $State3B , $Proba3 , $ErrorProba3) = split("\t",$line); # input data is missing columns 13,14,15 for some records.. $State2 //= ''; #defines a value if not already d +efined $Proba2 //= 0; $ErrorProba2 //= 0; $State3B //= ''; $Proba3 //= 0; $ErrorProba3 //= 0; $insert->execute($Time , $TH , $ErrorTH , $H , $HD0 , $State1 , $Proba1 , $ErrorProba1, $State2 , $Proba2 , $ErrorProba2, $State3A , $State3B , $Proba3 , $ErrorProba3); } $dbh->commit; ########## END TRANSACTION ########### } sub create_table { my ($dbh) = shift; # This shows the automatically created column "id". # You can omit this "id" line from table creation. # I explicitly put it here to show that there is such # a unique number gernerated for every line within a # table. # # Every column in the DB has to have a unique name. # I just appended numbers to get unique names. # I doubt that "=" can be in a column name, # hence HD=0 became just HD0 $dbh->do ("CREATE TABLE bioham ( id integer PRIMARY KEY AUTOINCREMENT, Time real, TH real, ErrorTH real, H real, HD0 integer, State1 varchar(150), Proba1 real, ErrorProba1 real, State2 varchar(150), Proba2 real, ErrorProba2 real, State3A varchar(150), State3B varchar(150), Proba3 real, ErrorProba3 real ) "); } __DATA__ Time TH ErrorTH H HD=0 State Proba ErrorProba +State Proba ErrorProba State State Proba ErrorProba 0 2.8858 0.0006 13.7791 1 TSP1_2 -- Invasiveness_migrat +ion -- Senescence -- Glut1_4 -- BCL_XL -- Permeability_leakiness -- E +nolase_1 -- Ang_1 -- Erythropoietin 1E-06 1E-06 TSP1_2 -- In +vasiveness_migration -- Senescence -- P21 -- BCL_XL -- Permeability_l +eakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 1E-06 0 TSP1 +_2 -- Invasiveness_migration -- Senescence -- BCL_XL -- LDHA -- Ang_1 + -- S6k1 -- Erythropoietin TSP1_2 -- Invasiveness_migration -- Sen +escence -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- A +ng_1 3E-06 1E-06 0.5 2.3538 0.0008 15.1476 1 TSP1_2 -- Senescence -- Glu +t1_4 -- BCL_XL -- Enolase_1 -- Ang_1 -- TWIST1 -- Erythropoietin 0 + 0 TSP1_2 -- Senescence -- Glut1_4 -- BCL_XL -- Permeability_le +akiness -- Ang_1 -- Hmox -- Erythropoietin 1E-06 1E-06 TSP1_ +2 -- Senescence -- BCL_XL -- LDHA -- Enolase_1 -- Ang_1 -- S6k1 TS +P1_2 -- Senescence -- LDHA -- Ang_1 -- S6k1 -- Hmox -- Erythropoietin + 1E-06 1E-06 1 1.8685 0.001 14.027 1 VEGF -- Ang_2 -- TSP1_2 -- Sene +scence -- Glut1_4 -- LDHA -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox 1E +-06 1E-06 VEGF -- Ang_2 -- TSP1_2 -- Senescence -- P21 -- BCL_X +L -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin + 1E-06 1E-06 VEGF -- Ang_2 -- TSP1_2 -- Senescence -- Enolase_ +1 -- S6k1 -- TWIST1 -- Erythropoietin VEGF -- Ang_2 -- TSP1_2 -- S +enescence -- P21 -- Permeability_leakiness -- Enolase_1 -- Ang_1 -- T +WIST1 0 0 1.5 1.4099 0.0011 12.1829 1 VEGF -- Ang_2 -- Invasivene +ss_migration -- Senescence -- Glut1_4 -- Enolase_1 -- Hmox -- Erythro +poietin 0 0 VEGF -- Ang_2 -- Invasiveness_migration -- Senes +cence -- LDHA -- Permeability_leakiness -- Enolase_1 -- Erythropoieti +n 0 0 VEGF -- Ang_2 -- Invasiveness_migration -- Senescence +-- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Ang_ +1 -- TWIST1 VEGF -- Ang_2 -- Invasiveness_migration -- Senescence +-- P21 -- LDHA -- Permeability_leakiness -- Enolase_1 -- Ang_1 -- S6k +1 -- Hmox -- TWIST1 -- Erythropoietin 1E-06 1E-06 2 1.0082 0.0011 10.2065 1 IL_8 -- Maspin -- Glut1_4 -- +P21 -- LDHA -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 1E-06 1 +E-06 IL_8 -- Maspin -- Glut1_4 -- P21 -- LDHA -- Enolase_1 -- Hmox + -- TWIST1 -- Erythropoietin 1E-06 1E-06 IL_8 -- Maspin -- G +lut1_4 -- P21 -- BCL_XL -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Ery +thropoietin VEGF -- P21 -- LDHA -- S6k1 -- Hmox -- TWIST1 -- Eryth +ropoietin 0 0 2.5 0.6879 0.001 8.365 1 VEGF -- Maspin -- Glut1_4 -- P +21 -- BCL_XL -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythr +opoietin 1E-06 1E-06 Glut1_4 -- P21 -- BCL_XL -- LDHA 0 + 0 Ang_2 -- TSP1_2 -- Glut1_4 -- P21 -- LDHA -- Enolase_1 -- Ang_ +1 -- TWIST1 VEGF -- Ang_2 -- Senescence -- Glut1_4 -- P21 -- BCL_X +L -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- Erythropoietin 6E-06 +3E-06 3 0.4512 0.0009 6.7607 1 IL_8 -- Ang_2 -- TSP1_2 -- Glu +t1_4 -- LDHA -- Permeability_leakiness -- S6k1 0 0 Invasiven +ess_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Ang_1 0 0 + Maspin -- Invasiveness_migration -- Glut1_4 -- P21 -- BCL_XL -- LD +HA -- Ang_1 VEGF -- TSP1_2 -- Invasiveness_migration -- Senescence + -- Glut1_4 -- P21 -- BCL_XL -- Permeability_leakiness -- Enolase_1 - +- Ang_1 -- S6k1 -- TWIST1 2E-06 2E-06 3.5 0.2865 0.0007 5.4133 1 VEGF -- Ang_2 -- Maspin -- G +lut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- TWIST +1 -- Erythropoietin 0 0 VEGF -- TSP1_2 -- Maspin -- Glut1_4 +-- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6 +k1 -- Hmox -- TWIST1 -- Erythropoietin 1E-06 1E-06 Maspin -- + Senescence -- Glut1_4 -- P21 -- BCL_XL -- Permeability_leakiness -- +Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 VEGF -- IL_8 -- Ang_2 + -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1 +_4 -- BCL_XL -- LDHA -- Permeability_leakiness -- Ang_1 -- S6k1 -- TW +IST1 -- Erythropoietin 3E-06 2E-06 4 0.1783 0.0006 4.3068 1 VEGF -- Maspin -- Invasiveness +_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Ang_1 -- S6k1 -- Hm +ox -- TWIST1 -- Erythropoietin 0 0 VEGF -- Maspin -- Invasiv +eness_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- S6k1 -- Hmox - +- TWIST1 -- Erythropoietin 1E-06 1E-06 VEGF -- Ang_2 -- TSP1 +_2 -- Invasiveness_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- P +ermeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Eryth +ropoietin VEGF -- TSP1_2 -- Invasiveness_migration -- Senescence - +- Glut1_4 -- P21 -- BCL_XL -- Permeability_leakiness -- Enolase_1 -- +Ang_1 -- S6k1 -- Hmox -- TWIST1 0 0 4.5 0.1101 0.0005 3.4108 1 Invasiveness_migration -- Se +nescence -- Glut1_4 -- P21 -- BCL_XL -- Ang_1 2E-06 2E-06 An +g_2 -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_ +XL -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 1E-06 1E-06 + Ang_2 -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- +BCL_XL -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoiet +in IL_8 -- Ang_2 -- TSP1_2 -- Invasiveness_migration -- Senescence + -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- S6k1 -- Hmox -- +TWIST1 5E-06 2E-06 5 0.0687 0.0004 2.6963 1 VEGF -- IL_8 -- Ang_2 -- TSP1_ +2 -- Maspin -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leaki +ness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-0 +6 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Glut1_4 -- + P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 + -- Hmox -- Erythropoietin 1E-06 1E-06 VEGF -- IL_8 -- Ang_2 + -- TSP1_2 -- Maspin -- Glut1_4 -- P21 -- BCL_XL -- Enolase_1 -- S6k1 + -- Hmox -- TWIST1 -- Erythropoietin VEGF -- IL_8 -- Ang_2 -- TSP1 +_2 -- Maspin -- Invasiveness_migration -- Senescence -- P21 -- LDHA - +- Permeability_leakiness -- Enolase_1 -- S6k1 -- TWIST1 1E-06 1 +E-06 5.5 0.0434 0.0003 2.1258 1 VEGF -- Ang_2 -- TSP1_2 -- S +enescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakine +ss -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 0 0 + VEGF -- TSP1_2 -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Perme +ability_leakiness -- Ang_1 0 0 TSP1_2 -- Maspin -- Invasiven +ess_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Permeabili +ty_leakiness -- Ang_1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- S6k1 +-- Hmox -- Erythropoietin 1E-06 1E-06 6 0.0278 0.0002 1.6687 1 IL_8 -- Ang_2 -- Invasiveness_ +migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolas +e_1 -- TWIST1 -- Erythropoietin 1E-06 1E-06 IL_8 -- Ang_2 -- + Invasiveness_migration -- Senescence -- Glut1_4 -- BCL_XL -- LDHA -- + Enolase_1 -- TWIST1 -- Erythropoietin 1E-06 1E-06 TSP1_2 -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Eryt +hropoietin VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasivene +ss_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Hmox + -- TWIST1 -- Erythropoietin 9E-06 4E-06 6.5 0.0185 0.0002 1.307 1 Ang_2 -- Maspin -- Invasivene +ss_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- TWI +ST1 -- Erythropoietin 0 0 Maspin -- Invasiveness_migration - +- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- TWIST1 -- Erythro +poietin 0 0 Maspin -- Invasiveness_migration -- Senescence - +- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- TWIST +1 -- Erythropoietin VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Invasivenes +s_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Perm +eability_leakiness -- S6k1 -- Hmox -- TWIST1 3E-06 2E-06 7 0.0127 0.0002 1.0198 1 VEGF -- TSP1_2 -- Invasiveness +_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Perme +ability_leakiness -- Ang_1 1E-06 1E-06 VEGF -- TSP1_2 -- Inv +asiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Ang_ +1 0 0 VEGF -- TSP1_2 -- Invasiveness_migration -- Senescence + -- Glut1_4 -- P21 -- Ang_1 VEGF -- IL_8 -- Invasiveness_migration + -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Hm +ox -- TWIST1 -- Erythropoietin 2E-06 2E-06 7.5 0.0087 0.0001 0.7924 1 VEGF -- TSP1_2 -- Maspin -- +Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- P +ermeability_leakiness -- Ang_1 2E-06 2E-06 VEGF -- Ang_2 -- +Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- LDHA -- Eno +lase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 1E-06 1E-06 + VEGF -- Ang_2 -- Invasiveness_migration -- Senescence -- Glut1_4 - +- P21 -- LDHA -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 -- Eryt +hropoietin VEGF -- IL_8 -- Ang_2 -- Maspin -- Invasiveness_migrati +on -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_ +leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Erythropoietin 0.00010 +1 1.3E-05 8 0.0061 0.0001 0.6144 1 VEGF -- IL_8 -- Ang_2 -- TSP1_ +2 -- Invasiveness_migration -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Pe +rmeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythr +opoietin 1E-06 1E-06 VEGF -- TSP1_2 -- Maspin -- Invasivenes +s_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Permeability +_leakiness -- Ang_1 0 0 VEGF -- TSP1_2 -- Maspin -- Invasive +ness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Permeabil +ity_leakiness 8.5 0.0043 0.0001 0.4727 1 VEGF -- IL_8 -- Ang_2 -- Mas +pin -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- + S6k1 -- Hmox -- TWIST1 -- Erythropoietin 0 0 VEGF -- Ang_2 +-- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 - +- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hm +ox -- TWIST1 -- Erythropoietin 0 0 VEGF -- Maspin -- Invasiv +eness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- +Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Eryt +hropoietin 9 0.0031 0.0001 0.363 1 VEGF -- Ang_2 -- TSP1_2 -- Masp +in -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_X +L -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- T +WIST1 -- Erythropoietin 7.7E-05 1.2E-05 VEGF -- IL_8 -- Ang_ +2 -- TSP1_2 -- Maspin -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LD +HA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 - +- Erythropoietin 5.3E-05 1E-05 IL_8 -- Ang_2 -- TSP1_2 -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- LDHA -- Perme +ability_leakiness -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 -- +Erythropoietin 9.5 0.0022 0.0001 0.2772 1 VEGF -- Ang_2 -- TSP1_2 -- I +nvasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LD +HA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 - +- Erythropoietin 0 0 VEGF -- IL_8 -- Invasiveness_migration +-- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_lea +kiness -- Enolase_1 -- Ang_1 -- TWIST1 -- Erythropoietin 1E-06 +1E-06 VEGF -- IL_8 -- Invasiveness_migration -- Senescence -- Glut +1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Ang_1 -- TWIST1 -- Eryth +ropoietin 10 0.0015 0.0001 0.2105 1 VEGF -- IL_8 -- Maspin -- Inv +asiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA + -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Erythrop +oietin 2E-06 2E-06 VEGF -- IL_8 -- Maspin -- Invasiveness_mi +gration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_ +1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 6E-06 3E-06 VE +GF -- IL_8 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1 +_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Hmox -- TWIST1 -- Erythro +poietin 10.5 0.0011 0 0.1595 1 VEGF -- IL_8 -- Ang_2 -- Invasiv +eness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- +Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Eryt +hropoietin 0 0 IL_8 -- Ang_2 -- TSP1_2 -- Invasiveness_migra +tion -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeabilit +y_leakiness -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 -- Erythr +opoietin 2E-06 2E-06 VEGF -- IL_8 -- Invasiveness_migration +-- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Ang +_1 -- Hmox -- TWIST1 -- Erythropoietin 11 0.0007 0 0.1199 1 VEGF -- IL_8 -- TSP1_2 -- Maspin - +- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- + LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST +1 -- Erythropoietin 8E-06 4E-06 VEGF -- IL_8 -- Ang_2 -- TSP +1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P +21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 - +- TWIST1 6E-06 3E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Masp +in -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_X +L -- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- Erythropo +ietin 11.5 0.0006 0 0.0896 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 +-- Maspin -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permea +bility_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoi +etin 2E-06 2E-06 VEGF -- IL_8 -- Invasiveness_migration -- S +enescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- S6k1 -- + Hmox -- TWIST1 -- Erythropoietin 2E-06 2E-06 VEGF -- IL_8 - +- Ang_2 -- TSP1_2 -- Invasiveness_migration -- Senescence -- Glut1_4 +-- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- An +g_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 12 0.0004 0 0.0664 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- + Maspin -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeabi +lity_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoiet +in 0 0 VEGF -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_mig +ration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeabil +ity_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoieti +n 4E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- I +nvasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- Pe +rmeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythr +opoietin 12.5 0.0002 0 0.0486 1 VEGF -- IL_8 -- Maspin -- Invasi +veness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- + Enolase_1 -- Hmox -- TWIST1 -- Erythropoietin 4E-06 3E-06 V +EGF -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senesce +nce -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- +Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 2E- +06 IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- +Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakin +ess -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin + 13 0.0002 0 0.0353 1 VEGF -- IL_8 -- Maspin -- Invasive +ness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- E +nolase_1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 2E-06 VEG +F -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senescenc +e -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- En +olase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 2E-06 + IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Se +nescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakines +s -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin + 13.5 0.0001 0 0.0261 1 VEGF -- IL_8 -- Maspin -- Invasi +veness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- + Enolase_1 -- Hmox -- TWIST1 -- Erythropoietin 1E-06 1E-06 V +EGF -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senesce +nce -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- +Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 2E- +06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Invasiveness_migration -- Se +nescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakines +s -- Enolase_1 -- Ang_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin + 14 0.0001 0 0.019 1 VEGF -- Ang_2 -- TSP1_2 -- Maspin - +- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- + LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST +1 -- Erythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP +1_2 -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_ +XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- +TWIST1 -- Erythropoietin 4.9E-05 9E-06 VEGF -- IL_8 -- Ang_2 + -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 +-- BCL_XL -- LDHA -- Enolase_1 -- Hmox -- TWIST1 -- Erythropoietin + 14.5 0.0001 0 0.0138 1 VEGF -- IL_8 -- Ang_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Enolase_1 -- Hmox -- TWIST1 -- Erythropoietin 6.9E-05 + 1.1E-05 VEGF -- IL_8 -- Ang_2 -- Maspin -- Invasiveness_migration + -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- S6 +k1 -- Hmox -- TWIST1 -- Erythropoietin 7.7E-05 1.2E-05 VEGF +-- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Sen +escence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness + -- Enolase_1 -- S6k1 -- TWIST1 -- Erythropoietin 15 0 0 0.01 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Invasi +veness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- + Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Ery +thropoietin 1.1E-05 5E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- + Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- +BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- TWIS +T1 -- Erythropoietin 4E-06 3E-06 VEGF -- IL_8 -- Ang_2 -- TS +P1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- +P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- S6k1 15.5 0 0 0.0073 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDH +A -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- + Erythropoietin 9E-06 4E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 +-- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 - +- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- TW +IST1 -- Erythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- +TSP1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 - +- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- S6k1 16 0 0 0.0051 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Inva +siveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA +-- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- E +rythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- + Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- +BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- TWIS +T1 -- Erythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TS +P1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- +P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- S6k1 -- Hmox -- TW +IST1 16.5 0 0 0.0037 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDH +A -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- + Erythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 +-- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 - +- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- TW +IST1 -- Erythropoietin 1E-06 1E-06 VEGF -- IL_8 -- Ang_2 -- +TSP1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 - +- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k +1 -- Hmox -- TWIST1 17 0 0 0.0027 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Inva +siveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA +-- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- E +rythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- + Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- +BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox + -- TWIST1 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Ma +spin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL +_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- + TWIST1 -- Erythropoietin 17.5 0 0 0.0019 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDH +A -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- + Erythropoietin 1E-06 1E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 +-- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 - +- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hm +ox -- TWIST1 1E-06 1E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- +Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- B +CL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox +-- TWIST1 -- Erythropoietin 18 0 0 0.0011 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Masp +in -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_X +L -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- T +WIST1 -- Erythropoietin 0.999932 1.1E-05 VEGF -- IL_8 -- Ang +_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senescence -- Glu +t1_4 -- P21 -- BCL_XL -- LDHA -- Enolase_1 -- Hmox -- TWIST1 -- Eryth +ropoietin 4E-06 3E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Mas +pin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_ +XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 - +- Erythropoietin 18.5 0 0 0.0008 1 VEGF -- IL_8 -- Ang_2 -- Maspin -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDH +A -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 + 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_ +migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Enolas +e_1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 2E-06 VEGF -- +IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_migration -- Senesc +ence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeability_leakiness -- + Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 19 0 0 0.0006 1 VEGF -- IL_8 -- Ang_2 -- Maspin -- Inva +siveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA +-- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 +2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_mi +gration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeabi +lity_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoiet +in 0.999964 8E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Er +ythropoietin 19.5 0 0 0.0004 1 VEGF -- IL_8 -- Ang_2 -- Maspin -- In +vasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDH +A -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 + 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_ +migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permea +bility_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoi +etin 0.999976 7E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspi +n -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL + -- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- +Erythropoietin 20 0 0 0.0003 1 VEGF -- IL_8 -- Ang_2 -- Maspin -- Inva +siveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA +-- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoietin 2E-06 +2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- Invasiveness_mi +gration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- LDHA -- Permeabi +lity_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 -- Erythropoiet +in 0.999986 5E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Er +ythropoietin 20.5 0 0 0.0001 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Ma +spin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL +_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 +-- Erythropoietin 6E-06 3E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_ +2 -- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 + -- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- +Hmox -- TWIST1 -- Erythropoietin 0.999994 3E-06 21 0 0 0.0001 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Masp +in -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_X +L -- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- + Erythropoietin 4E-06 3E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 +-- Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 - +- BCL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hm +ox -- TWIST1 -- Erythropoietin 0.999996 3E-06 21.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- Hmox -- TWIST1 -- Er +ythropoietin 2E-06 2E-06 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- +Maspin -- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- B +CL_XL -- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox +-- TWIST1 -- Erythropoietin 0.999998 2E-06 22 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0 22.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIS +T1 -- Erythropoietin 1 0 23 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0 23.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIS +T1 -- Erythropoietin 1 0 24 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0 24.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIS +T1 -- Erythropoietin 1 0 25 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0 25.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIS +T1 -- Erythropoietin 1 0 26 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0 26.5 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin +-- Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL - +- LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIS +T1 -- Erythropoietin 1 0 27 0 0 0 1 VEGF -- IL_8 -- Ang_2 -- TSP1_2 -- Maspin -- + Invasiveness_migration -- Senescence -- Glut1_4 -- P21 -- BCL_XL -- +LDHA -- Permeability_leakiness -- Enolase_1 -- S6k1 -- Hmox -- TWIST1 + -- Erythropoietin 1 0
|
|---|